yusicheng created IOTDB-1580:
--------------------------------
Summary: sort by time error when enable time partition
Key: IOTDB-1580
URL: https://issues.apache.org/jira/browse/IOTDB-1580
Project: Apache IoTDB
Issue Type: Bug
Affects Versions: master branch
Reporter: yusicheng
step1. change IoTDBConfig parameter
{code:java}
enablePartition = false -> enablePartition = true
partitionInterval = 604800 -> partitionINterval = 2592000
{code}
step2. execute following sql
{code:sql}
set storage group to root.group_1
create timeseries root.group_1.d_1.s_0 with datatype = boolean
create timeseries root.group_1.d_1.s_1 with datatype = INT32
create timeseries root.group_1.d_1.s_2 with datatype = float
insert into root.group_1.d_1(timestamp, s_1, s_0, s_2)
values(2018-07-18T00:00:00.000+08:00, 18, false, 18.18)
flush
insert into root.group_1.d_1(timestamp, s_1, s_0, s_2)
values(2018-07-19T00:00:00.000+08:00, 19, false, 19.18)
flush
insert into root.group_1.d_1(timestamp, s_1, s_0, s_2)
values(2019-07-19T00:00:00.000+08:00, 2019, false, 19.18)
insert into root.group_1.d_1(timestamp, s_1, s_0, s_2)
values(2019-08-19T00:00:00.000+08:00, 2018, false, 19.18)
select * from root.group_1.d_1 order by time desc
{code}
step3. we can find that the result looks like this
+-----------------------------+--------------------+--------------------+--------------------+
|
Time|root.group_1.d_1.s_1|root.group_1.d_1.s_0|root.group_1.d_1.s_2|
+-----------------------------+--------------------+--------------------+--------------------+
|2018-07-19T00:00:00.000+08:00| 19| false|
19.18|
|2018-07-18T00:00:00.000+08:00| 18| false|
18.18|
|2019-08-19T00:00:00.000+08:00| 2018| false|
19.18|
|2019-07-19T00:00:00.000+08:00| 2019| false|
19.18|
+-----------------------------+--------------------+--------------------+--------------------+
obviously, the result is not sorted by time desc
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
