[
https://issues.apache.org/jira/browse/IOTDB-5718?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17704049#comment-17704049
]
刘珍 commented on IOTDB-5718:
---------------------------
master 0323 6ed0106 ,已解决。
!screenshot-1.png!
> Time order bug while using align by device
> ------------------------------------------
>
> Key: IOTDB-5718
> URL: https://issues.apache.org/jira/browse/IOTDB-5718
> Project: Apache IoTDB
> Issue Type: Bug
> Components: Core/Query
> Reporter: Yuan Tian
> Assignee: yang caiyin
> Priority: Major
> Labels: pull-request-available
> Attachments: image-2023-03-23-10-03-24-601.png, screenshot-1.png
>
>
> 1C1D IoTDB
> change the following two configuration in iotdb-common.properties
>
> data_region_group_extension_policy=CUSTOM
> default_data_region_group_num_per_database=3
>
> Then, execute the following sqls
>
> ```
> insert into root.db.d1(time,s1) values(2018-08-30T08:00:01.000+08:00, 10);
> insert into root.db.d1(time,s1) values(2018-09-30T08:00:01.000+08:00, 10);
> insert into root.db.d1(time,s1) values(2018-10-07T08:00:01.000+08:00, 10);
> insert into root.db.d1(time,s1) values(2018-10-15T08:00:01.000+08:00, 10);
> insert into root.db.d1(time,s1) values(2018-10-25T08:00:01.000+08:00, 10);
> insert into root.db.d1(time,s1) values(2018-11-03T08:00:01.000+08:00, 10);
> insert into root.db.d1(time,s1) values(2018-11-13T08:00:01.000+08:00, 10);
> flush;
> ```
>
> After inserting the data, you can execute the align by device query and see
> the wrong time ordering
>
> ```
> select s1 from root.db.d1 align by device;
> ```
> while we don't add align by device, the result is right.
> !image-2023-03-23-10-03-24-601.png!
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
