Details
-
Improvement
-
Status: Resolved
-
Minor
-
Resolution: Fixed
-
1.13.0
Description
When a query uses ... ORDER BY ... LIMIT ..., the planner unconditionally picks the TopN operator to (efficiently) implement this order. This precludes an easy way to test the External Sort operator over a large dataset (e.g., test spilling).
A new internal option to disable picking TopN (hence using the External Sort instead) would be useful for various testings. (And may be in other scenarios, like a bug found in the TopN).
Attachments
Issue Links
- links to