blob: 582dcc802df2f88a9f54b70ae87c924f403a7c46 [file] [log] [blame]
danielk19771077e3f2008-06-21 18:07:37 +00001# 2008 June 21
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#
danielk19771077e3f2008-06-21 18:07:37 +000012
13set testdir [file dirname $argv0]
14source $testdir/tester.tcl
dan13a3cb82010-06-11 19:04:21 +000015db close
danielk19771077e3f2008-06-21 18:07:37 +000016
dan0626dfc2010-06-15 06:56:37 +000017#-------------------------------------------------------------------------
18# test_suite NAME OPTIONS
danielk19771077e3f2008-06-21 18:07:37 +000019#
20# where available options are:
21#
dan430e74c2010-06-07 17:47:26 +000022# -description TITLE (default "")
danielk19771077e3f2008-06-21 18:07:37 +000023# -initialize SCRIPT (default "")
24# -shutdown SCRIPT (default "")
danielk19771077e3f2008-06-21 18:07:37 +000025# -presql SQL (default "")
dan0626dfc2010-06-15 06:56:37 +000026# -files LIST-OF-FILES (default $::ALLTESTS)
dan2fce9ab2010-06-15 18:00:06 +000027# -prefix NAME (default "$::NAME.")
dan0626dfc2010-06-15 06:56:37 +000028#
29proc test_suite {name args} {
dan430e74c2010-06-07 17:47:26 +000030
dan0626dfc2010-06-15 06:56:37 +000031 set default(-shutdown) ""
32 set default(-initialize) ""
33 set default(-presql) ""
dan430e74c2010-06-07 17:47:26 +000034 set default(-description) "no description supplied (fixme)"
dan2fce9ab2010-06-15 18:00:06 +000035 set default(-files) ""
36 set default(-prefix) "${name}."
dan430e74c2010-06-07 17:47:26 +000037
38 array set options [array get default]
dan0626dfc2010-06-15 06:56:37 +000039 if {[llength $args]%2} {
40 error "uneven number of options/switches passed to test_suite"
dan430e74c2010-06-07 17:47:26 +000041 }
dan0626dfc2010-06-15 06:56:37 +000042 foreach {k v} $args {
43 set o [array names options ${k}*]
44 if {[llength $o]>1} { error "ambiguous option: $k" }
45 if {[llength $o]==0} { error "unknown option: $k" }
46 set options([lindex $o 0]) $v
drh0a846f92008-08-25 17:23:29 +000047 }
danielk19771077e3f2008-06-21 18:07:37 +000048
dan0626dfc2010-06-15 06:56:37 +000049 set ::testspec($name) [array get options]
50 lappend ::testsuitelist $name
dane91a54e2010-06-15 17:44:47 +000051
dan0626dfc2010-06-15 06:56:37 +000052}
dan430e74c2010-06-07 17:47:26 +000053
dan0626dfc2010-06-15 06:56:37 +000054#-------------------------------------------------------------------------
55# test_set ARGS...
56#
57proc test_set {args} {
58 set isExclude 0
59 foreach a $args {
60 if {[string match -* $a]} {
61 switch -- $a {
62 -include { set isExclude 0 }
63 -exclude { set isExclude 1 }
64 default {
65 error "Unknown switch: $a"
66 }
danielk1977c1def3e2008-08-30 13:25:10 +000067 }
dan0626dfc2010-06-15 06:56:37 +000068 } elseif {$isExclude == 0} {
69 foreach f $a { set t($f) 1 }
drh0a846f92008-08-25 17:23:29 +000070 } else {
dan0626dfc2010-06-15 06:56:37 +000071 foreach f $a { array unset t $f }
danielk19771077e3f2008-06-21 18:07:37 +000072 }
73 }
74
dan0626dfc2010-06-15 06:56:37 +000075 return [array names t]
danielk19771077e3f2008-06-21 18:07:37 +000076}
77
dan0626dfc2010-06-15 06:56:37 +000078#-------------------------------------------------------------------------
79# Set up the following global list variables containing the names of
80# various test scripts:
81#
82# $alltests
dan2fce9ab2010-06-15 18:00:06 +000083# $allquicktests
dan0626dfc2010-06-15 06:56:37 +000084#
dan0626dfc2010-06-15 06:56:37 +000085set alltests [list]
86foreach f [glob $testdir/*.test] { lappend alltests [file tail $f] }
87if {$::tcl_platform(platform)!="unix"} {
88 set alltests [test_set $alltests -exclude crash.test crash2.test]
danielk1977c1def3e2008-08-30 13:25:10 +000089}
dan0626dfc2010-06-15 06:56:37 +000090set alltests [test_set $alltests -exclude {
91 all.test async.test quick.test veryquick.test
92 memleak.test permutations.test soak.test fts3.test
93 mallocAll.test
94}]
95
96set allquicktests [test_set $alltests -exclude {
97 async2.test async3.test backup_ioerr.test corrupt.test
98 corruptC.test crash.test crash2.test crash3.test crash4.test crash5.test
99 crash6.test crash7.test delete3.test e_fts3.test fts3rnd.test
100 fkey_malloc.test fuzz.test fuzz3.test fuzz_malloc.test in2.test loadext.test
dan273f3f02010-06-26 15:42:33 +0000101 misc7.test mutex2.test notify2.test onefile.test pagerfault2.test
dan0626dfc2010-06-15 06:56:37 +0000102 savepoint4.test savepoint6.test select9.test
103 speed1.test speed1p.test speed2.test speed3.test speed4.test
104 speed4p.test sqllimits1.test tkt2686.test thread001.test thread002.test
105 thread003.test thread004.test thread005.test trans2.test vacuum3.test
106 incrvacuum_ioerr.test autovacuum_crash.test btree8.test shared_err.test
107 vtab_err.test walslow.test walcrash.test
dan273f3f02010-06-26 15:42:33 +0000108 walthread.test
dan0626dfc2010-06-15 06:56:37 +0000109}]
dan63109902010-07-05 05:54:55 +0000110if {[info exists ::env(QUICKTEST_INCLUDE)]} {
111 set allquicktests [concat $allquicktests $::env(QUICKTEST_INCLUDE)]
112}
danielk1977c1def3e2008-08-30 13:25:10 +0000113
danielk19771077e3f2008-06-21 18:07:37 +0000114#############################################################################
115# Start of tests
dan0626dfc2010-06-15 06:56:37 +0000116#
117
118#-------------------------------------------------------------------------
119# Define the generic test suites:
120#
121# veryquick
122# quick
123# full
dan0626dfc2010-06-15 06:56:37 +0000124#
dane91a54e2010-06-15 17:44:47 +0000125lappend ::testsuitelist xxx
dan0626dfc2010-06-15 06:56:37 +0000126
dan2fce9ab2010-06-15 18:00:06 +0000127test_suite "veryquick" -prefix "" -description {
dan0626dfc2010-06-15 06:56:37 +0000128 "Very" quick test suite. Runs in less than 5 minutes on a workstation.
129 This test suite is the same as the "quick" tests, except that some files
130 that test malloc and IO errors are omitted.
131} -files [
dan68928b62010-06-22 13:46:43 +0000132 test_set $allquicktests -exclude *malloc* *ioerr* *fault*
dan0626dfc2010-06-15 06:56:37 +0000133]
134
dan2fce9ab2010-06-15 18:00:06 +0000135test_suite "quick" -prefix "" -description {
dan0626dfc2010-06-15 06:56:37 +0000136 Quick test suite. Runs in around 10 minutes on a workstation.
137} -files [
138 test_set $allquicktests
139]
140
dan2fce9ab2010-06-15 18:00:06 +0000141test_suite "full" -prefix "" -description {
dan0626dfc2010-06-15 06:56:37 +0000142 Full test suite. Takes a long time.
143} -files [
144 test_set $alltests
145] -initialize {
146 unset -nocomplain ::G(isquick)
147}
148
danea5542d2010-07-06 11:26:15 +0000149test_suite "threads" -prefix "" -description {
150 All multi-threaded tests.
151} -files {
152 notify2.test thread001.test thread002.test thread003.test
153 thread004.test thread005.test walthread.test
154}
155
156
dane91a54e2010-06-15 17:44:47 +0000157lappend ::testsuitelist xxx
dan0626dfc2010-06-15 06:56:37 +0000158#-------------------------------------------------------------------------
159# Define the coverage related test suites:
160#
161# coverage-wal
dan0626dfc2010-06-15 06:56:37 +0000162#
163test_suite "coverage-wal" -description {
164 Coverage tests for file wal.c.
165} -files {
danf43d7fc2010-07-03 10:00:00 +0000166 wal.test wal2.test wal3.test walmode.test
167 walbak.test walhook.test walcrash2.test walcksum.test
danbd0e9072010-07-07 09:48:44 +0000168 walfault.test walbig.test
dan0626dfc2010-06-15 06:56:37 +0000169}
170
dane91a54e2010-06-15 17:44:47 +0000171test_suite "coverage-pager" -description {
172 Coverage tests for file pager.c.
173} -files {
danf43d7fc2010-07-03 10:00:00 +0000174 pager1.test pager2.test pagerfault.test pagerfault2.test
175 walfault.test walbak.test journal2.test tkt-9d68c883.test
dane91a54e2010-06-15 17:44:47 +0000176}
dan0626dfc2010-06-15 06:56:37 +0000177
178
dane91a54e2010-06-15 17:44:47 +0000179lappend ::testsuitelist xxx
dan0626dfc2010-06-15 06:56:37 +0000180#-------------------------------------------------------------------------
181# Define the permutation test suites:
182#
danielk19771077e3f2008-06-21 18:07:37 +0000183
184# Run some tests using pre-allocated page and scratch blocks.
185#
dan0626dfc2010-06-15 06:56:37 +0000186test_suite "memsubsys1" -description {
danielk19771077e3f2008-06-21 18:07:37 +0000187 Tests using pre-allocated page and scratch blocks
dan0626dfc2010-06-15 06:56:37 +0000188} -files [
189 test_set $::allquicktests -exclude ioerr5.test malloc5.test
190] -initialize {
drhd63bd752008-07-30 13:15:46 +0000191 catch {db close}
danielk19771077e3f2008-06-21 18:07:37 +0000192 sqlite3_shutdown
193 sqlite3_config_pagecache 4096 24
194 sqlite3_config_scratch 25000 1
195 sqlite3_initialize
drhbb77b752009-04-09 01:23:49 +0000196 autoinstall_test_functions
danielk19771077e3f2008-06-21 18:07:37 +0000197} -shutdown {
198 catch {db close}
199 sqlite3_shutdown
200 sqlite3_config_pagecache 0 0
201 sqlite3_config_scratch 0 0
202 sqlite3_initialize
drhbb77b752009-04-09 01:23:49 +0000203 autoinstall_test_functions
danielk19771077e3f2008-06-21 18:07:37 +0000204}
205
206# Run some tests using pre-allocated page and scratch blocks. This time
207# the allocations are too small to use in most cases.
208#
danielk197734c61e62008-08-29 12:00:20 +0000209# Both ioerr5.test and malloc5.test are excluded because they test the
210# sqlite3_soft_heap_limit() and sqlite3_release_memory() functionality.
211# This functionality is disabled if a pre-allocated page block is provided.
212#
dan0626dfc2010-06-15 06:56:37 +0000213test_suite "memsubsys2" -description {
danielk19771077e3f2008-06-21 18:07:37 +0000214 Tests using small pre-allocated page and scratch blocks
dan0626dfc2010-06-15 06:56:37 +0000215} -files [
216 test_set $::allquicktests -exclude ioerr5.test malloc5.test
217] -initialize {
drhd63bd752008-07-30 13:15:46 +0000218 catch {db close}
danielk19771077e3f2008-06-21 18:07:37 +0000219 sqlite3_shutdown
220 sqlite3_config_pagecache 512 5
221 sqlite3_config_scratch 1000 1
222 sqlite3_initialize
drhbb77b752009-04-09 01:23:49 +0000223 autoinstall_test_functions
danielk19771077e3f2008-06-21 18:07:37 +0000224} -shutdown {
225 catch {db close}
226 sqlite3_shutdown
227 sqlite3_config_pagecache 0 0
228 sqlite3_config_scratch 0 0
229 sqlite3_initialize
drhbb77b752009-04-09 01:23:49 +0000230 autoinstall_test_functions
danielk19771077e3f2008-06-21 18:07:37 +0000231}
232
drhe2a7c6e2008-08-01 15:06:30 +0000233# Run all tests with the lookaside allocator disabled.
234#
dan0626dfc2010-06-15 06:56:37 +0000235test_suite "nolookaside" -description {
drhe2a7c6e2008-08-01 15:06:30 +0000236 OOM tests with lookaside disabled
drhe2a7c6e2008-08-01 15:06:30 +0000237} -initialize {
238 catch {db close}
239 sqlite3_shutdown
240 sqlite3_config_lookaside 0 0
241 sqlite3_initialize
drhbb77b752009-04-09 01:23:49 +0000242 autoinstall_test_functions
drhe2a7c6e2008-08-01 15:06:30 +0000243} -shutdown {
244 catch {db close}
245 sqlite3_shutdown
246 sqlite3_config_lookaside 100 500
247 sqlite3_initialize
drhbb77b752009-04-09 01:23:49 +0000248 autoinstall_test_functions
dan0626dfc2010-06-15 06:56:37 +0000249} -files $::allquicktests
drhe2a7c6e2008-08-01 15:06:30 +0000250
danielk19771077e3f2008-06-21 18:07:37 +0000251# Run some tests in SQLITE_CONFIG_SINGLETHREAD mode.
252#
dan0626dfc2010-06-15 06:56:37 +0000253test_suite "singlethread" -description {
danielk19771077e3f2008-06-21 18:07:37 +0000254 Tests run in SQLITE_CONFIG_SINGLETHREAD mode
255} -initialize {
drh04df18d2009-01-06 14:50:11 +0000256 catch {db close}
257 sqlite3_shutdown
258 catch {sqlite3_config singlethread}
drhbb77b752009-04-09 01:23:49 +0000259 sqlite3_initialize
260 autoinstall_test_functions
dan0626dfc2010-06-15 06:56:37 +0000261} -files {
danielk19771077e3f2008-06-21 18:07:37 +0000262 delete.test delete2.test insert.test rollback.test select1.test
263 select2.test trans.test update.test vacuum.test types.test
264 types2.test types3.test
265} -shutdown {
drh04df18d2009-01-06 14:50:11 +0000266 catch {db close}
267 sqlite3_shutdown
268 catch {sqlite3_config serialized}
drhbb77b752009-04-09 01:23:49 +0000269 sqlite3_initialize
270 autoinstall_test_functions
danielk19771077e3f2008-06-21 18:07:37 +0000271}
272
dan0626dfc2010-06-15 06:56:37 +0000273test_suite "nomutex" -description {
drh039963a2008-09-03 00:43:15 +0000274 Tests run with the SQLITE_OPEN_MULTITHREADED flag passed to sqlite3_open().
danielk19779a6284c2008-07-10 17:52:49 +0000275} -initialize {
276 rename sqlite3 sqlite3_nomutex
277 proc sqlite3 {args} {
278 if {[string range [lindex $args 0] 0 0] ne "-"} {
drhcc91e7f2008-09-03 01:08:00 +0000279 lappend args -fullmutex 0 -nomutex 1
danielk19779a6284c2008-07-10 17:52:49 +0000280 }
281 uplevel [concat sqlite3_nomutex $args]
282 }
dan0626dfc2010-06-15 06:56:37 +0000283} -files {
danielk19779a6284c2008-07-10 17:52:49 +0000284 delete.test delete2.test insert.test rollback.test select1.test
285 select2.test trans.test update.test vacuum.test types.test
286 types2.test types3.test
287} -shutdown {
288 rename sqlite3 {}
289 rename sqlite3_nomutex sqlite3
290}
291
danielk19771077e3f2008-06-21 18:07:37 +0000292# Run some tests in SQLITE_CONFIG_MULTITHREAD mode.
293#
dan0626dfc2010-06-15 06:56:37 +0000294test_suite "multithread" -description {
danielk19771077e3f2008-06-21 18:07:37 +0000295 Tests run in SQLITE_CONFIG_MULTITHREAD mode
296} -initialize {
drh04df18d2009-01-06 14:50:11 +0000297 catch {db close}
298 sqlite3_shutdown
299 catch {sqlite3_config multithread}
drhbb77b752009-04-09 01:23:49 +0000300 sqlite3_initialize
301 autoinstall_test_functions
dan0626dfc2010-06-15 06:56:37 +0000302} -files {
danielk19771077e3f2008-06-21 18:07:37 +0000303 delete.test delete2.test insert.test rollback.test select1.test
304 select2.test trans.test update.test vacuum.test types.test
305 types2.test types3.test
306} -shutdown {
drh04df18d2009-01-06 14:50:11 +0000307 catch {db close}
308 sqlite3_shutdown
309 catch {sqlite3_config serialized}
drhbb77b752009-04-09 01:23:49 +0000310 sqlite3_initialize
311 autoinstall_test_functions
danielk19771077e3f2008-06-21 18:07:37 +0000312}
313
drh039963a2008-09-03 00:43:15 +0000314# Run some tests in SQLITE_OPEN_FULLMUTEX mode.
315#
dan0626dfc2010-06-15 06:56:37 +0000316test_suite "fullmutex" -description {
drh039963a2008-09-03 00:43:15 +0000317 Tests run in SQLITE_OPEN_FULLMUTEX mode
318} -initialize {
319 rename sqlite3 sqlite3_fullmutex
320 proc sqlite3 {args} {
321 if {[string range [lindex $args 0] 0 0] ne "-"} {
drhcc91e7f2008-09-03 01:08:00 +0000322 lappend args -nomutex 0 -fullmutex 1
drh039963a2008-09-03 00:43:15 +0000323 }
324 uplevel [concat sqlite3_fullmutex $args]
325 }
dan0626dfc2010-06-15 06:56:37 +0000326} -files {
drh039963a2008-09-03 00:43:15 +0000327 delete.test delete2.test insert.test rollback.test select1.test
328 select2.test trans.test update.test vacuum.test types.test
329 types2.test types3.test
330} -shutdown {
331 rename sqlite3 {}
332 rename sqlite3_fullmutex sqlite3
333}
334
danielk19771077e3f2008-06-21 18:07:37 +0000335# Run some tests using the "onefile" demo.
336#
dan0626dfc2010-06-15 06:56:37 +0000337test_suite "onefile" -description {
danielk19771077e3f2008-06-21 18:07:37 +0000338 Run some tests using the "test_onefile.c" demo
339} -initialize {
340 rename sqlite3 sqlite3_onefile
341 proc sqlite3 {args} {
342 if {[string range [lindex $args 0] 0 0] ne "-"} {
343 lappend args -vfs fs
344 }
345 uplevel [concat sqlite3_onefile $args]
346 }
dan0626dfc2010-06-15 06:56:37 +0000347} -files {
danielk19771077e3f2008-06-21 18:07:37 +0000348 conflict.test insert.test insert2.test insert3.test
349 rollback.test select1.test select2.test select3.test
danielk19771077e3f2008-06-21 18:07:37 +0000350} -shutdown {
351 rename sqlite3 {}
352 rename sqlite3_onefile sqlite3
353}
354
355# Run some tests using UTF-16 databases.
356#
dan0626dfc2010-06-15 06:56:37 +0000357test_suite "utf16" -description {
danielk19771077e3f2008-06-21 18:07:37 +0000358 Run tests using UTF-16 databases
danielk19772dd6d802008-06-21 19:10:27 +0000359} -presql {
danielk19771077e3f2008-06-21 18:07:37 +0000360 pragma encoding = 'UTF-16'
dan0626dfc2010-06-15 06:56:37 +0000361} -files {
danielk19771077e3f2008-06-21 18:07:37 +0000362 alter.test alter3.test
363 auth.test bind.test blob.test capi2.test capi3.test collate1.test
364 collate2.test collate3.test collate4.test collate5.test collate6.test
365 conflict.test date.test delete.test expr.test fkey1.test func.test
366 hook.test index.test insert2.test insert.test interrupt.test in.test
367 intpkey.test ioerr.test join2.test join.test lastinsert.test
368 laststmtchanges.test limit.test lock2.test lock.test main.test
369 memdb.test minmax.test misc1.test misc2.test misc3.test notnull.test
370 null.test progress.test quote.test rowid.test select1.test select2.test
371 select3.test select4.test select5.test select6.test sort.test
372 subselect.test tableapi.test table.test temptable.test
373 trace.test trigger1.test trigger2.test trigger3.test
374 trigger4.test types2.test types.test unique.test update.test
375 vacuum.test view.test where.test
376}
377
378# Run some tests in exclusive locking mode.
379#
dan0626dfc2010-06-15 06:56:37 +0000380test_suite "exclusive" -description {
danielk19771077e3f2008-06-21 18:07:37 +0000381 Run tests in exclusive locking mode.
382} -presql {
383 pragma locking_mode = 'exclusive'
dan0626dfc2010-06-15 06:56:37 +0000384} -files {
danielk19771077e3f2008-06-21 18:07:37 +0000385 rollback.test select1.test select2.test
386 malloc.test ioerr.test
387}
388
drh04335882008-09-26 21:08:08 +0000389# Run some tests in exclusive locking mode with truncated journals.
390#
dan0626dfc2010-06-15 06:56:37 +0000391test_suite "exclusive-truncate" -description {
drh04335882008-09-26 21:08:08 +0000392 Run tests in exclusive locking mode and truncate journal mode.
393} -presql {
394 pragma locking_mode = 'exclusive';
395 pragma journal_mode = TRUNCATE;
dan0626dfc2010-06-15 06:56:37 +0000396} -files {
drh04335882008-09-26 21:08:08 +0000397 delete.test delete2.test insert.test rollback.test select1.test
398 select2.test update.test malloc.test ioerr.test
399}
400
danielk19771077e3f2008-06-21 18:07:37 +0000401# Run some tests in persistent journal mode.
402#
dan0626dfc2010-06-15 06:56:37 +0000403test_suite "persistent_journal" -description {
danielk19771077e3f2008-06-21 18:07:37 +0000404 Run tests in persistent-journal mode.
405} -presql {
406 pragma journal_mode = persist
dan0626dfc2010-06-15 06:56:37 +0000407} -files {
danielk19771077e3f2008-06-21 18:07:37 +0000408 delete.test delete2.test insert.test rollback.test select1.test
409 select2.test trans.test update.test vacuum.test
410}
411
drh04335882008-09-26 21:08:08 +0000412# Run some tests in truncating journal mode.
413#
dan0626dfc2010-06-15 06:56:37 +0000414test_suite "truncate_journal" -description {
drh04335882008-09-26 21:08:08 +0000415 Run tests in persistent-journal mode.
416} -presql {
417 pragma journal_mode = truncate
dan0626dfc2010-06-15 06:56:37 +0000418} -files {
drh04335882008-09-26 21:08:08 +0000419 delete.test delete2.test insert.test rollback.test select1.test
420 select2.test trans.test update.test vacuum.test
421 malloc.test ioerr.test
422}
423
danielk19771077e3f2008-06-21 18:07:37 +0000424# Run some error tests in persistent journal mode.
425#
dan0626dfc2010-06-15 06:56:37 +0000426test_suite "persistent_journal_error" -description {
danielk19771077e3f2008-06-21 18:07:37 +0000427 Run malloc.test and ioerr.test in persistent-journal mode.
428} -presql {
429 pragma journal_mode = persist
dan0626dfc2010-06-15 06:56:37 +0000430} -files {
danielk19771077e3f2008-06-21 18:07:37 +0000431 malloc.test ioerr.test
432}
433
434# Run some tests in no journal mode.
435#
dan0626dfc2010-06-15 06:56:37 +0000436test_suite "no_journal" -description {
danielk19771077e3f2008-06-21 18:07:37 +0000437 Run tests in no-journal mode.
438} -presql {
439 pragma journal_mode = persist
dan0626dfc2010-06-15 06:56:37 +0000440} -files {
danielk19771077e3f2008-06-21 18:07:37 +0000441 delete.test delete2.test insert.test rollback.test select1.test
442 select2.test trans.test update.test vacuum.test
443}
444
445# Run some error tests in no journal mode.
446#
dan0626dfc2010-06-15 06:56:37 +0000447test_suite "no_journal_error" -description {
danielk19771077e3f2008-06-21 18:07:37 +0000448 Run malloc.test and ioerr.test in no-journal mode.
449} -presql {
450 pragma journal_mode = persist
dan0626dfc2010-06-15 06:56:37 +0000451} -files {
danielk19771077e3f2008-06-21 18:07:37 +0000452 malloc.test ioerr.test
453}
454
455# Run some crash-tests in autovacuum mode.
456#
dan0626dfc2010-06-15 06:56:37 +0000457test_suite "autovacuum_crash" -description {
danielk19771077e3f2008-06-21 18:07:37 +0000458 Run crash.test in autovacuum mode.
459} -presql {
460 pragma auto_vacuum = 1
dan0626dfc2010-06-15 06:56:37 +0000461} -files crash.test
danielk19771077e3f2008-06-21 18:07:37 +0000462
463# Run some ioerr-tests in autovacuum mode.
464#
dan0626dfc2010-06-15 06:56:37 +0000465test_suite "autovacuum_ioerr" -description {
danielk19771077e3f2008-06-21 18:07:37 +0000466 Run ioerr.test in autovacuum mode.
467} -presql {
468 pragma auto_vacuum = 1
dan0626dfc2010-06-15 06:56:37 +0000469} -files ioerr.test
danielk19771077e3f2008-06-21 18:07:37 +0000470
danielk1977b3175382008-10-17 18:51:52 +0000471# Run tests with an in-memory journal.
472#
dan0626dfc2010-06-15 06:56:37 +0000473test_suite "inmemory_journal" -description {
danielk1977b3175382008-10-17 18:51:52 +0000474 Run tests with an in-memory journal file.
475} -presql {
476 pragma journal_mode = 'memory'
dan0626dfc2010-06-15 06:56:37 +0000477} -files [test_set $::allquicktests -exclude {
danielk1977b3175382008-10-17 18:51:52 +0000478 # Exclude all tests that simulate IO errors.
479 autovacuum_ioerr2.test incrvacuum_ioerr.test ioerr.test
480 ioerr.test ioerr2.test ioerr3.test ioerr4.test ioerr5.test
drh2206a2b2009-04-01 23:09:43 +0000481 vacuum3.test incrblob_err.test diskfull.test backup_ioerr.test
drh08ede1d2010-04-12 20:54:13 +0000482 e_fts3.test
danielk1977b3175382008-10-17 18:51:52 +0000483
484 # Exclude test scripts that use tcl IO to access journal files or count
485 # the number of fsync() calls.
486 pager.test exclusive.test jrnlmode.test sync.test misc1.test
danielk1977cb257902009-04-10 18:32:29 +0000487 journal1.test conflict.test crash8.test tkt3457.test io.test
dan01d38562010-03-08 10:32:38 +0000488
dancb354602010-07-08 09:44:42 +0000489 pager1.test async4.test corrupt.test filefmt.test pager2.test
490 corrupt5.test corruptA.test pageropt.test
491
dan01d38562010-03-08 10:32:38 +0000492 # Exclude stmt.test, which expects sub-journals to use temporary files.
493 stmt.test
drh0b944132010-05-24 20:24:38 +0000494
495 # WAL mode is different.
dan0626dfc2010-06-15 06:56:37 +0000496 wal*
497}]
danielk1977b3175382008-10-17 18:51:52 +0000498
danielk19776b39c2e2008-06-25 14:57:53 +0000499ifcapable mem3 {
dan0626dfc2010-06-15 06:56:37 +0000500 test_suite "memsys3" -description {
danielk19776b39c2e2008-06-25 14:57:53 +0000501 Run tests using the allocator in mem3.c.
daneace5272010-07-05 05:31:48 +0000502 } -files [test_set $::allquicktests -exclude {
drh8a42cbd2008-07-10 18:13:42 +0000503 autovacuum.test delete3.test manydb.test
504 bigrow.test incrblob2.test memdb.test
505 bitvec.test index2.test memsubsys1.test
506 capi3c.test ioerr.test memsubsys2.test
507 capi3.test join3.test pagesize.test
danielk19778b322822009-07-01 18:09:01 +0000508 collate5.test limit.test backup_ioerr.test
509 backup_malloc.test
dan0626dfc2010-06-15 06:56:37 +0000510 }] -initialize {
danielk19776b39c2e2008-06-25 14:57:53 +0000511 catch {db close}
512 sqlite3_reset_auto_extension
513 sqlite3_shutdown
drh7830cd42008-07-16 12:25:32 +0000514 sqlite3_config_heap 25000000 0
drhe2a7c6e2008-08-01 15:06:30 +0000515 sqlite3_config_lookaside 0 0
danielk19778b322822009-07-01 18:09:01 +0000516 ifcapable mem5 {
517 # If both memsys3 and memsys5 are enabled in the build, the call to
518 # [sqlite3_config_heap] will initialize the system to use memsys5.
519 # The following overrides this preference and installs the memsys3
520 # allocator.
521 sqlite3_install_memsys3
522 }
danielk19776b39c2e2008-06-25 14:57:53 +0000523 install_malloc_faultsim 1
524 sqlite3_initialize
525 autoinstall_test_functions
526 } -shutdown {
527 catch {db close}
danielk19776b39c2e2008-06-25 14:57:53 +0000528 sqlite3_shutdown
danielk19770d84e5b2008-06-27 14:05:24 +0000529 sqlite3_config_heap 0 0
drhe2a7c6e2008-08-01 15:06:30 +0000530 sqlite3_config_lookaside 100 500
danielk19776b39c2e2008-06-25 14:57:53 +0000531 install_malloc_faultsim 1
532 sqlite3_initialize
drhbb77b752009-04-09 01:23:49 +0000533 autoinstall_test_functions
danielk19776b39c2e2008-06-25 14:57:53 +0000534 }
danielk197757e5ea92008-06-24 19:02:55 +0000535}
536
danielk19776b39c2e2008-06-25 14:57:53 +0000537ifcapable mem5 {
dan0626dfc2010-06-15 06:56:37 +0000538 test_suite "memsys5" -description {
danielk19776b39c2e2008-06-25 14:57:53 +0000539 Run tests using the allocator in mem5.c.
daneace5272010-07-05 05:31:48 +0000540 } -files [test_set $::allquicktests -exclude {
drh8a42cbd2008-07-10 18:13:42 +0000541 autovacuum.test delete3.test manydb.test
542 bigrow.test incrblob2.test memdb.test
543 bitvec.test index2.test memsubsys1.test
544 capi3c.test ioerr.test memsubsys2.test
545 capi3.test join3.test pagesize.test
danielk1977ac8d7b32008-11-13 16:21:50 +0000546 collate5.test limit.test zeroblob.test
dan0626dfc2010-06-15 06:56:37 +0000547 }] -initialize {
danielk19776b39c2e2008-06-25 14:57:53 +0000548 catch {db close}
danielk19776b39c2e2008-06-25 14:57:53 +0000549 sqlite3_shutdown
drh7830cd42008-07-16 12:25:32 +0000550 sqlite3_config_heap 25000000 64
drhe2a7c6e2008-08-01 15:06:30 +0000551 sqlite3_config_lookaside 0 0
danielk19775099be52008-06-27 13:27:03 +0000552 install_malloc_faultsim 1
553 sqlite3_initialize
554 autoinstall_test_functions
555 } -shutdown {
556 catch {db close}
danielk19775099be52008-06-27 13:27:03 +0000557 sqlite3_shutdown
danielk19770d84e5b2008-06-27 14:05:24 +0000558 sqlite3_config_heap 0 0
drhe2a7c6e2008-08-01 15:06:30 +0000559 sqlite3_config_lookaside 100 500
danielk19775099be52008-06-27 13:27:03 +0000560 install_malloc_faultsim 1
561 sqlite3_initialize
drhbb77b752009-04-09 01:23:49 +0000562 autoinstall_test_functions
danielk19775099be52008-06-27 13:27:03 +0000563 }
564
dan0626dfc2010-06-15 06:56:37 +0000565 test_suite "memsys5-2" -description {
danielk19775099be52008-06-27 13:27:03 +0000566 Run tests using the allocator in mem5.c in a different configuration.
dan0626dfc2010-06-15 06:56:37 +0000567 } -files {
drh8a42cbd2008-07-10 18:13:42 +0000568 select1.test
danielk19775099be52008-06-27 13:27:03 +0000569 } -initialize {
570 catch {db close}
danielk19775099be52008-06-27 13:27:03 +0000571 sqlite3_shutdown
drh7830cd42008-07-16 12:25:32 +0000572 sqlite3_config_heap 40000000 16
drhe2a7c6e2008-08-01 15:06:30 +0000573 sqlite3_config_lookaside 0 0
danielk19776b39c2e2008-06-25 14:57:53 +0000574 install_malloc_faultsim 1
575 sqlite3_initialize
576 autoinstall_test_functions
577 } -shutdown {
578 catch {db close}
danielk19776b39c2e2008-06-25 14:57:53 +0000579 sqlite3_shutdown
danielk19770d84e5b2008-06-27 14:05:24 +0000580 sqlite3_config_heap 0 0
drhe2a7c6e2008-08-01 15:06:30 +0000581 sqlite3_config_lookaside 100 500
danielk19776b39c2e2008-06-25 14:57:53 +0000582 install_malloc_faultsim 1
583 sqlite3_initialize
drhbb77b752009-04-09 01:23:49 +0000584 autoinstall_test_functions
danielk19776b39c2e2008-06-25 14:57:53 +0000585 }
danielk1977c66c0e12008-06-25 14:26:07 +0000586}
587
drh8a42cbd2008-07-10 18:13:42 +0000588ifcapable threadsafe {
dan0626dfc2010-06-15 06:56:37 +0000589 test_suite "no_mutex_try" -description {
drh8a42cbd2008-07-10 18:13:42 +0000590 The sqlite3_mutex_try() interface always fails
dan0626dfc2010-06-15 06:56:37 +0000591 } -files [
592 test_set $::allquicktests -exclude mutex1.test mutex2.test
593 ] -initialize {
drh8a42cbd2008-07-10 18:13:42 +0000594 catch {db close}
595 sqlite3_shutdown
596 install_mutex_counters 1
597 set ::disable_mutex_try 1
drhbb77b752009-04-09 01:23:49 +0000598 sqlite3_initialize
599 autoinstall_test_functions
drh8a42cbd2008-07-10 18:13:42 +0000600 } -shutdown {
601 catch {db close}
602 sqlite3_shutdown
603 install_mutex_counters 0
drhbb77b752009-04-09 01:23:49 +0000604 sqlite3_initialize
605 autoinstall_test_functions
drh8a42cbd2008-07-10 18:13:42 +0000606 }
607}
608
danielk1977b13dee92008-06-23 15:55:52 +0000609# run_tests "crash_safe_append" -description {
610# Run crash.test with persistent journals on a SAFE_APPEND file-system.
611# } -initialize {
612# rename crashsql sa_crashsql
613# proc crashsql {args} {
614# set options [lrange $args 0 [expr {[llength $args]-2}]]
615# lappend options -char safe_append
616# set sql [lindex $args end]
617# lappend options "
618# PRAGMA journal_mode=persistent;
619# $sql
620# "
621# set fd [open test.db-journal w]
622# puts $fd [string repeat 1234567890 100000]
623# close $fd
624# eval sa_crashsql $options
625# }
626# } -shutdown {
627# rename crashsql {}
628# rename sa_crashsql crashsql
dan0626dfc2010-06-15 06:56:37 +0000629# } -files crash.test
danielk1977b13dee92008-06-23 15:55:52 +0000630
dan0626dfc2010-06-15 06:56:37 +0000631test_suite "safe_append" -description {
danielk1977755339e2008-09-12 10:22:40 +0000632 Run some tests on a SAFE_APPEND file-system.
633} -initialize {
634 rename sqlite3 sqlite3_safeappend
635 proc sqlite3 {args} {
636 if {[string range [lindex $args 0] 0 0] ne "-"} {
637 lappend args -vfs devsym
638 }
639 uplevel [concat sqlite3_safeappend $args]
640 }
641 sqlite3_simulate_device -char safe_append
642} -shutdown {
643 rename sqlite3 {}
644 rename sqlite3_shutdown sqlite3
dan0626dfc2010-06-15 06:56:37 +0000645} -files [
646 test_set $::allquicktests shared_err.test -exclude async3.test
647]
danielk1977755339e2008-09-12 10:22:40 +0000648
drhb232c232008-11-19 01:20:26 +0000649# The set of tests to run on the alternative-pcache
650set perm-alt-pcache-testset {
651 async.test
652 attach.test
653 delete.test delete2.test
654 index.test
655 insert.test insert2.test
656 join.test join2.test
657 rollback.test
658 select1.test select2.test
659 trans.test
660 update.test
661}
662
dan0626dfc2010-06-15 06:56:37 +0000663test_suite "pcache0" -description {
drhb232c232008-11-19 01:20:26 +0000664 Alternative pcache implementation without random discard
665} -initialize {
666 catch {db close}
drhb232c232008-11-19 01:20:26 +0000667 sqlite3_shutdown
668 sqlite3_config_alt_pcache 1 0 1
669 sqlite3_initialize
670 autoinstall_test_functions
671} -shutdown {
672 catch {db close}
drhb232c232008-11-19 01:20:26 +0000673 sqlite3_shutdown
674 sqlite3_config_alt_pcache 0 0 0
675 sqlite3_config_lookaside 100 500
676 install_malloc_faultsim 1
677 sqlite3_initialize
drhbb77b752009-04-09 01:23:49 +0000678 autoinstall_test_functions
dan0626dfc2010-06-15 06:56:37 +0000679} -files ${perm-alt-pcache-testset}
drhb232c232008-11-19 01:20:26 +0000680
dan0626dfc2010-06-15 06:56:37 +0000681test_suite "pcache10" -description {
drhb232c232008-11-19 01:20:26 +0000682 Alternative pcache implementation without 10% random discard
683} -initialize {
684 catch {db close}
drhb232c232008-11-19 01:20:26 +0000685 sqlite3_shutdown
686 sqlite3_config_alt_pcache 1 50 1
687 sqlite3_initialize
688 autoinstall_test_functions
689} -shutdown {
690 catch {db close}
drhb232c232008-11-19 01:20:26 +0000691 sqlite3_shutdown
692 sqlite3_config_alt_pcache 0 0 0
693 sqlite3_initialize
drhbb77b752009-04-09 01:23:49 +0000694 autoinstall_test_functions
dan0626dfc2010-06-15 06:56:37 +0000695} -files ${perm-alt-pcache-testset}
drhb232c232008-11-19 01:20:26 +0000696
dan0626dfc2010-06-15 06:56:37 +0000697test_suite "pcache50" -description {
drhb232c232008-11-19 01:20:26 +0000698 Alternative pcache implementation without 50% random discard
699} -initialize {
700 catch {db close}
drhb232c232008-11-19 01:20:26 +0000701 sqlite3_shutdown
702 sqlite3_config_alt_pcache 1 50 1
703 sqlite3_initialize
704 autoinstall_test_functions
705} -shutdown {
706 catch {db close}
drhb232c232008-11-19 01:20:26 +0000707 sqlite3_shutdown
708 sqlite3_config_alt_pcache 0 0 0
709 sqlite3_initialize
drhbb77b752009-04-09 01:23:49 +0000710 autoinstall_test_functions
dan0626dfc2010-06-15 06:56:37 +0000711} -files ${perm-alt-pcache-testset}
drhb232c232008-11-19 01:20:26 +0000712
dan0626dfc2010-06-15 06:56:37 +0000713test_suite "pcache90" -description {
drhb232c232008-11-19 01:20:26 +0000714 Alternative pcache implementation without 90% random discard
715} -initialize {
716 catch {db close}
drhb232c232008-11-19 01:20:26 +0000717 sqlite3_shutdown
718 sqlite3_config_alt_pcache 1 50 1
719 sqlite3_initialize
720 autoinstall_test_functions
721} -shutdown {
722 catch {db close}
drhb232c232008-11-19 01:20:26 +0000723 sqlite3_shutdown
724 sqlite3_config_alt_pcache 0 0 0
725 sqlite3_initialize
drhbb77b752009-04-09 01:23:49 +0000726 autoinstall_test_functions
dan0626dfc2010-06-15 06:56:37 +0000727} -files ${perm-alt-pcache-testset}
drhb232c232008-11-19 01:20:26 +0000728
dan0626dfc2010-06-15 06:56:37 +0000729test_suite "pcache100" -description {
drhb232c232008-11-19 01:20:26 +0000730 Alternative pcache implementation that always discards when unpinning
731} -initialize {
732 catch {db close}
drhb232c232008-11-19 01:20:26 +0000733 sqlite3_shutdown
734 sqlite3_config_alt_pcache 1 100 1
735 sqlite3_initialize
736 autoinstall_test_functions
737} -shutdown {
738 catch {db close}
drhb232c232008-11-19 01:20:26 +0000739 sqlite3_shutdown
740 sqlite3_config_alt_pcache 0 0 0
741 sqlite3_initialize
drhbb77b752009-04-09 01:23:49 +0000742 autoinstall_test_functions
dan0626dfc2010-06-15 06:56:37 +0000743} -files ${perm-alt-pcache-testset}
danielk1977b13dee92008-06-23 15:55:52 +0000744
dan0626dfc2010-06-15 06:56:37 +0000745test_suite "journaltest" -description {
danielk1977f3107512008-12-22 10:58:46 +0000746 Check that pages are synced before being written (test_journal.c).
747} -initialize {
danielk1977f3107512008-12-22 10:58:46 +0000748 catch {db close}
749 register_jt_vfs -default ""
750} -shutdown {
751 unregister_jt_vfs
dan0626dfc2010-06-15 06:56:37 +0000752} -files [test_set $::allquicktests -exclude {
753 wal* incrvacuum.test ioerr.test corrupt4.test io.test crash8.test
754 async4.test bigfile.test
drhfb4a6262010-05-06 19:55:57 +0000755}]
danielk1977f3107512008-12-22 10:58:46 +0000756
dan0a7a9152010-04-07 07:57:38 +0000757if {[info commands register_demovfs] != ""} {
dan0626dfc2010-06-15 06:56:37 +0000758 test_suite "demovfs" -description {
dan430e74c2010-06-07 17:47:26 +0000759 Check that the demovfs (code in test_demovfs.c) more or less works.
dan0a7a9152010-04-07 07:57:38 +0000760 } -initialize {
761 register_demovfs
762 } -shutdown {
763 unregister_demovfs
dan0626dfc2010-06-15 06:56:37 +0000764 } -files {
dan0a7a9152010-04-07 07:57:38 +0000765 insert.test insert2.test insert3.test rollback.test
766 select1.test select2.test select3.test
767 }
768}
769
dan0626dfc2010-06-15 06:56:37 +0000770test_suite "wal" -description {
dan71cb5182010-04-26 12:39:03 +0000771 Run tests with journal_mode=WAL
dan31f98fc2010-04-27 05:42:32 +0000772} -initialize {
dan430e74c2010-06-07 17:47:26 +0000773 set ::G(savepoint6_iterations) 100
dan31f98fc2010-04-27 05:42:32 +0000774} -shutdown {
dan430e74c2010-06-07 17:47:26 +0000775 unset -nocomplain ::G(savepoint6_iterations)
dan0626dfc2010-06-15 06:56:37 +0000776} -files {
dane106de62010-04-27 06:49:34 +0000777 savepoint.test savepoint2.test savepoint6.test
778 trans.test avtrans.test
dan60f9da72010-07-07 11:42:59 +0000779
780 fts3aa.test fts3ab.test fts3ac.test fts3ad.test
781 fts3ae.test fts3af.test fts3ag.test fts3ah.test
782 fts3ai.test fts3aj.test fts3ak.test fts3al.test
783 fts3am.test fts3an.test fts3ao.test fts3b.test
784 fts3c.test fts3d.test fts3e.test fts3query.test
dan71cb5182010-04-26 12:39:03 +0000785}
danielk19771077e3f2008-06-21 18:07:37 +0000786# End of tests
787#############################################################################
788
dan0626dfc2010-06-15 06:56:37 +0000789# run_tests NAME OPTIONS
790#
791# where available options are:
792#
dan2fce9ab2010-06-15 18:00:06 +0000793# -description TITLE
794# -initialize SCRIPT
795# -shutdown SCRIPT
796# -presql SQL
797# -files LIST-OF-FILES
798# -prefix NAME
dan0626dfc2010-06-15 06:56:37 +0000799#
800proc run_tests {name args} {
801 array set options $args
danielk19771077e3f2008-06-21 18:07:37 +0000802
dand506de02010-07-03 13:59:01 +0000803 set ::G(perm:name) $name
804 set ::G(perm:prefix) $options(-prefix)
dan0626dfc2010-06-15 06:56:37 +0000805 set ::G(perm:presql) $options(-presql)
806 set ::G(isquick) 1
807
808 uplevel $options(-initialize)
809
810 foreach file [lsort $options(-files)] {
811 slave_test_file $::testdir/$file
812 }
813
814 uplevel $options(-shutdown)
815
816 unset ::G(perm:name)
dand506de02010-07-03 13:59:01 +0000817 unset ::G(perm:prefix)
dan0626dfc2010-06-15 06:56:37 +0000818 unset ::G(perm:presql)
819}
820
821proc run_test_suite {name} {
822 if {[info exists ::testspec($name)]==0} {
823 error "No such test suite: $name"
824 }
825 uplevel run_tests $name $::testspec($name)
826}
827
828proc help {} {
dane91a54e2010-06-15 17:44:47 +0000829 puts "Usage: $::argv0 TESTSUITE ?TESTFILE?"
830 puts ""
831 puts "Available test-suites are:"
dan0626dfc2010-06-15 06:56:37 +0000832 foreach k $::testsuitelist {
dane91a54e2010-06-15 17:44:47 +0000833 if {[info exists ::testspec($k)]==0} {
834 puts " ----------------------------------------"
835 puts ""
836 } else {
837 array set o $::testspec($k)
838 puts "Test suite: \"$k\""
839 set d [string trim $o(-description)]
840 set d [regsub {\n *} $d "\n "]
841 puts " $d"
842 puts ""
843 }
dan0626dfc2010-06-15 06:56:37 +0000844 }
845 exit -1
846}
847
848if {[info script] == $argv0} {
849 proc main {argv} {
850 if {[llength $argv]==0} {
851 help
852 } else {
853 set suite [lindex $argv 0]
854 if {[info exists ::testspec($suite)]==0} help
855 set extra ""
856 if {[llength $argv]>1} { set extra [list -files [lrange $argv 1 end]] }
857 eval run_tests $suite $::testspec($suite) $extra
858 }
859 }
860 main $argv
861 finish_test
862}
863