[
https://issues.apache.org/jira/browse/IOTDB-332?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17046113#comment-17046113
]
Jialin Qiao commented on IOTDB-332:
-----------------------------------
Hi, now we support "" in the leaf node and the following sqls are supported:
insert into root.哈哈.b(timestamp,c) values(1,2)
insert into root.sg.b(timestamp,哈哈) values(1,2)
insert into root.sg.b(timestamp,"哈哈") values(1,2)
insert into root.sg.b(timestamp,'哈哈') values(1,2)
insert into root.sg.b(timestamp,'哈哈') values(1,"哈哈")
I think this is enough for users want to use Chinese in path or in data
> Bugs when using Chinese character in the timeseries path
> --------------------------------------------------------
>
> Key: IOTDB-332
> URL: https://issues.apache.org/jira/browse/IOTDB-332
> Project: Apache IoTDB
> Issue Type: Bug
> Reporter: Lei Rui
> Priority: Major
>
> Note: At the beginning of every case, the data directory is deleted and the
> server is restarted.
> Case 1: insert into root."哈哈".b(timestamp,c) values(1,2)
> {code:java}
> IoTDB> insert into root."哈哈".b(timestamp,c) values(1,2)
> Msg: Fail to execute insert into root."哈哈".b(timestamp,c) values(1,2) after
> reconnecting. please check server status
> {code}
>
> Case 2: insert into root.a.b(timestamp,"哈哈") values(1,2)
> {code:java}
> IoTDB> insert into root.a.b(timestamp,"哈哈") values(1,2)
> It costs 0.240sIoTDB> select * from root
> +-----------------------------------+-----------+
> | Time|root.a.b.哈哈|
> +-----------------------------------+-----------+
> | 1970-01-01T08:00:00.001+08:00| 2|
> +-----------------------------------+-----------+
> Total line number = 1
> It costs 0.145s
> IoTDB> flush
> It costs 0.441sIoTDB> select * from root
> .....
> 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0,
> 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0,
> 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0,
> 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0,
> 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0,
> 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0]. Actual:26
> It costs 1.587
> {code}
>
> Case 3: insert into root.a.b(timestamp,"哈哈") values(1,"哈哈")
> {code:java}
> IoTDB> insert into root.a.b(timestamp,"哈哈") values(1,"哈哈")
> It costs 0.281s
> IoTDB> select * from root
> +-----------------------------------+-----------+
> | Time|root.a.b.哈哈|
> +-----------------------------------+-----------+
> | 1970-01-01T08:00:00.001+08:00| 哈哈|
> +-----------------------------------+-----------+
> Total line number = 1
> It costs 0.566s
> IoTDB> flush
> It costs 0.388s
> IoTDB> select * from root
> Msg: Cannot fetch result from server, because of network connection: {}
> It costs 0.080s{code}
>
> Case 4: insert into root.哈哈.b(timestamp,c) values(1,100)
> {code:java}
> IoTDB> insert into root.哈哈.b(timestamp,c) values(1,100)
> Msg: Statement format is not right: Parsing error, statement [insert into
> root.哈哈.b(timestamp,c) values(1,100)] failed when parsing AST tree to
> generate logical operator. Detailed information: [line 1:17 character '哈' not
> supported here. (Note that time format should be something like 1) number:
> eg.123456 2) function: eg.now() 3) datatime: eg.yyyy-MM-dd HH:mm:ss, please
> check whether inputting correct time format or referring to sql document)
> line 1:18 character '哈' not supported here. (Note that time format should be
> something like 1) number: eg.123456 2) function: eg.now() 3) datatime:
> eg.yyyy-MM-dd HH:mm:ss, please check whether inputting correct time format or
> referring to sql document)]
> It costs 0.117s
> {code}
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
