Aleksey Plekhanov created CALCITE-4922:
------------------------------------------

             Summary: Unqualified common column in ORDER BY fails for JOINs 
with USING and for NATURAL JOINs
                 Key: CALCITE-4922
                 URL: https://issues.apache.org/jira/browse/CALCITE-4922
             Project: Calcite
          Issue Type: Bug
            Reporter: Aleksey Plekhanov
            Assignee: Aleksey Plekhanov


Query:
{noformat}
SELECT name FROM emp JOIN dept USING (deptno) ORDER BY deptno{noformat}
Fails with:
{noformat}
Column 'DEPTNO' is ambiguous{noformat}



--
This message was sent by Atlassian Jira
(v8.20.1#820001)

Reply via email to