刘珍 created IOTDB-5938:
-------------------------
Summary: select into view (alias series) : The data type of
target path is recognized as BOOLEAN
Key: IOTDB-5938
URL: https://issues.apache.org/jira/browse/IOTDB-5938
Project: Apache IoTDB
Issue Type: Bug
Components: Core/Server, mpp-cluster
Affects Versions: 1.2
Reporter: 刘珍
Assignee: Yukun Zhou
Attachments: image-2023-05-30-13-56-06-712.png
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;
{color:#DE350B}*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]).
*{color}
!image-2023-05-30-13-56-06-712.png!
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
