[IOTDB-5957] Failed to insert into the alias series on the first attempt, succeeded on the second attempt

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.2
• Component/s: Core/Server, mpp-cluster
• Labels: view
• Assignee: Xingyu Liu
• Reporter: 刘珍
• Created: 31/May/23 08:49
• Updated: 14/Jun/23 14:27
• Resolved: 14/Jun/23 14:27

Description

问题描述：向别名序列insert，相同的SQL，第一次执行报错，第2次执行成功。
测试版本：iotdb_master_0531_fc2746e]

drop database root.1Y ;
drop database root.0Y ;
create database root.1Y ;
create database root.0Y ;
create ALIGNED timeseries root.1Y.2MO(1Y DOUBLE compressor=SNAPPY,2MO DOUBLE ENCODING=RLE compressor=LZ4,3W DOUBLE ENCODING=TS_2DIFF compressor=GZIP,4D DOUBLE ENCODING=GORILLA compressor=ZSTD,5H DOUBLE ENCODING=FREQ compressor=LZMA2,6M DOUBLE ENCODING=CHIMP compressor=UNCOMPRESSED,7S DOUBLE ENCODING=SPRINTZ compressor=LZ4,8MS DOUBLE ENCODING=RLBE compressor=GZIP,9US DOUBLE compressor=ZSTD,10NS DOUBLE compressor=LZMA2,11ns DOUBLE compressor=SNAPPY,12us DOUBLE compressor=UNCOMPRESSED) ;
insert into root.1Y.2MO(time,1Y) ALIGNED values(1,1.1);
insert into root.1Y.2MO(time,2MO) ALIGNED values(1,1.1);
insert into root.1Y.2MO(time,3W) ALIGNED values(2,2.1);
insert into root.1Y.2MO(time,4D) ALIGNED values(2,2.1);
insert into root.1Y.2MO(time,5H) ALIGNED values(3,3.1);
insert into root.1Y.2MO(time,6M) ALIGNED values(3,3.1);
insert into root.1Y.2MO(time,7S) ALIGNED values(4,4.1);
insert into root.1Y.2MO(time,8MS) ALIGNED values(4,4.1);
insert into root.1Y.2MO(time,9US) ALIGNED values(5,5.1);
insert into root.1Y.2MO(time,10NS) ALIGNED values(5,5.1);
insert into root.1Y.2MO(time,11ns) ALIGNED values(6,6.1);
insert into root.1Y.2MO(time,12us) ALIGNED values(6,6.1);
select * from root.1Y.2MO;
flush;
select * from root.1Y.2MO;
create view root.0Y.2MO(1Y ,2MO ,3W ,4D ,5H ,6M,7S ,8MS ,9US ,10NS ,11ns ,12us ) as root.1Y.2MO(1Y,2MO ,3W ,4D ,5H ,6M,7S ,8MS ,9US ,10NS ,11ns ,12us );
select 1Y ,2MO ,3W ,4D ,5H ,6M,7S ,8MS ,9US ,10NS ,11ns ,12us from root.1Y.*,root.0Y.*;
下面的2条sql在cli 串行执行。
IoTDB> insert into root.0Y.2MO(time,1Y ,2MO ,3W ,4D ,5H ,6M,7S ,8MS ,9US ,10NS ,11ns ,12us) aligned values(2,2.2,2.3,2.4,2.5,2.6,2.7,2.8,2.9,21.1,22.2,22.3,22.4);
Msg: 609: timeseries under this device are not aligned, please use non-aligned interface (Path: root.0Y.2MO)
IoTDB>
IoTDB> insert into root.0Y.2MO(time,1Y ,2MO ,3W ,4D ,5H ,6M,7S ,8MS ,9US ,10NS ,11ns ,12us) aligned values(2,2.2,2.3,2.4,2.5,2.6,2.7,2.8,2.9,21.1,22.2,22.3,22.4);
Msg: The statement is executed successfully.
insert into root.0Y.2MO(time,1Y ,2MO ,3W ,4D ,5H ,6M,7S ,8MS ,9US ,10NS ,11ns ,12us) aligned values(2,2.2,2.3,2.4,2.5,2.6,2.7,2.8,2.9,21.1,22.2,22.3,22.4);
insert into root.0Y.2MO(time,1Y ,2MO ,3W ,4D ,5H ,6M,7S ,8MS ,9US ,10NS ,11ns ,12us) aligned values(2,2.2,2.3,2.4,2.5,2.6,2.7,2.8,2.9,21.1,22.2,22.3,22.4);