You are viewing a plain text version of this content. The canonical link for it is here.
Posted to reviews@iotdb.apache.org by "LingweiKuang (via GitHub)" <gi...@apache.org> on 2024/10/11 13:31:46 UTC

[I] [Bug] The Not operator handles Boolean constants and Boolean operation results inconsistently. [iotdb]

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

   ### Search before asking
   
   - [X] I searched in the [issues](https://github.com/apache/iotdb/issues) and found nothing similar.
   
   
   ### Version
   
   1.3.2
   
   ### Describe the bug and provide the minimal reproduce step
   
   ```
   DROP DATABASE root.db0
   CREATE DATABASE root.db0
   
   INSERT INTO root.db0(t1) VALUES (1)
   INSERT INTO root.db0(timestamp, t1) VALUES (13453556, 2)
   INSERT INTO root.db0(timestamp, t1) VALUES (1519786882, 3)
   
   # query 1
   SELECT t1 FROM root.db0 WHERE !FALSE
   
   # query 2
   SELECT t1 FROM root.db0 WHERE !(1 != 1)
   ```
   
   ### What did you expect to see?
   
   Query 1 and Query 2 should yield the same result, as **1 != 1** is equivalent to **FALSE**.
   
   ### What did you see instead?
   
   Query 1 can retrieve all the data, but Query 2 reports the error `Msg: org.apache.iotdb.jdbc.IoTDBSQLException: 301: This predicate contains a not! Did you forget to run this predicate through PredicateRemoveNotRewriter?`.
   
   ### Anything else?
   
   Dear IoTDB team, I believe this is a logical bug, as 1 != 1 is equivalent to FALSE, yet the results of the two operations are inconsistent.
   
   ### 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] [Bug] The Not operator handles Boolean constants and Boolean operation results inconsistently. [iotdb]

Posted by "JackieTien97 (via GitHub)" <gi...@apache.org>.
JackieTien97 closed issue #13727: [Bug] The Not operator handles Boolean constants and Boolean operation results inconsistently.
URL: https://github.com/apache/iotdb/issues/13727


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

Re: [I] [Bug] The Not operator handles Boolean constants and Boolean operation results inconsistently. [iotdb]

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

   It's not a bug, in current version, we don't support constant expression in where or select clause.


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