Hi all,

I just observed a Plan transformation that I don’t quite understand.
The Logical Plan is:

LogicalSort(sort0=[$0], dir0=[DESC])
  LogicalProject(time=[COALESCE($0, $2)], s1=[$1], s0=[$3])
    LogicalJoin(condition=[=($0, $2)], joinType=[full])
      LogicalTableScan(table=[[root, root.test.d0.s1]])
      LogicalTableScan(table=[[root, root.vehicle.d0.s0]])

And the result of the Volcano Planner is

BindableProject(time=[COALESCE($0, $2)], s1=[$1], s0=[$3])
  BindableJoin(condition=[=($0, $2)], joinType=[full])
    BindableTableScan(table=[[root, root.test.d0.s1]])
BindableTableScan(table=[[root, root.vehicle.d0.s0]])

I know wonder, why the LogicalSort is removed from the planner as the Output of 
the Join is NOT sorted (for a full join, for a left join it would be fine as 
the input table is sorted).

Is there anything I am missing or is this probably a Bug?

Thanks already!
Julian

Reply via email to