[IOTDB-5539] An exception occurred while select into

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: master branch
• Component/s: mpp-cluster
• Assignee: Minghui Liu
• Reporter: xiaozhihong
• Created: 15/Feb/23 03:19
• Updated: 02/Mar/23 10:06
• Resolved: 02/Mar/23 10:06

Description

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

The SQL is:

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.**; 

The log is: