[
https://issues.apache.org/jira/browse/CALCITE-5929?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Yu Xu reassigned CALCITE-5929:
------------------------------
Assignee: Yu Xu
> 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
> Assignee: Yu Xu
> Priority: Major
>
> 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)
