SQLite Forum

CHECK violation during table definition ignored, normal or bug?
Login
Fine, although you're cheating a bit :)

The second error comes from `insert into x values ( new.b )` inside the trigger, and not from `insert into y values ( 14 )` per se.

But your example proves that it certainly helps to have the table name show as well; it will at least alert you to look at triggers.