3 # The author disclaims copyright to this source code. In place of
4 # a legal notice, here is a blessing:
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.
10 #***********************************************************************
13 set testdir [file dirname $argv0]
14 source $testdir/tester.tcl
15 source $testdir/malloc_common.tcl
17 set g_chunk_size [ expr ($::SQLITE_MAX_PAGE_SIZE*16384) ]
20 # This handles appending the chunk number
21 # to the end of the filename. if
22 # SQLITE_MULTIPLEX_EXT_OVWR is defined, then
23 # it overwrites the last 2 bytes of the
24 # file name with the chunk number.
25 proc multiplex_name {name chunk} {
26 if {$chunk==0} { return $name }
27 set num [format "%02d" $chunk]
28 ifcapable {multiplex_ext_overwrite} {
29 set name [string range $name 0 [expr [string length $name]-2-1]]
34 # This saves off the parameters and calls the
35 # underlying sqlite3_multiplex_control() API.
36 proc multiplex_set {db name chunk_size max_chunks} {
39 set g_chunk_size [ expr (($chunk_size+($::SQLITE_MAX_PAGE_SIZE-1)) & ~($::SQLITE_MAX_PAGE_SIZE-1)) ]
40 set g_max_chunks $max_chunks
41 set rc [catch {sqlite3_multiplex_control $db $name chunk_size $chunk_size} msg]
43 set rc [catch {sqlite3_multiplex_control $db $name max_chunks $max_chunks} msg]
48 # This attempts to delete the base file and
49 # and files with the chunk extension.
50 proc multiplex_delete {name} {
52 for {set i 0} {$i<$g_max_chunks} {incr i} {
53 forcedelete [multiplex_name $name $i]
54 forcedelete [multiplex_name $name-journal $i]
55 forcedelete [multiplex_name $name-wal $i]
61 multiplex_delete test.db
62 multiplex_delete test2.db
64 #-------------------------------------------------------------------------
65 # multiplex-1.1.*: Test initialize and shutdown.
67 do_test multiplex-1.1 { sqlite3_multiplex_initialize nosuchvfs 1 } {SQLITE_ERROR}
68 do_test multiplex-1.2 { sqlite3_multiplex_initialize "" 1 } {SQLITE_OK}
69 do_test multiplex-1.3 { sqlite3_multiplex_initialize "" 1 } {SQLITE_MISUSE}
70 do_test multiplex-1.4 { sqlite3_multiplex_shutdown } {SQLITE_OK}
72 do_test multiplex-1.5 { sqlite3_multiplex_initialize "" 0 } {SQLITE_OK}
73 do_test multiplex-1.6 { sqlite3_multiplex_shutdown } {SQLITE_OK}
74 do_test multiplex-1.7 { sqlite3_multiplex_initialize "" 1 } {SQLITE_OK}
75 do_test multiplex-1.8 { sqlite3_multiplex_shutdown } {SQLITE_OK}
78 do_test multiplex-1.9.1 { sqlite3_multiplex_initialize "" 1 } {SQLITE_OK}
79 do_test multiplex-1.9.2 { sqlite3 db test.db } {}
80 do_test multiplex-1.9.3 { multiplex_set db main 32768 16 } {SQLITE_OK}
81 do_test multiplex-1.9.4 { multiplex_set db main 32768 -1 } {SQLITE_MISUSE}
82 do_test multiplex-1.9.5 { multiplex_set db main -1 16 } {SQLITE_MISUSE}
83 do_test multiplex-1.9.6 { multiplex_set db main 31 16 } {SQLITE_OK}
84 do_test multiplex-1.9.7 { multiplex_set db main 32768 100 } {SQLITE_MISUSE}
85 do_test multiplex-1.9.8 { multiplex_set db main 1073741824 1 } {SQLITE_OK}
86 do_test multiplex-1.9.9 { db close } {}
87 do_test multiplex-1.9.10 { sqlite3_multiplex_shutdown } {SQLITE_OK}
89 do_test multiplex-1.10.1 { sqlite3_multiplex_initialize "" 1 } {SQLITE_OK}
90 do_test multiplex-1.10.2 { sqlite3 db test.db } {}
91 do_test multiplex-1.10.3 { lindex [ catchsql { SELECT multiplex_control(2, 32768); } ] 0 } {0}
92 do_test multiplex-1.10.4 { lindex [ catchsql { SELECT multiplex_control(3, -1); } ] 0 } {1}
93 do_test multiplex-1.10.5 { lindex [ catchsql { SELECT multiplex_control(2, -1); } ] 0 } {1}
94 do_test multiplex-1.10.6 { lindex [ catchsql { SELECT multiplex_control(2, 31); } ] 0 } {0}
95 do_test multiplex-1.10.7 { lindex [ catchsql { SELECT multiplex_control(3, 100); } ] 0 } {1}
96 do_test multiplex-1.10.8 { lindex [ catchsql { SELECT multiplex_control(2, 1073741824); } ] 0 } {0}
97 do_test multiplex-1.10.9 { db close } {}
98 do_test multiplex-1.10.10 { sqlite3_multiplex_shutdown } {SQLITE_OK}
100 do_test multiplex-1.11.1 { sqlite3_multiplex_initialize "" 1 } {SQLITE_OK}
101 do_test multiplex-1.11.2 { sqlite3 db test.db } {}
102 do_test multiplex-1.11.3 { sqlite3_multiplex_control db main enable 0 } {SQLITE_OK}
103 do_test multiplex-1.11.4 { sqlite3_multiplex_control db main enable 1 } {SQLITE_OK}
104 do_test multiplex-1.11.5 { sqlite3_multiplex_control db main enable -1 } {SQLITE_OK}
105 do_test multiplex-1.11.6 { db close } {}
106 do_test multiplex-1.11.7 { sqlite3_multiplex_shutdown } {SQLITE_OK}
108 do_test multiplex-1.12.1 { sqlite3_multiplex_initialize "" 1 } {SQLITE_OK}
109 do_test multiplex-1.12.2 { sqlite3 db test.db } {}
110 do_test multiplex-1.12.3 { lindex [ catchsql { SELECT multiplex_control(1, 0); } ] 0 } {0}
111 do_test multiplex-1.12.4 { lindex [ catchsql { SELECT multiplex_control(1, 1); } ] 0 } {0}
112 do_test multiplex-1.12.5 { lindex [ catchsql { SELECT multiplex_control(1, -1); } ] 0 } {0}
113 do_test multiplex-1.12.6 { db close } {}
114 do_test multiplex-1.12.7 { sqlite3_multiplex_shutdown } {SQLITE_OK}
116 do_test multiplex-1.13.1 { sqlite3_multiplex_initialize "" 1 } {SQLITE_OK}
117 do_test multiplex-1.13.2 { sqlite3 db test.db } {}
118 do_test multiplex-1.13.3 { lindex [ catchsql { SELECT multiplex_control(-1, 0); } ] 0 } {1}
119 do_test multiplex-1.13.4 { lindex [ catchsql { SELECT multiplex_control(4, 1); } ] 0 } {1}
120 do_test multiplex-1.13.6 { db close } {}
121 do_test multiplex-1.13.7 { sqlite3_multiplex_shutdown } {SQLITE_OK}
123 #-------------------------------------------------------------------------
124 # Some simple warm-body tests with a single database file in rollback
127 # multiplex-2.1.*: Test simple writing to a multiplex file.
129 # multiplex-2.2.*: More writing.
131 # multiplex-2.3.*: Open and close a second db.
133 # multiplex-2.4.*: Try to shutdown the multiplex system before closing the db
134 # file. Check that this fails and the multiplex system still works
135 # afterwards. Then close the database and successfully shut
136 # down the multiplex system.
138 # multiplex-2.5.*: More reading/writing.
140 # multiplex-2.6.*: More reading/writing with varying small chunk sizes, as
141 # well as varying journal mode.
143 # multiplex-2.7.*: Disable/enable tests.
146 sqlite3_multiplex_initialize "" 1
147 multiplex_set db main 32768 16
149 do_test multiplex-2.1.2 {
152 PRAGMA page_size=1024;
153 PRAGMA auto_vacuum=OFF;
154 PRAGMA journal_mode=DELETE;
157 CREATE TABLE t1(a, b);
158 INSERT INTO t1 VALUES(1, randomblob(1100));
159 INSERT INTO t1 VALUES(2, randomblob(1100));
162 do_test multiplex-2.1.3 { file size [multiplex_name test.db 0] } {4096}
163 do_test multiplex-2.1.4 {
164 execsql { INSERT INTO t1 VALUES(3, randomblob(1100)) }
167 do_test multiplex-2.2.1 {
168 execsql { INSERT INTO t1 VALUES(3, randomblob(1100)) }
170 do_test multiplex-2.2.3 { file size [multiplex_name test.db 0] } {6144}
172 do_test multiplex-2.3.1 {
178 do_test multiplex-2.4.1 {
179 sqlite3_multiplex_shutdown
181 do_test multiplex-2.4.2 {
182 execsql { INSERT INTO t1 VALUES(3, randomblob(1100)) }
184 do_test multiplex-2.4.4 { file size [multiplex_name test.db 0] } {7168}
185 do_test multiplex-2.4.99 {
187 sqlite3_multiplex_shutdown
191 do_test multiplex-2.5.1 {
192 multiplex_delete test.db
193 sqlite3_multiplex_initialize "" 1
195 multiplex_set db main 4096 16
198 do_test multiplex-2.5.2 {
200 PRAGMA page_size = 1024;
201 PRAGMA journal_mode = delete;
202 PRAGMA auto_vacuum = off;
203 CREATE TABLE t1(a PRIMARY KEY, b);
207 do_test multiplex-2.5.3 {
209 INSERT INTO t1 VALUES(1, 'one');
210 INSERT INTO t1 VALUES(2, randomblob(4000));
211 INSERT INTO t1 VALUES(3, 'three');
212 INSERT INTO t1 VALUES(4, randomblob(4000));
213 INSERT INTO t1 VALUES(5, 'five');
214 INSERT INTO t1 VALUES(6, randomblob($g_chunk_size));
215 INSERT INTO t1 VALUES(7, randomblob($g_chunk_size));
219 do_test multiplex-2.5.4 {
220 db eval {SELECT * FROM t1 WHERE a=1}
223 do_test multiplex-2.5.5 {
224 db eval {SELECT * FROM t1 WHERE a=3}
227 do_test multiplex-2.5.6 {
228 db eval {SELECT * FROM t1 WHERE a=5}
231 do_test multiplex-2.5.7 {
232 db eval {SELECT a,length(b) FROM t1 WHERE a=2}
235 do_test multiplex-2.5.8 {
236 db eval {SELECT a,length(b) FROM t1 WHERE a=4}
239 do_test multiplex-2.5.9 { file size [multiplex_name test.db 0] } [list $g_chunk_size]
240 do_test multiplex-2.5.10 { file size [multiplex_name test.db 1] } [list $g_chunk_size]
242 do_test multiplex-2.5.99 {
244 sqlite3_multiplex_shutdown
248 set all_journal_modes {delete persist truncate memory off}
249 foreach jmode $all_journal_modes {
250 for {set sz 151} {$sz<8000} {set sz [expr $sz+419]} {
252 do_test multiplex-2.6.1.$sz.$jmode {
253 multiplex_delete test.db
254 sqlite3_multiplex_initialize "" 1
256 multiplex_set db main $sz 32
259 do_test multiplex-2.6.2.$sz.$jmode {
261 PRAGMA page_size = 1024;
262 PRAGMA auto_vacuum = off;
264 db eval "PRAGMA journal_mode = $jmode;"
267 do_test multiplex-2.6.3.$sz.$jmode {
269 CREATE TABLE t1(a PRIMARY KEY, b);
270 INSERT INTO t1 VALUES(1, 'one');
271 INSERT INTO t1 VALUES(2, randomblob($g_chunk_size));
275 do_test multiplex-2.6.4.$sz.$jmode {
276 db eval {SELECT b FROM t1 WHERE a=1}
279 do_test multiplex-2.6.5.$sz.$jmode {
280 db eval {SELECT length(b) FROM t1 WHERE a=2}
281 } [list $g_chunk_size]
283 do_test multiplex-2.6.6.$sz.$jmode { file size [multiplex_name test.db 0] } [list $g_chunk_size]
285 do_test multiplex-2.6.99.$sz.$jmode {
287 sqlite3_multiplex_shutdown
293 do_test multiplex-2.7.1 { multiplex_delete test.db } {}
294 do_test multiplex-2.7.2 { sqlite3_multiplex_initialize "" 1 } {SQLITE_OK}
295 do_test multiplex-2.7.3 { sqlite3 db test.db } {}
296 do_test multiplex-2.7.4 { lindex [ catchsql { SELECT multiplex_control(2, 65536); } ] 0 } {0}
297 do_test multiplex-2.7.5 { lindex [ catchsql { SELECT multiplex_control(1, 0); } ] 0 } {0}
298 do_test multiplex-2.7.6 {
300 CREATE TABLE t1(a PRIMARY KEY, b);
301 INSERT INTO t1 VALUES(1, randomblob(1000));
304 # verify only one file, and file size is less than chunks size
305 do_test multiplex-2.7.7 { expr ([file size [multiplex_name test.db 0]] < 65536) } {1}
306 do_test multiplex-2.7.8 { file exists [multiplex_name test.db 1] } {0}
307 do_test multiplex-2.7.9 {
309 INSERT INTO t1 VALUES(2, randomblob(65536));
312 # verify only one file, and file size exceeds chunks size
313 do_test multiplex-2.7.10 { expr ([file size [multiplex_name test.db 0]] > 65536) } {1}
314 do_test multiplex-2.7.11 { file exists [multiplex_name test.db 1] } {0}
315 do_test multiplex-2.7.12 { db close } {}
316 do_test multiplex-2.7.13 { sqlite3_multiplex_shutdown } {SQLITE_OK}
318 #-------------------------------------------------------------------------
319 # Try some tests with more than one connection to a database file. Still
322 # multiplex-3.1.*: Two connections to a single database file.
324 # multiplex-3.2.*: Two connections to each of several database files (that
325 # are in the same multiplex group).
327 do_test multiplex-3.1.1 {
328 multiplex_delete test.db
329 sqlite3_multiplex_initialize "" 1
331 multiplex_set db main 32768 16
333 do_test multiplex-3.1.2 {
335 PRAGMA page_size = 1024;
336 PRAGMA journal_mode = delete;
337 PRAGMA auto_vacuum = off;
338 CREATE TABLE t1(a PRIMARY KEY, b);
339 INSERT INTO t1 VALUES(1, 'one');
341 file size [multiplex_name test.db 0]
343 do_test multiplex-3.1.3 {
345 execsql { CREATE TABLE t2(a, b) } db2
347 do_test multiplex-3.1.4 {
348 execsql { CREATE TABLE t3(a, b) }
350 do_test multiplex-3.1.5 {
351 catchsql { CREATE TABLE t3(a, b) }
352 } {1 {table t3 already exists}}
353 do_test multiplex-3.1.6 {
358 do_test multiplex-3.2.1a {
360 multiplex_delete test.db
361 multiplex_delete test2.db
364 sqlite3 db2a test2.db
366 foreach db {db1a db2a} {
368 PRAGMA page_size = 1024;
369 PRAGMA journal_mode = delete;
370 PRAGMA auto_vacuum = off;
371 CREATE TABLE t1(a, b);
375 list [file size [multiplex_name test.db 0]] [file size [multiplex_name test2.db 0]]
378 do_test multiplex-3.2.1b {
380 sqlite3 db2b test2.db
383 do_test multiplex-3.2.2 { execsql { INSERT INTO t1 VALUES('x', 'y') } db1a } {}
384 do_test multiplex-3.2.3 { execsql { INSERT INTO t1 VALUES('v', 'w') } db1b } {}
385 do_test multiplex-3.2.4 { execsql { INSERT INTO t1 VALUES('t', 'u') } db2a } {}
386 do_test multiplex-3.2.5 { execsql { INSERT INTO t1 VALUES('r', 's') } db2b } {}
388 do_test multiplex-3.2.6 {
389 execsql { INSERT INTO t1 VALUES(randomblob(500), randomblob(500)) } db1a
391 do_test multiplex-3.2.7 {
392 execsql { INSERT INTO t1 VALUES(randomblob(500), randomblob(500)) } db1b
394 do_test multiplex-3.2.8 {
395 execsql { INSERT INTO t1 VALUES(randomblob(500), randomblob(500)) } db2a
397 do_test multiplex-3.2.9 {
398 execsql { INSERT INTO t1 VALUES(randomblob(500), randomblob(500)) } db2b
401 do_test multiplex-3.3.1 {
402 execsql { INSERT INTO t1 VALUES(randomblob(500), randomblob(500)) } db1a
403 execsql { INSERT INTO t1 VALUES(randomblob(500), randomblob(500)) } db1b
404 execsql { INSERT INTO t1 VALUES(randomblob(500), randomblob(500)) } db2a
405 execsql { INSERT INTO t1 VALUES(randomblob(500), randomblob(500)) } db2b
408 do_test multiplex-3.2.X {
409 foreach db {db1a db2a db2b db1b} { catch { $db close } }
412 #-------------------------------------------------------------------------
415 sqlite3_multiplex_initialize "" 1
416 multiplex_set db main 32768 16
418 # Return a list of all currently defined multiplexs.
419 proc multiplex_list {} {
421 foreach q [sqlite3_multiplex_dump] {
422 lappend allq [lindex $q 0]
427 do_test multiplex-4.1.6 {
428 multiplex_delete test2.db
430 db eval {CREATE TABLE t2(x); INSERT INTO t2 VALUES('tab-t2');}
431 set res [multiplex_list]
432 list [regexp {test2.db} $res]
434 do_test multiplex-4.1.6a {
436 db2 eval {SELECT * FROM t2}
438 do_test multiplex-4.1.7 {
439 execsql {INSERT INTO t2 VALUES(zeroblob(200000))}
441 do_test multiplex-4.1.8 {
443 db2 eval {SELECT count(*) FROM t2}
445 do_test multiplex-4.1.8a {
446 db2 eval { DELETE FROM t2 WHERE x = 'tab-t2' }
448 do_test multiplex-4.1.8b {
450 db2 eval {SELECT count(*) FROM t2}
454 do_test multiplex-4.1.9 {
455 execsql {INSERT INTO t2 VALUES(zeroblob(200000))}
457 do_test multiplex-4.1.10 {
458 set res [multiplex_list]
459 list [regexp {test2.db} $res]
461 do_test multiplex-4.1.11 {
463 set res [multiplex_list]
464 list [regexp {test2.db} $res]
466 do_test multiplex-4.1.12 {
472 #-------------------------------------------------------------------------
473 # The following tests test that the multiplex VFS handles malloc and IO
477 sqlite3_multiplex_initialize "" 1
478 multiplex_set db main 32768 16
480 do_faultsim_test multiplex-5.1 -prep {
485 do_faultsim_test multiplex-5.2 -prep {
492 multiplex_delete test.db
493 multiplex_delete test2.db
495 do_test multiplex-5.3.prep {
498 PRAGMA auto_vacuum = 1;
499 PRAGMA page_size = 1024;
500 CREATE TABLE t1(a, b);
501 INSERT INTO t1 VALUES(10, zeroblob(1200));
503 faultsim_save_and_close
505 do_faultsim_test multiplex-5.3 -prep {
506 faultsim_restore_and_reopen
508 execsql { DELETE FROM t1 }
511 do_test multiplex-5.4.1 {
513 multiplex_delete test.db
515 list [catch { sqlite3 db test.db } msg] $msg
516 } {1 {unable to open database file}}
517 catch { file delete test.db }
519 do_faultsim_test multiplex-5.5 -prep {
520 catch { sqlite3_multiplex_shutdown }
522 sqlite3_multiplex_initialize "" 1
523 multiplex_set db main 32768 16
526 # test that mismatch filesize is detected
528 # Do not run this test if $::G(perm:presql) is set. If it is set, then the
529 # expected IO error will occur within the Tcl [sqlite3] wrapper, not within
530 # the first SQL statement executed below. This breaks the test case.
532 if {0==[info exists ::G(perm:presql)] || $::G(perm:presql) == ""} {
533 set all_journal_modes {delete persist truncate memory off}
534 foreach jmode $all_journal_modes {
535 do_test multiplex-5.6.1.$jmode {
536 sqlite3_multiplex_shutdown
537 multiplex_delete test.db
540 PRAGMA page_size = 1024;
541 PRAGMA auto_vacuum = off;
543 db eval "PRAGMA journal_mode = $jmode;"
545 do_test multiplex-5.6.2.$jmode {
547 CREATE TABLE t1(a, b);
548 INSERT INTO t1 VALUES(1, randomblob(15000));
549 INSERT INTO t1 VALUES(2, randomblob(15000));
550 INSERT INTO t1 VALUES(3, randomblob(15000));
551 INSERT INTO t1 VALUES(4, randomblob(15000));
552 INSERT INTO t1 VALUES(5, randomblob(15000));
555 sqlite3_multiplex_initialize "" 1
557 multiplex_set db main 4096 16
559 do_test multiplex-5.6.3.$jmode {
561 INSERT INTO t1 VALUES(6, randomblob(15000));
563 } {1 {disk I/O error}}
564 do_test multiplex-5.6.4.$jmode {
570 catch { sqlite3_multiplex_shutdown }