| OLD | NEW |
|---|
| (Empty) |
| 1 # 2010 June 15 | |
| 2 # | |
| 3 # The author disclaims copyright to this source code. In place of | |
| 4 # a legal notice, here is a blessing: | |
| 5 # | |
| 6 # May you do good and not evil. | |
| 7 # May you find forgiveness for yourself and forgive others. | |
| 8 # May you share freely, never taking more than you give. | |
| 9 # | |
| 10 #*********************************************************************** | |
| 11 # | |
| 12 # The tests in this file test the pager modules response to various | |
| 13 # fault conditions (OOM, IO error, disk full etc.). They are similar | |
| 14 # to those in file pagerfault1.test. | |
| 15 # | |
| 16 # More specifically, the tests in this file are those deemed too slow to | |
| 17 # run as part of pagerfault1.test. | |
| 18 # | |
| 19 | |
| 20 set testdir [file dirname $argv0] | |
| 21 source $testdir/tester.tcl | |
| 22 source $testdir/lock_common.tcl | |
| 23 source $testdir/malloc_common.tcl | |
| 24 | |
| 25 if {[permutation] == "inmemory_journal"} { | |
| 26 finish_test | |
| 27 return | |
| 28 } | |
| 29 | |
| 30 sqlite3_memdebug_vfs_oom_test 0 | |
| 31 | |
| 32 set a_string_counter 1 | |
| 33 proc a_string {n} { | |
| 34 global a_string_counter | |
| 35 incr a_string_counter | |
| 36 string range [string repeat "${a_string_counter}." $n] 1 $n | |
| 37 } | |
| 38 db func a_string a_string | |
| 39 | |
| 40 do_test pagerfault2-1-pre1 { | |
| 41 faultsim_delete_and_reopen | |
| 42 db func a_string a_string | |
| 43 execsql { | |
| 44 PRAGMA auto_vacuum = 0; | |
| 45 PRAGMA journal_mode = DELETE; | |
| 46 PRAGMA page_size = 1024; | |
| 47 CREATE TABLE t1(a, b); | |
| 48 INSERT INTO t1 VALUES(a_string(401), a_string(402)); | |
| 49 } | |
| 50 for {set ii 0} {$ii < 13} {incr ii} { | |
| 51 execsql { INSERT INTO t1 SELECT a_string(401), a_string(402) FROM t1 } | |
| 52 } | |
| 53 faultsim_save_and_close | |
| 54 file size test.db | |
| 55 } [expr 1024 * 8268] | |
| 56 | |
| 57 do_faultsim_test pagerfault2-1 -faults oom-transient -prep { | |
| 58 faultsim_restore_and_reopen | |
| 59 sqlite3_db_config_lookaside db 0 256 4096 | |
| 60 execsql { | |
| 61 BEGIN; | |
| 62 SELECT * FROM t1; | |
| 63 INSERT INTO t1 VALUES(5, 6); | |
| 64 SAVEPOINT abc; | |
| 65 UPDATE t1 SET a = a||'x' WHERE rowid<3700; | |
| 66 } | |
| 67 } -body { | |
| 68 execsql { UPDATE t1 SET a = a||'x' WHERE rowid>=3700 AND rowid<=4200 } | |
| 69 execsql { ROLLBACK TO abc } | |
| 70 } -test { | |
| 71 faultsim_test_result {0 {}} | |
| 72 } | |
| 73 | |
| 74 do_test pagerfault2-2-pre1 { | |
| 75 faultsim_restore_and_reopen | |
| 76 execsql { DELETE FROM t1 } | |
| 77 faultsim_save_and_close | |
| 78 } {} | |
| 79 | |
| 80 do_faultsim_test pagerfault2-2 -faults oom-transient -prep { | |
| 81 faultsim_restore_and_reopen | |
| 82 sqlite3_db_config_lookaside db 0 256 4096 | |
| 83 db func a_string a_string | |
| 84 | |
| 85 execsql { | |
| 86 PRAGMA cache_size = 20; | |
| 87 BEGIN; | |
| 88 INSERT INTO t1 VALUES(a_string(401), a_string(402)); | |
| 89 SAVEPOINT abc; | |
| 90 } | |
| 91 } -body { | |
| 92 execsql { INSERT INTO t1 VALUES (a_string(2000000), a_string(2500000)) } | |
| 93 } -test { | |
| 94 faultsim_test_result {0 {}} | |
| 95 } | |
| 96 | |
| 97 sqlite3_memdebug_vfs_oom_test 1 | |
| 98 finish_test | |
| OLD | NEW |
|---|
Chromium Code Reviews
Issue 2846743003:
[sql] Remove SQLite 3.10.2 reference directory. (Closed)
