apache / apache/iotdb

305 INTERNAL_SERVER_ERROR by Arithmetic time inside 'IN'

Open
#16,451 4 comments 0 reactions 0 assignees View on GitHub
Dominant language
Java
Stars
6.4k
Forks
1.2k
Avg merge
1d 23h
Merged PRs (30d)
115

Description

### Search before asking

- [x] I searched in the [issues](https://github.com/apache/iotdb/issues) and found nothing similar.

### Version

2.0.5 (build:0917050)

### Describe the bug and provide the minimal reproduce step

DELETE DATABASE root.min;
CREATE DATABASE root.min;

CREATE TIMESERIES root.min.t1.c1 INT64;
CREATE TIMESERIES root.min.t1.c2 INT64;

INSERT INTO root.min.t1(time, c1, c2) VALUES (1641024600000, 1, 42);

--query 1
SELECT c1, c2 FROM root.min.t1 WHERE time IN (1641024600000);

--query 2
SELECT c1, c2 FROM root.min.t1 WHERE (time + time) IN (3282049200000);

### What did you expect to see?

query 1 : return value

query 2 : return value

### What did you see instead?

query 1 : return value

query 2 : 305 INTERNAL SERVER ERROR

Image

### Anything else?

_No response_

### Are you willing to submit a PR?

- [ ] I'm willing to submit a PR!

Contributor guide

Open the contributing guide

Research direction

Reproduce the two queries from the issue on IoTDB 2.0.5 and compare their results. Trace the query execution for an arithmetic expression used inside an IN predicate; done means query 2 returns the expected value instead of a 305 INTERNAL SERVER ERROR.

Written by the indexing model from the issue text.

Assessment

Tech stack
java
Domain
databases
Issue type
Bug
Difficulty
4/5
Estimated time
3-5 days
Activity status
Stale
Clarity
Mostly clear
Newbie friendliness
35/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.