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

["Yukun Zhou (Jira)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/IOTDB-5961?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17730447#comment-17730447 ] 

Yukun Zhou commented on IOTDB-5961:
-----------------------------------

https://github.com/apache/iotdb/pull/10061

> 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
>            Priority: Major
>              Labels: view
>         Attachments: image-2023-06-01-10-06-09-132.png, image-2023-06-01-10-07-36-404.png, screenshot-1.png
>
>
> 测试版本：iotdb_master_0601_81f541d
> 有2个问题：
> cli执行报错不对。
> 指定占位符 ，创建view 不成功。
> 研发功能定义文档描述：
>  !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}*//下面这个语句是在cli中执行，这个bug 需要cli来解决*{color}
> {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! 
> {color:#DE350B}*// 指定占位符的创建方式，怎么才能执行成功*{color}
>  ./sbin/start-cli.sh  -h 172.20.70.3 -e " CREATE VIEW root.db.view(${2}_temperature) AS SELECT temperature FROM root.db.*;"
> Msg: 300: The number of target and source paths are miss matched! Please check your SQL.
>  !screenshot-1.png! 



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