SQLite Forum

CHECK violation during table definition ignored, normal or bug?
Login
> The check expression is not limited to having only one column as its term(s).

Either we're on different pages, or I misunderstand the syntax diagram.

From the [syntax diagram](https://sqlite.org/syntax/column-def.html) the constraint no matter how it is 'fired' (triggers or not), and what other columns it may include in its expression, it is associated with a single column during table definition.

That column name I'm talking about, it's always the same for a given constraint.

At any rate, if that's something that can be done without unreasonably affecting performance, it'd be good to have.  If not, life goes on!