blob: 06f629468f081ba7b94ffc29ee45067e5b180d15 [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 }
dan897230e2010-08-26 14:15:37 +000072 foreach f $a { array unset t */$f }
danielk19771077e3f2008-06-21 18:07:37 +000073 }
74 }
75
dan0626dfc2010-06-15 06:56:37 +000076 return [array names t]
danielk19771077e3f2008-06-21 18:07:37 +000077}
78
dan0626dfc2010-06-15 06:56:37 +000079#-------------------------------------------------------------------------
80# Set up the following global list variables containing the names of
81# various test scripts:
82#
83# $alltests
dan2fce9ab2010-06-15 18:00:06 +000084# $allquicktests
dan0626dfc2010-06-15 06:56:37 +000085#
dan0626dfc2010-06-15 06:56:37 +000086set alltests [list]
87foreach f [glob $testdir/*.test] { lappend alltests [file tail $f] }
dan897230e2010-08-26 14:15:37 +000088foreach f [glob -nocomplain $testdir/../ext/rtree/*.test] {
89 lappend alltests $f
90}
91
dan0626dfc2010-06-15 06:56:37 +000092if {$::tcl_platform(platform)!="unix"} {
93 set alltests [test_set $alltests -exclude crash.test crash2.test]
danielk1977c1def3e2008-08-30 13:25:10 +000094}
dan0626dfc2010-06-15 06:56:37 +000095set alltests [test_set $alltests -exclude {
96 all.test async.test quick.test veryquick.test
97 memleak.test permutations.test soak.test fts3.test
dan897230e2010-08-26 14:15:37 +000098 mallocAll.tes rtree.test
dan0626dfc2010-06-15 06:56:37 +000099}]
100
101set allquicktests [test_set $alltests -exclude {
102 async2.test async3.test backup_ioerr.test corrupt.test
103 corruptC.test crash.test crash2.test crash3.test crash4.test crash5.test
104 crash6.test crash7.test delete3.test e_fts3.test fts3rnd.test
105 fkey_malloc.test fuzz.test fuzz3.test fuzz_malloc.test in2.test loadext.test
dan273f3f02010-06-26 15:42:33 +0000106 misc7.test mutex2.test notify2.test onefile.test pagerfault2.test
dan0626dfc2010-06-15 06:56:37 +0000107 savepoint4.test savepoint6.test select9.test
108 speed1.test speed1p.test speed2.test speed3.test speed4.test
109 speed4p.test sqllimits1.test tkt2686.test thread001.test thread002.test
110 thread003.test thread004.test thread005.test trans2.test vacuum3.test
111 incrvacuum_ioerr.test autovacuum_crash.test btree8.test shared_err.test
112 vtab_err.test walslow.test walcrash.test
dan897230e2010-08-26 14:15:37 +0000113 walthread.test rtree3.test
dan0626dfc2010-06-15 06:56:37 +0000114}]
dan63109902010-07-05 05:54:55 +0000115if {[info exists ::env(QUICKTEST_INCLUDE)]} {
116 set allquicktests [concat $allquicktests $::env(QUICKTEST_INCLUDE)]
117}
danielk1977c1def3e2008-08-30 13:25:10 +0000118
danielk19771077e3f2008-06-21 18:07:37 +0000119#############################################################################
120# Start of tests
dan0626dfc2010-06-15 06:56:37 +0000121#
122
123#-------------------------------------------------------------------------
124# Define the generic test suites:
125#
126# veryquick
127# quick
128# full
dan0626dfc2010-06-15 06:56:37 +0000129#
dane91a54e2010-06-15 17:44:47 +0000130lappend ::testsuitelist xxx
dan0626dfc2010-06-15 06:56:37 +0000131
dan2fce9ab2010-06-15 18:00:06 +0000132test_suite "veryquick" -prefix "" -description {
dan0626dfc2010-06-15 06:56:37 +0000133 "Very" quick test suite. Runs in less than 5 minutes on a workstation.
134 This test suite is the same as the "quick" tests, except that some files
135 that test malloc and IO errors are omitted.
136} -files [
dan763afe62010-08-03 06:42:39 +0000137 test_set $allquicktests -exclude *malloc* *ioerr* *fault*
dan0626dfc2010-06-15 06:56:37 +0000138]
139
dan2fce9ab2010-06-15 18:00:06 +0000140test_suite "quick" -prefix "" -description {
dan0626dfc2010-06-15 06:56:37 +0000141 Quick test suite. Runs in around 10 minutes on a workstation.
142} -files [
143 test_set $allquicktests
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
danea5542d2010-07-06 11:26:15 +0000154test_suite "threads" -prefix "" -description {
155 All multi-threaded tests.
156} -files {
157 notify2.test thread001.test thread002.test thread003.test
158 thread004.test thread005.test walthread.test
159}
160
dana69f7d52010-07-19 11:16:36 +0000161test_suite "fts3" -prefix "" -description {
162 All FTS3 tests except fts3malloc.test and fts3rnd.test.
163} -files {
164 fts3aa.test fts3ab.test fts3ac.test fts3ad.test fts3ae.test
165 fts3af.test fts3ag.test fts3ah.test fts3ai.test fts3aj.test
166 fts3ak.test fts3al.test fts3am.test fts3an.test fts3ao.test
167 fts3atoken.test fts3b.test fts3c.test fts3cov.test fts3d.test
168 fts3e.test fts3expr.test fts3expr2.test fts3near.test
169 fts3query.test fts3snippet.test
170}
171
danea5542d2010-07-06 11:26:15 +0000172
dane91a54e2010-06-15 17:44:47 +0000173lappend ::testsuitelist xxx
dan0626dfc2010-06-15 06:56:37 +0000174#-------------------------------------------------------------------------
175# Define the coverage related test suites:
176#
177# coverage-wal
dan0626dfc2010-06-15 06:56:37 +0000178#
179test_suite "coverage-wal" -description {
180 Coverage tests for file wal.c.
181} -files {
danf43d7fc2010-07-03 10:00:00 +0000182 wal.test wal2.test wal3.test walmode.test
183 walbak.test walhook.test walcrash2.test walcksum.test
danbd0e9072010-07-07 09:48:44 +0000184 walfault.test walbig.test
dan0626dfc2010-06-15 06:56:37 +0000185}
186
dane91a54e2010-06-15 17:44:47 +0000187test_suite "coverage-pager" -description {
188 Coverage tests for file pager.c.
189} -files {
danf43d7fc2010-07-03 10:00:00 +0000190 pager1.test pager2.test pagerfault.test pagerfault2.test
191 walfault.test walbak.test journal2.test tkt-9d68c883.test
dane91a54e2010-06-15 17:44:47 +0000192}
dan0626dfc2010-06-15 06:56:37 +0000193
194
dane91a54e2010-06-15 17:44:47 +0000195lappend ::testsuitelist xxx
dan0626dfc2010-06-15 06:56:37 +0000196#-------------------------------------------------------------------------
197# Define the permutation test suites:
198#
danielk19771077e3f2008-06-21 18:07:37 +0000199
200# Run some tests using pre-allocated page and scratch blocks.
201#
dan0626dfc2010-06-15 06:56:37 +0000202test_suite "memsubsys1" -description {
danielk19771077e3f2008-06-21 18:07:37 +0000203 Tests using pre-allocated page and scratch blocks
dan0626dfc2010-06-15 06:56:37 +0000204} -files [
205 test_set $::allquicktests -exclude ioerr5.test malloc5.test
206] -initialize {
drhd63bd752008-07-30 13:15:46 +0000207 catch {db close}
danielk19771077e3f2008-06-21 18:07:37 +0000208 sqlite3_shutdown
209 sqlite3_config_pagecache 4096 24
210 sqlite3_config_scratch 25000 1
211 sqlite3_initialize
drhbb77b752009-04-09 01:23:49 +0000212 autoinstall_test_functions
danielk19771077e3f2008-06-21 18:07:37 +0000213} -shutdown {
214 catch {db close}
215 sqlite3_shutdown
216 sqlite3_config_pagecache 0 0
217 sqlite3_config_scratch 0 0
218 sqlite3_initialize
drhbb77b752009-04-09 01:23:49 +0000219 autoinstall_test_functions
danielk19771077e3f2008-06-21 18:07:37 +0000220}
221
222# Run some tests using pre-allocated page and scratch blocks. This time
223# the allocations are too small to use in most cases.
224#
danielk197734c61e62008-08-29 12:00:20 +0000225# Both ioerr5.test and malloc5.test are excluded because they test the
226# sqlite3_soft_heap_limit() and sqlite3_release_memory() functionality.
227# This functionality is disabled if a pre-allocated page block is provided.
228#
dan0626dfc2010-06-15 06:56:37 +0000229test_suite "memsubsys2" -description {
danielk19771077e3f2008-06-21 18:07:37 +0000230 Tests using small pre-allocated page and scratch blocks
dan0626dfc2010-06-15 06:56:37 +0000231} -files [
232 test_set $::allquicktests -exclude ioerr5.test malloc5.test
233] -initialize {
drhd63bd752008-07-30 13:15:46 +0000234 catch {db close}
danielk19771077e3f2008-06-21 18:07:37 +0000235 sqlite3_shutdown
236 sqlite3_config_pagecache 512 5
237 sqlite3_config_scratch 1000 1
238 sqlite3_initialize
drhbb77b752009-04-09 01:23:49 +0000239 autoinstall_test_functions
danielk19771077e3f2008-06-21 18:07:37 +0000240} -shutdown {
241 catch {db close}
242 sqlite3_shutdown
243 sqlite3_config_pagecache 0 0
244 sqlite3_config_scratch 0 0
245 sqlite3_initialize
drhbb77b752009-04-09 01:23:49 +0000246 autoinstall_test_functions
danielk19771077e3f2008-06-21 18:07:37 +0000247}
248
drhe2a7c6e2008-08-01 15:06:30 +0000249# Run all tests with the lookaside allocator disabled.
250#
dan0626dfc2010-06-15 06:56:37 +0000251test_suite "nolookaside" -description {
drhe2a7c6e2008-08-01 15:06:30 +0000252 OOM tests with lookaside disabled
drhe2a7c6e2008-08-01 15:06:30 +0000253} -initialize {
254 catch {db close}
255 sqlite3_shutdown
256 sqlite3_config_lookaside 0 0
257 sqlite3_initialize
drhbb77b752009-04-09 01:23:49 +0000258 autoinstall_test_functions
drhe2a7c6e2008-08-01 15:06:30 +0000259} -shutdown {
260 catch {db close}
261 sqlite3_shutdown
262 sqlite3_config_lookaside 100 500
263 sqlite3_initialize
drhbb77b752009-04-09 01:23:49 +0000264 autoinstall_test_functions
dan0626dfc2010-06-15 06:56:37 +0000265} -files $::allquicktests
drhe2a7c6e2008-08-01 15:06:30 +0000266
danielk19771077e3f2008-06-21 18:07:37 +0000267# Run some tests in SQLITE_CONFIG_SINGLETHREAD mode.
268#
dan0626dfc2010-06-15 06:56:37 +0000269test_suite "singlethread" -description {
danielk19771077e3f2008-06-21 18:07:37 +0000270 Tests run in SQLITE_CONFIG_SINGLETHREAD mode
271} -initialize {
drh04df18d2009-01-06 14:50:11 +0000272 catch {db close}
273 sqlite3_shutdown
274 catch {sqlite3_config singlethread}
drhbb77b752009-04-09 01:23:49 +0000275 sqlite3_initialize
276 autoinstall_test_functions
dan0626dfc2010-06-15 06:56:37 +0000277} -files {
danielk19771077e3f2008-06-21 18:07:37 +0000278 delete.test delete2.test insert.test rollback.test select1.test
279 select2.test trans.test update.test vacuum.test types.test
280 types2.test types3.test
281} -shutdown {
drh04df18d2009-01-06 14:50:11 +0000282 catch {db close}
283 sqlite3_shutdown
284 catch {sqlite3_config serialized}
drhbb77b752009-04-09 01:23:49 +0000285 sqlite3_initialize
286 autoinstall_test_functions
danielk19771077e3f2008-06-21 18:07:37 +0000287}
288
dan0626dfc2010-06-15 06:56:37 +0000289test_suite "nomutex" -description {
drh039963a2008-09-03 00:43:15 +0000290 Tests run with the SQLITE_OPEN_MULTITHREADED flag passed to sqlite3_open().
danielk19779a6284c2008-07-10 17:52:49 +0000291} -initialize {
292 rename sqlite3 sqlite3_nomutex
293 proc sqlite3 {args} {
294 if {[string range [lindex $args 0] 0 0] ne "-"} {
drhcc91e7f2008-09-03 01:08:00 +0000295 lappend args -fullmutex 0 -nomutex 1
danielk19779a6284c2008-07-10 17:52:49 +0000296 }
297 uplevel [concat sqlite3_nomutex $args]
298 }
dan0626dfc2010-06-15 06:56:37 +0000299} -files {
danielk19779a6284c2008-07-10 17:52:49 +0000300 delete.test delete2.test insert.test rollback.test select1.test
301 select2.test trans.test update.test vacuum.test types.test
302 types2.test types3.test
303} -shutdown {
304 rename sqlite3 {}
305 rename sqlite3_nomutex sqlite3
306}
307
danielk19771077e3f2008-06-21 18:07:37 +0000308# Run some tests in SQLITE_CONFIG_MULTITHREAD mode.
309#
dan0626dfc2010-06-15 06:56:37 +0000310test_suite "multithread" -description {
danielk19771077e3f2008-06-21 18:07:37 +0000311 Tests run in SQLITE_CONFIG_MULTITHREAD mode
312} -initialize {
drh04df18d2009-01-06 14:50:11 +0000313 catch {db close}
314 sqlite3_shutdown
315 catch {sqlite3_config multithread}
drhbb77b752009-04-09 01:23:49 +0000316 sqlite3_initialize
317 autoinstall_test_functions
dan0626dfc2010-06-15 06:56:37 +0000318} -files {
danielk19771077e3f2008-06-21 18:07:37 +0000319 delete.test delete2.test insert.test rollback.test select1.test
320 select2.test trans.test update.test vacuum.test types.test
321 types2.test types3.test
322} -shutdown {
drh04df18d2009-01-06 14:50:11 +0000323 catch {db close}
324 sqlite3_shutdown
325 catch {sqlite3_config serialized}
drhbb77b752009-04-09 01:23:49 +0000326 sqlite3_initialize
327 autoinstall_test_functions
danielk19771077e3f2008-06-21 18:07:37 +0000328}
329
drh039963a2008-09-03 00:43:15 +0000330# Run some tests in SQLITE_OPEN_FULLMUTEX mode.
331#
dan0626dfc2010-06-15 06:56:37 +0000332test_suite "fullmutex" -description {
drh039963a2008-09-03 00:43:15 +0000333 Tests run in SQLITE_OPEN_FULLMUTEX mode
334} -initialize {
335 rename sqlite3 sqlite3_fullmutex
336 proc sqlite3 {args} {
337 if {[string range [lindex $args 0] 0 0] ne "-"} {
drhcc91e7f2008-09-03 01:08:00 +0000338 lappend args -nomutex 0 -fullmutex 1
drh039963a2008-09-03 00:43:15 +0000339 }
340 uplevel [concat sqlite3_fullmutex $args]
341 }
dan0626dfc2010-06-15 06:56:37 +0000342} -files {
drh039963a2008-09-03 00:43:15 +0000343 delete.test delete2.test insert.test rollback.test select1.test
344 select2.test trans.test update.test vacuum.test types.test
345 types2.test types3.test
346} -shutdown {
347 rename sqlite3 {}
348 rename sqlite3_fullmutex sqlite3
349}
350
danielk19771077e3f2008-06-21 18:07:37 +0000351# Run some tests using the "onefile" demo.
352#
dan0626dfc2010-06-15 06:56:37 +0000353test_suite "onefile" -description {
danielk19771077e3f2008-06-21 18:07:37 +0000354 Run some tests using the "test_onefile.c" demo
355} -initialize {
356 rename sqlite3 sqlite3_onefile
357 proc sqlite3 {args} {
358 if {[string range [lindex $args 0] 0 0] ne "-"} {
359 lappend args -vfs fs
360 }
361 uplevel [concat sqlite3_onefile $args]
362 }
dan0626dfc2010-06-15 06:56:37 +0000363} -files {
danielk19771077e3f2008-06-21 18:07:37 +0000364 conflict.test insert.test insert2.test insert3.test
365 rollback.test select1.test select2.test select3.test
danielk19771077e3f2008-06-21 18:07:37 +0000366} -shutdown {
367 rename sqlite3 {}
368 rename sqlite3_onefile sqlite3
369}
370
371# Run some tests using UTF-16 databases.
372#
dan0626dfc2010-06-15 06:56:37 +0000373test_suite "utf16" -description {
danielk19771077e3f2008-06-21 18:07:37 +0000374 Run tests using UTF-16 databases
danielk19772dd6d802008-06-21 19:10:27 +0000375} -presql {
danielk19771077e3f2008-06-21 18:07:37 +0000376 pragma encoding = 'UTF-16'
dan0626dfc2010-06-15 06:56:37 +0000377} -files {
danielk19771077e3f2008-06-21 18:07:37 +0000378 alter.test alter3.test
379 auth.test bind.test blob.test capi2.test capi3.test collate1.test
380 collate2.test collate3.test collate4.test collate5.test collate6.test
381 conflict.test date.test delete.test expr.test fkey1.test func.test
382 hook.test index.test insert2.test insert.test interrupt.test in.test
383 intpkey.test ioerr.test join2.test join.test lastinsert.test
384 laststmtchanges.test limit.test lock2.test lock.test main.test
385 memdb.test minmax.test misc1.test misc2.test misc3.test notnull.test
386 null.test progress.test quote.test rowid.test select1.test select2.test
387 select3.test select4.test select5.test select6.test sort.test
388 subselect.test tableapi.test table.test temptable.test
389 trace.test trigger1.test trigger2.test trigger3.test
390 trigger4.test types2.test types.test unique.test update.test
391 vacuum.test view.test where.test
392}
393
394# Run some tests in exclusive locking mode.
395#
dan0626dfc2010-06-15 06:56:37 +0000396test_suite "exclusive" -description {
danielk19771077e3f2008-06-21 18:07:37 +0000397 Run tests in exclusive locking mode.
398} -presql {
399 pragma locking_mode = 'exclusive'
dan0626dfc2010-06-15 06:56:37 +0000400} -files {
danielk19771077e3f2008-06-21 18:07:37 +0000401 rollback.test select1.test select2.test
402 malloc.test ioerr.test
403}
404
drh04335882008-09-26 21:08:08 +0000405# Run some tests in exclusive locking mode with truncated journals.
406#
dan0626dfc2010-06-15 06:56:37 +0000407test_suite "exclusive-truncate" -description {
drh04335882008-09-26 21:08:08 +0000408 Run tests in exclusive locking mode and truncate journal mode.
409} -presql {
410 pragma locking_mode = 'exclusive';
411 pragma journal_mode = TRUNCATE;
dan0626dfc2010-06-15 06:56:37 +0000412} -files {
drh04335882008-09-26 21:08:08 +0000413 delete.test delete2.test insert.test rollback.test select1.test
414 select2.test update.test malloc.test ioerr.test
415}
416
danielk19771077e3f2008-06-21 18:07:37 +0000417# Run some tests in persistent journal mode.
418#
dan0626dfc2010-06-15 06:56:37 +0000419test_suite "persistent_journal" -description {
danielk19771077e3f2008-06-21 18:07:37 +0000420 Run tests in persistent-journal mode.
421} -presql {
422 pragma journal_mode = persist
dan0626dfc2010-06-15 06:56:37 +0000423} -files {
danielk19771077e3f2008-06-21 18:07:37 +0000424 delete.test delete2.test insert.test rollback.test select1.test
425 select2.test trans.test update.test vacuum.test
426}
427
drh04335882008-09-26 21:08:08 +0000428# Run some tests in truncating journal mode.
429#
dan0626dfc2010-06-15 06:56:37 +0000430test_suite "truncate_journal" -description {
drh04335882008-09-26 21:08:08 +0000431 Run tests in persistent-journal mode.
432} -presql {
433 pragma journal_mode = truncate
dan0626dfc2010-06-15 06:56:37 +0000434} -files {
drh04335882008-09-26 21:08:08 +0000435 delete.test delete2.test insert.test rollback.test select1.test
436 select2.test trans.test update.test vacuum.test
437 malloc.test ioerr.test
438}
439
danielk19771077e3f2008-06-21 18:07:37 +0000440# Run some error tests in persistent journal mode.
441#
dan0626dfc2010-06-15 06:56:37 +0000442test_suite "persistent_journal_error" -description {
danielk19771077e3f2008-06-21 18:07:37 +0000443 Run malloc.test and ioerr.test in persistent-journal mode.
444} -presql {
445 pragma journal_mode = persist
dan0626dfc2010-06-15 06:56:37 +0000446} -files {
danielk19771077e3f2008-06-21 18:07:37 +0000447 malloc.test ioerr.test
448}
449
450# Run some tests in no journal mode.
451#
dan0626dfc2010-06-15 06:56:37 +0000452test_suite "no_journal" -description {
danielk19771077e3f2008-06-21 18:07:37 +0000453 Run tests in no-journal mode.
454} -presql {
455 pragma journal_mode = persist
dan0626dfc2010-06-15 06:56:37 +0000456} -files {
danielk19771077e3f2008-06-21 18:07:37 +0000457 delete.test delete2.test insert.test rollback.test select1.test
458 select2.test trans.test update.test vacuum.test
459}
460
461# Run some error tests in no journal mode.
462#
dan0626dfc2010-06-15 06:56:37 +0000463test_suite "no_journal_error" -description {
danielk19771077e3f2008-06-21 18:07:37 +0000464 Run malloc.test and ioerr.test in no-journal mode.
465} -presql {
466 pragma journal_mode = persist
dan0626dfc2010-06-15 06:56:37 +0000467} -files {
danielk19771077e3f2008-06-21 18:07:37 +0000468 malloc.test ioerr.test
469}
470
471# Run some crash-tests in autovacuum mode.
472#
dan0626dfc2010-06-15 06:56:37 +0000473test_suite "autovacuum_crash" -description {
danielk19771077e3f2008-06-21 18:07:37 +0000474 Run crash.test in autovacuum mode.
475} -presql {
476 pragma auto_vacuum = 1
dan0626dfc2010-06-15 06:56:37 +0000477} -files crash.test
danielk19771077e3f2008-06-21 18:07:37 +0000478
479# Run some ioerr-tests in autovacuum mode.
480#
dan0626dfc2010-06-15 06:56:37 +0000481test_suite "autovacuum_ioerr" -description {
danielk19771077e3f2008-06-21 18:07:37 +0000482 Run ioerr.test in autovacuum mode.
483} -presql {
484 pragma auto_vacuum = 1
dan0626dfc2010-06-15 06:56:37 +0000485} -files ioerr.test
danielk19771077e3f2008-06-21 18:07:37 +0000486
danielk1977b3175382008-10-17 18:51:52 +0000487# Run tests with an in-memory journal.
488#
dan0626dfc2010-06-15 06:56:37 +0000489test_suite "inmemory_journal" -description {
danielk1977b3175382008-10-17 18:51:52 +0000490 Run tests with an in-memory journal file.
491} -presql {
492 pragma journal_mode = 'memory'
dan0626dfc2010-06-15 06:56:37 +0000493} -files [test_set $::allquicktests -exclude {
danielk1977b3175382008-10-17 18:51:52 +0000494 # Exclude all tests that simulate IO errors.
495 autovacuum_ioerr2.test incrvacuum_ioerr.test ioerr.test
496 ioerr.test ioerr2.test ioerr3.test ioerr4.test ioerr5.test
drh2206a2b2009-04-01 23:09:43 +0000497 vacuum3.test incrblob_err.test diskfull.test backup_ioerr.test
shanehc3b84832010-07-09 19:32:28 +0000498 e_fts3.test fts3cov.test fts3malloc.test fts3rnd.test
499 fts3snippet.test
danielk1977b3175382008-10-17 18:51:52 +0000500
501 # Exclude test scripts that use tcl IO to access journal files or count
502 # the number of fsync() calls.
503 pager.test exclusive.test jrnlmode.test sync.test misc1.test
danielk1977cb257902009-04-10 18:32:29 +0000504 journal1.test conflict.test crash8.test tkt3457.test io.test
dan37575562010-07-17 09:27:31 +0000505 journal3.test
dan01d38562010-03-08 10:32:38 +0000506
dancb354602010-07-08 09:44:42 +0000507 pager1.test async4.test corrupt.test filefmt.test pager2.test
508 corrupt5.test corruptA.test pageropt.test
509
dan01d38562010-03-08 10:32:38 +0000510 # Exclude stmt.test, which expects sub-journals to use temporary files.
511 stmt.test
drh0b944132010-05-24 20:24:38 +0000512
513 # WAL mode is different.
dan0626dfc2010-06-15 06:56:37 +0000514 wal*
515}]
danielk1977b3175382008-10-17 18:51:52 +0000516
danielk19776b39c2e2008-06-25 14:57:53 +0000517ifcapable mem3 {
dan0626dfc2010-06-15 06:56:37 +0000518 test_suite "memsys3" -description {
danielk19776b39c2e2008-06-25 14:57:53 +0000519 Run tests using the allocator in mem3.c.
daneace5272010-07-05 05:31:48 +0000520 } -files [test_set $::allquicktests -exclude {
drh8a42cbd2008-07-10 18:13:42 +0000521 autovacuum.test delete3.test manydb.test
522 bigrow.test incrblob2.test memdb.test
523 bitvec.test index2.test memsubsys1.test
524 capi3c.test ioerr.test memsubsys2.test
525 capi3.test join3.test pagesize.test
danielk19778b322822009-07-01 18:09:01 +0000526 collate5.test limit.test backup_ioerr.test
527 backup_malloc.test
dan0626dfc2010-06-15 06:56:37 +0000528 }] -initialize {
danielk19776b39c2e2008-06-25 14:57:53 +0000529 catch {db close}
530 sqlite3_reset_auto_extension
531 sqlite3_shutdown
drh7830cd42008-07-16 12:25:32 +0000532 sqlite3_config_heap 25000000 0
drhe2a7c6e2008-08-01 15:06:30 +0000533 sqlite3_config_lookaside 0 0
danielk19778b322822009-07-01 18:09:01 +0000534 ifcapable mem5 {
535 # If both memsys3 and memsys5 are enabled in the build, the call to
536 # [sqlite3_config_heap] will initialize the system to use memsys5.
537 # The following overrides this preference and installs the memsys3
538 # allocator.
539 sqlite3_install_memsys3
540 }
danielk19776b39c2e2008-06-25 14:57:53 +0000541 install_malloc_faultsim 1
542 sqlite3_initialize
543 autoinstall_test_functions
544 } -shutdown {
545 catch {db close}
danielk19776b39c2e2008-06-25 14:57:53 +0000546 sqlite3_shutdown
danielk19770d84e5b2008-06-27 14:05:24 +0000547 sqlite3_config_heap 0 0
drhe2a7c6e2008-08-01 15:06:30 +0000548 sqlite3_config_lookaside 100 500
danielk19776b39c2e2008-06-25 14:57:53 +0000549 install_malloc_faultsim 1
550 sqlite3_initialize
drhbb77b752009-04-09 01:23:49 +0000551 autoinstall_test_functions
danielk19776b39c2e2008-06-25 14:57:53 +0000552 }
danielk197757e5ea92008-06-24 19:02:55 +0000553}
554
danielk19776b39c2e2008-06-25 14:57:53 +0000555ifcapable mem5 {
dan0626dfc2010-06-15 06:56:37 +0000556 test_suite "memsys5" -description {
danielk19776b39c2e2008-06-25 14:57:53 +0000557 Run tests using the allocator in mem5.c.
daneace5272010-07-05 05:31:48 +0000558 } -files [test_set $::allquicktests -exclude {
drh8a42cbd2008-07-10 18:13:42 +0000559 autovacuum.test delete3.test manydb.test
560 bigrow.test incrblob2.test memdb.test
561 bitvec.test index2.test memsubsys1.test
562 capi3c.test ioerr.test memsubsys2.test
563 capi3.test join3.test pagesize.test
danielk1977ac8d7b32008-11-13 16:21:50 +0000564 collate5.test limit.test zeroblob.test
dan0626dfc2010-06-15 06:56:37 +0000565 }] -initialize {
danielk19776b39c2e2008-06-25 14:57:53 +0000566 catch {db close}
danielk19776b39c2e2008-06-25 14:57:53 +0000567 sqlite3_shutdown
drh7830cd42008-07-16 12:25:32 +0000568 sqlite3_config_heap 25000000 64
drhe2a7c6e2008-08-01 15:06:30 +0000569 sqlite3_config_lookaside 0 0
danielk19775099be52008-06-27 13:27:03 +0000570 install_malloc_faultsim 1
571 sqlite3_initialize
572 autoinstall_test_functions
573 } -shutdown {
574 catch {db close}
danielk19775099be52008-06-27 13:27:03 +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
danielk19775099be52008-06-27 13:27:03 +0000578 install_malloc_faultsim 1
579 sqlite3_initialize
drhbb77b752009-04-09 01:23:49 +0000580 autoinstall_test_functions
danielk19775099be52008-06-27 13:27:03 +0000581 }
582
dan0626dfc2010-06-15 06:56:37 +0000583 test_suite "memsys5-2" -description {
danielk19775099be52008-06-27 13:27:03 +0000584 Run tests using the allocator in mem5.c in a different configuration.
dan0626dfc2010-06-15 06:56:37 +0000585 } -files {
drh8a42cbd2008-07-10 18:13:42 +0000586 select1.test
danielk19775099be52008-06-27 13:27:03 +0000587 } -initialize {
588 catch {db close}
danielk19775099be52008-06-27 13:27:03 +0000589 sqlite3_shutdown
danb0c6a882010-09-02 10:08:41 +0000590 sqlite3_config_memstatus 0
drh7830cd42008-07-16 12:25:32 +0000591 sqlite3_config_heap 40000000 16
drhe2a7c6e2008-08-01 15:06:30 +0000592 sqlite3_config_lookaside 0 0
danielk19776b39c2e2008-06-25 14:57:53 +0000593 install_malloc_faultsim 1
594 sqlite3_initialize
595 autoinstall_test_functions
596 } -shutdown {
597 catch {db close}
danielk19776b39c2e2008-06-25 14:57:53 +0000598 sqlite3_shutdown
danielk19770d84e5b2008-06-27 14:05:24 +0000599 sqlite3_config_heap 0 0
drhe2a7c6e2008-08-01 15:06:30 +0000600 sqlite3_config_lookaside 100 500
danielk19776b39c2e2008-06-25 14:57:53 +0000601 install_malloc_faultsim 1
602 sqlite3_initialize
drhbb77b752009-04-09 01:23:49 +0000603 autoinstall_test_functions
danielk19776b39c2e2008-06-25 14:57:53 +0000604 }
danielk1977c66c0e12008-06-25 14:26:07 +0000605}
606
drh8a42cbd2008-07-10 18:13:42 +0000607ifcapable threadsafe {
dan0626dfc2010-06-15 06:56:37 +0000608 test_suite "no_mutex_try" -description {
drh8a42cbd2008-07-10 18:13:42 +0000609 The sqlite3_mutex_try() interface always fails
dan0626dfc2010-06-15 06:56:37 +0000610 } -files [
611 test_set $::allquicktests -exclude mutex1.test mutex2.test
612 ] -initialize {
drh8a42cbd2008-07-10 18:13:42 +0000613 catch {db close}
614 sqlite3_shutdown
615 install_mutex_counters 1
616 set ::disable_mutex_try 1
drhbb77b752009-04-09 01:23:49 +0000617 sqlite3_initialize
618 autoinstall_test_functions
drh8a42cbd2008-07-10 18:13:42 +0000619 } -shutdown {
620 catch {db close}
621 sqlite3_shutdown
622 install_mutex_counters 0
drhbb77b752009-04-09 01:23:49 +0000623 sqlite3_initialize
624 autoinstall_test_functions
drh8a42cbd2008-07-10 18:13:42 +0000625 }
626}
627
danielk1977b13dee92008-06-23 15:55:52 +0000628# run_tests "crash_safe_append" -description {
629# Run crash.test with persistent journals on a SAFE_APPEND file-system.
630# } -initialize {
631# rename crashsql sa_crashsql
632# proc crashsql {args} {
633# set options [lrange $args 0 [expr {[llength $args]-2}]]
634# lappend options -char safe_append
635# set sql [lindex $args end]
636# lappend options "
637# PRAGMA journal_mode=persistent;
638# $sql
639# "
640# set fd [open test.db-journal w]
641# puts $fd [string repeat 1234567890 100000]
642# close $fd
643# eval sa_crashsql $options
644# }
645# } -shutdown {
646# rename crashsql {}
647# rename sa_crashsql crashsql
dan0626dfc2010-06-15 06:56:37 +0000648# } -files crash.test
danielk1977b13dee92008-06-23 15:55:52 +0000649
dan0626dfc2010-06-15 06:56:37 +0000650test_suite "safe_append" -description {
danielk1977755339e2008-09-12 10:22:40 +0000651 Run some tests on a SAFE_APPEND file-system.
652} -initialize {
653 rename sqlite3 sqlite3_safeappend
654 proc sqlite3 {args} {
655 if {[string range [lindex $args 0] 0 0] ne "-"} {
656 lappend args -vfs devsym
657 }
658 uplevel [concat sqlite3_safeappend $args]
659 }
660 sqlite3_simulate_device -char safe_append
661} -shutdown {
662 rename sqlite3 {}
663 rename sqlite3_shutdown sqlite3
dan0626dfc2010-06-15 06:56:37 +0000664} -files [
665 test_set $::allquicktests shared_err.test -exclude async3.test
666]
danielk1977755339e2008-09-12 10:22:40 +0000667
drhb232c232008-11-19 01:20:26 +0000668# The set of tests to run on the alternative-pcache
669set perm-alt-pcache-testset {
670 async.test
671 attach.test
672 delete.test delete2.test
673 index.test
674 insert.test insert2.test
675 join.test join2.test
676 rollback.test
677 select1.test select2.test
678 trans.test
679 update.test
680}
681
dan2acd4c62010-07-13 14:22:39 +0000682foreach discard_rate {0 10 50 90 100} {
683 test_suite "pcache${discard_rate}" -description "
684 Alternative pcache implementation with ${discard_rate}% random discard
685 " -initialize "
686 catch {db close}
687 sqlite3_shutdown
688 sqlite3_config_alt_pcache 1 $discard_rate 1
689 sqlite3_initialize
690 autoinstall_test_functions
691 " -shutdown {
692 catch {db close}
693 sqlite3_shutdown
694 sqlite3_config_alt_pcache 0 0 0
695 sqlite3_config_lookaside 100 500
696 install_malloc_faultsim 1
697 sqlite3_initialize
698 autoinstall_test_functions
699 } -files ${perm-alt-pcache-testset}
700}
danielk1977b13dee92008-06-23 15:55:52 +0000701
dan0626dfc2010-06-15 06:56:37 +0000702test_suite "journaltest" -description {
danielk1977f3107512008-12-22 10:58:46 +0000703 Check that pages are synced before being written (test_journal.c).
704} -initialize {
danielk1977f3107512008-12-22 10:58:46 +0000705 catch {db close}
706 register_jt_vfs -default ""
707} -shutdown {
708 unregister_jt_vfs
dan0626dfc2010-06-15 06:56:37 +0000709} -files [test_set $::allquicktests -exclude {
710 wal* incrvacuum.test ioerr.test corrupt4.test io.test crash8.test
711 async4.test bigfile.test
drhfb4a6262010-05-06 19:55:57 +0000712}]
danielk1977f3107512008-12-22 10:58:46 +0000713
dan0a7a9152010-04-07 07:57:38 +0000714if {[info commands register_demovfs] != ""} {
dan0626dfc2010-06-15 06:56:37 +0000715 test_suite "demovfs" -description {
dan430e74c2010-06-07 17:47:26 +0000716 Check that the demovfs (code in test_demovfs.c) more or less works.
dan0a7a9152010-04-07 07:57:38 +0000717 } -initialize {
718 register_demovfs
719 } -shutdown {
720 unregister_demovfs
dan0626dfc2010-06-15 06:56:37 +0000721 } -files {
dan0a7a9152010-04-07 07:57:38 +0000722 insert.test insert2.test insert3.test rollback.test
723 select1.test select2.test select3.test
724 }
725}
726
dan0626dfc2010-06-15 06:56:37 +0000727test_suite "wal" -description {
dan71cb5182010-04-26 12:39:03 +0000728 Run tests with journal_mode=WAL
dan31f98fc2010-04-27 05:42:32 +0000729} -initialize {
dan430e74c2010-06-07 17:47:26 +0000730 set ::G(savepoint6_iterations) 100
dan31f98fc2010-04-27 05:42:32 +0000731} -shutdown {
dan430e74c2010-06-07 17:47:26 +0000732 unset -nocomplain ::G(savepoint6_iterations)
dan0626dfc2010-06-15 06:56:37 +0000733} -files {
dane106de62010-04-27 06:49:34 +0000734 savepoint.test savepoint2.test savepoint6.test
735 trans.test avtrans.test
dan60f9da72010-07-07 11:42:59 +0000736
737 fts3aa.test fts3ab.test fts3ac.test fts3ad.test
738 fts3ae.test fts3af.test fts3ag.test fts3ah.test
739 fts3ai.test fts3aj.test fts3ak.test fts3al.test
740 fts3am.test fts3an.test fts3ao.test fts3b.test
741 fts3c.test fts3d.test fts3e.test fts3query.test
dan71cb5182010-04-26 12:39:03 +0000742}
dan897230e2010-08-26 14:15:37 +0000743
744test_suite "rtree" -description {
745 All R-tree related tests. Provides coverage of source file rtree.c.
746} -files [glob -nocomplain $::testdir/../ext/rtree/*.test]
747
danielk19771077e3f2008-06-21 18:07:37 +0000748# End of tests
749#############################################################################
750
dan0626dfc2010-06-15 06:56:37 +0000751# run_tests NAME OPTIONS
752#
753# where available options are:
754#
dan2fce9ab2010-06-15 18:00:06 +0000755# -description TITLE
756# -initialize SCRIPT
757# -shutdown SCRIPT
758# -presql SQL
759# -files LIST-OF-FILES
760# -prefix NAME
dan0626dfc2010-06-15 06:56:37 +0000761#
762proc run_tests {name args} {
763 array set options $args
danielk19771077e3f2008-06-21 18:07:37 +0000764
dand506de02010-07-03 13:59:01 +0000765 set ::G(perm:name) $name
766 set ::G(perm:prefix) $options(-prefix)
dan0626dfc2010-06-15 06:56:37 +0000767 set ::G(perm:presql) $options(-presql)
768 set ::G(isquick) 1
769
770 uplevel $options(-initialize)
771
772 foreach file [lsort $options(-files)] {
dan897230e2010-08-26 14:15:37 +0000773 if {[file tail $file] == $file} { set file [file join $::testdir $file] }
774 slave_test_file $file
dan0626dfc2010-06-15 06:56:37 +0000775 }
776
777 uplevel $options(-shutdown)
778
779 unset ::G(perm:name)
dand506de02010-07-03 13:59:01 +0000780 unset ::G(perm:prefix)
dan0626dfc2010-06-15 06:56:37 +0000781 unset ::G(perm:presql)
782}
783
784proc run_test_suite {name} {
785 if {[info exists ::testspec($name)]==0} {
786 error "No such test suite: $name"
787 }
788 uplevel run_tests $name $::testspec($name)
789}
790
791proc help {} {
dane91a54e2010-06-15 17:44:47 +0000792 puts "Usage: $::argv0 TESTSUITE ?TESTFILE?"
793 puts ""
794 puts "Available test-suites are:"
dan0626dfc2010-06-15 06:56:37 +0000795 foreach k $::testsuitelist {
dane91a54e2010-06-15 17:44:47 +0000796 if {[info exists ::testspec($k)]==0} {
797 puts " ----------------------------------------"
798 puts ""
799 } else {
800 array set o $::testspec($k)
801 puts "Test suite: \"$k\""
802 set d [string trim $o(-description)]
803 set d [regsub {\n *} $d "\n "]
804 puts " $d"
805 puts ""
806 }
dan0626dfc2010-06-15 06:56:37 +0000807 }
808 exit -1
809}
810
811if {[info script] == $argv0} {
812 proc main {argv} {
813 if {[llength $argv]==0} {
814 help
815 } else {
816 set suite [lindex $argv 0]
817 if {[info exists ::testspec($suite)]==0} help
818 set extra ""
819 if {[llength $argv]>1} { set extra [list -files [lrange $argv 1 end]] }
820 eval run_tests $suite $::testspec($suite) $extra
821 }
822 }
823 main $argv
824 finish_test
825}
826