Describe the bug
output_ordering method of WindowAggExec gives output ordering of its input, as in the link. Although conceptually it is the correct behavior, SortExec is added before the WindowAggExec during BasicEnforcement pass of the PhysicalOptimizerRule (relevant section). Hence if we inquire the output_ordering of the WindowAggExec before SortExec is added, we will get wrong orderings.
To Reproduce
N.A
Expected behavior
I expect to get true output ordering for WindowAggExec during physical plan construction (before optimizations are applied)
Additional context
N.A
Describe the bug
output_orderingmethod ofWindowAggExecgives output ordering of its input, as in the link. Although conceptually it is the correct behavior,SortExecis added before theWindowAggExecduringBasicEnforcementpass of thePhysicalOptimizerRule(relevant section). Hence if we inquire theoutput_orderingof theWindowAggExecbeforeSortExecis added, we will get wrong orderings.To Reproduce
N.A
Expected behavior
I expect to get true output ordering for
WindowAggExecduring physical plan construction (before optimizations are applied)Additional context
N.A