Hello, I noticed that there is a Calcite rule (i.e., SortJoinTransposeRule) that pushes a LogicalSort past a LogicalJoin if the join is either left outer or right outer.
Who guarantees that the left and right outer joins are preserving the order of the inputs? Does the SQL standard requires that these types of joins are order preserving? Since we are working with logical operators, I would tend to think that we cannot assume anything about the physical equivalent. Best, Stamatis