[
https://issues.apache.org/jira/browse/CALCITE-365?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Julian Hyde updated CALCITE-365:
--------------------------------
Fix Version/s: 1.12.0
> AssertionError while translating query with WITH and correlated sub-query
> -------------------------------------------------------------------------
>
> Key: CALCITE-365
> URL: https://issues.apache.org/jira/browse/CALCITE-365
> Project: Calcite
> Issue Type: Bug
> Reporter: Julian Hyde
> Assignee: Julian Hyde
> Labels: sub-query
> Fix For: 1.12.0
>
>
> If a query has a WITH clause with column aliases, and also a correlated
> sub-query, Optiq gives an AssertionError while trying to translate a field
> name.
> {code:sql}
> with t (a, b) as (select * from (values (1, 2)))
> select * from t where exists (select 1 from emp where deptno = t.a);
> Caused by: java.lang.AssertionError: Internal error: Type 'RecordType(INTEGER
> A, INTEGER B)' has no field 'EXPR$0'
> at org.eigenbase.util.Util.newInternal(Util.java:734)
> at org.eigenbase.rex.RexBuilder.makeFieldAccess(RexBuilder.java:133)
> at
> org.eigenbase.sql2rel.SqlToRelConverter.convertIdentifier(SqlToRelConverter.java:3223)
> {code}
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
