[
https://issues.apache.org/jira/browse/DRILL-4794?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15387245#comment-15387245
]
ASF GitHub Bot commented on DRILL-4794:
---------------------------------------
Github user amansinha100 commented on the issue:
https://github.com/apache/drill/pull/550
@jinfengni could you pls review this small patch ? The bug was caused by
the fact that there was an extraneous 'break' statement that exited from the
outer loop (my intent was to only exit from an inner loop when
isSinglePartition=false ... but in this case there was no inner loop).
> Regression: Wrong result for query with disjunctive partition filters
> ---------------------------------------------------------------------
>
> Key: DRILL-4794
> URL: https://issues.apache.org/jira/browse/DRILL-4794
> Project: Apache Drill
> Issue Type: Bug
> Components: Query Planning & Optimization
> Affects Versions: 1.7.0
> Reporter: Aman Sinha
> Assignee: Aman Sinha
>
> For a query that contains certain types of disjunctive filter conditions such
> as 'dir0=x OR dir1=y' we get wrong result when metadata caching is used.
> This is a regression due to DRILL-4530.
> Note that the filter involves OR of 2 different directory levels. For the
> normal case of OR condition at the same level the problem does not occur.
> Correct result (without metadata cache)
> {noformat}
> 0: jdbc:drill:zk=local> select count(*) from dfs.`orders` where dir0=1994 or
> dir1='Q3' ;
> +---------+
> | EXPR$0 |
> +---------+
> | 60 |
> +---------+
> {noformat}
> Wrong result (with metadata cache):
> {noformat}
> 0: jdbc:drill:zk=local> select count(*) from dfs.`orders` where dir0=1994 or
> dir1='Q3' ;
> +---------+
> | EXPR$0 |
> +---------+
> | 50 |
> +---------+
> {noformat}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
