[
https://issues.apache.org/jira/browse/IOTDB-1239?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
FengQingxin reassigned IOTDB-1239:
----------------------------------
Assignee: Haonan Hou
> 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
> Attachments: image-2021-04-29-14-54-43-270.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)