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: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]

Reply via email to