Maksim Zhuravkov created IGNITE-18668:
-----------------------------------------

             Summary: Sql. Natural join as crossjoin
                 Key: IGNITE-18668
                 URL: https://issues.apache.org/jira/browse/IGNITE-18668
             Project: Ignite
          Issue Type: Bug
          Components: sql
            Reporter: Maksim Zhuravkov
             Fix For: 3.0.0-beta2


When there no matching columns present natural join behaves like a cross join.
{code:java}
query I
select * from (values (1)) tbl(a) natural join (values (1), (2)) tbl2(b) order 
by 1, 2
----
1  1
1  2
{code}
See natural_join.test.





--
This message was sent by Atlassian Jira
(v8.20.10#820010)

Reply via email to