You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@iotdb.apache.org by "Haonan Hou (Jira)" <ji...@apache.org> on 2021/09/10 07:25:00 UTC
[jira] [Assigned] (IOTDB-1670) IoTDB: timestamp_precision=ns ； ./sbin/start-cli.sh -e "...where time=[ timestamp in number ]"，the query result is incorrect
[ https://issues.apache.org/jira/browse/IOTDB-1670?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Haonan Hou reassigned IOTDB-1670:
---------------------------------
Assignee: Haonan Hou
> IoTDB: timestamp_precision=ns ； ./sbin/start-cli.sh -e "...where time=[ timestamp in number ]"，the query result is incorrect
> -----------------------------------------------------------------------------------------------------------------------------
>
> Key: IOTDB-1670
> URL: https://issues.apache.org/jira/browse/IOTDB-1670
> Project: Apache IoTDB
> Issue Type: Bug
> Components: Client/CLI
> Affects Versions: master branch, 0.12.2
> Reporter: 刘珍
> Assignee: Haonan Hou
> Priority: Minor
> Labels: pull-request-available
> Attachments: screenshot-2.png
>
>
>
> iotdb config：
> timestamp_precision=ns
> CREATE TIMESERIES root.sg.dev.s_0 WITH DATATYPE=INT32, ENCODING=PLAIN;
> insert into root.sg.dev(time,s_0) values(1630596013685000034,357)
> IoTDB> select * from root.sg.dev where time=1630596013685000034
> +-----------------------------------+---------------+
> | Time|root.sg.dev.s_0|
> +-----------------------------------+---------------+
> |2021-09-02T23:20:13.685000034+08:00| 357|
> +-----------------------------------+---------------+
> Total line number = 1
> Run the start-cli.sh command to specify the -e parameter. {color:#DE350B}*The result is incorrect:*{color}
> [cluster@i-uishrrtq release_1202]$ ./sbin/start-cli.sh -e "select s_0 from root.sg.dev where time=1630596013685000034"
> +----------------------------------+---------------+
> | Time|root.sg.dev.s_0|
> +----------------------------------+---------------+
> |+51673500-09-09T14:.03443:20+08:00| 357|
> +----------------------------------+---------------+
> Total line number = 1
> !screenshot-2.png!
--
This message was sent by Atlassian Jira
(v8.3.4#803005)