Uploaded image for project: 'Apache IoTDB'
  1. Apache IoTDB
  2. IOTDB-1670

IoTDB: timestamp_precision=ns ; ./sbin/start-cli.sh -e "...where time=[ timestamp in number ]",the query result is incorrect

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Minor
    • Resolution: Fixed
    • master branch, 0.12.2
    • None
    • Client/CLI

    Description

      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. The result is incorrect:

      [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

      Attachments

        1. screenshot-2.png
          29 kB
          刘珍

        Activity

          People

            haonan Haonan Hou
            刘珍 刘珍
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: