Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

sqlsmith: add table/index/constraint validation #62976

Open
mgartner opened this issue Apr 1, 2021 · 2 comments
Open

sqlsmith: add table/index/constraint validation #62976

mgartner opened this issue Apr 1, 2021 · 2 comments
Labels
C-enhancement Solution expected to add code/behavior + preserve backward-compat (pg compat issues are exception) T-sql-queries SQL Queries Team
Projects

Comments

@mgartner
Copy link
Collaborator

mgartner commented Apr 1, 2021

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 mgartner added the C-enhancement Solution expected to add code/behavior + preserve backward-compat (pg compat issues are exception) label Apr 1, 2021
@mgartner mgartner self-assigned this Apr 1, 2021
@mgartner mgartner added this to Triage in SQL Queries via automation Apr 1, 2021
@mgartner mgartner moved this from Triage to Backlog in SQL Queries Apr 1, 2021
@mgartner
Copy link
Collaborator Author

mgartner commented Apr 1, 2021

Comment from Radu:

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

@jlinder jlinder added the T-sql-queries SQL Queries Team label Jun 16, 2021
@mgartner mgartner removed their assignment Jul 7, 2021
@mgartner mgartner moved this from Backlog to New Backlog in SQL Queries Feb 16, 2023
@github-actions
Copy link

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!

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
C-enhancement Solution expected to add code/behavior + preserve backward-compat (pg compat issues are exception) T-sql-queries SQL Queries Team
Projects
Status: Backlog
SQL Queries
New Backlog
Development

No branches or pull requests

2 participants