-
Notifications
You must be signed in to change notification settings - Fork 4.1k
sql: add randomized tests for plan pinning #170693
Copy link
Copy link
Open
Labels
A-plan-managementA-statement-hintStatement hints applied to queries externally from the statement_hints table.Statement hints applied to queries externally from the statement_hints table.C-enhancementSolution expected to add code/behavior + preserve backward-compat (pg compat issues are exception)Solution expected to add code/behavior + preserve backward-compat (pg compat issues are exception)T-sql-queriesSQL Queries TeamSQL Queries Team
Metadata
Metadata
Assignees
Labels
A-plan-managementA-statement-hintStatement hints applied to queries externally from the statement_hints table.Statement hints applied to queries externally from the statement_hints table.C-enhancementSolution expected to add code/behavior + preserve backward-compat (pg compat issues are exception)Solution expected to add code/behavior + preserve backward-compat (pg compat issues are exception)T-sql-queriesSQL Queries TeamSQL Queries Team
Type
Fields
Give feedbackNo fields configured for Feature.
Projects
Status
Short-term
After finishing #170360, #170680, and #170692, we should add two randomized tests for plan pinning:
EXPLAIN (OPT, PLANGRAM)to get the PlanGram, (c) pins the plan using the PlanGram, and then (d) validates that a PlanGram match was found andEXPLAIN (OPT, PLANGRAM)is the same.EXPLAIN (GIST)to get the plan gist, (c) pins the plan using the plan gist, and then (d) validates that a PlanGram match was found andEXPLAIN (GIST)is the same.Jira issue: CRDB-64122