[IOTDB-1239] Incorrect datetime value can be inserted into iotdb successfully.

• Type: Bug
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Fix Version/s: 0.14.0
• Component/s: Client/CLI
• Labels: pull-request-available
• Sprint: 2022-5-StorageEngine
• Assignee: Haonan Hou
• Reporter: 刘珍
• Created: 17/Mar/21 05:34
• Updated: 10/May/22 06:12
• Resolved: 10/May/22 05:40

Description

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

------------------------------------------+

[phone]T00:00:.00000+08:00

8.76

------------------------------------------+

should be give an error :

Incorrect datetime value  ....

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}

 

Issue Links

• links to: GitHub Pull Request #3000
• links to: GitHub Pull Request #5832