[jira] [Commented] (IOTDB-1239) Incorrect datetime value can be inserted into iotdb successfully.

2021-03-17 Thread Haonan Hou (Jira) 


[ 
https://issues.apache.org/jira/browse/IOTDB-1239?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17303220#comment-17303220
 ] 

Haonan Hou commented on IOTDB-1239:
---

It should be a CLI bug caused by parseLongToDateWithPrecision method in 
RpcUtils class

> 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
>
> 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 (15741792,8.76);
> IoTDB> select * from root.sg.d1;
> +---+-+
> | Time|root.sg.d1.s2|
> +---+-+
> |{color:#FF}+{color}51853-10-03T00:00:{color:#FF}.0{color}+08:00| 
> 8.76|
> +---+-+
> {color:#FF}should be give an error :{color}
> {color:#FF}Incorrect datetime value  {color}
> IoTDB> select * from root.sg.d1 where time=51853-10-03T00:00:.0+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)

[jira] [Commented] (IOTDB-1239) Incorrect datetime value can be inserted into iotdb successfully.

2021-04-28 Thread Jira 


[ 
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 (15741792,8.76);
> IoTDB> select * from root.sg.d1;
> +---+-+
> | Time|root.sg.d1.s2|
> +---+-+
> |{color:#FF}+{color}51853-10-03T00:00:{color:#FF}.0{color}+08:00| 
> 8.76|
> +---+-+
> {color:#FF}should be give an error :{color}
> {color:#FF}Incorrect datetime value  {color}
> IoTDB> select * from root.sg.d1 where time=51853-10-03T00:00:.0+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)

[jira] [Commented] (IOTDB-1239) Incorrect datetime value can be inserted into iotdb successfully.

2022-05-09 Thread Jira 


[ 
https://issues.apache.org/jira/browse/IOTDB-1239?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17534156#comment-17534156
 ] 

刘珍 commented on IOTDB-1239:
---

 !screenshot-1.png! 

master_0510_19872aa ， 已解决。时间戳值按合法处理。

> 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
> Fix For: 0.14.0
>
> Attachments: image-2021-04-29-14-54-43-270.png, screenshot-1.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 (15741792,8.76);
> IoTDB> select * from root.sg.d1;
> +---+-+
> | Time|root.sg.d1.s2|
> +---+-+
> |{color:#FF}+{color}51853-10-03T00:00:{color:#FF}.0{color}+08:00| 
> 8.76|
> +---+-+
> {color:#FF}should be give an error :{color}
> {color:#FF}Incorrect datetime value  {color}
> IoTDB> select * from root.sg.d1 where time=51853-10-03T00:00:.0+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)