[
https://issues.apache.org/jira/browse/IGNITE-18668?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Evgeny Stanilovsky updated IGNITE-18668:
----------------------------------------
Fix Version/s: 3.2
(was: 3.1)
> 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.2
>
>
> 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)
