On 27.08.2010 18:58, Noah Hart wrote:
> http://www.sqlite.org/pragma.html#pragma_journal_mode states
>
> The OFF journaling mode disables the atomic commit and rollback capabilities
> of SQLite. The ROLLBACK command no longer works; it behaves in an undefined
> way. Applications must avoid using
http://www.sqlite.org/pragma.html#pragma_journal_mode states
The OFF journaling mode disables the atomic commit and rollback capabilities
of SQLite. The ROLLBACK command no longer works; it behaves in an undefined
way. Applications must avoid using the ROLLBACK command when the journal
mode is OF
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,
3 matches
Mail list logo