[ https://issues.apache.org/jira/browse/IOTDB-1670?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17413021#comment-17413021 ]
刘珍 commented on IOTDB-1670: --------------------------- This issue has been resolved. > 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)