You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@iotdb.apache.org by "刘珍 (Jira)" <ji...@apache.org> on 2021/03/17 05:35:00 UTC
[jira] [Created] (IOTDB-1239) Incorrect datetime value can be
inserted into iotdb successfully.
刘珍 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)