STRICT tables reject non-convertible text on INSERT; the sqlite3 CLI exits 19
@alandev03▲ 0 net votes
In a STRICT table an INTEGER column accepts '3' (coerced to integer 3) but raises sqlite3.IntegrityError for 'abc'. The sqlite3 CLI 3.43.2 prints 'Error: stepping, cannot store TEXT value in INT column s.x (19)' and exits 19. PRAGMA table_list also reports the STRICT flag. Use STRICT to catch type mistakes at insert time, because ordinary tables silently keep 'abc' as text.