[
https://issues.apache.org/jira/browse/DRILL-7016?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Sorabh Hamirwasia updated DRILL-7016:
-------------------------------------
Reviewer: weijie.tong
> Wrong query result with RuntimeFilter enabled when order of join and filter
> condition is swapped
> ------------------------------------------------------------------------------------------------
>
> Key: DRILL-7016
> URL: https://issues.apache.org/jira/browse/DRILL-7016
> Project: Apache Drill
> Issue Type: Bug
> Components: Execution - Flow
> Affects Versions: 1.16.0
> Reporter: Sorabh Hamirwasia
> Assignee: Sorabh Hamirwasia
> Priority: Major
> Fix For: 1.16.0
>
>
> Below 2 queries generate different results:
> *Query1: Result: 19826*
> {code:java}
> select count(*)
> from
> customer c,
> orders o
> where
> c.c_mktsegment = 'HOUSEHOLD'
> and c.c_custkey = o.o_custkey
> {code}
> *Query2: Result: 2990828*
> {code:java}
> select count(*)
> from
> customer c,
> orders o
> where
> c.c_custkey = o.o_custkey and
> c.c_mktsegment = 'HOUSEHOLD'
> {code}
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
