Yu Xu created CALCITE-7490:
------------------------------
Summary: PruneEmptyRules is ineffective for window statements
Key: CALCITE-7490
URL: https://issues.apache.org/jira/browse/CALCITE-7490
Project: Calcite
Issue Type: Bug
Components: core
Affects Versions: 1.41.0
Reporter: Yu Xu
Assignee: Yu Xu
Fix For: 1.42.0
PruneEmptyRules is ineffective for window statements.
SQL：
{code:java}
select count(*) over () from emp where false {code}
Current optimization is:
{code:java}
LogicalProject(EXPR$0=[$9])
LogicalWindow(window#0=[window(aggs [COUNT()])])
LogicalValues(tuples=[[]]) {code}
The target execution plan should better to be:
{code:java}
LogicalValues(tuples=[[]]) {code}
We maybe need to add support for Windows scenarios.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
