[jira] [Created] (IOTDB-5961) Syntax error when specifying placeholders in create view statement.

["刘珍 (Jira)" <ji...@apache.org>]

刘珍 created IOTDB-5961:
-------------------------

             Summary: Syntax error when specifying placeholders in create view statement.
                 Key: IOTDB-5961
                 URL: https://issues.apache.org/jira/browse/IOTDB-5961
             Project: Apache IoTDB
          Issue Type: Bug
          Components: mpp-cluster
    Affects Versions: 1.2
            Reporter: 刘珍
            Assignee: Yukun Zhou
         Attachments: image-2023-06-01-10-06-09-132.png, image-2023-06-01-10-07-36-404.png

测试版本：iotdb_master_0601_81f541d
研发功能定义文档描述：
 !image-2023-06-01-10-06-09-132.png! 
实际创建失败，测试用例：
drop database root.db;
drop database root.view;
create database root.db;
create database root.view;
create timeseries root.db.d01.temperature with datatype=INT32;
create timeseries root.db.d01.speed with datatype=INT64;
create timeseries root.db.d02.temperature with datatype=INT32;
create timeseries root.db.d02.s02 with datatype=INT64;
create timeseries root.db.d02.s03 with datatype=INT64;

create timeseries root.db.d03.temperature with datatype=TEXT;
create timeseries root.db.d03.c02 with datatype=INT64;
create timeseries root.db.d03.c03 with datatype=INT64;

create timeseries root.db.d04.temperature with datatype=TEXT;
create timeseries root.db.d04.d02 with datatype=INT64;
create timeseries root.db.d04.d03 with datatype=INT64;

create timeseries root.db.d05.temperature with datatype=float;
create timeseries root.db.d06.temperature with datatype=double;
insert into root.db.d01(time,temperature,speed) values(1,20,80);
insert into root.db.d06(time,temperature) values(1685583924366,30);

{color:#DE350B}*CREATE VIEW root.db.view(${2}_temperature) AS SELECT temperature FROM root.db.*;
CREATE VIEW root.db.view(${2}_${3}) AS SELECT temperature from root.db.*;*{color}

Msg: 701: ${2}_temperature is illegal, unquoted node name can only consist of digits, characters and underscore, or start or end with wildcard

 !image-2023-06-01-10-07-36-404.png! 





--
This message was sent by Atlassian Jira
(v8.20.10#820010)