[GitHub] [incubator-doris] huangmengbin opened a new pull request #6446: Erase where

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

huangmengbin opened a new pull request #6446:
URL: https://github.com/apache/incubator-doris/pull/6446


   ## Proposed changes
   
   See issue #6021 
   ```sql
   1. CREATE TABLE xx ... PARTITION BY RANGE(`time`) (
       PARTITION p20210520 VALUES [('2021-05-20'),('2021-05-21'))
   ) ......
   
   2. explain SELECT * FROM xx 
       WHERE `time` >= '2021-05-20 00:00:00' AND `time` < `2021-05-21 00:00:00`;
   ```
   ```java
   assert  ! explainString.contains("`time` >= '2021-05-20 00:00:00'");
   assert  ! explainString.contains("`time` < '2021-05-21 00:00:00'");
   ```
   - That's because the query only hits partition p20210520.
   - After partition pruning, some predicate will be unnecessary.
   
   ## Types of changes
   
   - [x] Bugfix (non-breaking change which fixes an issue)
   - [ ] New feature (non-breaking change which adds functionality)
   - [ ] Breaking change (fix or feature that would cause existing functionality to not work as expected)
   - [ ] Documentation Update (if none of the other choices apply)
   - [ ] Code refactor (Modify the code structure, format the code, etc...)
   - [x] Optimization. Including functional usability improvements and performance improvements.
   - [ ] Dependency. Such as changes related to third-party components.
   - [ ] Other.
   
   ## Checklist
   
   - [x] I have created issues on (Fix #5989 and Enhancement #6021 ) and described the bug/feature there in detail
   - [x] Compiling and unit tests pass locally with my changes
   - [x] I have added tests that prove my fix is effective or that my feature works
   - [x] If these changes need document changes, I have updated the document
   - [ ] Any dependent changes have been merged
   
   ## Further comments
   
   - I have created an ( PR #5991 ) ,  which will fix a bug related to this optimization, but haven't gotten a response for a long time, and the "NewDorisTest" is failed and I don't know why.
   - So I Merged its changes into here...... Forgive me


-- 
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: commits-unsubscribe@doris.apache.org

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



---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org