Recognises a constraint claimed by a rule and missing from the schema
enforcement: constraint where the physical model carries no matching constraint.
Can AI do this?
AI does this well Most of the tested AI models master this. 10 of 10 models master it.
| Model | Tier | Probability of mastery | Status |
|---|---|---|---|
| gemini-4-argon | Flagship | 100% | Mastered |
| gemini-3.1-pro-preview | Flagship | 100% | Mastered |
| gpt-6-astra | Flagship | 100% | Mastered |
| claude-fable-5-1 | Flagship | 100% | Mastered |
| gemini-3.8-flash | Mid tier | 100% | Mastered |
| gpt-6.1-sol | Mid tier | 100% | Mastered |
| claude-sonnet-5-5 | Mid tier | 100% | Mastered |
| gemini-3.5-flash-lite | Low cost | 100% | Mastered |
| 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 rule and the absent constraint, with where to add it or how to make the enforcement honest
How it is assessed: Flags the deficient case and passes the acceptable one. Deficient: A mandatory rule whose column is nullable: true Acceptable: Either the column is NOT NULL, or the rule's enforcement is honestly dq-check (ANO-010)
Also known as: Rule claims schema enforcement it does not have (data rule); Logical constraint lost on the way down (physical model); Rule marked `constraint` with no constraint in the SQL (generated DDL)
Related knobits
Builds on
All 28 knobits of Document data rules as SBVR fact types and rule statements.
Source: Review checklist 03-data-rules, row 10