Skip to content

Enable sort query fuzzing with limited memory #15517

Open
@2010YOUY01

Description

@2010YOUY01

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

Metadata

Metadata

Assignees

No one assigned

    Labels

    enhancementNew feature or request

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions