[IOTDB-5938] select into view (alias series) : The data type of target path is recognized as BOOLEAN - ASF JIRA

XML

Word

Printable

JSON

Details

Type: Bug
Status: Resolved
Priority: Major
Resolution: Fixed
Affects Version/s: 1.2
Fix Version/s: None
Component/s: Core/Server, mpp-cluster
Labels:
- pull-request-available
- view

Description

iotdb master 0528_84780e2。
select into 别名序列报错，别名序列的数据类型被识别为BOOLEAN
drop database root.view;
drop database root.db;
create database root.db;
create database root.view;

create timeseries root.db.device.s01 with datatype=INT32;
create timeseries root.db.device.s02 with datatype=INT32;
CREATE VIEW root.view.device.status AS SELECT s01 FROM root.db.device;
insert into root.db.device(time,s02) values(1,1);
select s01,s02 from root.db.device;
select status from root.view.device;
select s02 into root.view.device(status) from root.db.device;
*Msg: 701: The data type of target path (root.view.device.status[BOOLEAN]) is not compatible with the data type of source column (root.db.device.s02[INT32]).
*