pengzhiwei created CALCITE-3738:
-----------------------------------
Summary: Missing order by logical plan for insert statement
Key: CALCITE-3738
URL: https://issues.apache.org/jira/browse/CALCITE-3738
Project: Calcite
Issue Type: Bug
Components: core
Affects Versions: 1.19.0
Reporter: pengzhiwei
Assignee: pengzhiwei
The following sql statement generates a wrong logical plan which missing the
LogicalSort :
{code:java}
"insert into t select id*10,name from users order by name;{code}
the plan is :
{code:java}
LogicalTableModify(table=[[t]], operation=[INSERT], flattened=[false])
LogicalProject(id=[*($0, 10)], name=[$1])
LogicalTableScan(table=[[users]])
{code}
This issue is introduced by the issue
https://issues.apache.org/jira/browse/CALCITE-2978
which removed the sort by in sub-query.However the query in insert statement is
not a sub-query.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
