Julian Hyde created OPTIQ-365:
---------------------------------
Summary: AssertionError while translating query with WITH and
correlated sub-query
Key: OPTIQ-365
URL: https://issues.apache.org/jira/browse/OPTIQ-365
Project: Optiq
Issue Type: Bug
Reporter: Julian Hyde
Assignee: Julian Hyde
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.2#6252)
