Have basic integration tests that check CDC records ordering #106
Description
We need to make sure that this CDC consumer gets CDC records in the same or similar order that they are happening in the cluster.
Tests requirements:
- Tests should be random but yet deterministic, use pseudo randomization, seed is picked randomly and logged at the beginning of the test.
- All scenarios should be tested against two table cases: PK and PK+CK
- Should make sure that order of operations withing PK/PK+CK is preserved
- All combination of possible operations should be tested within one test run: insert, update, delete; including insert,delete,insert .. etc...
- Try to test against different CDC configurations, pre image, post image, pre+post ...