[jira] [Created] (IOTDB-5539) An exception occurred while select into

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

xiaozhihong created IOTDB-5539:
----------------------------------

             Summary: An exception occurred while select into 
                 Key: IOTDB-5539
                 URL: https://issues.apache.org/jira/browse/IOTDB-5539
             Project: Apache IoTDB
          Issue Type: Bug
          Components: mpp-cluster
    Affects Versions: master branch
            Reporter: xiaozhihong
            Assignee: Minghui Liu
         Attachments: image-2023-02-15-11-16-21-822.png

branch : Master
commit eaee1d8dbf832d96098f699d3143bf4a3d917dd7
Executing select into SQL, then an exception occurred.

The SQL is:
{code:java}
create database root.sg;
create database root.ln;
CREATE TIMESERIES root.sg.d1.s1 WITH DATATYPE=INT64, ENCODING=RLE;
CREATE TIMESERIES root.sg.d1.s2 WITH DATATYPE=FLOAT, ENCODING=RLE;
CREATE TIMESERIES root.sg.d1.s3 WITH DATATYPE=TEXT, ENCODING=PLAIN;
CREATE TIMESERIES root.sg.d2.s1 WITH DATATYPE=INT64, ENCODING=RLE;
CREATE TIMESERIES root.sg.d2.s2 WITH DATATYPE=FLOAT, ENCODING=RLE;
CREATE TIMESERIES root.sg.d2.s3 WITH DATATYPE=TEXT, ENCODING=PLAIN;
CREATE TIMESERIES root.ln.wf01.wt01.temperature WITH DATATYPE=FLOAT, ENCODING=RLE;
CREATE TIMESERIES root.ln.wf01.wt01.status WITH DATATYPE=BOOLEAN, ENCODING=PLAIN;

insert into root.sg.d1(time,s1,s2,s3) values(1,1,1.1,'001'),(2,-1,-1.1,'false');
insert into root.sg.d1(time,s1,s2,s3) values(3,3,5.1,'1'),(4,11,12.1,'2'),(5,9,10.1,'true');
insert into root.sg.d1(time,s1,s2,s3) values(6,1531604122307244742,0.0,'warn:-8721');
insert into root.sg.d1(time,s1,s2,s3) values(7,-8581625725655917595,1.0,'error:-37229');
insert into root.sg.d1(time,s1,s2,s3) values(8,-7162825364312197604,0.0,'warn:1731');
insert into root.sg.d1(time,s1,s2,s3) values(9,0,1.0,'test');
insert into root.sg.d1(time,s1,s2,s3) values(10,1,0.0,'111');
insert into root.sg.d2(time,s1,s2,s3) values(1,10,0.5,'15');
insert into root.sg.d2(time,s1,s2,s3) values(2,12,null,'test');
insert into root.sg.d2(time,s1,s2,s3) values(3,null,11.1,'abcc');
insert into root.sg.d2(time,s1,s2,s3) values(4,25,null,'abccadd');
insert into root.sg.d2(time,s1,s2,s3) values(5,100,-2.15,'test');
insert into root.sg.d2(time,s1,s2,s3) values(6,0,0.15,'abc');
insert into root.ln.wf01.wt01(time,temperature,status) values(1,1.0,false),(2,0.0,true),(3,-1.0,false);

select d1.s1, d1.s2, d2.s1, d1.s2 into ::(s1_1, s2_2), root.sg.d2_2(s3_3), root.${2}_copy.::(s4) from root.sg;
select * from root.**; {code}

The log is:
!image-2023-02-15-11-16-21-822.png|width=531,height=189!

 



--
This message was sent by Atlassian Jira
(v8.20.10#820010)