pengzhiwei created CALCITE-3738:

             Summary: Missing order by logical plan for insert statement
                 Key: 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 :
"insert into t select id*10,name from users order by name;{code}
the plan is :
LogicalTableModify(table=[[t]], operation=[INSERT], flattened=[false])
  LogicalProject(id=[*($0, 10)], name=[$1])
This issue is introduced by the issue 

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

Reply via email to