Open
Description
Is your feature request related to a problem or challenge?
A new sort query fuzzer for out-of-core sorting has been added in #15501.
However, the memory limit is not enabled because there are known issues that cause external sort queries to fail, resulting in the fuzzer consistently failing. Once these issues are resolved, we can enable the memory limit configuration in the fuzzer.
After this ticket is resolved: #14748
The following update can be made to the sort query fuzzer to increase coverage for memory-limited sorts.
- Support generating queries with arbitrary number of ORDER BY clauses (Currently it's limited to be smaller than number of projected columns)
- Enable special type columns like
utf8_low
to be used in ORDER BY clauses - Enable memory limiting functionality in the fuzzer runner
- Increase the fuzzing throughput: now it spent a lot of time verifying the results (by formatting all the sorted results), we can make it more efficient by splitting the test into smaller tests to run in parallel.
Describe the solution you'd like
No response
Describe alternatives you've considered
No response
Additional context
No response