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)