刘珍 created IOTDB-1239: ------------------------- Summary: 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: Server Reporter: 刘珍
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.3.4#803005)