search

cockroachdb / cockroach

CockroachDB — the cloud native, distributed SQL database designed for high availability, effortless scale, and control over data placement.
https://www.cockroachlabs.com
Other
30.01k stars 3.79k forks source link

sqlsmith: add table/index/constraint validation #62976

Open mgartner opened 3 years ago

mgartner commented 3 years ago

Fix up the debt in scrub or build something like SQLite's PRAGMA schema.integrity_check which can validate the state of tables, indexes, and constraints. Then, randomly sprinkle these checks in sqlsmith tests to find bugs in mutations.

Epic: CRDB-2469

Jira issue: CRDB-6370

mgartner commented 3 years ago

Comment from Radu:

The randomized schema change workload must be doing some sort of index integrity checking, I'd investigate what's there

github-actions[bot] commented 1 year ago

We have marked this issue as stale because it has been inactive for 18 months. If this issue is still relevant, removing the stale label or adding a comment will keep it active. Otherwise, we'll close it in 10 days to keep the issue queue tidy. Thank you for your contribution to CockroachDB!