[ 
https://issues.apache.org/jira/browse/IOTDB-1239?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17534156#comment-17534156
 ] 

刘珍 commented on IOTDB-1239:
---------------------------

 !screenshot-1.png! 

master_0510_19872aa , 已解决。时间戳值按合法处理。

> Incorrect datetime value can be inserted into iotdb successfully.
> -----------------------------------------------------------------
>
>                 Key: IOTDB-1239
>                 URL: https://issues.apache.org/jira/browse/IOTDB-1239
>             Project: Apache IoTDB
>          Issue Type: Bug
>          Components: Client/CLI
>            Reporter: 刘珍
>            Assignee: Haonan Hou
>            Priority: Minor
>              Labels: pull-request-available
>             Fix For: 0.14.0
>
>         Attachments: image-2021-04-29-14-54-43-270.png, screenshot-1.png
>
>
> master branch.
> commit id 5fcff40f2299caeb0c8a9ae42f68bc18ecf8fee7 .
>  
> SET STORAGE GROUP TO root.sg
> CREATE TIMESERIES root.sg.d1.s2 WITH DATATYPE=DOUBLE, ENCODING=PLAIN
> insert into root.sg.d1(time,s2 ) values (1574179200000000,8.76);
> IoTDB> select * from root.sg.d1;
> +-------------------------------+-------------+
> | Time|root.sg.d1.s2|
> +-------------------------------+-------------+
> |{color:#FF0000}+{color}51853-10-03T00:00:{color:#FF0000}.00000{color}+08:00| 
> 8.76|
> +-------------------------------+-------------+
> {color:#FF0000}should be give an error :{color}
> {color:#FF0000}Incorrect datetime value  ....{color}
> IoTDB> select * from root.sg.d1 where time=51853-10-03T00:00:.00000+08:00
> Msg: 401: Error occurred while parsing SQL to physical plan: line 1:36 
> extraneous input '51853-10-03T00:00:' expecting \{NOW, TRUE, FALSE, '-', '.', 
> 'NaN', INT, EXPONENT, DATETIME, DOUBLE_QUOTE_STRING_LITERAL, 
> SINGLE_QUOTE_STRING_LITERAL}
>  



--
This message was sent by Atlassian Jira
(v8.20.7#820007)

Reply via email to