[jira] [Created] (IOTDB-3381) There is still an error when executing the query of the constant sequence generation function

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

xiaozhihong created IOTDB-3381:
----------------------------------

             Summary: There is still an error when executing the query of the constant sequence generation function
                 Key: IOTDB-3381
                 URL: https://issues.apache.org/jira/browse/IOTDB-3381
             Project: Apache IoTDB
          Issue Type: Bug
          Components: Core/Cluster, mpp-cluster
    Affects Versions: 0.14.0-SNAPSHOT
            Reporter: xiaozhihong
            Assignee: Steve Yurong Su
         Attachments: logs.zip

Start 3 confignodes, 3 datanodes, execute SQL, then reported error message.
{code:java}
IoTDB> select s1, s2, const(s1, 'value'='1024', 'type'='INT64'), pi(s2), e(s1, s2) from root.sg.d1; 
Msg: 500: [INTERNAL_SERVER_ERROR(500)] Exception occurred: "select s1, s2, const(s1, 'value'='1024', 'type'='INT64'), pi(s2), e(s1, s2) from root.sg.d1". executeStatement failed. error code: TSStatus(code:411, message:Fragment cannot be dispatched)
 {code}
The steps to reproduce are as follows:

step 1 : start 3 confignodes, 3 datanodes

step 2: enter cli,  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;{code}
{code:java}
insert into root.sg.d1(time,s1,s2,s3,s4,s5,s6) values(1,1.1,2.2,TRUE,'warn:1731',12,20);
insert into root.sg.d1(time,s1,s2,s3,s4,s5,s6) values(2,2.2,3.3,FALSE,'warn:-8721',22,14);
insert into root.sg.d1(time,s1,s2,s3,s4,s5,s6) values(3,2.5,2.2,TRUE,'error:-37229',14,22);
insert into root.sg.d1(time,s1,s2,s3,s4,s5,s6) values(4,2.6,3.3,FALSE,'warn:1731',23,14);
insert into root.sg.d1(time,s1,s2,s3,s4,s5,s6) values(5,1.1,2.2,TRUE,'warn:1731',12,20);
insert into root.sg.d1(time,s1,s2,s3,s4,s5,s6) values(6,2.2,3.3,FALSE,'warn:-8721',22,14);
insert into root.sg.d1(time,s1,s2,s3,s4,s5,s6) values(7,2.5,2.2,TRUE,'warn:1731',14,22);
insert into root.sg.d1(time,s1,s2,s3,s4,s5,s6) values(8,2.6,3.3,FALSE,'error:-37229',23,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); {code}
{code:java}
select s1, s2, const(s1, 'value'='1024', 'type'='INT64'), pi(s2), e(s1, s2) from root.sg.d1; 
{code}

log information view attachment.



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