Table 10. Class Code 21: Cardinality Violation
| SQLSTATE Value |
Meaning |
|---|---|
| 21000 | The result of a SELECT INTO is a result table of more than one row, or the result of the subquery of a basic predicate is more than one value. |
| 21501 | A multiple-row INSERT into a self-referencing table is invalid. |
| 21502 | A multiple-row UPDATE of a primary key is invalid. |
| 21504 | A multiple-row DELETE from a self-referencing table with a delete rule of RESTRICT or SET NULL is invalid. |
| 21505 | A row function must return not more than one row. |