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)
