Details
-
Type:
Bug
-
Status:
Closed
-
Priority:
Major
-
Resolution: Won't Fix
-
Affects Version/s: None
-
Fix Version/s: CMT8.4.1.201211
-
Component/s: CUBRID Migration Toolkit
-
Labels:
-
Environment:
jdk 1.6.0_21
Description
1.From mysql xml to cvs:set_type will popup Error window:NullPointerException.
You can use xml below to reproduce this issue,and please use jdk 1.6.
<table_structure name="set_type">
<field Field="set_type" Type="set('','abcdefghijklmnopqrstuvwxyzabcdefghijklmnopqrstuvwxyzabcdefghijklmnopqrstuvwxyzabcdefghijklmnopqrstuvwxyzabcdefghijklmnopqrstuvwxyzabcdefghijklmnopqrstuvwxyzabcdefghijklmnopqrstuvwxyzabcdefghijklmnopqrstuvwxyzabcdefghijklmnopqrstuvwxyzabcdefghijklmnopqrstu','j','i','h','g','f','e','c','d','b','a','sf','dsd')" Null="NO" Key="PRI" Extra="" />
<field Field="set_type_number" Type="set('-0999999999999999999999999999999999999999999999999','-0x3232434234','0x21235564767878','0222333','123','-9999999999999999999999999999999999999999999999999999999999999','999999999999999999999999999999999999999999999999999999999999999999999','-1111111111111111111111111111111111111111111111111111111111111','-111','2','1')" Null="YES" Key="" Extra="" />
<key Table="set_type" Non_unique="0" Key_name="PRIMARY" Seq_in_index="1" Column_name="set_type" Collation="A" Cardinality="4" Null="" Index_type="BTREE" Comment="" Index_comment="" />
<options Name="set_type" Engine="InnoDB" Version="10" Row_format="Compact" Rows="4" Avg_row_length="4096" Data_length="16384" Max_data_length="0" Index_length="0" Data_free="23068672" Create_time="2012-06-20 07:00:24" Collation="latin1_swedish_ci" Create_options="" Comment="" />
</table_structure>
<table_data name="set_type">
<row>
<field name="set_type">h</field>
<field name="set_type_number">-0999999999999999999999999999999999999999999999999</field>
</row>
<row>
<field name="set_type">h,g,f,e</field>
<field name="set_type_number">0x21235564767878,0222333,123,-111,2,1</field>
</row>
<row>
<field name="set_type">sf</field>
<field name="set_type_number">999999999999999999999999999999999999999999999999999999999999999999999</field>
</row>
<row>
<field name="set_type">abcdefghijklmnopqrstuvwxyzabcdefghijklmnopqrstuvwxyzabcdefghijklmnopqrstuvwxyzabcdefghijklmnopqrstuvwxyzabcdefghijklmnopqrstuvwxyzabcdefghijklmnopqrstuvwxyzabcdefghijklmnopqrstuvwxyzabcdefghijklmnopqrstuvwxyzabcdefghijklmnopqrstuvwxyzabcdefghijklmnopqrstu,dsd</field>
<field name="set_type_number">-0x3232434234</field>
</row>
</table_data>
2.From mysql xml to sql: table:blogtopic will popup Error window:NullPointerException.
You can use xml below to reproduce this issue,and please use jdk 1.6.
<table_structure name="blogtopic">
<field Field="topicId" Type="int(11)" Null="YES" Key="MUL" Extra="" />
<field Field="postDate" Type="date" Null="YES" Key="" Extra="" />
<field Field="closedDate" Type="date" Null="YES" Key="" Extra="" />
<key Table="blogtopic" Non_unique="1" Key_name="my_filter_index" Seq_in_index="1" Column_name="topicId" Collation="A" Cardinality="1" Null="YES" Index_type="BTREE" Comment="" Index_comment="" />
<key Table="blogtopic" Non_unique="1" Key_name="my_filter_index" Seq_in_index="2" Column_name="postDate" Collation="A" Cardinality="1" Null="YES" Index_type="BTREE" Comment="" Index_comment="" />
<key Table="blogtopic" Non_unique="1" Key_name="my_filter_index" Seq_in_index="3" Column_name="closedDate" Collation="A" Cardinality="1" Null="YES" Index_type="BTREE" Comment="" Index_comment="" />
<options Name="blogtopic" Engine="InnoDB" Version="10" Row_format="Compact" Rows="1" Avg_row_length="16384" Data_length="16384" Max_data_length="0" Index_length="16384" Data_free="23068672" Create_time="2012-06-20 07:00:22" Collation="utf8_general_ci" Create_options="" Comment="" />
</table_structure>
<table_data name="blogtopic">
<row>
<field name="topicId">1</field>
<field name="postDate">2010-01-01</field>
<field name="closedDate">2010-01-02</field>
</row>
</table_data>
You can use the xml in attachmen mysql1106.zip to reproduce the issue. You can only use table:set_type and blogtopic.