Chromium Code Reviews
chromiumcodereview-hr@appspot.gserviceaccount.com (chromiumcodereview-hr) | Please choose your nickname with Settings | Help | Chromium Project | Gerrit Changes | Sign out
(310)

Unified Diff: third_party/sqlite/sqlite-src-3080704/test/walpersist.test

Issue 2363173002: [sqlite] Remove obsolete reference version 3.8.7.4. (Closed)
Patch Set: Created 4 years, 3 months ago
Use n/p to move between diff chunks; N/P to move between comments. Draft comments are only viewable by you.
Jump to:
View side-by-side diff with in-line comments
Download patch
Index: third_party/sqlite/sqlite-src-3080704/test/walpersist.test
diff --git a/third_party/sqlite/sqlite-src-3080704/test/walpersist.test b/third_party/sqlite/sqlite-src-3080704/test/walpersist.test
deleted file mode 100644
index 692728dda48d296a0aa8a3aabeeb6c9730f7b780..0000000000000000000000000000000000000000
--- a/third_party/sqlite/sqlite-src-3080704/test/walpersist.test
+++ /dev/null
@@ -1,126 +0,0 @@
-# 2011 July 26
-#
-# The author disclaims copyright to this source code. In place of
-# a legal notice, here is a blessing:
-#
-# May you do good and not evil.
-# May you find forgiveness for yourself and forgive others.
-# May you share freely, never taking more than you give.
-#
-#***********************************************************************
-#
-# This file contains tests for using WAL with persistent WAL file mode.
-#
-
-set testdir [file dirname $argv0]
-source $testdir/tester.tcl
-source $testdir/lock_common.tcl
-set ::testprefix walpersist
-
-ifcapable !wal {
- finish_test
- return
-}
-
-do_test walpersist-1.0 {
- db eval {
- PRAGMA journal_mode=WAL;
- CREATE TABLE t1(a);
- INSERT INTO t1 VALUES(randomblob(5000));
- }
- file exists test.db-wal
-} {1}
-do_test walpersist-1.1 {
- file exists test.db-shm
-} {1}
-do_test walpersist-1.2 {
- db close
- list [file exists test.db] [file exists test.db-wal] [file exists test.db-shm]
-} {1 0 0}
-do_test walpersist-1.3 {
- sqlite3 db test.db
- db eval {SELECT length(a) FROM t1}
-} {5000}
-do_test walpersist-1.4 {
- list [file exists test.db] [file exists test.db-wal] [file exists test.db-shm]
-} {1 1 1}
-do_test walpersist-1.5 {
- file_control_persist_wal db -1
-} {0 0}
-do_test walpersist-1.6 {
- file_control_persist_wal db 1
-} {0 1}
-do_test walpersist-1.7 {
- file_control_persist_wal db -1
-} {0 1}
-do_test walpersist-1.8 {
- file_control_persist_wal db 0
-} {0 0}
-do_test walpersist-1.9 {
- file_control_persist_wal db -1
-} {0 0}
-do_test walpersist-1.10 {
- file_control_persist_wal db 1
-} {0 1}
-do_test walpersist-1.11 {
- db close
- list [file exists test.db] [file exists test.db-wal] [file exists test.db-shm]
-} {1 1 1}
-
-# Make sure the journal_size_limit works to limit the size of the
-# persisted wal file. In persistent-wal mode, any non-negative
-# journal_size_limit causes the WAL file to be truncated to zero bytes
-# when closing.
-#
-forcedelete test.db test.db-shm test.db-wal
-do_test walpersist-2.1 {
- sqlite3 db test.db
- db eval {
- PRAGMA journal_mode=WAL;
- PRAGMA wal_autocheckpoint=OFF;
- PRAGMA journal_size_limit=12000;
- CREATE TABLE t1(x);
- INSERT INTO t1 VALUES(randomblob(50000));
- UPDATE t1 SET x=randomblob(50000);
- }
- expr {[file size test.db-wal]>100000}
-} {1}
-do_test walpersist-2.2 {
- file_control_persist_wal db 1
- db close
- concat [file exists test.db-wal] [file size test.db-wal]
-} {1 0}
-do_test walpersist-2.3 {
- sqlite3 db test.db
- execsql { PRAGMA integrity_check }
-} {ok}
-
-do_test 3.1 {
- catch {db close}
- forcedelete test.db test.db-shm test.db-wal
- sqlite3 db test.db
- execsql {
- PRAGMA page_size = 1024;
- PRAGMA journal_mode = WAL;
- PRAGMA wal_autocheckpoint=128;
- PRAGMA journal_size_limit=16384;
- CREATE TABLE t1(a, b, PRIMARY KEY(a, b));
- }
-} {wal 128 16384}
-do_test 3.2 {
- for {set i 0} {$i<200} {incr i} {
- execsql { INSERT INTO t1 VALUES(randomblob(500), randomblob(500)) }
- }
- file_control_persist_wal db 1
- db close
-} {}
-do_test walpersist-3.3 {
- file size test.db-wal
-} {0}
-do_test walpersist-3.4 {
- sqlite3 db test.db
- execsql { PRAGMA integrity_check }
-} {ok}
-
-
-finish_test
« no previous file with comments | « third_party/sqlite/sqlite-src-3080704/test/walnoshm.test ('k') | third_party/sqlite/sqlite-src-3080704/test/walro.test » ('j') | no next file with comments »

Powered by Google App Engine
This is Rietveld 408576698