[jira] [Resolved] (CALCITE-2227) "SELECT *" in a NATURAL JOIN and JOIN USING query should output join columns only once

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

     [ https://issues.apache.org/jira/browse/CALCITE-2227?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Julian Hyde resolved CALCITE-2227.
----------------------------------
       Resolution: Fixed
    Fix Version/s: 1.17.0

Fixed in [92f7259b|http://git-wip-us.apache.org/repos/asf/calcite/commit/92f7259b].

> "SELECT *" in a NATURAL JOIN and JOIN USING query should output join columns only once
> --------------------------------------------------------------------------------------
>
>                 Key: CALCITE-2227
>                 URL: https://issues.apache.org/jira/browse/CALCITE-2227
>             Project: Calcite
>          Issue Type: Bug
>            Reporter: Julian Hyde
>            Assignee: Julian Hyde
>            Priority: Major
>             Fix For: 1.17.0
>
>
> "SELECT *" in a NATURAL JOIN and JOIN USING query should output join columns only once.
> For example,
> {code:java}
> SELECT * FROM Emp NATURAL JOIN Dept{code} should give columns {deptno, empno, ename, dname}. Note that deptno, the join key, has been moved to the start of the list only occurs once.
> This behavior is specified in the SQL standard. I don't know how I missed it.
> For outer joins, the value is coalesce(left.key, right.key) therefore never null.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)