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

   ### 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
   
   ```
   DROP DATABASE root.db0
   CREATE DATABASE root.db0.t1
   
   CREATE TIMESERIES root.db0.t1.c0 WITH datatype=INT32;
   INSERT INTO root.db0.t1(timestamp, c0) VALUES (1641024000000, 0), 
(1641024005000, 1);
   
   # query 1
   SELECT TIME_DIFFERENCE(c0) FROM root.db0.t1 WHERE c0 < 0;
   
   # query 2
   SELECT TIME_DIFFERENCE(c0) FROM root.db0.t1 WHERE time != time;
   ```
   
   ### What did you expect to see?
   
   
   The expected result set for Query 1 is: **empty set**
   
   The expected result set for Query 2 is: **empty set**
   
   ### What did you see instead?
   
   The actual result set returned by Query 1 is: **empty set**
   
   The actual result set returned by Query 2 is: **Msg: 
org.apache.iotdb.jdbc.IoTDBSQLException: 301: Index 1 out of bounds for length 
1**
   
   ### Anything else?
   
   Dear IoTDB team, In the above queries, both Query 1 and Query 2 are unable 
to retrieve any data, so they both perform the `TIME_DIFFERENCE` operation on 
empty sets. However, Query 2 triggers an index out of bounds error during 
execution. This should be considered a crash error.
   
   ### 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: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]

Reply via email to