Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

[Bug] In version 1.3.3 of IoTDB, The time series function TIME_DIFFERENCE returns an index out of bounds error. #14522

Open
1 of 2 tasks
LingweiKuang opened this issue Dec 23, 2024 · 1 comment

Comments

@LingweiKuang
Copy link

LingweiKuang commented Dec 23, 2024

Search before asking

  • I searched in the 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.t1
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!
@LingweiKuang
Copy link
Author

In version 1 3 3 of IoTDB, The time series function TIME_DIFFERENCE returns an index out of bounds error

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant