[jira] [Commented] (IOTDB-1209) When loading a tsfile with a large timestamp, the data is incorrect

["Eric Pai (Jira)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/IOTDB-1209?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17311137#comment-17311137 ] 

Eric Pai commented on IOTDB-1209:
---------------------------------

It's weird. I can help to investigate this issue if no one haven't started this yet.

> When loading a tsfile with a large timestamp, the data is incorrect
> -------------------------------------------------------------------
>
>                 Key: IOTDB-1209
>                 URL: https://issues.apache.org/jira/browse/IOTDB-1209
>             Project: Apache IoTDB
>          Issue Type: Bug
>    Affects Versions: 0.11.2
>            Reporter: Houliang Qi
>            Priority: Critical
>         Attachments: 1.1.png, 1.2.png, 1.3.png, 1.4.png, 1.5.png, 1678502448000-1-0.tsfile
>
>
> Step 1： 
>  # 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
> !1.1.png!
>  
> Step2：
> load one tsfile which the tsfile name have a  large timestamp, but its data's timestamp are small. 
>  #  load "../1678502448000-1-0.tsfile" 
>  # !1.2.png!
>  # after load the tsfile, we can see that the root.group_1.d_1 has 3 rows as below. 
>  # !1.3.png!
>  
> Step3：insert another two rows
>  # 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)
>  # we can see that the query result  is rowng when we query the root.group_1.d_1
> !1.4.png!
>  
> Step4 : Query with the order by time keyword, we can see from the result that it have two problems:
>  #  it's not ordered by time
>  # time value of time 2018-07-18T00:00:00.000+08:00 （s1, s_0, s2）are (18, false, 18.18 ) which we insert in step one, however, the result show is another vlaue.
>   !1.5.png!
>  
>  
>  



--
This message was sent by Atlassian Jira
(v8.3.4#803005)