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.16k stars 3.82k forks source link

sql: add FK relationship to randomized tests #135695

Open mgartner opened 2 days ago

mgartner commented 2 days ago

Discussed in a pre-mortem.

Jira issue: CRDB-44680

mw5h commented 2 days ago

@michae2 says that "they're there, but you have to have two tables with columns of the same type and then randomly insert the same data into both, so they're never really exercised"

We could change the mutator to look for a parent column and then do an ALTER TABLE to the proposed child to add a column. (Then we would have to figure out how to populate this new column).