lancelly commented on issue #7485:
URL: https://github.com/apache/iotdb/issues/7485#issuecomment-1263017455
In 0.13, the SQL syntax has been changed. The identifiers not enclosed in
backquotes can only contain the following characters, otherwise they need to be
enclosed in backquotes.
[0-9 a-z A-Z _ : @ # $ { }] (letters, digits, some special characters)
['\u2E80'..'\u9FFF'] (UNICODE Chinese characters)
Also, In 0.13, if the path node name in the SELECT clause consists of pure
numbers, it needs to be enclosed in backquotes to distinguish it from the
constant in the expression. For example, in the statement "select 123 + `123`
from root.sg", the former 123 represents a constant, and the latter `123` will
be spliced with root.sg, indicating the path root.sg.`123`.
More details can be found at
https://iotdb.apache.org/UserGuide/V0.13.x/Reference/Syntax-Conventions.html
--
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: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
