[
https://issues.apache.org/jira/browse/DRILL-2239?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14319371#comment-14319371
]
Daniel Barclay (Drill/MapR) commented on DRILL-2239:
----------------------------------------------------
Roger. Closing.
> Confusing error message "Column 't1' is ambiguous" for _table_ name t1
> ----------------------------------------------------------------------
>
> Key: DRILL-2239
> URL: https://issues.apache.org/jira/browse/DRILL-2239
> Project: Apache Drill
> Issue Type: Bug
> Components: SQL Parser
> Reporter: Daniel Barclay (Drill/MapR)
> Assignee: Aman Sinha
> Priority: Minor
>
> The error message about the erroneous use of "t1" in "t1 IS NULL" in this
> query:
> select *
> from dfs_test.`xxx/jsoninput/nullable1U.json` t1
> left outer join dfs_test.`xxx/jsoninput/nullable2U.json` t2
> on ( t1.key = t2.key OR ( t1 IS NULL AND t2 IS NULL) )
> says "Column 't1' is ambiguous" even though t1 is not a column name and isn't
> ambiguous.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
