Maksim Zhuravkov created IGNITE-22306:
-----------------------------------------
Summary: Sql. NATURAL join. Column name must be ambiguous.
Key: IGNITE-22306
URL: https://issues.apache.org/jira/browse/IGNITE-22306
Project: Ignite
Issue Type: Bug
Components: sql
Reporter: Maksim Zhuravkov
Query:
{noformat}
select * from (values (1)) t1(i) join (values (1)) t2(i) on (t1.i=t2.i) natural
join (values (1)) t3(i);
{noformat}
Should return an error because the left table of the outermost join consists of
two columns named "I".
Q1 (wrapped in select )
{noformat}
select * from (
(values (1)) t1(i) join (values (1)) t2(i) on (t1.i=t2.i)
) q1
# returns i, i
# 1, 1
{noformat}
Q2 (wrapped in select )
{noformat}
select * from (
(values (1)) t3(i);
) q2
# returns i
# 1
{noformat}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
