Mihai Budiu created CALCITE-7900:
------------------------------------
Summary: Query with DISTINCT ON crashes
Key: CALCITE-7900
URL: https://issues.apache.org/jira/browse/CALCITE-7900
Project: Calcite
Issue Type: Bug
Components: core
Affects Versions: 1.42.0
Reporter: Mihai Budiu
The following query crashes at runtime (with a conformance which enables
DISTINCT ON):
{code:java}
SELECT * FROM (
SELECT DISTINCT ON (deptno) empno, ename, deptno
FROM emp
ORDER BY deptno, empno) AS t
ORDER BY deptno;{code}
stack trace:
{code:java}
java.sql.SQLException: Error while executing SQL "SELECT * FROM (...)": Index 0
out of bounds for length 0
Caused by: java.lang.IndexOutOfBoundsException: Index 0 out of bounds for
length 0
at java.base/java.util.ArrayList.get(ArrayList.java:427)
at
org.apache.calcite.sql2rel.SqlToRelConverter.convertDistinctOn(SqlToRelConverter.java:1075)
at
org.apache.calcite.sql2rel.SqlToRelConverter.convertSelectImpl(SqlToRelConverter.java:862)
at
org.apache.calcite.sql2rel.SqlToRelConverter.convertSelect(SqlToRelConverter.java:752)
at
org.apache.calcite.sql2rel.SqlToRelConverter.convertQueryRecursive(SqlToRelConverter.java:4445)
at
org.apache.calcite.sql2rel.SqlToRelConverter.convertFrom(SqlToRelConverter.java:2887)
{code}
--
This message was sent by Atlassian Jira
(v10.3.26#10030026)
