Minghui Liu created IOTDB-1620:
----------------------------------
Summary: Support backtick (`) character to quote identifiers
Key: IOTDB-1620
URL: https://issues.apache.org/jira/browse/IOTDB-1620
Project: Apache IoTDB
Issue Type: New Feature
Reporter: Minghui Liu
Assignee: Minghui Liu
Fix For: master branch
Certain objects within IoTDB, including storage group, device, timeseries,
schema template, alias, function, trigger and other object names are known as
identifiers. An identifier may be quoted or unquoted. If an identifier contains
special characters or is a reserved word, you _must_ quote it whenever you
refer to it.
The identifier quote character is the backtick ({{`}}):
{code:java}
IoTDB> SET STORAGE GROUP TO root.`storage`
Msg: The statement is executed successfully.
IoTDB> SHOW STORAGE GROUP
+-------------+
|storage group|
+-------------+
| root.storage|
+-------------+
Total line number = 1
It costs 0.050s
{code}
{code:java}
IoTDB> INSERT INTO root.sg.`select`(TIMESTAMP,`s(0)`) VALUES(1,1)
Msg: The statement is executed successfully.
IoTDB> SELECT `s(0)` FROM root.sg.`select`
+-----------------------------+-------------------+
| Time|root.sg.select.s(0)|
+-----------------------------+-------------------+
|1970-01-01T08:00:00.001+08:00| 1.0|
+-----------------------------+-------------------+
Total line number = 1
It costs 0.142s
{code}
Identifier quote characters can be included within an identifier if you quote
the identifier. If the character to be included within the identifier is the
same as that used to quote the identifier itself, then you need to double the
character. The following statement creates a storage group named {{root.a`b}} :
{code:java}
IoTDB> SET STORAGE GROUP TO root.`a``b`
Msg: The statement is executed successfully.
IoTDB> SHOW STORAGE GROUP
+-------------+
|storage group|
+-------------+
| root.a`b|
+-------------+
Total line number = 1
It costs 0.050s
{code}
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
