(text/x-fossil-wiki)
The following sequence of SQL statements results in a database where the
primary key index has fewer rows than the table:
<blockquote><verbatim>
CREATE TABLE t1 (c0, c1 REAL PRIMARY KEY);
INSERT INTO t1(c0, c1) VALUES (0, 9223372036854775807), (0, 0);
UPDATE t1 SET c0 = NULL;
PRAGMA integrity_check;
</verbatim></blockquote>
This problem was discovered by Manuel Rigger and reported on the SQLite
mailing list. Bisecting shows the problem being introduced by check-in
[849e686da2d20fd7] which was a fix for ticket [38a97a87a6e4e83]. This
was on 2015-11-06 and first appeared in the 3.10.0 release of SQLite.
|