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)