You are viewing a plain text version of this content. The canonical link for it is here.
Posted to reviews@iotdb.apache.org by "timbytimmy (via GitHub)" <gi...@apache.org> on 2025/09/22 02:24:35 UTC

[I] OR FALSE trigger error [iotdb]

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

   ### 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.c0 INT64;
   CREATE TIMESERIES root.min.t1.c2 INT64;
   CREATE TIMESERIES root.min.t1.c3 DOUBLE;
   
   INSERT INTO root.min.t1(time, c0, c2, c3) VALUES (1641024300000, 1, 2, 111.0);
   
   --query 1
   SELECT c2, c0, c3 FROM root.min.t1
   WHERE (111.0 = c3) & ((time BETWEEN 1641088367591 AND 1696815489424) | (time IN (1659164962649))) AND (time BETWEEN 1641024265420 AND 1641024393069);
   
   -- query 2
   SELECT c2, c0, c3 FROM root.min.t1 WHERE ((111.0 = c3) & ((time BETWEEN 1641088367591 AND 1696815489424) | (time IN (1659164962649)))) AND (time BETWEEN 1641024265420 AND 1641024393069) OR FALSE;
   
   ### What did you expect to see?
   
   query 1: return empty set
   
   query 2: return empty set
   
   ### What did you see instead?
   
   query 1: return empty set
   
   query 2: return error
   
   <img width="1897" height="752" alt="Image" src="https://github.com/user-attachments/assets/f8ab3f57-79a2-4da0-a0d1-aa4e9196fdd4" />
   
   ### Anything else?
   
   _No response_
   
   ### 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] OR FALSE trigger error [iotdb]

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

   SELECT c2, c0, c3 FROM root.min.t1 WHERE ((111.0 = c3) & ((time BETWEEN 1641088367591 AND 1696815489424) | (time IN (1659164962649)))) AND (time BETWEEN 1641024265420 AND 1641024393069) OR FALSE;
   
   The OR FALSE at the tail can be removed, but rewriting is not currently supported, can try OR 1!=1
   
   


-- 
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