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

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

Julian Hyde created CALCITE-2227:
------------------------------------

             Summary: "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


"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)