[
https://issues.apache.org/jira/browse/IGNITE-28879?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Evgeny Stanilovsky resolved IGNITE-28879.
-----------------------------------------
Resolution: Not A Problem
> Calcite. Window function is failed after calcite ver changed to 1.42
> --------------------------------------------------------------------
>
> Key: IGNITE-28879
> URL: https://issues.apache.org/jira/browse/IGNITE-28879
> Project: Ignite
> Issue Type: Improvement
> Components: sql
> Reporter: Evgeny Stanilovsky
> Assignee: Evgeny Stanilovsky
> Priority: Major
> Labels: ignite-2, ise
>
> Query (check [1]) :
> {code:java}
> SELECT * FROM (
> SELECT
> COUNT(*) OVER (PARTITION BY val2 ORDER BY val3) + SUM(val4) OVER
> (PARTITION BY val1 ORDER BY val3) AS total,
> COUNT(*) OVER (PARTITION BY val2 ORDER BY val3) AS val2count,
> SUM(val4) OVER (PARTITION BY val1 ORDER BY val3) AS val1sum
> FROM numbers
> ) sub WHERE total = val2count + val1sum;
> {code}
> Fails with :
> {noformat}
> Caused by: java.util.NoSuchElementException:
> java.lang.IndexOutOfBoundsException: Index 0 out of bounds for length 0
> at java.base/java.util.AbstractList$Itr.next(AbstractList.java:377)
> at
> org.apache.ignite.internal.processors.query.calcite.util.Commons.transform(Commons.java:228)
> at
> org.apache.ignite.internal.processors.query.calcite.exec.exp.window.WindowPartitionFactory.<init>(WindowPartitionFactory.java:64)
> at
> org.apache.ignite.internal.processors.query.calcite.exec.LogicalRelImplementor.visit(LogicalRelImplementor.java:965)
> at
> org.apache.ignite.internal.processors.query.calcite.exec.LogicalRelImplementor.visit(LogicalRelImplementor.java:139)
> at
> org.apache.ignite.internal.processors.query.calcite.rel.IgniteWindow.accept(IgniteWindow.java:122)
> {noformat}
> [1] test_window_functions.test_ignore
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
