SQLite 3.7.2 has a regression with journal_mode=off and
locking_mode=exclusive. Here is the SQL reproduce:
------------
drop table if exists t1;
PRAGMA locking_mode=exclusive;
pragma locking_mode;
CREATE TABLE t1(a PRIMARY KEY, b);
PRAGMA journal_mode = off;
BEGIN;
INSERT INTO t1 VALUES(13, 14);
SAVEPOINT s1;
INSERT INTO t1 VALUES(15, 16);
ROLLBACK TO s1;
ROLLBACK;
SELECT * FROM t1;
-------------
SQLite3 3.7.2 rolls back the savepoint insert and yields:
exclusive
exclusive
off
13|14
SQLite3 3.6.23.1 commits the savepoint insert and yields:
exclusive
exclusive
off
13|14
15|16
The SQL was shortened from savepoint.test. It works well in
locking_mode=normal so I dare say this is most likely a
locking_mode=exclusive bug.
Ralf
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
