You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@iotdb.apache.org by 廖兰宇 <18...@smail.nju.edu.cn> on 2022/05/12 07:21:57 UTC

Discuss New Syntax Convention

Hi everybody,
We defined some complex syntax in ordered to be compatible with the older version. We are trying to update the Syntax Convention Part in the next version of IoTDB. Below is a list of changes between new Syntax Convention and old Syntax Convention.&nbsp;
Change list:
1. In quoted identifier, ` should be written as `` instead of \`. Also, in quoted identifier, ‘ and “ needs no special treatment and need not be doubled or escaped.
2. Identifier consists of digit is not allowed now. If you want to use 111 as an identifier, please quote it with ``, like `111`. ` will be a part of the quoted identifier, which means `identifier1` is not the same as identifier1.
3. Node name can not be quoted with ‘’ or “” now. If you want to use node name that contains special characters(including .), please quote it with ``.
4. String in IoTDB will not be unescaped. In the older version, if you insert data of Text type using SQL, it will be unescaped.
5. Alias can be both identifier and String now.
6. Role and User are identifiers now.
More details can be found at https://apache-iotdb.feishu.cn/docs/doccnjsAnItPKK6Wa80dI2dvykf#
Any comments would be much appreciated.
Best,
------------------------------------
Lanyu Liao
School of Software, NanJing University


廖兰宇
南京大学 软件学院

Re: Discuss New Syntax Convention

Posted by 廖兰宇 <18...@smail.nju.edu.cn>.
Yes, columnWrapper in this issue is no longer needed.
&nbsp;
&nbsp;
------------------&nbsp;Original&nbsp;------------------
From: &nbsp;"Eric&nbsp;Pai"<ericpai94@hotmail.com&gt;;
Date: &nbsp;Thu, May 12, 2022 03:38 PM
To: &nbsp;"dev"<dev@iotdb.apache.org&gt;; 

Subject: &nbsp;Re: Discuss New Syntax Convention

&nbsp;

