You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@calcite.apache.org by "Aleksey Plekhanov (Jira)" <ji...@apache.org> on 2021/12/03 08:53:00 UTC

[jira] [Created] (CALCITE-4922) Unqualified common column in ORDER BY fails for JOINs with USING and for NATURAL JOINs

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)