Describe the bug
Currently, the limit can be pushed down:
--GlobalLimitExec
----BoundedWindowAggExec: wdw=
------SortPreservingMergeExec: [c1@2 ASC NULLS LAST, c2@3 ASC NULLS LAST]
--------SortExec: expr=[c1@2 ASC NULLS LAST, c2@3 ASC NULLS LAST], preserve_partitioning=[true]
We should be able to push down limit below SPM as well.
To Reproduce
No response
Expected behavior
No response
Additional context
No response