[jira] [Assigned] (IOTDB-3598) Arithmetic query on time series of different paths， query result maybe has result or maybe get error.

["Yuan Tian (Jira)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/IOTDB-3598?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Yuan Tian reassigned IOTDB-3598:
--------------------------------

    Assignee: Yuan Tian  (was: 李伟豪)

> Arithmetic query on time series of different paths， query result maybe has result or maybe get error. 
> ------------------------------------------------------------------------------------------------------
>
>                 Key: IOTDB-3598
>                 URL: https://issues.apache.org/jira/browse/IOTDB-3598
>             Project: Apache IoTDB
>          Issue Type: Bug
>          Components: Core/Cluster, mpp-cluster
>    Affects Versions: 0.14.0-SNAPSHOT
>            Reporter: xiaozhihong
>            Assignee: Yuan Tian
>            Priority: Major
>         Attachments: 31-2-log_all.log, 31-3-log_all-1.log, 31-3-log_all.log, 31-6-log_all.log, image-2022-06-22-15-15-27-705.png
>
>
> Cluster execution of expression queries, when executing arithmetic queries of different paths, the query results are very strange, sometimes there are results and sometimes errors are reported.
> !image-2022-06-22-15-15-27-705.png|width=530,height=238!
> The steps to reproduce are as follows：
> step 1: start 3 confignodes and 3 datanodes
> step 2: choose 1 DataNode，enter CLI
> step 3: execute SQL
> {code:java}
> create storage group root.sg;
> create timeseries root.sg.d1.s1 with datatype=float,encoding=RLE;
> create timeseries root.sg.d1.s2 with datatype=double,encoding=RLE;
> create timeseries root.sg.d1.s3 with datatype=BOOLEAN,encoding=RLE;
> create timeseries root.sg.d1.s4 with datatype=TEXT,encoding=PLAIN;
> create timeseries root.sg.d1.s5 with datatype=INT32,encoding=RLE;
> create timeseries root.sg.d1.s6 with datatype=INT64,encoding=RLE;
> create timeseries root.sg.d2.s1 with datatype=INT64,encoding=RLE;
> create timeseries root.sg.d2.s2 with datatype=float,encoding=RLE;{code}
> {code:java}
> insert into root.sg.d1(time,s1,s2,s3,s4,s6) values(1,1.1,2.2,TRUE,'warn:1731',20);
> insert into root.sg.d1(time,s1,s2,s3,s4,s6) values(20,2.2,3.3,FALSE,'warn:-8721',14);
> insert into root.sg.d1(time,s1,s2,s3,s4,s6) values(35,2.5,2.2,TRUE,'error:-37229',22);
> insert into root.sg.d1(time,s1,s2,s3,s4,s6) values(49,2.6,3.3,FALSE,'warn:1731',14);
> insert into root.sg.d1(time,s1,s2,s3,s4,s6) values(55,1.1,2.2,TRUE,'warn:1731',20);
> insert into root.sg.d1(time,s1,s2,s3,s4,s6) values(63,2.2,3.3,FALSE,'warn:-8721',14);
> insert into root.sg.d1(time,s1,s2,s3,s4,s6) values(79,2.5,2.2,TRUE,'warn:1731',22);
> insert into root.sg.d1(time,s1,s2,s3,s4,s6) values(80,2.6,3.3,FALSE,'error:-37229',14);
> insert into root.sg.d2(time,s1) values(1,12);
> insert into root.sg.d2(time,s1) values(2,32);
> insert into root.sg.d2(time,s1) values(1607603775000,1531604122307244742);
> insert into root.sg.d2(time,s1) values(1607603776000,-8581625725655917595);
> select s1 + s2 from root.sg.d1, root.sg.d2; {code}
> log information view attachment
>  



--
This message was sent by Atlassian Jira
(v8.20.7#820007)