Chao Wang created IOTDB-4063:
--------------------------------
Summary: An error is reported when data from version 0.12 is
exported to version 0.14.
Key: IOTDB-4063
URL: https://issues.apache.org/jira/browse/IOTDB-4063
Project: Apache IoTDB
Issue Type: Bug
Components: Tools/Others
Reporter: Chao Wang
Fix For: 0.14.0
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.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
