blob: 27f795676a85a779e9baec0aa10d27fb1fda1f1b [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
danb0ac3e32010-06-16 10:55:42 +0000172 pagerfault.test
dan146ed782010-06-19 17:26:37 +0000173 journal2.test
dane91a54e2010-06-15 17:44:47 +0000174}
dan0626dfc2010-06-15 06:56:37 +0000175
176
dane91a54e2010-06-15 17:44:47 +0000177lappend ::testsuitelist xxx
dan0626dfc2010-06-15 06:56:37 +0000178#-------------------------------------------------------------------------
179# Define the permutation test suites:
180#
danielk19771077e3f2008-06-21 18:07:37 +0000181
182# Run some tests using pre-allocated page and scratch blocks.
183#
dan0626dfc2010-06-15 06:56:37 +0000184test_suite "memsubsys1" -description {
danielk19771077e3f2008-06-21 18:07:37 +0000185 Tests using pre-allocated page and scratch blocks
dan0626dfc2010-06-15 06:56:37 +0000186} -files [
187 test_set $::allquicktests -exclude ioerr5.test malloc5.test
188] -initialize {
drhd63bd752008-07-30 13:15:46 +0000189 catch {db close}
danielk19771077e3f2008-06-21 18:07:37 +0000190 sqlite3_shutdown
191 sqlite3_config_pagecache 4096 24
192 sqlite3_config_scratch 25000 1
193 sqlite3_initialize
drhbb77b752009-04-09 01:23:49 +0000194 autoinstall_test_functions
danielk19771077e3f2008-06-21 18:07:37 +0000195} -shutdown {
196 catch {db close}
197 sqlite3_shutdown
198 sqlite3_config_pagecache 0 0
199 sqlite3_config_scratch 0 0
200 sqlite3_initialize
drhbb77b752009-04-09 01:23:49 +0000201 autoinstall_test_functions
danielk19771077e3f2008-06-21 18:07:37 +0000202}
203
204# Run some tests using pre-allocated page and scratch blocks. This time
205# the allocations are too small to use in most cases.
206#
danielk197734c61e62008-08-29 12:00:20 +0000207# Both ioerr5.test and malloc5.test are excluded because they test the
208# sqlite3_soft_heap_limit() and sqlite3_release_memory() functionality.
209# This functionality is disabled if a pre-allocated page block is provided.
210#
dan0626dfc2010-06-15 06:56:37 +0000211test_suite "memsubsys2" -description {
danielk19771077e3f2008-06-21 18:07:37 +0000212 Tests using small pre-allocated page and scratch blocks
dan0626dfc2010-06-15 06:56:37 +0000213} -files [
214 test_set $::allquicktests -exclude ioerr5.test malloc5.test
215] -initialize {
drhd63bd752008-07-30 13:15:46 +0000216 catch {db close}
danielk19771077e3f2008-06-21 18:07:37 +0000217 sqlite3_shutdown
218 sqlite3_config_pagecache 512 5
219 sqlite3_config_scratch 1000 1
220 sqlite3_initialize
drhbb77b752009-04-09 01:23:49 +0000221 autoinstall_test_functions
danielk19771077e3f2008-06-21 18:07:37 +0000222} -shutdown {
223 catch {db close}
224 sqlite3_shutdown
225 sqlite3_config_pagecache 0 0
226 sqlite3_config_scratch 0 0
227 sqlite3_initialize
drhbb77b752009-04-09 01:23:49 +0000228 autoinstall_test_functions
danielk19771077e3f2008-06-21 18:07:37 +0000229}
230
drhe2a7c6e2008-08-01 15:06:30 +0000231# Run all tests with the lookaside allocator disabled.
232#
dan0626dfc2010-06-15 06:56:37 +0000233test_suite "nolookaside" -description {
drhe2a7c6e2008-08-01 15:06:30 +0000234 OOM tests with lookaside disabled
drhe2a7c6e2008-08-01 15:06:30 +0000235} -initialize {
236 catch {db close}
237 sqlite3_shutdown
238 sqlite3_config_lookaside 0 0
239 sqlite3_initialize
drhbb77b752009-04-09 01:23:49 +0000240 autoinstall_test_functions
drhe2a7c6e2008-08-01 15:06:30 +0000241} -shutdown {
242 catch {db close}
243 sqlite3_shutdown
244 sqlite3_config_lookaside 100 500
245 sqlite3_initialize
drhbb77b752009-04-09 01:23:49 +0000246 autoinstall_test_functions
dan0626dfc2010-06-15 06:56:37 +0000247} -files $::allquicktests
drhe2a7c6e2008-08-01 15:06:30 +0000248
danielk19771077e3f2008-06-21 18:07:37 +0000249# Run some tests in SQLITE_CONFIG_SINGLETHREAD mode.
250#
dan0626dfc2010-06-15 06:56:37 +0000251test_suite "singlethread" -description {
danielk19771077e3f2008-06-21 18:07:37 +0000252 Tests run in SQLITE_CONFIG_SINGLETHREAD mode
253} -initialize {
drh04df18d2009-01-06 14:50:11 +0000254 catch {db close}
255 sqlite3_shutdown
256 catch {sqlite3_config singlethread}
drhbb77b752009-04-09 01:23:49 +0000257 sqlite3_initialize
258 autoinstall_test_functions
dan0626dfc2010-06-15 06:56:37 +0000259} -files {
danielk19771077e3f2008-06-21 18:07:37 +0000260 delete.test delete2.test insert.test rollback.test select1.test
261 select2.test trans.test update.test vacuum.test types.test
262 types2.test types3.test
263} -shutdown {
drh04df18d2009-01-06 14:50:11 +0000264 catch {db close}
265 sqlite3_shutdown
266 catch {sqlite3_config serialized}
drhbb77b752009-04-09 01:23:49 +0000267 sqlite3_initialize
268 autoinstall_test_functions
danielk19771077e3f2008-06-21 18:07:37 +0000269}
270
dan0626dfc2010-06-15 06:56:37 +0000271test_suite "nomutex" -description {
drh039963a2008-09-03 00:43:15 +0000272 Tests run with the SQLITE_OPEN_MULTITHREADED flag passed to sqlite3_open().
danielk19779a6284c2008-07-10 17:52:49 +0000273} -initialize {
274 rename sqlite3 sqlite3_nomutex
275 proc sqlite3 {args} {
276 if {[string range [lindex $args 0] 0 0] ne "-"} {
drhcc91e7f2008-09-03 01:08:00 +0000277 lappend args -fullmutex 0 -nomutex 1
danielk19779a6284c2008-07-10 17:52:49 +0000278 }
279 uplevel [concat sqlite3_nomutex $args]
280 }
dan0626dfc2010-06-15 06:56:37 +0000281} -files {
danielk19779a6284c2008-07-10 17:52:49 +0000282 delete.test delete2.test insert.test rollback.test select1.test
283 select2.test trans.test update.test vacuum.test types.test
284 types2.test types3.test
285} -shutdown {
286 rename sqlite3 {}
287 rename sqlite3_nomutex sqlite3
288}
289
danielk19771077e3f2008-06-21 18:07:37 +0000290# Run some tests in SQLITE_CONFIG_MULTITHREAD mode.
291#
dan0626dfc2010-06-15 06:56:37 +0000292test_suite "multithread" -description {
danielk19771077e3f2008-06-21 18:07:37 +0000293 Tests run in SQLITE_CONFIG_MULTITHREAD mode
294} -initialize {
drh04df18d2009-01-06 14:50:11 +0000295 catch {db close}
296 sqlite3_shutdown
297 catch {sqlite3_config multithread}
drhbb77b752009-04-09 01:23:49 +0000298 sqlite3_initialize
299 autoinstall_test_functions
dan0626dfc2010-06-15 06:56:37 +0000300} -files {
danielk19771077e3f2008-06-21 18:07:37 +0000301 delete.test delete2.test insert.test rollback.test select1.test
302 select2.test trans.test update.test vacuum.test types.test
303 types2.test types3.test
304} -shutdown {
drh04df18d2009-01-06 14:50:11 +0000305 catch {db close}
306 sqlite3_shutdown
307 catch {sqlite3_config serialized}
drhbb77b752009-04-09 01:23:49 +0000308 sqlite3_initialize
309 autoinstall_test_functions
danielk19771077e3f2008-06-21 18:07:37 +0000310}
311
drh039963a2008-09-03 00:43:15 +0000312# Run some tests in SQLITE_OPEN_FULLMUTEX mode.
313#
dan0626dfc2010-06-15 06:56:37 +0000314test_suite "fullmutex" -description {
drh039963a2008-09-03 00:43:15 +0000315 Tests run in SQLITE_OPEN_FULLMUTEX mode
316} -initialize {
317 rename sqlite3 sqlite3_fullmutex
318 proc sqlite3 {args} {
319 if {[string range [lindex $args 0] 0 0] ne "-"} {
drhcc91e7f2008-09-03 01:08:00 +0000320 lappend args -nomutex 0 -fullmutex 1
drh039963a2008-09-03 00:43:15 +0000321 }
322 uplevel [concat sqlite3_fullmutex $args]
323 }
dan0626dfc2010-06-15 06:56:37 +0000324} -files {
drh039963a2008-09-03 00:43:15 +0000325 delete.test delete2.test insert.test rollback.test select1.test
326 select2.test trans.test update.test vacuum.test types.test
327 types2.test types3.test
328} -shutdown {
329 rename sqlite3 {}
330 rename sqlite3_fullmutex sqlite3
331}
332
danielk19771077e3f2008-06-21 18:07:37 +0000333# Run some tests using the "onefile" demo.
334#
dan0626dfc2010-06-15 06:56:37 +0000335test_suite "onefile" -description {
danielk19771077e3f2008-06-21 18:07:37 +0000336 Run some tests using the "test_onefile.c" demo
337} -initialize {
338 rename sqlite3 sqlite3_onefile
339 proc sqlite3 {args} {
340 if {[string range [lindex $args 0] 0 0] ne "-"} {
341 lappend args -vfs fs
342 }
343 uplevel [concat sqlite3_onefile $args]
344 }
dan0626dfc2010-06-15 06:56:37 +0000345} -files {
danielk19771077e3f2008-06-21 18:07:37 +0000346 conflict.test insert.test insert2.test insert3.test
347 rollback.test select1.test select2.test select3.test
danielk19771077e3f2008-06-21 18:07:37 +0000348} -shutdown {
349 rename sqlite3 {}
350 rename sqlite3_onefile sqlite3
351}
352
353# Run some tests using UTF-16 databases.
354#
dan0626dfc2010-06-15 06:56:37 +0000355test_suite "utf16" -description {
danielk19771077e3f2008-06-21 18:07:37 +0000356 Run tests using UTF-16 databases
danielk19772dd6d802008-06-21 19:10:27 +0000357} -presql {
danielk19771077e3f2008-06-21 18:07:37 +0000358 pragma encoding = 'UTF-16'
dan0626dfc2010-06-15 06:56:37 +0000359} -files {
danielk19771077e3f2008-06-21 18:07:37 +0000360 alter.test alter3.test
361 auth.test bind.test blob.test capi2.test capi3.test collate1.test
362 collate2.test collate3.test collate4.test collate5.test collate6.test
363 conflict.test date.test delete.test expr.test fkey1.test func.test
364 hook.test index.test insert2.test insert.test interrupt.test in.test
365 intpkey.test ioerr.test join2.test join.test lastinsert.test
366 laststmtchanges.test limit.test lock2.test lock.test main.test
367 memdb.test minmax.test misc1.test misc2.test misc3.test notnull.test
368 null.test progress.test quote.test rowid.test select1.test select2.test
369 select3.test select4.test select5.test select6.test sort.test
370 subselect.test tableapi.test table.test temptable.test
371 trace.test trigger1.test trigger2.test trigger3.test
372 trigger4.test types2.test types.test unique.test update.test
373 vacuum.test view.test where.test
374}
375
376# Run some tests in exclusive locking mode.
377#
dan0626dfc2010-06-15 06:56:37 +0000378test_suite "exclusive" -description {
danielk19771077e3f2008-06-21 18:07:37 +0000379 Run tests in exclusive locking mode.
380} -presql {
381 pragma locking_mode = 'exclusive'
dan0626dfc2010-06-15 06:56:37 +0000382} -files {
danielk19771077e3f2008-06-21 18:07:37 +0000383 rollback.test select1.test select2.test
384 malloc.test ioerr.test
385}
386
drh04335882008-09-26 21:08:08 +0000387# Run some tests in exclusive locking mode with truncated journals.
388#
dan0626dfc2010-06-15 06:56:37 +0000389test_suite "exclusive-truncate" -description {
drh04335882008-09-26 21:08:08 +0000390 Run tests in exclusive locking mode and truncate journal mode.
391} -presql {
392 pragma locking_mode = 'exclusive';
393 pragma journal_mode = TRUNCATE;
dan0626dfc2010-06-15 06:56:37 +0000394} -files {
drh04335882008-09-26 21:08:08 +0000395 delete.test delete2.test insert.test rollback.test select1.test
396 select2.test update.test malloc.test ioerr.test
397}
398
danielk19771077e3f2008-06-21 18:07:37 +0000399# Run some tests in persistent journal mode.
400#
dan0626dfc2010-06-15 06:56:37 +0000401test_suite "persistent_journal" -description {
danielk19771077e3f2008-06-21 18:07:37 +0000402 Run tests in persistent-journal mode.
403} -presql {
404 pragma journal_mode = persist
dan0626dfc2010-06-15 06:56:37 +0000405} -files {
danielk19771077e3f2008-06-21 18:07:37 +0000406 delete.test delete2.test insert.test rollback.test select1.test
407 select2.test trans.test update.test vacuum.test
408}
409
drh04335882008-09-26 21:08:08 +0000410# Run some tests in truncating journal mode.
411#
dan0626dfc2010-06-15 06:56:37 +0000412test_suite "truncate_journal" -description {
drh04335882008-09-26 21:08:08 +0000413 Run tests in persistent-journal mode.
414} -presql {
415 pragma journal_mode = truncate
dan0626dfc2010-06-15 06:56:37 +0000416} -files {
drh04335882008-09-26 21:08:08 +0000417 delete.test delete2.test insert.test rollback.test select1.test
418 select2.test trans.test update.test vacuum.test
419 malloc.test ioerr.test
420}
421
danielk19771077e3f2008-06-21 18:07:37 +0000422# Run some error tests in persistent journal mode.
423#
dan0626dfc2010-06-15 06:56:37 +0000424test_suite "persistent_journal_error" -description {
danielk19771077e3f2008-06-21 18:07:37 +0000425 Run malloc.test and ioerr.test in persistent-journal mode.
426} -presql {
427 pragma journal_mode = persist
dan0626dfc2010-06-15 06:56:37 +0000428} -files {
danielk19771077e3f2008-06-21 18:07:37 +0000429 malloc.test ioerr.test
430}
431
432# Run some tests in no journal mode.
433#
dan0626dfc2010-06-15 06:56:37 +0000434test_suite "no_journal" -description {
danielk19771077e3f2008-06-21 18:07:37 +0000435 Run tests in no-journal mode.
436} -presql {
437 pragma journal_mode = persist
dan0626dfc2010-06-15 06:56:37 +0000438} -files {
danielk19771077e3f2008-06-21 18:07:37 +0000439 delete.test delete2.test insert.test rollback.test select1.test
440 select2.test trans.test update.test vacuum.test
441}
442
443# Run some error tests in no journal mode.
444#
dan0626dfc2010-06-15 06:56:37 +0000445test_suite "no_journal_error" -description {
danielk19771077e3f2008-06-21 18:07:37 +0000446 Run malloc.test and ioerr.test in no-journal mode.
447} -presql {
448 pragma journal_mode = persist
dan0626dfc2010-06-15 06:56:37 +0000449} -files {
danielk19771077e3f2008-06-21 18:07:37 +0000450 malloc.test ioerr.test
451}
452
453# Run some crash-tests in autovacuum mode.
454#
dan0626dfc2010-06-15 06:56:37 +0000455test_suite "autovacuum_crash" -description {
danielk19771077e3f2008-06-21 18:07:37 +0000456 Run crash.test in autovacuum mode.
457} -presql {
458 pragma auto_vacuum = 1
dan0626dfc2010-06-15 06:56:37 +0000459} -files crash.test
danielk19771077e3f2008-06-21 18:07:37 +0000460
461# Run some ioerr-tests in autovacuum mode.
462#
dan0626dfc2010-06-15 06:56:37 +0000463test_suite "autovacuum_ioerr" -description {
danielk19771077e3f2008-06-21 18:07:37 +0000464 Run ioerr.test in autovacuum mode.
465} -presql {
466 pragma auto_vacuum = 1
dan0626dfc2010-06-15 06:56:37 +0000467} -files ioerr.test
danielk19771077e3f2008-06-21 18:07:37 +0000468
danielk1977b3175382008-10-17 18:51:52 +0000469# Run tests with an in-memory journal.
470#
dan0626dfc2010-06-15 06:56:37 +0000471test_suite "inmemory_journal" -description {
danielk1977b3175382008-10-17 18:51:52 +0000472 Run tests with an in-memory journal file.
473} -presql {
474 pragma journal_mode = 'memory'
dan0626dfc2010-06-15 06:56:37 +0000475} -files [test_set $::allquicktests -exclude {
danielk1977b3175382008-10-17 18:51:52 +0000476 # Exclude all tests that simulate IO errors.
477 autovacuum_ioerr2.test incrvacuum_ioerr.test ioerr.test
478 ioerr.test ioerr2.test ioerr3.test ioerr4.test ioerr5.test
drh2206a2b2009-04-01 23:09:43 +0000479 vacuum3.test incrblob_err.test diskfull.test backup_ioerr.test
drh08ede1d2010-04-12 20:54:13 +0000480 e_fts3.test
danielk1977b3175382008-10-17 18:51:52 +0000481
482 # Exclude test scripts that use tcl IO to access journal files or count
483 # the number of fsync() calls.
484 pager.test exclusive.test jrnlmode.test sync.test misc1.test
danielk1977cb257902009-04-10 18:32:29 +0000485 journal1.test conflict.test crash8.test tkt3457.test io.test
dan01d38562010-03-08 10:32:38 +0000486
487 # Exclude stmt.test, which expects sub-journals to use temporary files.
488 stmt.test
drh0b944132010-05-24 20:24:38 +0000489
490 # WAL mode is different.
dan0626dfc2010-06-15 06:56:37 +0000491 wal*
492}]
danielk1977b3175382008-10-17 18:51:52 +0000493
danielk19776b39c2e2008-06-25 14:57:53 +0000494ifcapable mem3 {
dan0626dfc2010-06-15 06:56:37 +0000495 test_suite "memsys3" -description {
danielk19776b39c2e2008-06-25 14:57:53 +0000496 Run tests using the allocator in mem3.c.
dan0626dfc2010-06-15 06:56:37 +0000497 } [test_set $::allquicktests -exclude {
drh8a42cbd2008-07-10 18:13:42 +0000498 autovacuum.test delete3.test manydb.test
499 bigrow.test incrblob2.test memdb.test
500 bitvec.test index2.test memsubsys1.test
501 capi3c.test ioerr.test memsubsys2.test
502 capi3.test join3.test pagesize.test
danielk19778b322822009-07-01 18:09:01 +0000503 collate5.test limit.test backup_ioerr.test
504 backup_malloc.test
dan0626dfc2010-06-15 06:56:37 +0000505 }] -initialize {
danielk19776b39c2e2008-06-25 14:57:53 +0000506 catch {db close}
507 sqlite3_reset_auto_extension
508 sqlite3_shutdown
drh7830cd42008-07-16 12:25:32 +0000509 sqlite3_config_heap 25000000 0
drhe2a7c6e2008-08-01 15:06:30 +0000510 sqlite3_config_lookaside 0 0
danielk19778b322822009-07-01 18:09:01 +0000511 ifcapable mem5 {
512 # If both memsys3 and memsys5 are enabled in the build, the call to
513 # [sqlite3_config_heap] will initialize the system to use memsys5.
514 # The following overrides this preference and installs the memsys3
515 # allocator.
516 sqlite3_install_memsys3
517 }
danielk19776b39c2e2008-06-25 14:57:53 +0000518 install_malloc_faultsim 1
519 sqlite3_initialize
520 autoinstall_test_functions
521 } -shutdown {
522 catch {db close}
danielk19776b39c2e2008-06-25 14:57:53 +0000523 sqlite3_shutdown
danielk19770d84e5b2008-06-27 14:05:24 +0000524 sqlite3_config_heap 0 0
drhe2a7c6e2008-08-01 15:06:30 +0000525 sqlite3_config_lookaside 100 500
danielk19776b39c2e2008-06-25 14:57:53 +0000526 install_malloc_faultsim 1
527 sqlite3_initialize
drhbb77b752009-04-09 01:23:49 +0000528 autoinstall_test_functions
danielk19776b39c2e2008-06-25 14:57:53 +0000529 }
danielk197757e5ea92008-06-24 19:02:55 +0000530}
531
danielk19776b39c2e2008-06-25 14:57:53 +0000532ifcapable mem5 {
dan0626dfc2010-06-15 06:56:37 +0000533 test_suite "memsys5" -description {
danielk19776b39c2e2008-06-25 14:57:53 +0000534 Run tests using the allocator in mem5.c.
dan0626dfc2010-06-15 06:56:37 +0000535 } [test_set $::allquicktests -exclude {
drh8a42cbd2008-07-10 18:13:42 +0000536 autovacuum.test delete3.test manydb.test
537 bigrow.test incrblob2.test memdb.test
538 bitvec.test index2.test memsubsys1.test
539 capi3c.test ioerr.test memsubsys2.test
540 capi3.test join3.test pagesize.test
danielk1977ac8d7b32008-11-13 16:21:50 +0000541 collate5.test limit.test zeroblob.test
dan0626dfc2010-06-15 06:56:37 +0000542 }] -initialize {
danielk19776b39c2e2008-06-25 14:57:53 +0000543 catch {db close}
danielk19776b39c2e2008-06-25 14:57:53 +0000544 sqlite3_shutdown
drh7830cd42008-07-16 12:25:32 +0000545 sqlite3_config_heap 25000000 64
drhe2a7c6e2008-08-01 15:06:30 +0000546 sqlite3_config_lookaside 0 0
danielk19775099be52008-06-27 13:27:03 +0000547 install_malloc_faultsim 1
548 sqlite3_initialize
549 autoinstall_test_functions
550 } -shutdown {
551 catch {db close}
danielk19775099be52008-06-27 13:27:03 +0000552 sqlite3_shutdown
danielk19770d84e5b2008-06-27 14:05:24 +0000553 sqlite3_config_heap 0 0
drhe2a7c6e2008-08-01 15:06:30 +0000554 sqlite3_config_lookaside 100 500
danielk19775099be52008-06-27 13:27:03 +0000555 install_malloc_faultsim 1
556 sqlite3_initialize
drhbb77b752009-04-09 01:23:49 +0000557 autoinstall_test_functions
danielk19775099be52008-06-27 13:27:03 +0000558 }
559
dan0626dfc2010-06-15 06:56:37 +0000560 test_suite "memsys5-2" -description {
danielk19775099be52008-06-27 13:27:03 +0000561 Run tests using the allocator in mem5.c in a different configuration.
dan0626dfc2010-06-15 06:56:37 +0000562 } -files {
drh8a42cbd2008-07-10 18:13:42 +0000563 select1.test
danielk19775099be52008-06-27 13:27:03 +0000564 } -initialize {
565 catch {db close}
danielk19775099be52008-06-27 13:27:03 +0000566 sqlite3_shutdown
drh7830cd42008-07-16 12:25:32 +0000567 sqlite3_config_heap 40000000 16
drhe2a7c6e2008-08-01 15:06:30 +0000568 sqlite3_config_lookaside 0 0
danielk19776b39c2e2008-06-25 14:57:53 +0000569 install_malloc_faultsim 1
570 sqlite3_initialize
571 autoinstall_test_functions
572 } -shutdown {
573 catch {db close}
danielk19776b39c2e2008-06-25 14:57:53 +0000574 sqlite3_shutdown
danielk19770d84e5b2008-06-27 14:05:24 +0000575 sqlite3_config_heap 0 0
drhe2a7c6e2008-08-01 15:06:30 +0000576 sqlite3_config_lookaside 100 500
danielk19776b39c2e2008-06-25 14:57:53 +0000577 install_malloc_faultsim 1
578 sqlite3_initialize
drhbb77b752009-04-09 01:23:49 +0000579 autoinstall_test_functions
danielk19776b39c2e2008-06-25 14:57:53 +0000580 }
danielk1977c66c0e12008-06-25 14:26:07 +0000581}
582
drh8a42cbd2008-07-10 18:13:42 +0000583ifcapable threadsafe {
dan0626dfc2010-06-15 06:56:37 +0000584 test_suite "no_mutex_try" -description {
drh8a42cbd2008-07-10 18:13:42 +0000585 The sqlite3_mutex_try() interface always fails
dan0626dfc2010-06-15 06:56:37 +0000586 } -files [
587 test_set $::allquicktests -exclude mutex1.test mutex2.test
588 ] -initialize {
drh8a42cbd2008-07-10 18:13:42 +0000589 catch {db close}
590 sqlite3_shutdown
591 install_mutex_counters 1
592 set ::disable_mutex_try 1
drhbb77b752009-04-09 01:23:49 +0000593 sqlite3_initialize
594 autoinstall_test_functions
drh8a42cbd2008-07-10 18:13:42 +0000595 } -shutdown {
596 catch {db close}
597 sqlite3_shutdown
598 install_mutex_counters 0
drhbb77b752009-04-09 01:23:49 +0000599 sqlite3_initialize
600 autoinstall_test_functions
drh8a42cbd2008-07-10 18:13:42 +0000601 }
602}
603
danielk1977b13dee92008-06-23 15:55:52 +0000604# run_tests "crash_safe_append" -description {
605# Run crash.test with persistent journals on a SAFE_APPEND file-system.
606# } -initialize {
607# rename crashsql sa_crashsql
608# proc crashsql {args} {
609# set options [lrange $args 0 [expr {[llength $args]-2}]]
610# lappend options -char safe_append
611# set sql [lindex $args end]
612# lappend options "
613# PRAGMA journal_mode=persistent;
614# $sql
615# "
616# set fd [open test.db-journal w]
617# puts $fd [string repeat 1234567890 100000]
618# close $fd
619# eval sa_crashsql $options
620# }
621# } -shutdown {
622# rename crashsql {}
623# rename sa_crashsql crashsql
dan0626dfc2010-06-15 06:56:37 +0000624# } -files crash.test
danielk1977b13dee92008-06-23 15:55:52 +0000625
dan0626dfc2010-06-15 06:56:37 +0000626test_suite "safe_append" -description {
danielk1977755339e2008-09-12 10:22:40 +0000627 Run some tests on a SAFE_APPEND file-system.
628} -initialize {
629 rename sqlite3 sqlite3_safeappend
630 proc sqlite3 {args} {
631 if {[string range [lindex $args 0] 0 0] ne "-"} {
632 lappend args -vfs devsym
633 }
634 uplevel [concat sqlite3_safeappend $args]
635 }
636 sqlite3_simulate_device -char safe_append
637} -shutdown {
638 rename sqlite3 {}
639 rename sqlite3_shutdown sqlite3
dan0626dfc2010-06-15 06:56:37 +0000640} -files [
641 test_set $::allquicktests shared_err.test -exclude async3.test
642]
danielk1977755339e2008-09-12 10:22:40 +0000643
drhb232c232008-11-19 01:20:26 +0000644# The set of tests to run on the alternative-pcache
645set perm-alt-pcache-testset {
646 async.test
647 attach.test
648 delete.test delete2.test
649 index.test
650 insert.test insert2.test
651 join.test join2.test
652 rollback.test
653 select1.test select2.test
654 trans.test
655 update.test
656}
657
dan0626dfc2010-06-15 06:56:37 +0000658test_suite "pcache0" -description {
drhb232c232008-11-19 01:20:26 +0000659 Alternative pcache implementation without random discard
660} -initialize {
661 catch {db close}
drhb232c232008-11-19 01:20:26 +0000662 sqlite3_shutdown
663 sqlite3_config_alt_pcache 1 0 1
664 sqlite3_initialize
665 autoinstall_test_functions
666} -shutdown {
667 catch {db close}
drhb232c232008-11-19 01:20:26 +0000668 sqlite3_shutdown
669 sqlite3_config_alt_pcache 0 0 0
670 sqlite3_config_lookaside 100 500
671 install_malloc_faultsim 1
672 sqlite3_initialize
drhbb77b752009-04-09 01:23:49 +0000673 autoinstall_test_functions
dan0626dfc2010-06-15 06:56:37 +0000674} -files ${perm-alt-pcache-testset}
drhb232c232008-11-19 01:20:26 +0000675
dan0626dfc2010-06-15 06:56:37 +0000676test_suite "pcache10" -description {
drhb232c232008-11-19 01:20:26 +0000677 Alternative pcache implementation without 10% random discard
678} -initialize {
679 catch {db close}
drhb232c232008-11-19 01:20:26 +0000680 sqlite3_shutdown
681 sqlite3_config_alt_pcache 1 50 1
682 sqlite3_initialize
683 autoinstall_test_functions
684} -shutdown {
685 catch {db close}
drhb232c232008-11-19 01:20:26 +0000686 sqlite3_shutdown
687 sqlite3_config_alt_pcache 0 0 0
688 sqlite3_initialize
drhbb77b752009-04-09 01:23:49 +0000689 autoinstall_test_functions
dan0626dfc2010-06-15 06:56:37 +0000690} -files ${perm-alt-pcache-testset}
drhb232c232008-11-19 01:20:26 +0000691
dan0626dfc2010-06-15 06:56:37 +0000692test_suite "pcache50" -description {
drhb232c232008-11-19 01:20:26 +0000693 Alternative pcache implementation without 50% random discard
694} -initialize {
695 catch {db close}
drhb232c232008-11-19 01:20:26 +0000696 sqlite3_shutdown
697 sqlite3_config_alt_pcache 1 50 1
698 sqlite3_initialize
699 autoinstall_test_functions
700} -shutdown {
701 catch {db close}
drhb232c232008-11-19 01:20:26 +0000702 sqlite3_shutdown
703 sqlite3_config_alt_pcache 0 0 0
704 sqlite3_initialize
drhbb77b752009-04-09 01:23:49 +0000705 autoinstall_test_functions
dan0626dfc2010-06-15 06:56:37 +0000706} -files ${perm-alt-pcache-testset}
drhb232c232008-11-19 01:20:26 +0000707
dan0626dfc2010-06-15 06:56:37 +0000708test_suite "pcache90" -description {
drhb232c232008-11-19 01:20:26 +0000709 Alternative pcache implementation without 90% random discard
710} -initialize {
711 catch {db close}
drhb232c232008-11-19 01:20:26 +0000712 sqlite3_shutdown
713 sqlite3_config_alt_pcache 1 50 1
714 sqlite3_initialize
715 autoinstall_test_functions
716} -shutdown {
717 catch {db close}
drhb232c232008-11-19 01:20:26 +0000718 sqlite3_shutdown
719 sqlite3_config_alt_pcache 0 0 0
720 sqlite3_initialize
drhbb77b752009-04-09 01:23:49 +0000721 autoinstall_test_functions
dan0626dfc2010-06-15 06:56:37 +0000722} -files ${perm-alt-pcache-testset}
drhb232c232008-11-19 01:20:26 +0000723
dan0626dfc2010-06-15 06:56:37 +0000724test_suite "pcache100" -description {
drhb232c232008-11-19 01:20:26 +0000725 Alternative pcache implementation that always discards when unpinning
726} -initialize {
727 catch {db close}
drhb232c232008-11-19 01:20:26 +0000728 sqlite3_shutdown
729 sqlite3_config_alt_pcache 1 100 1
730 sqlite3_initialize
731 autoinstall_test_functions
732} -shutdown {
733 catch {db close}
drhb232c232008-11-19 01:20:26 +0000734 sqlite3_shutdown
735 sqlite3_config_alt_pcache 0 0 0
736 sqlite3_initialize
drhbb77b752009-04-09 01:23:49 +0000737 autoinstall_test_functions
dan0626dfc2010-06-15 06:56:37 +0000738} -files ${perm-alt-pcache-testset}
danielk1977b13dee92008-06-23 15:55:52 +0000739
dan0626dfc2010-06-15 06:56:37 +0000740test_suite "journaltest" -description {
danielk1977f3107512008-12-22 10:58:46 +0000741 Check that pages are synced before being written (test_journal.c).
742} -initialize {
danielk1977f3107512008-12-22 10:58:46 +0000743 catch {db close}
744 register_jt_vfs -default ""
745} -shutdown {
746 unregister_jt_vfs
dan0626dfc2010-06-15 06:56:37 +0000747} -files [test_set $::allquicktests -exclude {
748 wal* incrvacuum.test ioerr.test corrupt4.test io.test crash8.test
749 async4.test bigfile.test
drhfb4a6262010-05-06 19:55:57 +0000750}]
danielk1977f3107512008-12-22 10:58:46 +0000751
dan0a7a9152010-04-07 07:57:38 +0000752if {[info commands register_demovfs] != ""} {
dan0626dfc2010-06-15 06:56:37 +0000753 test_suite "demovfs" -description {
dan430e74c2010-06-07 17:47:26 +0000754 Check that the demovfs (code in test_demovfs.c) more or less works.
dan0a7a9152010-04-07 07:57:38 +0000755 } -initialize {
756 register_demovfs
757 } -shutdown {
758 unregister_demovfs
dan0626dfc2010-06-15 06:56:37 +0000759 } -files {
dan0a7a9152010-04-07 07:57:38 +0000760 insert.test insert2.test insert3.test rollback.test
761 select1.test select2.test select3.test
762 }
763}
764
dan0626dfc2010-06-15 06:56:37 +0000765test_suite "wal" -description {
dan71cb5182010-04-26 12:39:03 +0000766 Run tests with journal_mode=WAL
dan31f98fc2010-04-27 05:42:32 +0000767} -initialize {
dan430e74c2010-06-07 17:47:26 +0000768 set ::G(savepoint6_iterations) 100
dan31f98fc2010-04-27 05:42:32 +0000769} -shutdown {
dan430e74c2010-06-07 17:47:26 +0000770 unset -nocomplain ::G(savepoint6_iterations)
dan0626dfc2010-06-15 06:56:37 +0000771} -files {
dane106de62010-04-27 06:49:34 +0000772 savepoint.test savepoint2.test savepoint6.test
773 trans.test avtrans.test
dan71cb5182010-04-26 12:39:03 +0000774}
danielk19771077e3f2008-06-21 18:07:37 +0000775# End of tests
776#############################################################################
777
dan0626dfc2010-06-15 06:56:37 +0000778# run_tests NAME OPTIONS
779#
780# where available options are:
781#
dan2fce9ab2010-06-15 18:00:06 +0000782# -description TITLE
783# -initialize SCRIPT
784# -shutdown SCRIPT
785# -presql SQL
786# -files LIST-OF-FILES
787# -prefix NAME
dan0626dfc2010-06-15 06:56:37 +0000788#
789proc run_tests {name args} {
790 array set options $args
danielk19771077e3f2008-06-21 18:07:37 +0000791
dan2fce9ab2010-06-15 18:00:06 +0000792 set ::G(perm:name) $options(-prefix)
dan0626dfc2010-06-15 06:56:37 +0000793 set ::G(perm:presql) $options(-presql)
794 set ::G(isquick) 1
795
796 uplevel $options(-initialize)
797
798 foreach file [lsort $options(-files)] {
799 slave_test_file $::testdir/$file
800 }
801
802 uplevel $options(-shutdown)
803
804 unset ::G(perm:name)
805 unset ::G(perm:presql)
806}
807
808proc run_test_suite {name} {
809 if {[info exists ::testspec($name)]==0} {
810 error "No such test suite: $name"
811 }
812 uplevel run_tests $name $::testspec($name)
813}
814
815proc help {} {
dane91a54e2010-06-15 17:44:47 +0000816 puts "Usage: $::argv0 TESTSUITE ?TESTFILE?"
817 puts ""
818 puts "Available test-suites are:"
dan0626dfc2010-06-15 06:56:37 +0000819 foreach k $::testsuitelist {
dane91a54e2010-06-15 17:44:47 +0000820 if {[info exists ::testspec($k)]==0} {
821 puts " ----------------------------------------"
822 puts ""
823 } else {
824 array set o $::testspec($k)
825 puts "Test suite: \"$k\""
826 set d [string trim $o(-description)]
827 set d [regsub {\n *} $d "\n "]
828 puts " $d"
829 puts ""
830 }
dan0626dfc2010-06-15 06:56:37 +0000831 }
832 exit -1
833}
834
835if {[info script] == $argv0} {
836 proc main {argv} {
837 if {[llength $argv]==0} {
838 help
839 } else {
840 set suite [lindex $argv 0]
841 if {[info exists ::testspec($suite)]==0} help
842 set extra ""
843 if {[llength $argv]>1} { set extra [list -files [lrange $argv 1 end]] }
844 eval run_tests $suite $::testspec($suite) $extra
845 }
846 }
847 main $argv
848 finish_test
849}
850