xiaozhihong created IOTDB-5837:
----------------------------------
Summary: Exceptions for select into using placeholders
Key: IOTDB-5837
URL: https://issues.apache.org/jira/browse/IOTDB-5837
Project: Apache IoTDB
Issue Type: Bug
Components: Core/Query
Affects Versions: master
Reporter: xiaozhihong
Assignee: Minghui Liu
Attachments: image-2023-04-28-16-35-29-407.png
Branch ： Master
commit 17711231b881f4fb3bca7a7a5c324df172721d39
The target device uses variable placeholders & the target measurement does not
use variable placeholders, then execute SQL report exception.
Start 1C1D, Enter CLI to execute SQL.
{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 * from root.**;
IoTDB> select avg(s1), sum(s1) + sum(s1), count(s3) into
root.agg_${2}.::(avg_s1, sum_s1_add_s1, count_s3) from root.sg.d1, root.sg.d2
align by device;
Msg: 301: org.apache.iotdb.tsfile.read.common.block.column.DoubleColumn {code}
!image-2023-04-28-16-35-29-407.png|width=560,height=207!
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
