4.4Why Test Constraints?

"If the database has the constraint, why test it?" Because:

1. Constraints can be accidentally removed during migrations
2. Constraints may not exist even when you assume they do
3. Application code may bypass constraints (e.g., ORM bug, raw SQL)
4. Constraint behavior varies (CASCADE vs RESTRICT, case sensitivity)
5. Documentation — constraint tests document the data integrity rules