[jira] [Updated] (IGNITE-18668) Sql. Natural join as crossjoin

["Maksim Zhuravkov (Jira)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/IGNITE-18668?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Maksim Zhuravkov updated IGNITE-18668:
--------------------------------------
    Description: 
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.
At the moment this test case is expected to fail. We should decide whether we allow such queries or not.




  was:
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.




> 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
>            Priority: Major
>              Labels: calcite2-required, calcite3-required, ignite-3
>             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.
> At the moment this test case is expected to fail. We should decide whether we allow such queries or not.



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