[GitHub] [arrow-datafusion] jackwener commented on issue #2254: [Optimizer] Infer is not null predicate from `where clause`

[GitBox <gi...@apache.org>]

jackwener commented on issue #2254:
URL: https://github.com/apache/arrow-datafusion/issues/2254#issuecomment-1100876623

   Note: It isn't a `optimizer rule` !
   
   It is because the following transformation can't terminate in Finite State Machine of rule.
   
   ```
   select * from t1 where c1 > 0;  
   -> 
   select * from t1 where c1 > 0 and c1 is not null;
   ->
   select * from t1 where c1 > 0 and c1 is not null and c1 is not null;
   ->
   .....
   ```
   
   So, In fact, this is a `rewrite` in planner build (Specifically, it is in `plan_selection`).


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