Skip to content

sql: use optimizer cost perturbation and disable rule settings for metamorphic testingย #93825

Closed

Description

@rytaft

We created session settings testing_optimizer_cost_perturbation and testing_optimizer_disable_rule_probability to use for the randomized tests costfuzz and unoptimized_query_oracle. We should also use them as metamorphic constants that are used with metamorphic testing. This will give us more test coverage.

Jira issue: CRDB-22542

Activity

  1. added
    C-enhancementSolution expected to add code/behavior + preserve backward-compat (pg compat issues are exception)
    on Dec 16, 2022
  2. rytaft commented on Dec 20, 2022

    @rytaft
    ContributorAuthor

    Since these flags will make plans slow, we should probably not enable these flags on SQLite.

  3. yuzefovich commented on Feb 15, 2023

    @yuzefovich
    Member

    I looked into this in #94936, but there were quite a few failures and I since lost the context on it, so unassigning myself and putting into 23.2 bucket.

  4. removed their assignment
    on Feb 15, 2023
  5. moved this to New Backlog in SQL Querieson Jul 24, 2023
  6. moved this from Backlog to Done in SQL Querieson Jun 10, 2026
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Labels

    C-enhancementSolution expected to add code/behavior + preserve backward-compat (pg compat issues are exception)T-sql-queriesSQL Queries Teamv26.3.0-prerelease

    Type

    No type

    Projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions