Recognises a check weaker than its rule
A check that lets through rows the rule forbids: one direction of a two-way rule, presence where the rule says exactly one, a range with an open end the rule closes, a value set wider than the rule's.
Can AI do this?
AI does this well Most of the tested AI models master this. 7 of 10 models master it.
| Model | Tier | Probability of mastery | Status |
|---|---|---|---|
| gemini-4-argon | Flagship | 100% | Mastered |
| gemini-3.1-pro-preview | Flagship | 44% | Not shown |
| gpt-6-astra | Flagship | 100% | Mastered |
| claude-fable-5-1 | Flagship | 100% | Mastered |
| gemini-3.8-flash | Mid tier | 76% | Not shown |
| gpt-6.1-sol | Mid tier | 99% | Mastered |
| claude-sonnet-5-5 | Mid tier | 99% | Mastered |
| gemini-3.5-flash-lite | Low cost | 74% | Not shown |
| gpt-6-luna | Low cost | 100% | Mastered |
| claude-haiku-5-5 | Low cost | 100% | Mastered |
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 check, the rows it lets through and the missing check
How it is assessed: Flags the deficient case and passes the acceptable one. Deficient: Rule: each account has exactly one IBAN and no IBAN is shared. Check: account_identifier IS NOT NULL only. Duplicates pass Acceptable: Two checks: completeness on account_identifier, and uniqueness over it. Or the rule split into two at stage 3, each with its check
Also known as: Check weaker than its rule (data quality rule)
Related knobits
Builds on
- K-567 Explains relationship cardinality and optionality
- K-752 Explains traceability from data rule to check
All 31 knobits of Derive data quality rules.
Source: Review checklist 07-dq-rules, row 11; Olson 2003; DMBOK2