blob: 3d112610782044cde3690a23e55e1df7bee5f161 [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}]
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 [
dan68928b62010-06-22 13:46:43 +0000130 test_set $allquicktests -exclude *malloc* *ioerr* *fault*
dan0626dfc2010-06-15 06:56:37 +0000131]
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
dan273f3f02010-06-26 15:42:33 +0000164 walbak.test walhook.test walcrash2.test walcksum.test
dan0626dfc2010-06-15 06:56:37 +0000165 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
dan273f3f02010-06-26 15:42:33 +0000174 walfault.test
175 walbak.test
dan146ed782010-06-19 17:26:37 +0000176 journal2.test
dane91a54e2010-06-15 17:44:47 +0000177}
dan0626dfc2010-06-15 06:56:37 +0000178
179
dane91a54e2010-06-15 17:44:47 +0000180lappend ::testsuitelist xxx
dan0626dfc2010-06-15 06:56:37 +0000181#-------------------------------------------------------------------------
182# Define the permutation test suites:
183#
danielk19771077e3f2008-06-21 18:07:37 +0000184
185# Run some tests using pre-allocated page and scratch blocks.
186#
dan0626dfc2010-06-15 06:56:37 +0000187test_suite "memsubsys1" -description {
danielk19771077e3f2008-06-21 18:07:37 +0000188 Tests using pre-allocated page and scratch blocks
dan0626dfc2010-06-15 06:56:37 +0000189} -files [
190 test_set $::allquicktests -exclude ioerr5.test malloc5.test
191] -initialize {
drhd63bd752008-07-30 13:15:46 +0000192 catch {db close}
danielk19771077e3f2008-06-21 18:07:37 +0000193 sqlite3_shutdown
194 sqlite3_config_pagecache 4096 24
195 sqlite3_config_scratch 25000 1
196 sqlite3_initialize
drhbb77b752009-04-09 01:23:49 +0000197 autoinstall_test_functions
danielk19771077e3f2008-06-21 18:07:37 +0000198} -shutdown {
199 catch {db close}
200 sqlite3_shutdown
201 sqlite3_config_pagecache 0 0
202 sqlite3_config_scratch 0 0
203 sqlite3_initialize
drhbb77b752009-04-09 01:23:49 +0000204 autoinstall_test_functions
danielk19771077e3f2008-06-21 18:07:37 +0000205}
206
207# Run some tests using pre-allocated page and scratch blocks. This time
208# the allocations are too small to use in most cases.
209#
danielk197734c61e62008-08-29 12:00:20 +0000210# Both ioerr5.test and malloc5.test are excluded because they test the
211# sqlite3_soft_heap_limit() and sqlite3_release_memory() functionality.
212# This functionality is disabled if a pre-allocated page block is provided.
213#
dan0626dfc2010-06-15 06:56:37 +0000214test_suite "memsubsys2" -description {
danielk19771077e3f2008-06-21 18:07:37 +0000215 Tests using small pre-allocated page and scratch blocks
dan0626dfc2010-06-15 06:56:37 +0000216} -files [
217 test_set $::allquicktests -exclude ioerr5.test malloc5.test
218] -initialize {
drhd63bd752008-07-30 13:15:46 +0000219 catch {db close}
danielk19771077e3f2008-06-21 18:07:37 +0000220 sqlite3_shutdown
221 sqlite3_config_pagecache 512 5
222 sqlite3_config_scratch 1000 1
223 sqlite3_initialize
drhbb77b752009-04-09 01:23:49 +0000224 autoinstall_test_functions
danielk19771077e3f2008-06-21 18:07:37 +0000225} -shutdown {
226 catch {db close}
227 sqlite3_shutdown
228 sqlite3_config_pagecache 0 0
229 sqlite3_config_scratch 0 0
230 sqlite3_initialize
drhbb77b752009-04-09 01:23:49 +0000231 autoinstall_test_functions
danielk19771077e3f2008-06-21 18:07:37 +0000232}
233
drhe2a7c6e2008-08-01 15:06:30 +0000234# Run all tests with the lookaside allocator disabled.
235#
dan0626dfc2010-06-15 06:56:37 +0000236test_suite "nolookaside" -description {
drhe2a7c6e2008-08-01 15:06:30 +0000237 OOM tests with lookaside disabled
drhe2a7c6e2008-08-01 15:06:30 +0000238} -initialize {
239 catch {db close}
240 sqlite3_shutdown
241 sqlite3_config_lookaside 0 0
242 sqlite3_initialize
drhbb77b752009-04-09 01:23:49 +0000243 autoinstall_test_functions
drhe2a7c6e2008-08-01 15:06:30 +0000244} -shutdown {
245 catch {db close}
246 sqlite3_shutdown
247 sqlite3_config_lookaside 100 500
248 sqlite3_initialize
drhbb77b752009-04-09 01:23:49 +0000249 autoinstall_test_functions
dan0626dfc2010-06-15 06:56:37 +0000250} -files $::allquicktests
drhe2a7c6e2008-08-01 15:06:30 +0000251
danielk19771077e3f2008-06-21 18:07:37 +0000252# Run some tests in SQLITE_CONFIG_SINGLETHREAD mode.
253#
dan0626dfc2010-06-15 06:56:37 +0000254test_suite "singlethread" -description {
danielk19771077e3f2008-06-21 18:07:37 +0000255 Tests run in SQLITE_CONFIG_SINGLETHREAD mode
256} -initialize {
drh04df18d2009-01-06 14:50:11 +0000257 catch {db close}
258 sqlite3_shutdown
259 catch {sqlite3_config singlethread}
drhbb77b752009-04-09 01:23:49 +0000260 sqlite3_initialize
261 autoinstall_test_functions
dan0626dfc2010-06-15 06:56:37 +0000262} -files {
danielk19771077e3f2008-06-21 18:07:37 +0000263 delete.test delete2.test insert.test rollback.test select1.test
264 select2.test trans.test update.test vacuum.test types.test
265 types2.test types3.test
266} -shutdown {
drh04df18d2009-01-06 14:50:11 +0000267 catch {db close}
268 sqlite3_shutdown
269 catch {sqlite3_config serialized}
drhbb77b752009-04-09 01:23:49 +0000270 sqlite3_initialize
271 autoinstall_test_functions
danielk19771077e3f2008-06-21 18:07:37 +0000272}
273
dan0626dfc2010-06-15 06:56:37 +0000274test_suite "nomutex" -description {
drh039963a2008-09-03 00:43:15 +0000275 Tests run with the SQLITE_OPEN_MULTITHREADED flag passed to sqlite3_open().
danielk19779a6284c2008-07-10 17:52:49 +0000276} -initialize {
277 rename sqlite3 sqlite3_nomutex
278 proc sqlite3 {args} {
279 if {[string range [lindex $args 0] 0 0] ne "-"} {
drhcc91e7f2008-09-03 01:08:00 +0000280 lappend args -fullmutex 0 -nomutex 1
danielk19779a6284c2008-07-10 17:52:49 +0000281 }
282 uplevel [concat sqlite3_nomutex $args]
283 }
dan0626dfc2010-06-15 06:56:37 +0000284} -files {
danielk19779a6284c2008-07-10 17:52:49 +0000285 delete.test delete2.test insert.test rollback.test select1.test
286 select2.test trans.test update.test vacuum.test types.test
287 types2.test types3.test
288} -shutdown {
289 rename sqlite3 {}
290 rename sqlite3_nomutex sqlite3
291}
292
danielk19771077e3f2008-06-21 18:07:37 +0000293# Run some tests in SQLITE_CONFIG_MULTITHREAD mode.
294#
dan0626dfc2010-06-15 06:56:37 +0000295test_suite "multithread" -description {
danielk19771077e3f2008-06-21 18:07:37 +0000296 Tests run in SQLITE_CONFIG_MULTITHREAD mode
297} -initialize {
drh04df18d2009-01-06 14:50:11 +0000298 catch {db close}
299 sqlite3_shutdown
300 catch {sqlite3_config multithread}
drhbb77b752009-04-09 01:23:49 +0000301 sqlite3_initialize
302 autoinstall_test_functions
dan0626dfc2010-06-15 06:56:37 +0000303} -files {
danielk19771077e3f2008-06-21 18:07:37 +0000304 delete.test delete2.test insert.test rollback.test select1.test
305 select2.test trans.test update.test vacuum.test types.test
306 types2.test types3.test
307} -shutdown {
drh04df18d2009-01-06 14:50:11 +0000308 catch {db close}
309 sqlite3_shutdown
310 catch {sqlite3_config serialized}
drhbb77b752009-04-09 01:23:49 +0000311 sqlite3_initialize
312 autoinstall_test_functions
danielk19771077e3f2008-06-21 18:07:37 +0000313}
314
drh039963a2008-09-03 00:43:15 +0000315# Run some tests in SQLITE_OPEN_FULLMUTEX mode.
316#
dan0626dfc2010-06-15 06:56:37 +0000317test_suite "fullmutex" -description {
drh039963a2008-09-03 00:43:15 +0000318 Tests run in SQLITE_OPEN_FULLMUTEX mode
319} -initialize {
320 rename sqlite3 sqlite3_fullmutex
321 proc sqlite3 {args} {
322 if {[string range [lindex $args 0] 0 0] ne "-"} {
drhcc91e7f2008-09-03 01:08:00 +0000323 lappend args -nomutex 0 -fullmutex 1
drh039963a2008-09-03 00:43:15 +0000324 }
325 uplevel [concat sqlite3_fullmutex $args]
326 }
dan0626dfc2010-06-15 06:56:37 +0000327} -files {
drh039963a2008-09-03 00:43:15 +0000328 delete.test delete2.test insert.test rollback.test select1.test
329 select2.test trans.test update.test vacuum.test types.test
330 types2.test types3.test
331} -shutdown {
332 rename sqlite3 {}
333 rename sqlite3_fullmutex sqlite3
334}
335
danielk19771077e3f2008-06-21 18:07:37 +0000336# Run some tests using the "onefile" demo.
337#
dan0626dfc2010-06-15 06:56:37 +0000338test_suite "onefile" -description {
danielk19771077e3f2008-06-21 18:07:37 +0000339 Run some tests using the "test_onefile.c" demo
340} -initialize {
341 rename sqlite3 sqlite3_onefile
342 proc sqlite3 {args} {
343 if {[string range [lindex $args 0] 0 0] ne "-"} {
344 lappend args -vfs fs
345 }
346 uplevel [concat sqlite3_onefile $args]
347 }
dan0626dfc2010-06-15 06:56:37 +0000348} -files {
danielk19771077e3f2008-06-21 18:07:37 +0000349 conflict.test insert.test insert2.test insert3.test
350 rollback.test select1.test select2.test select3.test
danielk19771077e3f2008-06-21 18:07:37 +0000351} -shutdown {
352 rename sqlite3 {}
353 rename sqlite3_onefile sqlite3
354}
355
356# Run some tests using UTF-16 databases.
357#
dan0626dfc2010-06-15 06:56:37 +0000358test_suite "utf16" -description {
danielk19771077e3f2008-06-21 18:07:37 +0000359 Run tests using UTF-16 databases
danielk19772dd6d802008-06-21 19:10:27 +0000360} -presql {
danielk19771077e3f2008-06-21 18:07:37 +0000361 pragma encoding = 'UTF-16'
dan0626dfc2010-06-15 06:56:37 +0000362} -files {
danielk19771077e3f2008-06-21 18:07:37 +0000363 alter.test alter3.test
364 auth.test bind.test blob.test capi2.test capi3.test collate1.test
365 collate2.test collate3.test collate4.test collate5.test collate6.test
366 conflict.test date.test delete.test expr.test fkey1.test func.test
367 hook.test index.test insert2.test insert.test interrupt.test in.test
368 intpkey.test ioerr.test join2.test join.test lastinsert.test
369 laststmtchanges.test limit.test lock2.test lock.test main.test
370 memdb.test minmax.test misc1.test misc2.test misc3.test notnull.test
371 null.test progress.test quote.test rowid.test select1.test select2.test
372 select3.test select4.test select5.test select6.test sort.test
373 subselect.test tableapi.test table.test temptable.test
374 trace.test trigger1.test trigger2.test trigger3.test
375 trigger4.test types2.test types.test unique.test update.test
376 vacuum.test view.test where.test
377}
378
379# Run some tests in exclusive locking mode.
380#
dan0626dfc2010-06-15 06:56:37 +0000381test_suite "exclusive" -description {
danielk19771077e3f2008-06-21 18:07:37 +0000382 Run tests in exclusive locking mode.
383} -presql {
384 pragma locking_mode = 'exclusive'
dan0626dfc2010-06-15 06:56:37 +0000385} -files {
danielk19771077e3f2008-06-21 18:07:37 +0000386 rollback.test select1.test select2.test
387 malloc.test ioerr.test
388}
389
drh04335882008-09-26 21:08:08 +0000390# Run some tests in exclusive locking mode with truncated journals.
391#
dan0626dfc2010-06-15 06:56:37 +0000392test_suite "exclusive-truncate" -description {
drh04335882008-09-26 21:08:08 +0000393 Run tests in exclusive locking mode and truncate journal mode.
394} -presql {
395 pragma locking_mode = 'exclusive';
396 pragma journal_mode = TRUNCATE;
dan0626dfc2010-06-15 06:56:37 +0000397} -files {
drh04335882008-09-26 21:08:08 +0000398 delete.test delete2.test insert.test rollback.test select1.test
399 select2.test update.test malloc.test ioerr.test
400}
401
danielk19771077e3f2008-06-21 18:07:37 +0000402# Run some tests in persistent journal mode.
403#
dan0626dfc2010-06-15 06:56:37 +0000404test_suite "persistent_journal" -description {
danielk19771077e3f2008-06-21 18:07:37 +0000405 Run tests in persistent-journal mode.
406} -presql {
407 pragma journal_mode = persist
dan0626dfc2010-06-15 06:56:37 +0000408} -files {
danielk19771077e3f2008-06-21 18:07:37 +0000409 delete.test delete2.test insert.test rollback.test select1.test
410 select2.test trans.test update.test vacuum.test
411}
412
drh04335882008-09-26 21:08:08 +0000413# Run some tests in truncating journal mode.
414#
dan0626dfc2010-06-15 06:56:37 +0000415test_suite "truncate_journal" -description {
drh04335882008-09-26 21:08:08 +0000416 Run tests in persistent-journal mode.
417} -presql {
418 pragma journal_mode = truncate
dan0626dfc2010-06-15 06:56:37 +0000419} -files {
drh04335882008-09-26 21:08:08 +0000420 delete.test delete2.test insert.test rollback.test select1.test
421 select2.test trans.test update.test vacuum.test
422 malloc.test ioerr.test
423}
424
danielk19771077e3f2008-06-21 18:07:37 +0000425# Run some error tests in persistent journal mode.
426#
dan0626dfc2010-06-15 06:56:37 +0000427test_suite "persistent_journal_error" -description {
danielk19771077e3f2008-06-21 18:07:37 +0000428 Run malloc.test and ioerr.test in persistent-journal mode.
429} -presql {
430 pragma journal_mode = persist
dan0626dfc2010-06-15 06:56:37 +0000431} -files {
danielk19771077e3f2008-06-21 18:07:37 +0000432 malloc.test ioerr.test
433}
434
435# Run some tests in no journal mode.
436#
dan0626dfc2010-06-15 06:56:37 +0000437test_suite "no_journal" -description {
danielk19771077e3f2008-06-21 18:07:37 +0000438 Run tests in no-journal mode.
439} -presql {
440 pragma journal_mode = persist
dan0626dfc2010-06-15 06:56:37 +0000441} -files {
danielk19771077e3f2008-06-21 18:07:37 +0000442 delete.test delete2.test insert.test rollback.test select1.test
443 select2.test trans.test update.test vacuum.test
444}
445
446# Run some error tests in no journal mode.
447#
dan0626dfc2010-06-15 06:56:37 +0000448test_suite "no_journal_error" -description {
danielk19771077e3f2008-06-21 18:07:37 +0000449 Run malloc.test and ioerr.test in no-journal mode.
450} -presql {
451 pragma journal_mode = persist
dan0626dfc2010-06-15 06:56:37 +0000452} -files {
danielk19771077e3f2008-06-21 18:07:37 +0000453 malloc.test ioerr.test
454}
455
456# Run some crash-tests in autovacuum mode.
457#
dan0626dfc2010-06-15 06:56:37 +0000458test_suite "autovacuum_crash" -description {
danielk19771077e3f2008-06-21 18:07:37 +0000459 Run crash.test in autovacuum mode.
460} -presql {
461 pragma auto_vacuum = 1
dan0626dfc2010-06-15 06:56:37 +0000462} -files crash.test
danielk19771077e3f2008-06-21 18:07:37 +0000463
464# Run some ioerr-tests in autovacuum mode.
465#
dan0626dfc2010-06-15 06:56:37 +0000466test_suite "autovacuum_ioerr" -description {
danielk19771077e3f2008-06-21 18:07:37 +0000467 Run ioerr.test in autovacuum mode.
468} -presql {
469 pragma auto_vacuum = 1
dan0626dfc2010-06-15 06:56:37 +0000470} -files ioerr.test
danielk19771077e3f2008-06-21 18:07:37 +0000471
danielk1977b3175382008-10-17 18:51:52 +0000472# Run tests with an in-memory journal.
473#
dan0626dfc2010-06-15 06:56:37 +0000474test_suite "inmemory_journal" -description {
danielk1977b3175382008-10-17 18:51:52 +0000475 Run tests with an in-memory journal file.
476} -presql {
477 pragma journal_mode = 'memory'
dan0626dfc2010-06-15 06:56:37 +0000478} -files [test_set $::allquicktests -exclude {
danielk1977b3175382008-10-17 18:51:52 +0000479 # Exclude all tests that simulate IO errors.
480 autovacuum_ioerr2.test incrvacuum_ioerr.test ioerr.test
481 ioerr.test ioerr2.test ioerr3.test ioerr4.test ioerr5.test
drh2206a2b2009-04-01 23:09:43 +0000482 vacuum3.test incrblob_err.test diskfull.test backup_ioerr.test
drh08ede1d2010-04-12 20:54:13 +0000483 e_fts3.test
danielk1977b3175382008-10-17 18:51:52 +0000484
485 # Exclude test scripts that use tcl IO to access journal files or count
486 # the number of fsync() calls.
487 pager.test exclusive.test jrnlmode.test sync.test misc1.test
danielk1977cb257902009-04-10 18:32:29 +0000488 journal1.test conflict.test crash8.test tkt3457.test io.test
dan01d38562010-03-08 10:32:38 +0000489
490 # Exclude stmt.test, which expects sub-journals to use temporary files.
491 stmt.test
drh0b944132010-05-24 20:24:38 +0000492
493 # WAL mode is different.
dan0626dfc2010-06-15 06:56:37 +0000494 wal*
495}]
danielk1977b3175382008-10-17 18:51:52 +0000496
danielk19776b39c2e2008-06-25 14:57:53 +0000497ifcapable mem3 {
dan0626dfc2010-06-15 06:56:37 +0000498 test_suite "memsys3" -description {
danielk19776b39c2e2008-06-25 14:57:53 +0000499 Run tests using the allocator in mem3.c.
dan0626dfc2010-06-15 06:56:37 +0000500 } [test_set $::allquicktests -exclude {
drh8a42cbd2008-07-10 18:13:42 +0000501 autovacuum.test delete3.test manydb.test
502 bigrow.test incrblob2.test memdb.test
503 bitvec.test index2.test memsubsys1.test
504 capi3c.test ioerr.test memsubsys2.test
505 capi3.test join3.test pagesize.test
danielk19778b322822009-07-01 18:09:01 +0000506 collate5.test limit.test backup_ioerr.test
507 backup_malloc.test
dan0626dfc2010-06-15 06:56:37 +0000508 }] -initialize {
danielk19776b39c2e2008-06-25 14:57:53 +0000509 catch {db close}
510 sqlite3_reset_auto_extension
511 sqlite3_shutdown
drh7830cd42008-07-16 12:25:32 +0000512 sqlite3_config_heap 25000000 0
drhe2a7c6e2008-08-01 15:06:30 +0000513 sqlite3_config_lookaside 0 0
danielk19778b322822009-07-01 18:09:01 +0000514 ifcapable mem5 {
515 # If both memsys3 and memsys5 are enabled in the build, the call to
516 # [sqlite3_config_heap] will initialize the system to use memsys5.
517 # The following overrides this preference and installs the memsys3
518 # allocator.
519 sqlite3_install_memsys3
520 }
danielk19776b39c2e2008-06-25 14:57:53 +0000521 install_malloc_faultsim 1
522 sqlite3_initialize
523 autoinstall_test_functions
524 } -shutdown {
525 catch {db close}
danielk19776b39c2e2008-06-25 14:57:53 +0000526 sqlite3_shutdown
danielk19770d84e5b2008-06-27 14:05:24 +0000527 sqlite3_config_heap 0 0
drhe2a7c6e2008-08-01 15:06:30 +0000528 sqlite3_config_lookaside 100 500
danielk19776b39c2e2008-06-25 14:57:53 +0000529 install_malloc_faultsim 1
530 sqlite3_initialize
drhbb77b752009-04-09 01:23:49 +0000531 autoinstall_test_functions
danielk19776b39c2e2008-06-25 14:57:53 +0000532 }
danielk197757e5ea92008-06-24 19:02:55 +0000533}
534
danielk19776b39c2e2008-06-25 14:57:53 +0000535ifcapable mem5 {
dan0626dfc2010-06-15 06:56:37 +0000536 test_suite "memsys5" -description {
danielk19776b39c2e2008-06-25 14:57:53 +0000537 Run tests using the allocator in mem5.c.
dan0626dfc2010-06-15 06:56:37 +0000538 } [test_set $::allquicktests -exclude {
drh8a42cbd2008-07-10 18:13:42 +0000539 autovacuum.test delete3.test manydb.test
540 bigrow.test incrblob2.test memdb.test
541 bitvec.test index2.test memsubsys1.test
542 capi3c.test ioerr.test memsubsys2.test
543 capi3.test join3.test pagesize.test
danielk1977ac8d7b32008-11-13 16:21:50 +0000544 collate5.test limit.test zeroblob.test
dan0626dfc2010-06-15 06:56:37 +0000545 }] -initialize {
danielk19776b39c2e2008-06-25 14:57:53 +0000546 catch {db close}
danielk19776b39c2e2008-06-25 14:57:53 +0000547 sqlite3_shutdown
drh7830cd42008-07-16 12:25:32 +0000548 sqlite3_config_heap 25000000 64
drhe2a7c6e2008-08-01 15:06:30 +0000549 sqlite3_config_lookaside 0 0
danielk19775099be52008-06-27 13:27:03 +0000550 install_malloc_faultsim 1
551 sqlite3_initialize
552 autoinstall_test_functions
553 } -shutdown {
554 catch {db close}
danielk19775099be52008-06-27 13:27:03 +0000555 sqlite3_shutdown
danielk19770d84e5b2008-06-27 14:05:24 +0000556 sqlite3_config_heap 0 0
drhe2a7c6e2008-08-01 15:06:30 +0000557 sqlite3_config_lookaside 100 500
danielk19775099be52008-06-27 13:27:03 +0000558 install_malloc_faultsim 1
559 sqlite3_initialize
drhbb77b752009-04-09 01:23:49 +0000560 autoinstall_test_functions
danielk19775099be52008-06-27 13:27:03 +0000561 }
562
dan0626dfc2010-06-15 06:56:37 +0000563 test_suite "memsys5-2" -description {
danielk19775099be52008-06-27 13:27:03 +0000564 Run tests using the allocator in mem5.c in a different configuration.
dan0626dfc2010-06-15 06:56:37 +0000565 } -files {
drh8a42cbd2008-07-10 18:13:42 +0000566 select1.test
danielk19775099be52008-06-27 13:27:03 +0000567 } -initialize {
568 catch {db close}
danielk19775099be52008-06-27 13:27:03 +0000569 sqlite3_shutdown
drh7830cd42008-07-16 12:25:32 +0000570 sqlite3_config_heap 40000000 16
drhe2a7c6e2008-08-01 15:06:30 +0000571 sqlite3_config_lookaside 0 0
danielk19776b39c2e2008-06-25 14:57:53 +0000572 install_malloc_faultsim 1
573 sqlite3_initialize
574 autoinstall_test_functions
575 } -shutdown {
576 catch {db close}
danielk19776b39c2e2008-06-25 14:57:53 +0000577 sqlite3_shutdown
danielk19770d84e5b2008-06-27 14:05:24 +0000578 sqlite3_config_heap 0 0
drhe2a7c6e2008-08-01 15:06:30 +0000579 sqlite3_config_lookaside 100 500
danielk19776b39c2e2008-06-25 14:57:53 +0000580 install_malloc_faultsim 1
581 sqlite3_initialize
drhbb77b752009-04-09 01:23:49 +0000582 autoinstall_test_functions
danielk19776b39c2e2008-06-25 14:57:53 +0000583 }
danielk1977c66c0e12008-06-25 14:26:07 +0000584}
585
drh8a42cbd2008-07-10 18:13:42 +0000586ifcapable threadsafe {
dan0626dfc2010-06-15 06:56:37 +0000587 test_suite "no_mutex_try" -description {
drh8a42cbd2008-07-10 18:13:42 +0000588 The sqlite3_mutex_try() interface always fails
dan0626dfc2010-06-15 06:56:37 +0000589 } -files [
590 test_set $::allquicktests -exclude mutex1.test mutex2.test
591 ] -initialize {
drh8a42cbd2008-07-10 18:13:42 +0000592 catch {db close}
593 sqlite3_shutdown
594 install_mutex_counters 1
595 set ::disable_mutex_try 1
drhbb77b752009-04-09 01:23:49 +0000596 sqlite3_initialize
597 autoinstall_test_functions
drh8a42cbd2008-07-10 18:13:42 +0000598 } -shutdown {
599 catch {db close}
600 sqlite3_shutdown
601 install_mutex_counters 0
drhbb77b752009-04-09 01:23:49 +0000602 sqlite3_initialize
603 autoinstall_test_functions
drh8a42cbd2008-07-10 18:13:42 +0000604 }
605}
606
danielk1977b13dee92008-06-23 15:55:52 +0000607# run_tests "crash_safe_append" -description {
608# Run crash.test with persistent journals on a SAFE_APPEND file-system.
609# } -initialize {
610# rename crashsql sa_crashsql
611# proc crashsql {args} {
612# set options [lrange $args 0 [expr {[llength $args]-2}]]
613# lappend options -char safe_append
614# set sql [lindex $args end]
615# lappend options "
616# PRAGMA journal_mode=persistent;
617# $sql
618# "
619# set fd [open test.db-journal w]
620# puts $fd [string repeat 1234567890 100000]
621# close $fd
622# eval sa_crashsql $options
623# }
624# } -shutdown {
625# rename crashsql {}
626# rename sa_crashsql crashsql
dan0626dfc2010-06-15 06:56:37 +0000627# } -files crash.test
danielk1977b13dee92008-06-23 15:55:52 +0000628
dan0626dfc2010-06-15 06:56:37 +0000629test_suite "safe_append" -description {
danielk1977755339e2008-09-12 10:22:40 +0000630 Run some tests on a SAFE_APPEND file-system.
631} -initialize {
632 rename sqlite3 sqlite3_safeappend
633 proc sqlite3 {args} {
634 if {[string range [lindex $args 0] 0 0] ne "-"} {
635 lappend args -vfs devsym
636 }
637 uplevel [concat sqlite3_safeappend $args]
638 }
639 sqlite3_simulate_device -char safe_append
640} -shutdown {
641 rename sqlite3 {}
642 rename sqlite3_shutdown sqlite3
dan0626dfc2010-06-15 06:56:37 +0000643} -files [
644 test_set $::allquicktests shared_err.test -exclude async3.test
645]
danielk1977755339e2008-09-12 10:22:40 +0000646
drhb232c232008-11-19 01:20:26 +0000647# The set of tests to run on the alternative-pcache
648set perm-alt-pcache-testset {
649 async.test
650 attach.test
651 delete.test delete2.test
652 index.test
653 insert.test insert2.test
654 join.test join2.test
655 rollback.test
656 select1.test select2.test
657 trans.test
658 update.test
659}
660
dan0626dfc2010-06-15 06:56:37 +0000661test_suite "pcache0" -description {
drhb232c232008-11-19 01:20:26 +0000662 Alternative pcache implementation without random discard
663} -initialize {
664 catch {db close}
drhb232c232008-11-19 01:20:26 +0000665 sqlite3_shutdown
666 sqlite3_config_alt_pcache 1 0 1
667 sqlite3_initialize
668 autoinstall_test_functions
669} -shutdown {
670 catch {db close}
drhb232c232008-11-19 01:20:26 +0000671 sqlite3_shutdown
672 sqlite3_config_alt_pcache 0 0 0
673 sqlite3_config_lookaside 100 500
674 install_malloc_faultsim 1
675 sqlite3_initialize
drhbb77b752009-04-09 01:23:49 +0000676 autoinstall_test_functions
dan0626dfc2010-06-15 06:56:37 +0000677} -files ${perm-alt-pcache-testset}
drhb232c232008-11-19 01:20:26 +0000678
dan0626dfc2010-06-15 06:56:37 +0000679test_suite "pcache10" -description {
drhb232c232008-11-19 01:20:26 +0000680 Alternative pcache implementation without 10% random discard
681} -initialize {
682 catch {db close}
drhb232c232008-11-19 01:20:26 +0000683 sqlite3_shutdown
684 sqlite3_config_alt_pcache 1 50 1
685 sqlite3_initialize
686 autoinstall_test_functions
687} -shutdown {
688 catch {db close}
drhb232c232008-11-19 01:20:26 +0000689 sqlite3_shutdown
690 sqlite3_config_alt_pcache 0 0 0
691 sqlite3_initialize
drhbb77b752009-04-09 01:23:49 +0000692 autoinstall_test_functions
dan0626dfc2010-06-15 06:56:37 +0000693} -files ${perm-alt-pcache-testset}
drhb232c232008-11-19 01:20:26 +0000694
dan0626dfc2010-06-15 06:56:37 +0000695test_suite "pcache50" -description {
drhb232c232008-11-19 01:20:26 +0000696 Alternative pcache implementation without 50% random discard
697} -initialize {
698 catch {db close}
drhb232c232008-11-19 01:20:26 +0000699 sqlite3_shutdown
700 sqlite3_config_alt_pcache 1 50 1
701 sqlite3_initialize
702 autoinstall_test_functions
703} -shutdown {
704 catch {db close}
drhb232c232008-11-19 01:20:26 +0000705 sqlite3_shutdown
706 sqlite3_config_alt_pcache 0 0 0
707 sqlite3_initialize
drhbb77b752009-04-09 01:23:49 +0000708 autoinstall_test_functions
dan0626dfc2010-06-15 06:56:37 +0000709} -files ${perm-alt-pcache-testset}
drhb232c232008-11-19 01:20:26 +0000710
dan0626dfc2010-06-15 06:56:37 +0000711test_suite "pcache90" -description {
drhb232c232008-11-19 01:20:26 +0000712 Alternative pcache implementation without 90% random discard
713} -initialize {
714 catch {db close}
drhb232c232008-11-19 01:20:26 +0000715 sqlite3_shutdown
716 sqlite3_config_alt_pcache 1 50 1
717 sqlite3_initialize
718 autoinstall_test_functions
719} -shutdown {
720 catch {db close}
drhb232c232008-11-19 01:20:26 +0000721 sqlite3_shutdown
722 sqlite3_config_alt_pcache 0 0 0
723 sqlite3_initialize
drhbb77b752009-04-09 01:23:49 +0000724 autoinstall_test_functions
dan0626dfc2010-06-15 06:56:37 +0000725} -files ${perm-alt-pcache-testset}
drhb232c232008-11-19 01:20:26 +0000726
dan0626dfc2010-06-15 06:56:37 +0000727test_suite "pcache100" -description {
drhb232c232008-11-19 01:20:26 +0000728 Alternative pcache implementation that always discards when unpinning
729} -initialize {
730 catch {db close}
drhb232c232008-11-19 01:20:26 +0000731 sqlite3_shutdown
732 sqlite3_config_alt_pcache 1 100 1
733 sqlite3_initialize
734 autoinstall_test_functions
735} -shutdown {
736 catch {db close}
drhb232c232008-11-19 01:20:26 +0000737 sqlite3_shutdown
738 sqlite3_config_alt_pcache 0 0 0
739 sqlite3_initialize
drhbb77b752009-04-09 01:23:49 +0000740 autoinstall_test_functions
dan0626dfc2010-06-15 06:56:37 +0000741} -files ${perm-alt-pcache-testset}
danielk1977b13dee92008-06-23 15:55:52 +0000742
dan0626dfc2010-06-15 06:56:37 +0000743test_suite "journaltest" -description {
danielk1977f3107512008-12-22 10:58:46 +0000744 Check that pages are synced before being written (test_journal.c).
745} -initialize {
danielk1977f3107512008-12-22 10:58:46 +0000746 catch {db close}
747 register_jt_vfs -default ""
748} -shutdown {
749 unregister_jt_vfs
dan0626dfc2010-06-15 06:56:37 +0000750} -files [test_set $::allquicktests -exclude {
751 wal* incrvacuum.test ioerr.test corrupt4.test io.test crash8.test
752 async4.test bigfile.test
drhfb4a6262010-05-06 19:55:57 +0000753}]
danielk1977f3107512008-12-22 10:58:46 +0000754
dan0a7a9152010-04-07 07:57:38 +0000755if {[info commands register_demovfs] != ""} {
dan0626dfc2010-06-15 06:56:37 +0000756 test_suite "demovfs" -description {
dan430e74c2010-06-07 17:47:26 +0000757 Check that the demovfs (code in test_demovfs.c) more or less works.
dan0a7a9152010-04-07 07:57:38 +0000758 } -initialize {
759 register_demovfs
760 } -shutdown {
761 unregister_demovfs
dan0626dfc2010-06-15 06:56:37 +0000762 } -files {
dan0a7a9152010-04-07 07:57:38 +0000763 insert.test insert2.test insert3.test rollback.test
764 select1.test select2.test select3.test
765 }
766}
767
dan0626dfc2010-06-15 06:56:37 +0000768test_suite "wal" -description {
dan71cb5182010-04-26 12:39:03 +0000769 Run tests with journal_mode=WAL
dan31f98fc2010-04-27 05:42:32 +0000770} -initialize {
dan430e74c2010-06-07 17:47:26 +0000771 set ::G(savepoint6_iterations) 100
dan31f98fc2010-04-27 05:42:32 +0000772} -shutdown {
dan430e74c2010-06-07 17:47:26 +0000773 unset -nocomplain ::G(savepoint6_iterations)
dan0626dfc2010-06-15 06:56:37 +0000774} -files {
dane106de62010-04-27 06:49:34 +0000775 savepoint.test savepoint2.test savepoint6.test
776 trans.test avtrans.test
dan71cb5182010-04-26 12:39:03 +0000777}
danielk19771077e3f2008-06-21 18:07:37 +0000778# End of tests
779#############################################################################
780
dan0626dfc2010-06-15 06:56:37 +0000781# run_tests NAME OPTIONS
782#
783# where available options are:
784#
dan2fce9ab2010-06-15 18:00:06 +0000785# -description TITLE
786# -initialize SCRIPT
787# -shutdown SCRIPT
788# -presql SQL
789# -files LIST-OF-FILES
790# -prefix NAME
dan0626dfc2010-06-15 06:56:37 +0000791#
792proc run_tests {name args} {
793 array set options $args
danielk19771077e3f2008-06-21 18:07:37 +0000794
dan2fce9ab2010-06-15 18:00:06 +0000795 set ::G(perm:name) $options(-prefix)
dan0626dfc2010-06-15 06:56:37 +0000796 set ::G(perm:presql) $options(-presql)
797 set ::G(isquick) 1
798
799 uplevel $options(-initialize)
800
801 foreach file [lsort $options(-files)] {
802 slave_test_file $::testdir/$file
803 }
804
805 uplevel $options(-shutdown)
806
807 unset ::G(perm:name)
808 unset ::G(perm:presql)
809}
810
811proc run_test_suite {name} {
812 if {[info exists ::testspec($name)]==0} {
813 error "No such test suite: $name"
814 }
815 uplevel run_tests $name $::testspec($name)
816}
817
818proc help {} {
dane91a54e2010-06-15 17:44:47 +0000819 puts "Usage: $::argv0 TESTSUITE ?TESTFILE?"
820 puts ""
821 puts "Available test-suites are:"
dan0626dfc2010-06-15 06:56:37 +0000822 foreach k $::testsuitelist {
dane91a54e2010-06-15 17:44:47 +0000823 if {[info exists ::testspec($k)]==0} {
824 puts " ----------------------------------------"
825 puts ""
826 } else {
827 array set o $::testspec($k)
828 puts "Test suite: \"$k\""
829 set d [string trim $o(-description)]
830 set d [regsub {\n *} $d "\n "]
831 puts " $d"
832 puts ""
833 }
dan0626dfc2010-06-15 06:56:37 +0000834 }
835 exit -1
836}
837
838if {[info script] == $argv0} {
839 proc main {argv} {
840 if {[llength $argv]==0} {
841 help
842 } else {
843 set suite [lindex $argv 0]
844 if {[info exists ::testspec($suite)]==0} help
845 set extra ""
846 if {[llength $argv]>1} { set extra [list -files [lrange $argv 1 end]] }
847 eval run_tests $suite $::testspec($suite) $extra
848 }
849 }
850 main $argv
851 finish_test
852}
853