Maryann Xue created CALCITE-863:
-----------------------------------
Summary: AssertionError while translating query with UNNEST and
having two correlation conditions
Key: CALCITE-863
URL: https://issues.apache.org/jira/browse/CALCITE-863
Project: Calcite
Issue Type: Bug
Reporter: Maryann Xue
Assignee: Julian Hyde
DDL:
{code}
CREATE TABLE score_table(
student_id INTEGER NOT NULL,
subject_id INTEGER NOT NULL,
scores INTEGER[]
CONSTRAINT pk PRIMARY KEY (student_id, subject_id));
{code}
Running the UNNEST correlated query with two correlation conditions would cause
an AssertionError:
{code}
SELECT s.student_id, s.subject_id, t.score
FROM
score_table s,
UNNEST((
SELECT scores
FROM score_table s2
WHERE s.student_id = s2.student_id
AND s.subject_id = s2.subject_id))
AS t(score)
java.lang.AssertionError: Internal error: Type 'RecordType(INTEGER STUDENT_ID,
INTEGER SUBJECT_ID, INTEGER ARRAY SCORES)' has no field 'EXPR$0'
at org.apache.calcite.util.Util.newInternal(Util.java:777)
at
org.apache.calcite.rex.RexBuilder.makeFieldAccess(RexBuilder.java:167)
at
org.apache.calcite.sql2rel.SqlToRelConverter.convertIdentifier(SqlToRelConverter.java:3187)
at
org.apache.calcite.sql2rel.SqlToRelConverter.access$5(SqlToRelConverter.java:3161)
at
org.apache.calcite.sql2rel.SqlToRelConverter$Blackboard.visit(SqlToRelConverter.java:4126)
at
org.apache.calcite.sql2rel.SqlToRelConverter$Blackboard.visit(SqlToRelConverter.java:1)
at org.apache.calcite.sql.SqlIdentifier.accept(SqlIdentifier.java:271)
at
org.apache.calcite.sql2rel.SqlToRelConverter$Blackboard.convertExpression(SqlToRelConverter.java:4009)
at
org.apache.calcite.sql2rel.SqlToRelConverter.convertSelectList(SqlToRelConverter.java:3396)
at
org.apache.calcite.sql2rel.SqlToRelConverter.convertSelectImpl(SqlToRelConverter.java:625)
at
org.apache.calcite.sql2rel.SqlToRelConverter.convertSelect(SqlToRelConverter.java:581)
at
org.apache.calcite.sql2rel.SqlToRelConverter.convertQueryRecursive(SqlToRelConverter.java:2768)
at
org.apache.calcite.sql2rel.SqlToRelConverter.convertQuery(SqlToRelConverter.java:535)
at org.apache.calcite.prepare.Prepare.prepareSql(Prepare.java:222)
at org.apache.calcite.prepare.Prepare.prepareSql(Prepare.java:188)
at
org.apache.calcite.prepare.CalcitePrepareImpl.prepare2_(CalcitePrepareImpl.java:671)
at
org.apache.calcite.prepare.CalcitePrepareImpl.prepare_(CalcitePrepareImpl.java:572)
at
org.apache.calcite.prepare.CalcitePrepareImpl.prepareSql(CalcitePrepareImpl.java:541)
at
org.apache.calcite.jdbc.CalciteConnectionImpl.parseQuery(CalciteConnectionImpl.java:173)
at
org.apache.calcite.jdbc.CalciteMetaImpl.prepareAndExecute(CalciteMetaImpl.java:561)
at
org.apache.calcite.avatica.AvaticaConnection.prepareAndExecuteInternal(AvaticaConnection.java:477)
at
org.apache.calcite.avatica.AvaticaStatement.executeInternal(AvaticaStatement.java:109)
at
org.apache.calcite.avatica.AvaticaStatement.executeQuery(AvaticaStatement.java:130)
at
org.apache.phoenix.calcite.CalciteIT$Sql.getResult(CalciteIT.java:157)
at
org.apache.phoenix.calcite.CalciteIT$Sql.explainIs(CalciteIT.java:133)
at org.apache.phoenix.calcite.CalciteIT.testUnnest(CalciteIT.java:1057)
{code}
But if there's only one correlation condition, the query runs *fine*:
{code}
SELECT s.student_id, s.subject_id, t.score
FROM
score_table s,
UNNEST((
SELECT scores
FROM score_table s2
WHERE s.student_id = s2.student_id))
AS t(score)
{code}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
