You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@calcite.apache.org by "Evgeny Stanilovsky (Jira)" <ji...@apache.org> on 2022/08/30 09:23:00 UTC
[jira] [Created] (CALCITE-5253) Join fields validation partially broken after CALCITE-5171
Evgeny Stanilovsky created CALCITE-5253:
-------------------------------------------
Summary: Join fields validation partially broken after CALCITE-5171
Key: CALCITE-5253
URL: https://issues.apache.org/jira/browse/CALCITE-5253
Project: Calcite
Issue Type: Bug
Components: core
Affects Versions: 1.31.0
Reporter: Evgeny Stanilovsky
Assignee: Evgeny Stanilovsky
Such issue is not possible for now:
{code:java}
CREATE TABLE t1(a INTEGER, b INTEGER, c INTEGER);
CREATE TABLE t2(b INTEGER, c INTEGER, d INTEGER);
CREATE TABLE t3(c INTEGER, d INTEGER, e INTEGER);
SELECT t1.c, t2.d, t1.b, t1.a, t3.e FROM t1 natural join t2 natural join t3 WHERE t1.a=1;
{code}
cause:
{noformat}
SqlValidatorException: Column name 'C' in NATURAL join or USING clause is not unique on one side of join
{noformat}
Was broken by:
[1] https://issues.apache.org/jira/browse/CALCITE-5171
So this is a regression.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)