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

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

xiaozhihong created IOTDB-3598:
----------------------------------

             Summary: 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: 李伟豪
         Attachments: 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)