[jira] [Created] (DRILL-2239) Confusing error message "Column 't1' is ambiguous" for _table_ name t1

["Daniel Barclay (Drill/MapR) (JIRA)" <ji...@apache.org>]

Daniel Barclay (Drill/MapR) created DRILL-2239:
--------------------------------------------------

             Summary: 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)