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)