[GitHub] [arrow-datafusion] jackwener opened a new issue, #2252: [Optimizer] Eliminate self compare self

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

jackwener opened a new issue, #2252:
URL: https://github.com/apache/arrow-datafusion/issues/2252

   **Is your feature request related to a problem or challenge? Please describe what you are trying to do.**
   Eliminate self compare self.
   
   ```sql
   select * from t1 where c1 = c1;
   -- infer is not null -->
   select * from t1 where c1 = c1 and c1 is not null;
   -- this rule to eliminate self compare -->
   select * from t1 where c1 is not null;
   ```
   
   **Describe the solution you'd like**
   It depend on infer `is not null` from `where clause`;
   
   **Describe alternatives you've considered**
   A clear and concise description of any alternative solutions or features you've considered.
   
   **Additional context**
   Add any other context or screenshots about the feature request here.
   


-- 
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.apache.org

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

[GitHub] [arrow-datafusion] jackwener closed issue #2252: [Optimizer] Eliminate self compare self

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

jackwener closed issue #2252: [Optimizer] Eliminate self compare self
URL: https://github.com/apache/arrow-datafusion/issues/2252


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