Details
-
Type:
Bug
-
Status:
Closed
-
Priority:
Major
-
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 one table
CREATE TABLE `code` (
`s_name` char(1) NOT NULL,
`f_name` char(6) DEFAULT NULL,
PRIMARY KEY (`s_name`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
INSERT INTO `code` VALUES ('B', 'Bronze');
INSERT INTO `code` VALUES ('G', 'Gold');
INSERT INTO `code` VALUES ('M', 'Man');
INSERT INTO `code` VALUES ('S', 'Silver');
INSERT INTO `code` VALUES ('W', 'Woman');
INSERT INTO `code` VALUES ('X', 'Mixed');
2 Create view
create view gao as select * from code;
3 Do migration
Goto step 2,choose utf-8
Goto step 4, click multiplication, the views data type doesn't became.
Addtional
1 If it doesn't change, when add long string to cubrid, the view will see part of the string.
2 SQL,FK,Index has been changed.
Issue Links
- is cloned by
-
TOOLS-287
[CMT][BUG]When multitype in tables, the view hasn't multitype.
-
The function of editing view's columns was removed.
This function doesn't make sense for the migration.