Julian Hyde created CALCITE-4323: ------------------------------------ Summary: View with ORDER BY throws AssertionError during view expansion Key: CALCITE-4323 URL: https://issues.apache.org/jira/browse/CALCITE-4323 Project: Calcite Issue Type: Bug Reporter: Julian Hyde
If you have a view that has an ORDER BY clause, and try to execute a query on that view, SqlToRelConverter throws AssertionError during view expansion. For example, {noformat} create view v as select * from "EMPLOYEES" order by "deptno"; select * from V; java.lang.AssertionError at org.apache.calcite.sql2rel.SqlToRelConverter.requiredCollation(SqlToRelConverter.java:634) at org.apache.calcite.sql2rel.SqlToRelConverter.requiredCollation(SqlToRelConverter.java:629) at org.apache.calcite.sql2rel.SqlToRelConverter.convertQuery(SqlToRelConverter.java:578) at org.apache.calcite.prepare.CalcitePrepareImpl$CalcitePreparingStmt.expandView(CalcitePrepareImpl.java:1072) at org.apache.calcite.plan.ViewExpanders$1.expandView(ViewExpanders.java:52) at org.apache.calcite.schema.impl.ViewTable.expandView(ViewTable.java:127) at org.apache.calcite.schema.impl.ViewTable.toRel(ViewTable.java:120) at org.apache.calcite.prepare.RelOptTableImpl.toRel(RelOptTableImpl.java:285) at org.apache.calcite.sql2rel.SqlToRelConverter.toRel(SqlToRelConverter.java:3605) at org.apache.calcite.sql2rel.SqlToRelConverter.convertIdentifier(SqlToRelConverter.java:2522) at org.apache.calcite.sql2rel.SqlToRelConverter.convertFrom(SqlToRelConverter.java:2160) at org.apache.calcite.sql2rel.SqlToRelConverter.convertFrom(SqlToRelConverter.java:2109) at org.apache.calcite.sql2rel.SqlToRelConverter.convertFrom(SqlToRelConverter.java:2066) at org.apache.calcite.sql2rel.SqlToRelConverter.convertSelectImpl(SqlToRelConverter.java:662) at org.apache.calcite.sql2rel.SqlToRelConverter.convertSelect(SqlToRelConverter.java:643) at org.apache.calcite.sql2rel.SqlToRelConverter.convertQueryRecursive(SqlToRelConverter.java:3458) at org.apache.calcite.sql2rel.SqlToRelConverter.convertQuery(SqlToRelConverter.java:569) at org.apache.calcite.prepare.Prepare.prepareSql(Prepare.java:242) {noformat} I suspected that it would be a problem for when the view does not project the sort column(s), but it seems to be a problem even if the columns are projected. -- This message was sent by Atlassian Jira (v8.3.4#803005)