xiong duan created CALCITE-5929:
-----------------------------------
Summary: Improve LogicalWindow print plan to add the constant value
Key: CALCITE-5929
URL: https://issues.apache.org/jira/browse/CALCITE-5929
Project: Calcite
Issue Type: Improvement
Components: core
Affects Versions: 1.35.0
Reporter: xiong duan
In general, we can extract the original SQL from the plan. But when the SQL
includes the LogicalWindow with a constant value, the Plan didn't print it.
The SQL:
{code:java}
select COUNT(*) over (
ORDER BY empno
ROWS BETWEEN 5 + 5 PRECEDING AND 1 PRECEDING) AS w_count from emp{code}
The Plan:
{code:java}
LogicalProject($0=[$1])
LogicalWindow(window#0=[window(order by [0] rows between $1 PRECEDING and $2
PRECEDING aggs [COUNT()])])
LogicalProject(EMPNO=[$0])
LogicalTableScan(table=[[CATALOG, SALES, EMP]]) {code}
In this plan, we don't know the $1 and $2 values.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
