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


   ## Proposed changes
   - Fix the bug in issue 
[5989](https://github.com/apache/incubator-doris/issues/5989).
   ```sql
   CREATE TABLE xxx ( ..... ) 
   UNIQUE KEY (`a`,`b`,`c`) 
   PARTITION BY RANGE (`a`,`b`,`c`) (
       PARTITION p VALUES LESS THAN ('0')
   )   ......
   ```
   ```sql
   INSERT INTO xxx VALUES ('-1', '-1', '-1' .... );
   ```
   ```sql
   EXPLAIN SELECT * FROM xxx where a > 0;
   EXPLAIN SELECT * FROM xxx where a >= 0;
   ```
   - Before fix the bug,the result of explain contains "partitions=1/1"
   - After fix the bug,the result of explain contains "partitions=0/1"
   
   
   
   ## 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...)
   
   ## Checklist
   
   - [x] I have created an issue on (Fix #ISSUE) 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
   - [ ] If these changes need document changes, I have updated the document
   - [ ] Any dependent changes have been merged
   
   ## Further comments
   


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

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



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

Reply via email to