[jira] [Created] (CALCITE-7886) Subquery expansion fails for IN subquery with ROW types

[Mihai Budiu (Jira)]

Mihai Budiu created CALCITE-7886:
------------------------------------

             Summary: Subquery expansion fails for IN subquery with ROW types
                 Key: CALCITE-7886
                 URL: https://issues.apache.org/jira/browse/CALCITE-7886
             Project: Calcite
          Issue Type: Bug
          Components: core
    Affects Versions: 1.42.0
            Reporter: Mihai Budiu


Here is a quidem test which crashes the compiler:
{code:java}
!use post
!set insubquerythreshold 0
select * from (select row(1, 2) as r) as t where r in (row(1, 2), row(3, 4)); 
{code}
Stack trace:
{code:java}
java.lang.AssertionError
        at org.apache.calcite.rex.RexSubQuery.type(RexSubQuery.java:78)
        at org.apache.calcite.rex.RexSubQuery.in(RexSubQuery.java:54)
        at 
org.apache.calcite.sql2rel.SqlToRelConverter.createSubquery(SqlToRelConverter.java:6555)
        at 
org.apache.calcite.sql2rel.SqlToRelConverter.convertNodeListToSubQuery(SqlToRelConverter.java:2090)
        at 
org.apache.calcite.sql2rel.SqlToRelConverter.substituteSubQuery(SqlToRelConverter.java:1446)
        at 
org.apache.calcite.sql2rel.SqlToRelConverter.replaceSubQueries(SqlToRelConverter.java:1371)
        at 
org.apache.calcite.sql2rel.SqlToRelConverter.convertWhere(SqlToRelConverter.java:1336)
 {code}



--
This message was sent by Atlassian Jira
(v10.3.26#10030026)