Danny Chen created CALCITE-3955:
-----------------------------------
Summary: Remove the first operand of RexCall from
SqlWindowTableFunction
Key: CALCITE-3955
URL: https://issues.apache.org/jira/browse/CALCITE-3955
Project: Calcite
Issue Type: Bug
Components: core
Affects Versions: 1.22.0
Reporter: Danny Chen
Assignee: Danny Chen
Fix For: 1.23.0
In CALCITE-3382, we introduced TUMBLE window function to replace the deprecated
group tumble window.
But for query
{code:sql}
select *
from table(tumble(table Shipments, descriptor(rowtime), INTERVAL '1' MINUTE))
{code}
the outputs plan is
{code:xml}
LogicalProject(ORDERID=[$0], ROWTIME=[$1], window_start=[$2], window_end=[$3])
LogicalTableFunctionScan(invocation=[TUMBLE($1, DESCRIPTOR($1),
60000:INTERVAL MINUTE)], rowType=[RecordType(INTEGER ORDERID, TIMESTAMP(0)
ROWTIME, TIMESTAMP(0) window_start, TIMESTAMP(0) window_end)])
LogicalProject(ORDERID=[$0], ROWTIME=[$1])
LogicalTableScan(table=[[CATALOG, SALES, SHIPMENTS]])
{code}
The first operand of TUMBLE rex call is always the last input field, but
actually it represents the source table which is the input rel node.
This issue remove the first operand from the RexCall because it is useless and
confusing.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
