timbytimmy opened a new issue, #16437: URL: https://github.com/apache/iotdb/issues/16437
### 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 ALIGNED TIMESERIES root.min.d1 (c0 INT64); INSERT INTO root.min.d1(time, c0) VALUES (1641025977946, 1); --query 1 SELECT c0 FROM root.min.d1 WHERE time BETWEEN 1641025977946 AND 1641026043074; -- query 2 SELECT c0 FROM root.min.d1 WHERE time NOT BETWEEN 1641025977946 AND 1641026043074; -- query 3 SELECT c0 FROM root.min.d1 WHERE NOT (time BETWEEN 1641025977946 AND 1641026043074); -- query 4 SELECT c0 FROM root.min.d1 WHERE time BETWEEN 1641025977946 AND NOT 1641026043074; ### What did you expect to see? query 1: retrurn 1 result query 2: retrurn empty query 3: retrurn empty query 4: retrurn syntax error ### What did you see instead? query 1: retrurn 1 result query 2: retrurn empty query 3: retrurn empty query 4: retrurn 305 INTERNAL SERVER ERROR <img width="1888" height="883" alt="Image" src="https://github.com/user-attachments/assets/16570ac7-336a-4d96-bff8-0efb02d78398"; /> ### Anything else? BETWEEN A AND NOT B, should returning a clear syntax error instead of a 305. ### 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]
