[jira] [Created] (CALCITE-3387) Query with GROUP BY and JOIN ... USING wrongly fails with "Column 'DEPTNO' is ambiguous" error

["Julian Hyde (Jira)" <ji...@apache.org>]

Julian Hyde created CALCITE-3387:
------------------------------------

             Summary: Query with GROUP BY and JOIN ... USING wrongly fails with "Column 'DEPTNO' is ambiguous" error
                 Key: CALCITE-3387
                 URL: https://issues.apache.org/jira/browse/CALCITE-3387
             Project: Calcite
          Issue Type: Bug
            Reporter: Julian Hyde


Query with GROUP BY and JOIN ... USING wrongly fails with "Column 'DEPTNO' is ambiguous" error. Here is the query:
{code}
select deptno, count(*)
from emp
join dept using (deptno)
group by deptno;
{code}

Because of USING, the two deptno fields should be merged into one, and therefore {{deptno}} is not ambiguous. That query works in Oracle. Also note that

{code}select deptno
from emp
join dept using (deptno)
{code}

works correctly, and has since CALCITE-2227 was fixed.



--
This message was sent by Atlassian Jira
(v8.3.4#803005)