Khurram Faraaz created DRILL-4975:
-------------------------------------
Summary: Null equality join over non existing columns returns
nulls forever
Key: DRILL-4975
URL: https://issues.apache.org/jira/browse/DRILL-4975
Project: Apache Drill
Issue Type: Bug
Components: Execution - Flow
Affects Versions: 1.9.0
Reporter: Khurram Faraaz
Null equality join query that involves non-existing columns in the join
predicate, runs for ever and returns nulls.
Since the columns are not part of the parquet file, the join should fail
gracefully, and not return infinite number of nulls.
{noformat}
SELECT t1.col_blah , t2.col_blah FROM typeall_l t1, typeall_r t2 WHERE
t1.col_blah = t2.col_blah OR ( t1.col_blah IS NULL AND t2.col_blah IS NULL );
...
| null | null |
| null | null |
| null | null |
| null | null |
| null | null |
| null | null |
...
{noformat}
Upon removing, OR ( t1.col_blah IS NULL AND t2.col_blah IS NULL ) from the
query, no results are returned, as expected.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
