[ https://issues.apache.org/jira/browse/IOTDB-1239?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17335184#comment-17335184 ]
刘珍 commented on IOTDB-1239: --------------------------- 这个报错也有问题,和insert成功的表现不一致。 !image-2021-04-29-14-54-43-270.png! > 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: 刘珍 > 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.3.4#803005)