cockroachdb / cockroachdb/cockroach

sql: check for mutations of prepared memos

Open
#147,351 4 comments 0 reactions 0 assignees View on GitHub
A-prepared-stmts C-enhancement O-postmortem P-3 T-sql-queries
Dominant language
Go
Stars
32.5k
Forks
4.1k
PR merge metrics
PR metrics pending

Description

Add validation, maybe in test-only builds, that verifies that a prepared memo is not mutated when placeholders are assigned and the memo is optimized. This might have caught #147186.

Jira issue: CRDB-51014

Contributor guide

Open the contributing guide

Research direction

Start by tracing the prepared memo paths involved when placeholders are assigned and the memo is optimized. Determine where test-only validation can observe mutations without changing production behavior. Done means validation detects unintended prepared-memo mutation and covers the regression described in #147186.

Written by the indexing model from the issue text.

Assessment

Tech stack
go, sql
Domain
databases, testing-qa
Issue type
Feature
Difficulty
4/5
Estimated time
3-5 days
Activity status
Stale
Clarity
Needs clarification
Newbie friendliness
30/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.