[CMT8.4.1.1205] There isn't data in smallint, it will become 0 after do online migration.

Details

  • Type: Bug Bug
  • Status: Closed Closed
  • Priority: Minor Minor
  • Resolution: Fixed
  • Affects Version/s: CMT8.4.1.201205
  • Fix Version/s: CMT8.4.1.201205
  • Component/s: CUBRID Migration Toolkit
  • Labels:
    None
  • Environment:

    CUBRID 8.4.1.0024
    From mysql to CUBRI8.4.1.2023

Description

There is null in smallint in mysql database.
1 Do online migration, change smallint to varchar(4)

Actual result
Null will be change null to 0

Activity

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

refer to TOOLS-1103

Show
曹轶麟 added a comment - refer to TOOLS-1103
Hide
Permalink
高艳铭 added a comment -

Regression on CMT8.4.1.0026

tools-1103 has been resolved, but the problem existed too.

Show
高艳铭 added a comment - Regression on CMT8.4.1.0026 tools-1103 has been resolved, but the problem existed too.
Hide
Permalink
曹轶麟 added a comment -

If the column value is NULL , the getInt of mysql jdbc will return 0.

Show
曹轶麟 added a comment - If the column value is NULL , the getInt of mysql jdbc will return 0.
Hide
Permalink
高艳铭 added a comment -

Fixed in CMT8.4.1.0026

Show
高艳铭 added a comment - Fixed in CMT8.4.1.0026

People

  • Assignee:
    高艳铭
    Reporter:
    高艳铭
Vote (0)
Watch (2)

Dates

  • Due:
    Created:
    Updated:
    Resolved:

Time Tracking

Estimated:
Not Specified
Original Estimate - Not Specified
Remaining:
0m
Remaining Estimate - 0 minutes
Logged:
2h
Time Spent - 2 hours