[
https://issues.apache.org/jira/browse/CALCITE-7900?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
ASF GitHub Bot updated CALCITE-7900:
------------------------------------
Labels: pull-request-available (was: )
> 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
> Assignee: Mihai Budiu
> Priority: Minor
> Labels: pull-request-available
>
> 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)
