Recognises deletes invisible to change data capture
Query-based CDC on a source that hard-deletes.
Can AI do this?
Not settled yet The benchmark tested this, but the models' answers do not settle yet whether they master it. 0 of 4 models in the current benchmark master it.
| Model | Tier | Probability of mastery | Status |
|---|---|---|---|
| gemini-4-argon | Flagship | 74% | Not shown |
| gemini-3.5-flash-lite | Low cost | 47% | Not shown |
| gpt-6-luna | Low cost | 44% | Not shown |
| claude-haiku-5-5 | Low cost | 74% | Not shown |
Mastered means a probability of at least 90% that the model has this knobit, estimated from its graded answers. “Not shown” means the answers do not settle it either way. How the models are tested.
What it looks like in practice
Expected result: The flow and a delete-aware capture
How it is assessed: Flags the deficient case and passes the acceptable one. Deficient: IF-003 CRM CDC by updated_at; CRM hard-deletes erased customers Acceptable: Log-based CDC or periodic full compare
Also known as: Deletes invisible to CDC
Related knobits
Builds on
All 15 knobits of Design the integration patterns.
Source: Review checklist 03-integration-patterns, row 5 (DMBOK)