[jira] [Created] (CALCITE-4680) AssertionError: contains $cor1, while converting SQL query with UNNEST to logical plan

["Thomas Rebele (Jira)" <ji...@apache.org>]

Thomas Rebele created CALCITE-4680:
--------------------------------------

             Summary: AssertionError: contains $cor1, while converting SQL query with UNNEST to logical plan
                 Key: CALCITE-4680
                 URL: https://issues.apache.org/jira/browse/CALCITE-4680
             Project: Calcite
          Issue Type: Bug
    Affects Versions: 1.27.0
            Reporter: Thomas Rebele


The exception happens with the following SQL query
{code:java}
SELECT field1 FROM tab t1
WHERE t1.field1 NOT IN (
	SELECT l.subfield
	FROM tab t2, UNNEST(t2.field2) AS l
	WHERE t1.field1 = t2.field1)
{code}
and the schema
{code:java}
RecordType(VARCHAR NOT NULL field1, RecordType(VARCHAR subfield) ARRAY field2)
{code}
(where field2.subfield is nullable). Previous versions of Calcite threw a ClassCastException: LogicalCorrelate cannot be cast to Join.

However, it passes after removing the WHERE clause of the subquery.



--
This message was sent by Atlassian Jira
(v8.3.4#803005)