Error Returned by INSERT OR IGNORE
(1.1) By Jinsheng Ba (bajinsheng) on 2022-07-11 02:17:00 edited from 1.0 [source]
Please see this test case. Why the error is not ignored in the INSERT OR IGNORE statement?
CREATE TABLE t0(c0 INT) STRICT;
INSERT OR IGNORE INTO t0 VALUES(1.1); --Runtime error: cannot store REAL value in INT column t0.c0 (19)
Commit ID: 50c8e8de
(2) By Richard Damon (RichardDamon) on 2022-07-11 02:31:08 in reply to 1.1 [link] [source]
IGNORE means IGNORE unique key errors, not all errors.