You are viewing a plain text version of this content. The canonical link for it is here.
Posted to reviews@iotdb.apache.org by GitBox <gi...@apache.org> on 2021/01/04 13:38:21 UTC

[GitHub] [iotdb] HTHou opened a new issue #2416: Sql statement with unsupported mark isn't handled correctly

HTHou opened a new issue #2416:
URL: https://github.com/apache/iotdb/issues/2416


   
   **To Reproduce**
   ```sql
   IoTDB> insert into root.sg.d1(time,s1) values(100,‘100’)
   Msg: The statement is executed successfully.
   IoTDB> show timeseries
   +-------------+-----+-------------+--------+--------+-----------+----+----------+
   |   timeseries|alias|storage group|dataType|encoding|compression|tags|attributes|
   +-------------+-----+-------------+--------+--------+-----------+----+----------+
   |root.sg.d1.s1| null|      root.sg|   FLOAT| GORILLA|     SNAPPY|null|      null|
   +-------------+-----+-------------+--------+--------+-----------+----+----------+
   Total line number = 1
   It costs 0.035s
   IoTDB> select * from root
   +-----------------------------+-------------+
   |                         Time|root.sg.d1.s1|
   +-----------------------------+-------------+
   |1970-01-01T08:00:00.100+08:00|        100.0|
   +-----------------------------+-------------+
   Total line number = 1
   It costs 0.185s
   ```
   Note: `‘` and `’` are quotation marks with Chinese input method. 
   
   There is also a warn message on server.
   ```
   21:17:25.025 [pool-7-IoTDB-RPC-Client-thread-1] WARN org.apache.iotdb.db.service.TSServiceImpl - meet error while parsing SQL to physical plan: insert into root line 1:16 mismatched input '<EOF>' expecting {'.', '('}
   line 1:43 token recognition error at: '‘'
   line 1:47 token recognition error at: '’'
   ```
   **Expected behavior**
   The IoTDB server should return the error message to CLI rather than recognize `‘100’` as the number 100.
   
   **Desktop (please complete the following information):**
    - OS: macos
   
   


----------------------------------------------------------------
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.

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



[GitHub] [iotdb] HTHou closed issue #2416: Sql statement with unsupported mark doesn't be handled correctly

Posted by GitBox <gi...@apache.org>.
HTHou closed issue #2416:
URL: https://github.com/apache/iotdb/issues/2416


   


----------------------------------------------------------------
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.

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