Virtual table constraint violation

SQLITE_CONSTRAINT_VTAB (2323) is returned by a virtual table's xUpdate method to signal a constraint violation within the virtual table's own logic — not a SQLite core constraint.

1. 1Custom virtual table rejected an INSERT, UPDATE, or DELETE via xUpdate returning SQLITE_CONSTRAINT.
2. 2FTS virtual table rejecting an operation that violates its constraints.

DML on a virtual table where xUpdate returns SQLITE_CONSTRAINT.

-- FTS5 example: duplicate row ID in direct content mode
INSERT INTO fts_table(rowid, content) VALUES(1, 'hello');
INSERT INTO fts_table(rowid, content) VALUES(1, 'world'); -- constraint

sqlite3.IntegrityError: constraint failed

Content generated with AI assistance and reviewed for accuracy. Found an error? hello@errcodes.dev