[CMT2][BUG] After migration, binary(255) cannot be migrated

Details

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

    CMT2.0.0.4873

Description

1 Create table in mysql
CREATE TABLE `binarytest` (
`binary1` binary(1) DEFAULT NULL,
`binary255` binary(255) DEFAULT NULL,
`binary30` binary(30) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
INSERT INTO `binarytest` VALUES ('2', '2323333fdsafasdfdsafsdfsdaf', 'fasdfasdfsdafsafds');
INSERT INTO `binarytest` VALUES ('a', 'estchangdTestchangdTestchangdTestchangdTestchangdTestchangdTestchangdTestchangdTestchangdTestchangdTestchangdTestchangdTestchangdTestchangdTestchangdTestchangdTestchangdTestchangdTestchangdTestchangdTestchangdTestchangdTestchangd高stchangdTestchangdTestch', 'TestchangdTestchangdTestchangd');

2 Do migration

Actual result
After migration, the data of binary(255) cannot be migrated.

Activity

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

The data was not lost in the migration,It just was turned to BIT data type.
We add a feather that binary(MYSQL) can be transformed into char(CUBRID)

Show
曹轶麟 added a comment - The data was not lost in the migration,It just was turned to BIT data type. We add a feather that binary(MYSQL) can be transformed into char(CUBRID)
Hide
Permalink
高艳铭 added a comment - - edited

When change binary(255) to char(255),it will lost some character.It became"estchangdTestchangdTestchangdTestchangdTestchangdTestchangdTestchangdTestchangdTestchangdTestchangdTestchangdTestchangdTestchangdTestchangdTestchangdTestchangdTestchangdTestchangdTestchangdTestchangdTestchangdTestchangdTestchangd��stchangdTestchangdTe"

Show
高艳铭 added a comment - - edited When change binary(255) to char(255),it will lost some character.It became"estchangdTestchangdTestchangdTestchangdTestchangdTestchangdTestchangdTestchangdTestchangdTestchangdTestchangdTestchangdTestchangdTestchangdTestchangdTestchangdTestchangdTestchangdTestchangdTestchangdTestchangdTestchangdTestchangd��stchangdTestchangdTe"
Hide
Permalink
高艳铭 added a comment -

From xml to cubrid, it is same.

Show
高艳铭 added a comment - From xml to cubrid, it is same.
Hide
Permalink
曹轶麟 added a comment -

About XML refer to TOOLS-412

Show
曹轶麟 added a comment - About XML refer to TOOLS-412
Hide
Permalink
孙泽玺 added a comment -

fixed in the version of cmt2.0.0.5131

Show
孙泽玺 added a comment - fixed in the version of cmt2.0.0.5131

People

  • Assignee:
    孙泽玺
    Reporter:
    高艳铭
Vote (0)
Watch (0)

Dates

  • Due:
    Created:
    Updated:
    Resolved: