the form of data is inconsistent when migrating "decimal unsigned(20,10)" to "character varying(30)"

Details

  • Type: Bug Bug
  • Status: Closed Closed
  • Priority: Trivial Trivial
  • Resolution: Fixed
  • Affects Version/s: CMT8.4.1, CMT8.4.1.201203
  • Fix Version/s: CMT8.4.1.201211
  • Component/s: CUBRID Migration Toolkit
  • Labels:
  • Environment:

    OS:win 7 32bit
    CM:CUBRID 2008 R4.1 (8.4.1.0011) (64bit release build for linux_gnu)
    CMT:Version:R2.0 Build id:2.0.0.4920

Description

1.Mysql:refer to the attachment(decimal20_unsigned_type.sql)
2.do migration
3.check the original data and the target data.

  1. File
    CODE_REVIEW.creview
    11/Apr/12 4:08 AM
    1 kB
    曹轶麟
  1. bug034-decimal_unsigned_migrate_character_varying_error.png
    63 kB
    15/Dec/11 6:10 AM
  2. decimal.png
    155 kB
    20/Dec/12 4:09 AM
  3. decimal.PNG
    10 kB
    11/May/12 3:32 AM
  4. numer.PNG
    8 kB
    30/May/12 6:59 AM

Activity

Ascending order - Click to sort in descending order
Hide
Permalink
曹轶麟 added a comment -

Move to 2.0.1

Show
曹轶麟 added a comment - Move to 2.0.1
Hide
Permalink
曹轶麟 added a comment -

1.Number(p,s) to Varchar

Show
曹轶麟 added a comment - 1.Number(p,s) to Varchar
Hide
Permalink
高艳铭 added a comment -

Regression result in CMT8.4.1.0022-20120510
The bug hasn't been changed.

Show
高艳铭 added a comment - Regression result in CMT8.4.1.0022-20120510 The bug hasn't been changed.
Hide
Permalink
高艳铭 added a comment -

Maybe the initial is right. It only has a little bug which hasn't pop it may be lost data. Because decimal(20,10) need to change to varchar(31). So it change to varchar(30), it will lost one zero

Regression in CMT8.4.1.0029
After offline migration, it become hasn't any zero

Show
高艳铭 added a comment - Maybe the initial is right. It only has a little bug which hasn't pop it may be lost data. Because decimal(20,10) need to change to varchar(31). So it change to varchar(30), it will lost one zero Regression in CMT8.4.1.0029 After offline migration, it become hasn't any zero
Hide
Permalink
曹轶麟 added a comment -

decimal unsigned (20,10) to varchar: it's maxime length is 20+1=21, not 31

Show
曹轶麟 added a comment - decimal unsigned (20,10) to varchar: it's maxime length is 20+1=21, not 31
Hide
Permalink
曹轶麟 added a comment -

Please verify the numeric type to varchar mapping when verify this issue.

If the target varchar type does not have enough length, a warning will be popped.

Show
曹轶麟 added a comment - Please verify the numeric type to varchar mapping when verify this issue. If the target varchar type does not have enough length, a warning will be popped.
Hide
Permalink
董志玲(Ella) added a comment - - edited

Online Migration from mysql to cubrid 8.4.1.7007,has error whether decimal->varchar.please see decimal.png.
It is not a bug.

Show
董志玲(Ella) added a comment - - edited Online Migration from mysql to cubrid 8.4.1.7007,has error whether decimal->varchar.please see decimal.png. It is not a bug.
Hide
Permalink
董志玲(Ella) added a comment -

Fixed in build 8.4.3.4033.

Show
董志玲(Ella) added a comment - Fixed in build 8.4.3.4033.

People

  • Assignee:
    曹轶麟
    Reporter:
    孙泽玺
Vote (0)
Watch (3)

Dates

  • Created:
    Updated:
    Resolved:

Time Tracking

Estimated:
Not Specified
Original Estimate - Not Specified
Remaining:
0m
Remaining Estimate - 0 minutes
Logged:
1d 6h
Time Spent - 1 day, 6 hours