You are viewing a plain text version of this content. The canonical link for it is here.
Posted to reviews@iotdb.apache.org by "LingweiKuang (via GitHub)" <gi...@apache.org> on 2024/12/14 13:24:42 UTC

[I] [Bug] In the latest version of IoTDB, When multiple elements exist under a certain node, there is an error in filtering data using the TIME field. [iotdb]

LingweiKuang opened a new issue, #14430:
URL: https://github.com/apache/iotdb/issues/14430

   ### Search before asking
   
   - [X] I searched in the [issues](https://github.com/apache/iotdb/issues) and found nothing similar.
   
   
   ### Version
   
   version 1.3.3 (Build: ad95a7e)
   
   ### Describe the bug and provide the minimal reproduce step
   
   ```
   # statement 1
   DROP DATABASE root.db0
   CREATE TIMESERIES root.db0.t1.c0 WITH datatype=INT32
   INSERT INTO root.db0.t1(timestamp, c0) VALUES (1641024000000, 1);
   SELECT * FROM root.db0.t1 WHERE time < 1641024150000 - 1000;
   
   # statement 2
   DROP DATABASE root.db1
   CREATE TIMESERIES root.db1.t1.c0 INT32;
   CREATE TIMESERIES root.db1.t1.c1 INT32;
   CREATE TIMESERIES root.db1.t1.c2 WITH datatype=INT32;
   INSERT INTO root.db1.t1(timestamp, c2, c1, c0) VALUES (1641024000000, 1, 1, 1);
   SELECT * FROM root.db1.t1 WHERE time < 1641024150000 - 1000;
   ```
   
   ### What did you expect to see?
   
   Expected result set for statement 1:  **1**
   
   Expected result set for statement 1:  **1** 
   
   ### What did you see instead?
   
   statement 1 returned result set: **1**
   
   statement 2 returned result set: [INTERNAL_SERVER_ERROR(305)] Exception occurred: "SELECT * FROM root.db1.t1 WHERE (time) < 1641024150000 - 1000". executeStatement failed. null
   
   ### Anything else?
   
   Dear IoTDB team, Statement 1 and Statement 2 perform the same query, with the only difference being that the data nodes are different. The data node in Statement 2 contains multiple elements. Theoretically, the query results of both should be identical, but an error occurs when executing Statement 2.
   
   ### Are you willing to submit a PR?
   
   - [ ] I'm willing to submit a PR!


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: reviews-unsubscribe@iotdb.apache.org.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


Re: [I] [Bug] In the latest version of IoTDB, When multiple elements exist under a certain node, there is an error in filtering data using the TIME field. [iotdb]

Posted by "LingweiKuang (via GitHub)" <gi...@apache.org>.
LingweiKuang commented on issue #14430:
URL: https://github.com/apache/iotdb/issues/14430#issuecomment-2543110625

   result: 
   ![In the latest version of IoTDB, When multiple elements exist under a certain node, there is an error in filtering data using the TIME field](https://github.com/user-attachments/assets/b4d5fe02-34a5-4cd6-980a-073960b9d58e)
   Execution Log: 
   ![In the latest version of IoTDB, When multiple elements exist under a certain node, there is an error in filtering data using the TIME field-2](https://github.com/user-attachments/assets/ab3be0dd-8117-48aa-bf90-1c8e07a610f1)
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: reviews-unsubscribe@iotdb.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org