[IOTDB-4063] An error is reported when data from version 0.12 is exported to version 0.14.

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Fix Version/s: 0.14.0
• Component/s: Tools/Others
• Assignee: Unassigned Assign to me
• Reporter: Chao Wang
• Created: 08/Aug/22 09:54
• Updated: 08/Aug/22 09:54

Description

1.  execute in 0.12 version

INSERT INTO root.sgcc.wf01.wt01(timestamp, ts0, ts1, ts2, ts3, ts4, ts5) VALUES (2022-05-27T23:50:00.000+08:00, true, 5, 23, 15.88, 8888.88, "IOTDB!IOTDB12345");
INSERT INTO root.sgcc.wf01.wt01(timestamp, ts0, ts1, ts2, ts3, ts4, ts5) VALUES (2022-05-26T23:50:00.000+08:00, 1, 11, 8, 88.88, 8888.88, "IOTDB!@#B12345");
INSERT INTO root.sgcc.wf01.wt01(timestamp, ts0, ts1, ts2, ts3, ts4, ts5) VALUES (2022-05-22T00:00:00.000+08:00, true, 12, 25, 88.88, 8888.88, "12345");
INSERT INTO root.sgcc.wf01.wt01(timestamp, ts0, ts1, ts2, ts3, ts4, ts5) VALUES (2022-05-20T23:01:14.857+08:00, 0, 3, 15, 88.88, 8888.88, "@#$%IOTDB");
INSERT INTO root.sgcc.wf01.wt01(timestamp, ts0, ts1, ts2, ts3, ts4, ts5) VALUES (2022-05-20T16:05:02.001+08:00, 1, 7, 88, 83.08, 8888.88, "IOTDB!@#$%IOTDB!@#$%IOTDB12345");
INSERT INTO root.sgcc.wf01.wt01(timestamp, ts0, ts1, ts2, ts3, ts4, ts5) VALUES (2022-05-21T01:05:02.258+08:00, false, 9, 24, 88.88, 8888.88, "@#$%!@#$%12345");
INSERT INTO root.sgcc.wf01.wt01(timestamp, ts0, ts1, ts2, ts3, ts4, ts5) VALUES (2022-05-21T08:40:04.147+08:00, true, 10, 36, 88.88, 8888.88, "IOTDB!@#$%&IOTDB!@#$%IOTDB12345");
INSERT INTO root.sgcc.wf01.wt01(timestamp, ts0, ts1, ts2, ts3, ts4, ts5) VALUES (2022-05-21T08:39:04.147+08:00, false, 2, 36, 88.88, 8888.88, "IOTDBexcellent");
INSERT INTO root.sgcc.wf01.wt01(timestamp, ts0, ts1, ts2, ts3, ts4, ts5) VALUES (2022-05-21T08:40:25.976+08:00, false, 7, 36, 88.88, 8888.88, "GoodIOTDB12345");
INSERT INTO root.sgcc.wf01.wt01(timestamp, ts0, ts1, ts2, ts3, ts4, ts5) VALUES (2022-05-21T08:56:56.249+08:00, true, 14, 36, 88.88, 8888.88, "Hello_word");
INSERT INTO root.sgcc.wf01.wt01(timestamp, ts0, ts1, ts2, ts3, ts4, ts5) VALUES (2022-05-21T08:57:40.256+08:00, true, 14, 36, 88.88, 8888.88, "Nihao!");
INSERT INTO root.sgcc.wf01.wt01(timestamp, ts0, ts1, ts2, ts3, ts4, ts5) VALUES (2022-05-21T08:58:55.260+08:00, true, 14, 36, 88.88, 8888.88, "My&Name&Is&gaga");

 

2. ./export-csv.sh -h XXXXXXXX -p XXXX

 

3. in 0.14 version

./import-csv.sh -h XXXX -p XXXX

 

Import the data created in 313 to 320. The data is incompatible. The data type and encoding mode are changed. The data type changes from float to double and text to int32. The encoding mode is changed from PLAIN to RLE.