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

changefeedccl: add randomized testing #124146

Open rharding6373 opened 6 months ago

rharding6373 commented 6 months ago

Add a randomized test that creates a random table, does random inserts/updates/deletes, then compares the output to the original table. This could be done with and without an initial scan on initial data. This should have correctness validation for ordering and table content.

Our current direction is to integrate sqlsmith into the nemeses test (see TestChangefeedNemeses), which already supports all sinks and introduces some chaos.

We should make sure the randomized testing covers:

Jira issue: CRDB-38724

Epic CRDB-42866

blathers-crl[bot] commented 6 months ago

cc @cockroachdb/cdc