Details
-
Type:
Bug
-
Status:
Closed
-
Priority:
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.4736
Description
1 Create table in mysql
CREATE TABLE `bittest` (
`BIT16` bit(16) DEFAULT NULL,
`BIT20` bit(20) DEFAULT NULL,
`BIT10` bit(10) DEFAULT NULL,
`BIT8` bit(8) DEFAULT NULL,
`BIT1` bit(1) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
insert into bittest(bit1) values(1),(0);
2 Do online database to cubrid
Actual result:
After migration, it will be pop error as attachment.
Additional
Use the table:
CREATE TABLE `bittest` (
`BIT16` bit(16) DEFAULT NULL,
`BIT20` bit(20) DEFAULT NULL,
`BIT10` bit(10) DEFAULT NULL,
`BIT8` bit(8) DEFAULT NULL,
`BIT1` bit(1) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
INSERT INTO `bittest` VALUES (b'1010101010101010',b'10101010101010101010',b'1010101010',b'10101010',b'1');
INSERT INTO `bittest` VALUES (b'1111111111111111',b'11111111111111111111',b'1111111111',b'11111111',b'0');
insert into `bittest`(bit1) VALUES (b'1');
All of the three records will be error.
mysql Jdbc will get the value of bit(1) as boolean