[GitHub] [iotdb] 23931017wu commented on pull request #6158: [IOTDB-3168] Fix the path with * could be executed successfully when inserting in version 14.

[GitBox <gi...@apache.org>]

23931017wu commented on PR #6158:
URL: https://github.com/apache/iotdb/pull/6158#issuecomment-1146644560

   
   The state before modification
   
   IoTDB> create timeseries root.test.*.a.b
   create timeseries root.test.*.a.b
   Msg: 401: Error occurred while parsing SQL to physical plan: line 1:28 no viable alternative at input '.*'
   IoTDB> insert into root.test.*.a(timestamp, b) values(1509465600000, true)
   insert into root.test.*.a(timestamp, b) values(1509465600000, true)
   Msg: The statement is executed successfully.
   IoTDB> show timeseries root.**
   show timeseries root.**
   +---------------+-----+-------------+--------+--------+-----------+----+----------+
   |     timeseries|alias|storage group|dataType|encoding|compression|tags|attributes|
   +---------------+-----+-------------+--------+--------+-----------+----+----------+
   |root.test.*.a.b| null|    root.test| BOOLEAN|     RLE|     SNAPPY|null|      null|
   +---------------+-----+-------------+--------+--------+-----------+----+----------+
   Total line number = 1
   It costs 2.721s
   IoTDB> 
   ![image](https://user-images.githubusercontent.com/71131924/172015284-cb3b5434-82fe-437f-8eb3-61ff4783e345.png)
   
   The state after modification：
   
   IoTDB> create timeseries root.test.*.a.b
   create timeseries root.test.*.a.b
   Msg: 401: Error occurred while parsing SQL to physical plan: line 1:28 no viable alternative at input '.*'
   IoTDB> insert into root.test.*.a(timestamp, b) values(1509465600000, true)
   insert into root.test.*.a(timestamp, b) values(1509465600000, true)
   Msg: 315: root.test.*.a is not a legal path, because * is an illegal name.
   IoTDB> show timeseries root.test
   show timeseries root.test
   +----------+-----+-------------+--------+--------+-----------+----+----------+
   |timeseries|alias|storage group|dataType|encoding|compression|tags|attributes|
   +----------+-----+-------------+--------+--------+-----------+----+----------+
   +----------+-----+-------------+--------+--------+-----------+----+----------+
   Empty set.
   It costs 0.004s
   IoTDB> 
   
   ![image](https://user-images.githubusercontent.com/71131924/172015392-f4b329f7-2f96-4022-aa83-baf0ae599cd2.png)
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: reviews-unsubscribe@iotdb.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org