blob: e1846c13ac4e4e6bde3891f672bef0b8f484001f [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
101 misc7.test mutex2.test notify2.test onefile.test
102 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
108 walthread.test
109}]
danielk1977c1def3e2008-08-30 13:25:10 +0000110
danielk19771077e3f2008-06-21 18:07:37 +0000111#############################################################################
112# Start of tests
dan0626dfc2010-06-15 06:56:37 +0000113#
114
115#-------------------------------------------------------------------------
116# Define the generic test suites:
117#
118# veryquick
119# quick
120# full
121# veryquick_plus_notify2
122#
dane91a54e2010-06-15 17:44:47 +0000123lappend ::testsuitelist xxx
dan0626dfc2010-06-15 06:56:37 +0000124
dan2fce9ab2010-06-15 18:00:06 +0000125test_suite "veryquick" -prefix "" -description {
dan0626dfc2010-06-15 06:56:37 +0000126 "Very" quick test suite. Runs in less than 5 minutes on a workstation.
127 This test suite is the same as the "quick" tests, except that some files
128 that test malloc and IO errors are omitted.
129} -files [
130 test_set $allquicktests -exclude *malloc* *ioerr* *fault*
131]
132
dan2fce9ab2010-06-15 18:00:06 +0000133test_suite "quick" -prefix "" -description {
dan0626dfc2010-06-15 06:56:37 +0000134 Quick test suite. Runs in around 10 minutes on a workstation.
135} -files [
136 test_set $allquicktests
137]
138
dan2fce9ab2010-06-15 18:00:06 +0000139test_suite "veryquick_plus_notify2" -prefix "" -description {
dan0626dfc2010-06-15 06:56:37 +0000140 Very quick test suite + file notify2.test. This is used by one of the
141 sqlite.org release test configurations.
142} -files [
143 test_set $allquicktests notify2.test -exclude *malloc* *ioerr* *fault*
144]
145
dan2fce9ab2010-06-15 18:00:06 +0000146test_suite "full" -prefix "" -description {
dan0626dfc2010-06-15 06:56:37 +0000147 Full test suite. Takes a long time.
148} -files [
149 test_set $alltests
150] -initialize {
151 unset -nocomplain ::G(isquick)
152}
153
dane91a54e2010-06-15 17:44:47 +0000154lappend ::testsuitelist xxx
dan0626dfc2010-06-15 06:56:37 +0000155#-------------------------------------------------------------------------
156# Define the coverage related test suites:
157#
158# coverage-wal
dan0626dfc2010-06-15 06:56:37 +0000159#
160test_suite "coverage-wal" -description {
161 Coverage tests for file wal.c.
162} -files {
163 wal.test wal2.test wal3.test walmode.test
164 walbak.test walhook.test walcrash2.test walcksum.test
165 walfault.test
166}
167
dane91a54e2010-06-15 17:44:47 +0000168test_suite "coverage-pager" -description {
169 Coverage tests for file pager.c.
170} -files {
171 pager1.test
dan153eda02010-06-21 07:45:47 +0000172 pager2.test
danb0ac3e32010-06-16 10:55:42 +0000173 pagerfault.test
dan146ed782010-06-19 17:26:37 +0000174 journal2.test
dane91a54e2010-06-15 17:44:47 +0000175}
dan0626dfc2010-06-15 06:56:37 +0000176
177
dane91a54e2010-06-15 17:44:47 +0000178lappend ::testsuitelist xxx
dan0626dfc2010-06-15 06:56:37 +0000179#-------------------------------------------------------------------------
180# Define the permutation test suites:
181#
danielk19771077e3f2008-06-21 18:07:37 +0000182
183# Run some tests using pre-allocated page and scratch blocks.
184#
dan0626dfc2010-06-15 06:56:37 +0000185test_suite "memsubsys1" -description {
danielk19771077e3f2008-06-21 18:07:37 +0000186 Tests using pre-allocated page and scratch blocks
dan0626dfc2010-06-15 06:56:37 +0000187} -files [
188 test_set $::allquicktests -exclude ioerr5.test malloc5.test
189] -initialize {
drhd63bd752008-07-30 13:15:46 +0000190 catch {db close}
danielk19771077e3f2008-06-21 18:07:37 +0000191 sqlite3_shutdown
192 sqlite3_config_pagecache 4096 24
193 sqlite3_config_scratch 25000 1
194 sqlite3_initialize
drhbb77b752009-04-09 01:23:49 +0000195 autoinstall_test_functions
danielk19771077e3f2008-06-21 18:07:37 +0000196} -shutdown {
197 catch {db close}
198 sqlite3_shutdown
199 sqlite3_config_pagecache 0 0
200 sqlite3_config_scratch 0 0
201 sqlite3_initialize
drhbb77b752009-04-09 01:23:49 +0000202 autoinstall_test_functions
danielk19771077e3f2008-06-21 18:07:37 +0000203}
204
205# Run some tests using pre-allocated page and scratch blocks. This time
206# the allocations are too small to use in most cases.
207#
danielk197734c61e62008-08-29 12:00:20 +0000208# Both ioerr5.test and malloc5.test are excluded because they test the
209# sqlite3_soft_heap_limit() and sqlite3_release_memory() functionality.
210# This functionality is disabled if a pre-allocated page block is provided.
211#
dan0626dfc2010-06-15 06:56:37 +0000212test_suite "memsubsys2" -description {
danielk19771077e3f2008-06-21 18:07:37 +0000213 Tests using small pre-allocated page and scratch blocks
dan0626dfc2010-06-15 06:56:37 +0000214} -files [
215 test_set $::allquicktests -exclude ioerr5.test malloc5.test
216] -initialize {
drhd63bd752008-07-30 13:15:46 +0000217 catch {db close}
danielk19771077e3f2008-06-21 18:07:37 +0000218 sqlite3_shutdown
219 sqlite3_config_pagecache 512 5
220 sqlite3_config_scratch 1000 1
221 sqlite3_initialize
drhbb77b752009-04-09 01:23:49 +0000222 autoinstall_test_functions
danielk19771077e3f2008-06-21 18:07:37 +0000223} -shutdown {
224 catch {db close}
225 sqlite3_shutdown
226 sqlite3_config_pagecache 0 0
227 sqlite3_config_scratch 0 0
228 sqlite3_initialize
drhbb77b752009-04-09 01:23:49 +0000229 autoinstall_test_functions
danielk19771077e3f2008-06-21 18:07:37 +0000230}
231
drhe2a7c6e2008-08-01 15:06:30 +0000232# Run all tests with the lookaside allocator disabled.
233#
dan0626dfc2010-06-15 06:56:37 +0000234test_suite "nolookaside" -description {
drhe2a7c6e2008-08-01 15:06:30 +0000235 OOM tests with lookaside disabled
drhe2a7c6e2008-08-01 15:06:30 +0000236} -initialize {
237 catch {db close}
238 sqlite3_shutdown
239 sqlite3_config_lookaside 0 0
240 sqlite3_initialize
drhbb77b752009-04-09 01:23:49 +0000241 autoinstall_test_functions
drhe2a7c6e2008-08-01 15:06:30 +0000242} -shutdown {
243 catch {db close}
244 sqlite3_shutdown
245 sqlite3_config_lookaside 100 500
246 sqlite3_initialize
drhbb77b752009-04-09 01:23:49 +0000247 autoinstall_test_functions
dan0626dfc2010-06-15 06:56:37 +0000248} -files $::allquicktests
drhe2a7c6e2008-08-01 15:06:30 +0000249
danielk19771077e3f2008-06-21 18:07:37 +0000250# Run some tests in SQLITE_CONFIG_SINGLETHREAD mode.
251#
dan0626dfc2010-06-15 06:56:37 +0000252test_suite "singlethread" -description {
danielk19771077e3f2008-06-21 18:07:37 +0000253 Tests run in SQLITE_CONFIG_SINGLETHREAD mode
254} -initialize {
drh04df18d2009-01-06 14:50:11 +0000255 catch {db close}
256 sqlite3_shutdown
257 catch {sqlite3_config singlethread}
drhbb77b752009-04-09 01:23:49 +0000258 sqlite3_initialize
259 autoinstall_test_functions
dan0626dfc2010-06-15 06:56:37 +0000260} -files {
danielk19771077e3f2008-06-21 18:07:37 +0000261 delete.test delete2.test insert.test rollback.test select1.test
262 select2.test trans.test update.test vacuum.test types.test
263 types2.test types3.test
264} -shutdown {
drh04df18d2009-01-06 14:50:11 +0000265 catch {db close}
266 sqlite3_shutdown
267 catch {sqlite3_config serialized}
drhbb77b752009-04-09 01:23:49 +0000268 sqlite3_initialize
269 autoinstall_test_functions
danielk19771077e3f2008-06-21 18:07:37 +0000270}
271
dan0626dfc2010-06-15 06:56:37 +0000272test_suite "nomutex" -description {
drh039963a2008-09-03 00:43:15 +0000273 Tests run with the SQLITE_OPEN_MULTITHREADED flag passed to sqlite3_open().
danielk19779a6284c2008-07-10 17:52:49 +0000274} -initialize {
275 rename sqlite3 sqlite3_nomutex
276 proc sqlite3 {args} {
277 if {[string range [lindex $args 0] 0 0] ne "-"} {
drhcc91e7f2008-09-03 01:08:00 +0000278 lappend args -fullmutex 0 -nomutex 1
danielk19779a6284c2008-07-10 17:52:49 +0000279 }
280 uplevel [concat sqlite3_nomutex $args]
281 }
dan0626dfc2010-06-15 06:56:37 +0000282} -files {
danielk19779a6284c2008-07-10 17:52:49 +0000283 delete.test delete2.test insert.test rollback.test select1.test
284 select2.test trans.test update.test vacuum.test types.test
285 types2.test types3.test
286} -shutdown {
287 rename sqlite3 {}
288 rename sqlite3_nomutex sqlite3
289}
290
danielk19771077e3f2008-06-21 18:07:37 +0000291# Run some tests in SQLITE_CONFIG_MULTITHREAD mode.
292#
dan0626dfc2010-06-15 06:56:37 +0000293test_suite "multithread" -description {
danielk19771077e3f2008-06-21 18:07:37 +0000294 Tests run in SQLITE_CONFIG_MULTITHREAD mode
295} -initialize {
drh04df18d2009-01-06 14:50:11 +0000296 catch {db close}
297 sqlite3_shutdown
298 catch {sqlite3_config multithread}
drhbb77b752009-04-09 01:23:49 +0000299 sqlite3_initialize
300 autoinstall_test_functions
dan0626dfc2010-06-15 06:56:37 +0000301} -files {
danielk19771077e3f2008-06-21 18:07:37 +0000302 delete.test delete2.test insert.test rollback.test select1.test
303 select2.test trans.test update.test vacuum.test types.test
304 types2.test types3.test
305} -shutdown {
drh04df18d2009-01-06 14:50:11 +0000306 catch {db close}
307 sqlite3_shutdown
308 catch {sqlite3_config serialized}
drhbb77b752009-04-09 01:23:49 +0000309 sqlite3_initialize
310 autoinstall_test_functions
danielk19771077e3f2008-06-21 18:07:37 +0000311}
312
drh039963a2008-09-03 00:43:15 +0000313# Run some tests in SQLITE_OPEN_FULLMUTEX mode.
314#
dan0626dfc2010-06-15 06:56:37 +0000315test_suite "fullmutex" -description {
drh039963a2008-09-03 00:43:15 +0000316 Tests run in SQLITE_OPEN_FULLMUTEX mode
317} -initialize {
318 rename sqlite3 sqlite3_fullmutex
319 proc sqlite3 {args} {
320 if {[string range [lindex $args 0] 0 0] ne "-"} {
drhcc91e7f2008-09-03 01:08:00 +0000321 lappend args -nomutex 0 -fullmutex 1
drh039963a2008-09-03 00:43:15 +0000322 }
323 uplevel [concat sqlite3_fullmutex $args]
324 }
dan0626dfc2010-06-15 06:56:37 +0000325} -files {
drh039963a2008-09-03 00:43:15 +0000326 delete.test delete2.test insert.test rollback.test select1.test
327 select2.test trans.test update.test vacuum.test types.test
328 types2.test types3.test
329} -shutdown {
330 rename sqlite3 {}
331 rename sqlite3_fullmutex sqlite3
332}
333
danielk19771077e3f2008-06-21 18:07:37 +0000334# Run some tests using the "onefile" demo.
335#
dan0626dfc2010-06-15 06:56:37 +0000336test_suite "onefile" -description {
danielk19771077e3f2008-06-21 18:07:37 +0000337 Run some tests using the "test_onefile.c" demo
338} -initialize {
339 rename sqlite3 sqlite3_onefile
340 proc sqlite3 {args} {
341 if {[string range [lindex $args 0] 0 0] ne "-"} {
342 lappend args -vfs fs
343 }
344 uplevel [concat sqlite3_onefile $args]
345 }
dan0626dfc2010-06-15 06:56:37 +0000346} -files {
danielk19771077e3f2008-06-21 18:07:37 +0000347 conflict.test insert.test insert2.test insert3.test
348 rollback.test select1.test select2.test select3.test
danielk19771077e3f2008-06-21 18:07:37 +0000349} -shutdown {
350 rename sqlite3 {}
351 rename sqlite3_onefile sqlite3
352}
353
354# Run some tests using UTF-16 databases.
355#
dan0626dfc2010-06-15 06:56:37 +0000356test_suite "utf16" -description {
danielk19771077e3f2008-06-21 18:07:37 +0000357 Run tests using UTF-16 databases
danielk19772dd6d802008-06-21 19:10:27 +0000358} -presql {
danielk19771077e3f2008-06-21 18:07:37 +0000359 pragma encoding = 'UTF-16'
dan0626dfc2010-06-15 06:56:37 +0000360} -files {
danielk19771077e3f2008-06-21 18:07:37 +0000361 alter.test alter3.test
362 auth.test bind.test blob.test capi2.test capi3.test collate1.test
363 collate2.test collate3.test collate4.test collate5.test collate6.test
364 conflict.test date.test delete.test expr.test fkey1.test func.test
365 hook.test index.test insert2.test insert.test interrupt.test in.test
366 intpkey.test ioerr.test join2.test join.test lastinsert.test
367 laststmtchanges.test limit.test lock2.test lock.test main.test
368 memdb.test minmax.test misc1.test misc2.test misc3.test notnull.test
369 null.test progress.test quote.test rowid.test select1.test select2.test
370 select3.test select4.test select5.test select6.test sort.test
371 subselect.test tableapi.test table.test temptable.test
372 trace.test trigger1.test trigger2.test trigger3.test
373 trigger4.test types2.test types.test unique.test update.test
374 vacuum.test view.test where.test
375}
376
377# Run some tests in exclusive locking mode.
378#
dan0626dfc2010-06-15 06:56:37 +0000379test_suite "exclusive" -description {
danielk19771077e3f2008-06-21 18:07:37 +0000380 Run tests in exclusive locking mode.
381} -presql {
382 pragma locking_mode = 'exclusive'
dan0626dfc2010-06-15 06:56:37 +0000383} -files {
danielk19771077e3f2008-06-21 18:07:37 +0000384 rollback.test select1.test select2.test
385 malloc.test ioerr.test
386}
387
drh04335882008-09-26 21:08:08 +0000388# Run some tests in exclusive locking mode with truncated journals.
389#
dan0626dfc2010-06-15 06:56:37 +0000390test_suite "exclusive-truncate" -description {
drh04335882008-09-26 21:08:08 +0000391 Run tests in exclusive locking mode and truncate journal mode.
392} -presql {
393 pragma locking_mode = 'exclusive';
394 pragma journal_mode = TRUNCATE;
dan0626dfc2010-06-15 06:56:37 +0000395} -files {
drh04335882008-09-26 21:08:08 +0000396 delete.test delete2.test insert.test rollback.test select1.test
397 select2.test update.test malloc.test ioerr.test
398}
399
danielk19771077e3f2008-06-21 18:07:37 +0000400# Run some tests in persistent journal mode.
401#
dan0626dfc2010-06-15 06:56:37 +0000402test_suite "persistent_journal" -description {
danielk19771077e3f2008-06-21 18:07:37 +0000403 Run tests in persistent-journal mode.
404} -presql {
405 pragma journal_mode = persist
dan0626dfc2010-06-15 06:56:37 +0000406} -files {
danielk19771077e3f2008-06-21 18:07:37 +0000407 delete.test delete2.test insert.test rollback.test select1.test
408 select2.test trans.test update.test vacuum.test
409}
410
drh04335882008-09-26 21:08:08 +0000411# Run some tests in truncating journal mode.
412#
dan0626dfc2010-06-15 06:56:37 +0000413test_suite "truncate_journal" -description {
drh04335882008-09-26 21:08:08 +0000414 Run tests in persistent-journal mode.
415} -presql {
416 pragma journal_mode = truncate
dan0626dfc2010-06-15 06:56:37 +0000417} -files {
drh04335882008-09-26 21:08:08 +0000418 delete.test delete2.test insert.test rollback.test select1.test
419 select2.test trans.test update.test vacuum.test
420 malloc.test ioerr.test
421}
422
danielk19771077e3f2008-06-21 18:07:37 +0000423# Run some error tests in persistent journal mode.
424#
dan0626dfc2010-06-15 06:56:37 +0000425test_suite "persistent_journal_error" -description {
danielk19771077e3f2008-06-21 18:07:37 +0000426 Run malloc.test and ioerr.test in persistent-journal mode.
427} -presql {
428 pragma journal_mode = persist
dan0626dfc2010-06-15 06:56:37 +0000429} -files {
danielk19771077e3f2008-06-21 18:07:37 +0000430 malloc.test ioerr.test
431}
432
433# Run some tests in no journal mode.
434#
dan0626dfc2010-06-15 06:56:37 +0000435test_suite "no_journal" -description {
danielk19771077e3f2008-06-21 18:07:37 +0000436 Run tests in no-journal mode.
437} -presql {
438 pragma journal_mode = persist
dan0626dfc2010-06-15 06:56:37 +0000439} -files {
danielk19771077e3f2008-06-21 18:07:37 +0000440 delete.test delete2.test insert.test rollback.test select1.test
441 select2.test trans.test update.test vacuum.test
442}
443
444# Run some error tests in no journal mode.
445#
dan0626dfc2010-06-15 06:56:37 +0000446test_suite "no_journal_error" -description {
danielk19771077e3f2008-06-21 18:07:37 +0000447 Run malloc.test and ioerr.test in no-journal mode.
448} -presql {
449 pragma journal_mode = persist
dan0626dfc2010-06-15 06:56:37 +0000450} -files {
danielk19771077e3f2008-06-21 18:07:37 +0000451 malloc.test ioerr.test
452}
453
454# Run some crash-tests in autovacuum mode.
455#
dan0626dfc2010-06-15 06:56:37 +0000456test_suite "autovacuum_crash" -description {
danielk19771077e3f2008-06-21 18:07:37 +0000457 Run crash.test in autovacuum mode.
458} -presql {
459 pragma auto_vacuum = 1
dan0626dfc2010-06-15 06:56:37 +0000460} -files crash.test
danielk19771077e3f2008-06-21 18:07:37 +0000461
462# Run some ioerr-tests in autovacuum mode.
463#
dan0626dfc2010-06-15 06:56:37 +0000464test_suite "autovacuum_ioerr" -description {
danielk19771077e3f2008-06-21 18:07:37 +0000465 Run ioerr.test in autovacuum mode.
466} -presql {
467 pragma auto_vacuum = 1
dan0626dfc2010-06-15 06:56:37 +0000468} -files ioerr.test
danielk19771077e3f2008-06-21 18:07:37 +0000469
danielk1977b3175382008-10-17 18:51:52 +0000470# Run tests with an in-memory journal.
471#
dan0626dfc2010-06-15 06:56:37 +0000472test_suite "inmemory_journal" -description {
danielk1977b3175382008-10-17 18:51:52 +0000473 Run tests with an in-memory journal file.
474} -presql {
475 pragma journal_mode = 'memory'
dan0626dfc2010-06-15 06:56:37 +0000476} -files [test_set $::allquicktests -exclude {
danielk1977b3175382008-10-17 18:51:52 +0000477 # Exclude all tests that simulate IO errors.
478 autovacuum_ioerr2.test incrvacuum_ioerr.test ioerr.test
479 ioerr.test ioerr2.test ioerr3.test ioerr4.test ioerr5.test
drh2206a2b2009-04-01 23:09:43 +0000480 vacuum3.test incrblob_err.test diskfull.test backup_ioerr.test
drh08ede1d2010-04-12 20:54:13 +0000481 e_fts3.test
danielk1977b3175382008-10-17 18:51:52 +0000482
483 # Exclude test scripts that use tcl IO to access journal files or count
484 # the number of fsync() calls.
485 pager.test exclusive.test jrnlmode.test sync.test misc1.test
danielk1977cb257902009-04-10 18:32:29 +0000486 journal1.test conflict.test crash8.test tkt3457.test io.test
dan01d38562010-03-08 10:32:38 +0000487
488 # Exclude stmt.test, which expects sub-journals to use temporary files.
489 stmt.test
drh0b944132010-05-24 20:24:38 +0000490
491 # WAL mode is different.
dan0626dfc2010-06-15 06:56:37 +0000492 wal*
493}]
danielk1977b3175382008-10-17 18:51:52 +0000494
danielk19776b39c2e2008-06-25 14:57:53 +0000495ifcapable mem3 {
dan0626dfc2010-06-15 06:56:37 +0000496 test_suite "memsys3" -description {
danielk19776b39c2e2008-06-25 14:57:53 +0000497 Run tests using the allocator in mem3.c.
dan0626dfc2010-06-15 06:56:37 +0000498 } [test_set $::allquicktests -exclude {
drh8a42cbd2008-07-10 18:13:42 +0000499 autovacuum.test delete3.test manydb.test
500 bigrow.test incrblob2.test memdb.test
501 bitvec.test index2.test memsubsys1.test
502 capi3c.test ioerr.test memsubsys2.test
503 capi3.test join3.test pagesize.test
danielk19778b322822009-07-01 18:09:01 +0000504 collate5.test limit.test backup_ioerr.test
505 backup_malloc.test
dan0626dfc2010-06-15 06:56:37 +0000506 }] -initialize {
danielk19776b39c2e2008-06-25 14:57:53 +0000507 catch {db close}
508 sqlite3_reset_auto_extension
509 sqlite3_shutdown
drh7830cd42008-07-16 12:25:32 +0000510 sqlite3_config_heap 25000000 0
drhe2a7c6e2008-08-01 15:06:30 +0000511 sqlite3_config_lookaside 0 0
danielk19778b322822009-07-01 18:09:01 +0000512 ifcapable mem5 {
513 # If both memsys3 and memsys5 are enabled in the build, the call to
514 # [sqlite3_config_heap] will initialize the system to use memsys5.
515 # The following overrides this preference and installs the memsys3
516 # allocator.
517 sqlite3_install_memsys3
518 }
danielk19776b39c2e2008-06-25 14:57:53 +0000519 install_malloc_faultsim 1
520 sqlite3_initialize
521 autoinstall_test_functions
522 } -shutdown {
523 catch {db close}
danielk19776b39c2e2008-06-25 14:57:53 +0000524 sqlite3_shutdown
danielk19770d84e5b2008-06-27 14:05:24 +0000525 sqlite3_config_heap 0 0
drhe2a7c6e2008-08-01 15:06:30 +0000526 sqlite3_config_lookaside 100 500
danielk19776b39c2e2008-06-25 14:57:53 +0000527 install_malloc_faultsim 1
528 sqlite3_initialize
drhbb77b752009-04-09 01:23:49 +0000529 autoinstall_test_functions
danielk19776b39c2e2008-06-25 14:57:53 +0000530 }
danielk197757e5ea92008-06-24 19:02:55 +0000531}
532
danielk19776b39c2e2008-06-25 14:57:53 +0000533ifcapable mem5 {
dan0626dfc2010-06-15 06:56:37 +0000534 test_suite "memsys5" -description {
danielk19776b39c2e2008-06-25 14:57:53 +0000535 Run tests using the allocator in mem5.c.
dan0626dfc2010-06-15 06:56:37 +0000536 } [test_set $::allquicktests -exclude {
drh8a42cbd2008-07-10 18:13:42 +0000537 autovacuum.test delete3.test manydb.test
538 bigrow.test incrblob2.test memdb.test
539 bitvec.test index2.test memsubsys1.test
540 capi3c.test ioerr.test memsubsys2.test
541 capi3.test join3.test pagesize.test
danielk1977ac8d7b32008-11-13 16:21:50 +0000542 collate5.test limit.test zeroblob.test
dan0626dfc2010-06-15 06:56:37 +0000543 }] -initialize {
danielk19776b39c2e2008-06-25 14:57:53 +0000544 catch {db close}
danielk19776b39c2e2008-06-25 14:57:53 +0000545 sqlite3_shutdown
drh7830cd42008-07-16 12:25:32 +0000546 sqlite3_config_heap 25000000 64
drhe2a7c6e2008-08-01 15:06:30 +0000547 sqlite3_config_lookaside 0 0
danielk19775099be52008-06-27 13:27:03 +0000548 install_malloc_faultsim 1
549 sqlite3_initialize
550 autoinstall_test_functions
551 } -shutdown {
552 catch {db close}
danielk19775099be52008-06-27 13:27:03 +0000553 sqlite3_shutdown
danielk19770d84e5b2008-06-27 14:05:24 +0000554 sqlite3_config_heap 0 0
drhe2a7c6e2008-08-01 15:06:30 +0000555 sqlite3_config_lookaside 100 500
danielk19775099be52008-06-27 13:27:03 +0000556 install_malloc_faultsim 1
557 sqlite3_initialize
drhbb77b752009-04-09 01:23:49 +0000558 autoinstall_test_functions
danielk19775099be52008-06-27 13:27:03 +0000559 }
560
dan0626dfc2010-06-15 06:56:37 +0000561 test_suite "memsys5-2" -description {
danielk19775099be52008-06-27 13:27:03 +0000562 Run tests using the allocator in mem5.c in a different configuration.
dan0626dfc2010-06-15 06:56:37 +0000563 } -files {
drh8a42cbd2008-07-10 18:13:42 +0000564 select1.test
danielk19775099be52008-06-27 13:27:03 +0000565 } -initialize {
566 catch {db close}
danielk19775099be52008-06-27 13:27:03 +0000567 sqlite3_shutdown
drh7830cd42008-07-16 12:25:32 +0000568 sqlite3_config_heap 40000000 16
drhe2a7c6e2008-08-01 15:06:30 +0000569 sqlite3_config_lookaside 0 0
danielk19776b39c2e2008-06-25 14:57:53 +0000570 install_malloc_faultsim 1
571 sqlite3_initialize
572 autoinstall_test_functions
573 } -shutdown {
574 catch {db close}
danielk19776b39c2e2008-06-25 14:57:53 +0000575 sqlite3_shutdown
danielk19770d84e5b2008-06-27 14:05:24 +0000576 sqlite3_config_heap 0 0
drhe2a7c6e2008-08-01 15:06:30 +0000577 sqlite3_config_lookaside 100 500
danielk19776b39c2e2008-06-25 14:57:53 +0000578 install_malloc_faultsim 1
579 sqlite3_initialize
drhbb77b752009-04-09 01:23:49 +0000580 autoinstall_test_functions
danielk19776b39c2e2008-06-25 14:57:53 +0000581 }
danielk1977c66c0e12008-06-25 14:26:07 +0000582}
583
drh8a42cbd2008-07-10 18:13:42 +0000584ifcapable threadsafe {
dan0626dfc2010-06-15 06:56:37 +0000585 test_suite "no_mutex_try" -description {
drh8a42cbd2008-07-10 18:13:42 +0000586 The sqlite3_mutex_try() interface always fails
dan0626dfc2010-06-15 06:56:37 +0000587 } -files [
588 test_set $::allquicktests -exclude mutex1.test mutex2.test
589 ] -initialize {
drh8a42cbd2008-07-10 18:13:42 +0000590 catch {db close}
591 sqlite3_shutdown
592 install_mutex_counters 1
593 set ::disable_mutex_try 1
drhbb77b752009-04-09 01:23:49 +0000594 sqlite3_initialize
595 autoinstall_test_functions
drh8a42cbd2008-07-10 18:13:42 +0000596 } -shutdown {
597 catch {db close}
598 sqlite3_shutdown
599 install_mutex_counters 0
drhbb77b752009-04-09 01:23:49 +0000600 sqlite3_initialize
601 autoinstall_test_functions
drh8a42cbd2008-07-10 18:13:42 +0000602 }
603}
604
danielk1977b13dee92008-06-23 15:55:52 +0000605# run_tests "crash_safe_append" -description {
606# Run crash.test with persistent journals on a SAFE_APPEND file-system.
607# } -initialize {
608# rename crashsql sa_crashsql
609# proc crashsql {args} {
610# set options [lrange $args 0 [expr {[llength $args]-2}]]
611# lappend options -char safe_append
612# set sql [lindex $args end]
613# lappend options "
614# PRAGMA journal_mode=persistent;
615# $sql
616# "
617# set fd [open test.db-journal w]
618# puts $fd [string repeat 1234567890 100000]
619# close $fd
620# eval sa_crashsql $options
621# }
622# } -shutdown {
623# rename crashsql {}
624# rename sa_crashsql crashsql
dan0626dfc2010-06-15 06:56:37 +0000625# } -files crash.test
danielk1977b13dee92008-06-23 15:55:52 +0000626
dan0626dfc2010-06-15 06:56:37 +0000627test_suite "safe_append" -description {
danielk1977755339e2008-09-12 10:22:40 +0000628 Run some tests on a SAFE_APPEND file-system.
629} -initialize {
630 rename sqlite3 sqlite3_safeappend
631 proc sqlite3 {args} {
632 if {[string range [lindex $args 0] 0 0] ne "-"} {
633 lappend args -vfs devsym
634 }
635 uplevel [concat sqlite3_safeappend $args]
636 }
637 sqlite3_simulate_device -char safe_append
638} -shutdown {
639 rename sqlite3 {}
640 rename sqlite3_shutdown sqlite3
dan0626dfc2010-06-15 06:56:37 +0000641} -files [
642 test_set $::allquicktests shared_err.test -exclude async3.test
643]
danielk1977755339e2008-09-12 10:22:40 +0000644
drhb232c232008-11-19 01:20:26 +0000645# The set of tests to run on the alternative-pcache
646set perm-alt-pcache-testset {
647 async.test
648 attach.test
649 delete.test delete2.test
650 index.test
651 insert.test insert2.test
652 join.test join2.test
653 rollback.test
654 select1.test select2.test
655 trans.test
656 update.test
657}
658
dan0626dfc2010-06-15 06:56:37 +0000659test_suite "pcache0" -description {
drhb232c232008-11-19 01:20:26 +0000660 Alternative pcache implementation without random discard
661} -initialize {
662 catch {db close}
drhb232c232008-11-19 01:20:26 +0000663 sqlite3_shutdown
664 sqlite3_config_alt_pcache 1 0 1
665 sqlite3_initialize
666 autoinstall_test_functions
667} -shutdown {
668 catch {db close}
drhb232c232008-11-19 01:20:26 +0000669 sqlite3_shutdown
670 sqlite3_config_alt_pcache 0 0 0
671 sqlite3_config_lookaside 100 500
672 install_malloc_faultsim 1
673 sqlite3_initialize
drhbb77b752009-04-09 01:23:49 +0000674 autoinstall_test_functions
dan0626dfc2010-06-15 06:56:37 +0000675} -files ${perm-alt-pcache-testset}
drhb232c232008-11-19 01:20:26 +0000676
dan0626dfc2010-06-15 06:56:37 +0000677test_suite "pcache10" -description {
drhb232c232008-11-19 01:20:26 +0000678 Alternative pcache implementation without 10% random discard
679} -initialize {
680 catch {db close}
drhb232c232008-11-19 01:20:26 +0000681 sqlite3_shutdown
682 sqlite3_config_alt_pcache 1 50 1
683 sqlite3_initialize
684 autoinstall_test_functions
685} -shutdown {
686 catch {db close}
drhb232c232008-11-19 01:20:26 +0000687 sqlite3_shutdown
688 sqlite3_config_alt_pcache 0 0 0
689 sqlite3_initialize
drhbb77b752009-04-09 01:23:49 +0000690 autoinstall_test_functions
dan0626dfc2010-06-15 06:56:37 +0000691} -files ${perm-alt-pcache-testset}
drhb232c232008-11-19 01:20:26 +0000692
dan0626dfc2010-06-15 06:56:37 +0000693test_suite "pcache50" -description {
drhb232c232008-11-19 01:20:26 +0000694 Alternative pcache implementation without 50% random discard
695} -initialize {
696 catch {db close}
drhb232c232008-11-19 01:20:26 +0000697 sqlite3_shutdown
698 sqlite3_config_alt_pcache 1 50 1
699 sqlite3_initialize
700 autoinstall_test_functions
701} -shutdown {
702 catch {db close}
drhb232c232008-11-19 01:20:26 +0000703 sqlite3_shutdown
704 sqlite3_config_alt_pcache 0 0 0
705 sqlite3_initialize
drhbb77b752009-04-09 01:23:49 +0000706 autoinstall_test_functions
dan0626dfc2010-06-15 06:56:37 +0000707} -files ${perm-alt-pcache-testset}
drhb232c232008-11-19 01:20:26 +0000708
dan0626dfc2010-06-15 06:56:37 +0000709test_suite "pcache90" -description {
drhb232c232008-11-19 01:20:26 +0000710 Alternative pcache implementation without 90% random discard
711} -initialize {
712 catch {db close}
drhb232c232008-11-19 01:20:26 +0000713 sqlite3_shutdown
714 sqlite3_config_alt_pcache 1 50 1
715 sqlite3_initialize
716 autoinstall_test_functions
717} -shutdown {
718 catch {db close}
drhb232c232008-11-19 01:20:26 +0000719 sqlite3_shutdown
720 sqlite3_config_alt_pcache 0 0 0
721 sqlite3_initialize
drhbb77b752009-04-09 01:23:49 +0000722 autoinstall_test_functions
dan0626dfc2010-06-15 06:56:37 +0000723} -files ${perm-alt-pcache-testset}
drhb232c232008-11-19 01:20:26 +0000724
dan0626dfc2010-06-15 06:56:37 +0000725test_suite "pcache100" -description {
drhb232c232008-11-19 01:20:26 +0000726 Alternative pcache implementation that always discards when unpinning
727} -initialize {
728 catch {db close}
drhb232c232008-11-19 01:20:26 +0000729 sqlite3_shutdown
730 sqlite3_config_alt_pcache 1 100 1
731 sqlite3_initialize
732 autoinstall_test_functions
733} -shutdown {
734 catch {db close}
drhb232c232008-11-19 01:20:26 +0000735 sqlite3_shutdown
736 sqlite3_config_alt_pcache 0 0 0
737 sqlite3_initialize
drhbb77b752009-04-09 01:23:49 +0000738 autoinstall_test_functions
dan0626dfc2010-06-15 06:56:37 +0000739} -files ${perm-alt-pcache-testset}
danielk1977b13dee92008-06-23 15:55:52 +0000740
dan0626dfc2010-06-15 06:56:37 +0000741test_suite "journaltest" -description {
danielk1977f3107512008-12-22 10:58:46 +0000742 Check that pages are synced before being written (test_journal.c).
743} -initialize {
danielk1977f3107512008-12-22 10:58:46 +0000744 catch {db close}
745 register_jt_vfs -default ""
746} -shutdown {
747 unregister_jt_vfs
dan0626dfc2010-06-15 06:56:37 +0000748} -files [test_set $::allquicktests -exclude {
749 wal* incrvacuum.test ioerr.test corrupt4.test io.test crash8.test
750 async4.test bigfile.test
drhfb4a6262010-05-06 19:55:57 +0000751}]
danielk1977f3107512008-12-22 10:58:46 +0000752
dan0a7a9152010-04-07 07:57:38 +0000753if {[info commands register_demovfs] != ""} {
dan0626dfc2010-06-15 06:56:37 +0000754 test_suite "demovfs" -description {
dan430e74c2010-06-07 17:47:26 +0000755 Check that the demovfs (code in test_demovfs.c) more or less works.
dan0a7a9152010-04-07 07:57:38 +0000756 } -initialize {
757 register_demovfs
758 } -shutdown {
759 unregister_demovfs
dan0626dfc2010-06-15 06:56:37 +0000760 } -files {
dan0a7a9152010-04-07 07:57:38 +0000761 insert.test insert2.test insert3.test rollback.test
762 select1.test select2.test select3.test
763 }
764}
765
dan0626dfc2010-06-15 06:56:37 +0000766test_suite "wal" -description {
dan71cb5182010-04-26 12:39:03 +0000767 Run tests with journal_mode=WAL
dan31f98fc2010-04-27 05:42:32 +0000768} -initialize {
dan430e74c2010-06-07 17:47:26 +0000769 set ::G(savepoint6_iterations) 100
dan31f98fc2010-04-27 05:42:32 +0000770} -shutdown {
dan430e74c2010-06-07 17:47:26 +0000771 unset -nocomplain ::G(savepoint6_iterations)
dan0626dfc2010-06-15 06:56:37 +0000772} -files {
dane106de62010-04-27 06:49:34 +0000773 savepoint.test savepoint2.test savepoint6.test
774 trans.test avtrans.test
dan71cb5182010-04-26 12:39:03 +0000775}
danielk19771077e3f2008-06-21 18:07:37 +0000776# End of tests
777#############################################################################
778
dan0626dfc2010-06-15 06:56:37 +0000779# run_tests NAME OPTIONS
780#
781# where available options are:
782#
dan2fce9ab2010-06-15 18:00:06 +0000783# -description TITLE
784# -initialize SCRIPT
785# -shutdown SCRIPT
786# -presql SQL
787# -files LIST-OF-FILES
788# -prefix NAME
dan0626dfc2010-06-15 06:56:37 +0000789#
790proc run_tests {name args} {
791 array set options $args
danielk19771077e3f2008-06-21 18:07:37 +0000792
dan2fce9ab2010-06-15 18:00:06 +0000793 set ::G(perm:name) $options(-prefix)
dan0626dfc2010-06-15 06:56:37 +0000794 set ::G(perm:presql) $options(-presql)
795 set ::G(isquick) 1
796
797 uplevel $options(-initialize)
798
799 foreach file [lsort $options(-files)] {
800 slave_test_file $::testdir/$file
801 }
802
803 uplevel $options(-shutdown)
804
805 unset ::G(perm:name)
806 unset ::G(perm:presql)
807}
808
809proc run_test_suite {name} {
810 if {[info exists ::testspec($name)]==0} {
811 error "No such test suite: $name"
812 }
813 uplevel run_tests $name $::testspec($name)
814}
815
816proc help {} {
dane91a54e2010-06-15 17:44:47 +0000817 puts "Usage: $::argv0 TESTSUITE ?TESTFILE?"
818 puts ""
819 puts "Available test-suites are:"
dan0626dfc2010-06-15 06:56:37 +0000820 foreach k $::testsuitelist {
dane91a54e2010-06-15 17:44:47 +0000821 if {[info exists ::testspec($k)]==0} {
822 puts " ----------------------------------------"
823 puts ""
824 } else {
825 array set o $::testspec($k)
826 puts "Test suite: \"$k\""
827 set d [string trim $o(-description)]
828 set d [regsub {\n *} $d "\n "]
829 puts " $d"
830 puts ""
831 }
dan0626dfc2010-06-15 06:56:37 +0000832 }
833 exit -1
834}
835
836if {[info script] == $argv0} {
837 proc main {argv} {
838 if {[llength $argv]==0} {
839 help
840 } else {
841 set suite [lindex $argv 0]
842 if {[info exists ::testspec($suite)]==0} help
843 set extra ""
844 if {[llength $argv]>1} { set extra [list -files [lrange $argv 1 end]] }
845 eval run_tests $suite $::testspec($suite) $extra
846 }
847 }
848 main $argv
849 finish_test
850}
851