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)