Good work. After this patch is applied, could this issue(https://github.com/apache/iotdb/pull/5760) be solved properly?

在 2022/5/12 15:22，“廖兰宇”<181250082@smail.nju.edu.cn&gt; 写入:

&nbsp;&nbsp;&nbsp; Hi everybody,
&nbsp;&nbsp;&nbsp; We defined some complex syntax in ordered to be compatible with the older version. We are trying to update the Syntax Convention Part in the next version of IoTDB. Below is a list of changes between new Syntax Convention and old Syntax Convention.&amp;nbsp;
&nbsp;&nbsp;&nbsp; Change list:
&nbsp;&nbsp;&nbsp; 1. In quoted identifier, ` should be written as `` instead of \`. Also, in quoted identifier, ‘ and “ needs no special treatment and need not be doubled or escaped.
&nbsp;&nbsp;&nbsp; 2. Identifier consists of digit is not allowed now. If you want to use 111 as an identifier, please quote it with ``, like `111`. ` will be a part of the quoted identifier, which means `identifier1` is not the same as identifier1.
&nbsp;&nbsp;&nbsp; 3. Node name can not be quoted with ‘’ or “” now. If you want to use node name that contains special characters(including .), please quote it with ``.
&nbsp;&nbsp;&nbsp; 4. String in IoTDB will not be unescaped. In the older version, if you insert data of Text type using SQL, it will be unescaped.
&nbsp;&nbsp;&nbsp; 5. Alias can be both identifier and String now.
&nbsp;&nbsp;&nbsp; 6. Role and User are identifiers now.
&nbsp;&nbsp;&nbsp; More details can be found at https://nam12.safelinks.protection.outlook.com/?url=https%3A%2F%2Fapache-iotdb.feishu.cn%2Fdocs%2FdoccnjsAnItPKK6Wa80dI2dvykf%23&amp;amp;data=05%7C01%7C%7C9fac2e5807b044dc4ca908da33e822b6%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637879369382944586%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&amp;amp;sdata=%2BgEoBK9Sxg9zOI%2Far3PIbQ7q%2BUjZUI3Tu4X%2FC%2FAmW9o%3D&amp;amp;reserved=0
&nbsp;&nbsp;&nbsp; Any comments would be much appreciated.
&nbsp;&nbsp;&nbsp; Best,
&nbsp;&nbsp;&nbsp; ------------------------------------
&nbsp;&nbsp;&nbsp; Lanyu Liao
&nbsp;&nbsp;&nbsp; School of Software, NanJing University


&nbsp;&nbsp;&nbsp; 廖兰宇
&nbsp;&nbsp;&nbsp; 南京大学 软件学院

Re: Discuss New Syntax Convention

Posted by 廖兰宇 <18...@smail.nju.edu.cn>.
&nbsp;New Syntax Convention is still under discussion. Any suggestions would be appreciated.
&nbsp;
------------------&nbsp;Original&nbsp;------------------
From: &nbsp;"Eric&nbsp;Pai"<ericpai94@hotmail.com&gt;;
Date: &nbsp;Thu, May 12, 2022 03:38 PM
To: &nbsp;"dev"<dev@iotdb.apache.org&gt;; 

Subject: &nbsp;Re: Discuss New Syntax Convention

&nbsp;

Good work. After this patch is applied, could this issue(https://github.com/apache/iotdb/pull/5760) be solved properly?

在 2022/5/12 15:22，“廖兰宇”<181250082@smail.nju.edu.cn&gt; 写入:

&nbsp;&nbsp;&nbsp; Hi everybody,
&nbsp;&nbsp;&nbsp; We defined some complex syntax in ordered to be compatible with the older version. We are trying to update the Syntax Convention Part in the next version of IoTDB. Below is a list of changes between new Syntax Convention and old Syntax Convention.&amp;nbsp;
&nbsp;&nbsp;&nbsp; Change list:
&nbsp;&nbsp;&nbsp; 1. In quoted identifier, ` should be written as `` instead of \`. Also, in quoted identifier, ‘ and “ needs no special treatment and need not be doubled or escaped.
&nbsp;&nbsp;&nbsp; 2. Identifier consists of digit is not allowed now. If you want to use 111 as an identifier, please quote it with ``, like `111`. ` will be a part of the quoted identifier, which means `identifier1` is not the same as identifier1.
&nbsp;&nbsp;&nbsp; 3. Node name can not be quoted with ‘’ or “” now. If you want to use node name that contains special characters(including .), please quote it with ``.
&nbsp;&nbsp;&nbsp; 4. String in IoTDB will not be unescaped. In the older version, if you insert data of Text type using SQL, it will be unescaped.
&nbsp;&nbsp;&nbsp; 5. Alias can be both identifier and String now.
&nbsp;&nbsp;&nbsp; 6. Role and User are identifiers now.
&nbsp;&nbsp;&nbsp; More details can be found at https://nam12.safelinks.protection.outlook.com/?url=https%3A%2F%2Fapache-iotdb.feishu.cn%2Fdocs%2FdoccnjsAnItPKK6Wa80dI2dvykf%23&amp;amp;data=05%7C01%7C%7C9fac2e5807b044dc4ca908da33e822b6%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637879369382944586%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&amp;amp;sdata=%2BgEoBK9Sxg9zOI%2Far3PIbQ7q%2BUjZUI3Tu4X%2FC%2FAmW9o%3D&amp;amp;reserved=0
&nbsp;&nbsp;&nbsp; Any comments would be much appreciated.
&nbsp;&nbsp;&nbsp; Best,
&nbsp;&nbsp;&nbsp; ------------------------------------
&nbsp;&nbsp;&nbsp; Lanyu Liao
&nbsp;&nbsp;&nbsp; School of Software, NanJing University


&nbsp;&nbsp;&nbsp; 廖兰宇
&nbsp;&nbsp;&nbsp; 南京大学 软件学院

Re: Discuss New Syntax Convention

Posted by Eric Pai <er...@hotmail.com>.
Good work. After this patch is applied, could this issue(https://github.com/apache/iotdb/pull/5760) be solved properly?

在 2022/5/12 15:22，“廖兰宇”<18...@smail.nju.edu.cn> 写入:

    Hi everybody,
    We defined some complex syntax in ordered to be compatible with the older version. We are trying to update the Syntax Convention Part in the next version of IoTDB. Below is a list of changes between new Syntax Convention and old Syntax Convention.&nbsp;
    Change list:
    1. In quoted identifier, ` should be written as `` instead of \`. Also, in quoted identifier, ‘ and “ needs no special treatment and need not be doubled or escaped.
    2. Identifier consists of digit is not allowed now. If you want to use 111 as an identifier, please quote it with ``, like `111`. ` will be a part of the quoted identifier, which means `identifier1` is not the same as identifier1.
    3. Node name can not be quoted with ‘’ or “” now. If you want to use node name that contains special characters(including .), please quote it with ``.
    4. String in IoTDB will not be unescaped. In the older version, if you insert data of Text type using SQL, it will be unescaped.
    5. Alias can be both identifier and String now.
    6. Role and User are identifiers now.
    More details can be found at https://nam12.safelinks.protection.outlook.com/?url=https%3A%2F%2Fapache-iotdb.feishu.cn%2Fdocs%2FdoccnjsAnItPKK6Wa80dI2dvykf%23&amp;data=05%7C01%7C%7C9fac2e5807b044dc4ca908da33e822b6%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637879369382944586%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&amp;sdata=%2BgEoBK9Sxg9zOI%2Far3PIbQ7q%2BUjZUI3Tu4X%2FC%2FAmW9o%3D&amp;reserved=0
    Any comments would be much appreciated.
    Best,
    ------------------------------------
    Lanyu Liao
    School of Software, NanJing University


    廖兰宇
    南京大学 软件学院