[GitHub] [arrow-datafusion] alamb commented on issue #5830: Simplify predicate expressions like 'a > 1 and a < 1' to constant false

["alamb (via GitHub)" <gi...@apache.org>]

alamb commented on issue #5830:
URL: https://github.com/apache/arrow-datafusion/issues/5830#issuecomment-1497463640

   I think we could probably add this specific type of simplification to  the expression simplifier and it would be fine.
   
   I think a more general approach for handling arbitrary predicates with constraints, such as @doki23 describes   
   
   ```
   a is not null and b is not null and a > 1 and a < 100 and b > 1 and b < 100 and a + b < 2
   ```
   
   Is not rewrite rules but rather some form of range analysis (e.g. as described on https://github.com/apache/arrow-datafusion/issues/5535)


-- 
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: github-unsubscribe@arrow.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org