blob: 83ee11e53c8a7017085685c48f2c407b872237ca [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
danfa2a4772010-09-14 10:53:45 +000098 mallocAll.test 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 {
danddf80eb2010-10-25 12:47:43 +0000162 All FTS3 tests except fts3rnd.test.
dana69f7d52010-07-19 11:16:36 +0000163} -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
danddf80eb2010-10-25 12:47:43 +0000168 fts3defer.test fts3defer2.test fts3e.test fts3expr.test fts3expr2.test
169 fts3near.test fts3query.test fts3shared.test fts3snippet.test
170
171 fts3fault.test fts3malloc.test
dana69f7d52010-07-19 11:16:36 +0000172}
173
danea5542d2010-07-06 11:26:15 +0000174
dane91a54e2010-06-15 17:44:47 +0000175lappend ::testsuitelist xxx
dan0626dfc2010-06-15 06:56:37 +0000176#-------------------------------------------------------------------------
177# Define the coverage related test suites:
178#
179# coverage-wal
dan0626dfc2010-06-15 06:56:37 +0000180#
181test_suite "coverage-wal" -description {
182 Coverage tests for file wal.c.
183} -files {
danf43d7fc2010-07-03 10:00:00 +0000184 wal.test wal2.test wal3.test walmode.test
185 walbak.test walhook.test walcrash2.test walcksum.test
danbd0e9072010-07-07 09:48:44 +0000186 walfault.test walbig.test
dan0626dfc2010-06-15 06:56:37 +0000187}
188
dane91a54e2010-06-15 17:44:47 +0000189test_suite "coverage-pager" -description {
190 Coverage tests for file pager.c.
191} -files {
danf43d7fc2010-07-03 10:00:00 +0000192 pager1.test pager2.test pagerfault.test pagerfault2.test
193 walfault.test walbak.test journal2.test tkt-9d68c883.test
dane91a54e2010-06-15 17:44:47 +0000194}
dan0626dfc2010-06-15 06:56:37 +0000195
196
dane91a54e2010-06-15 17:44:47 +0000197lappend ::testsuitelist xxx
dan0626dfc2010-06-15 06:56:37 +0000198#-------------------------------------------------------------------------
199# Define the permutation test suites:
200#
danielk19771077e3f2008-06-21 18:07:37 +0000201
202# Run some tests using pre-allocated page and scratch blocks.
203#
dan0626dfc2010-06-15 06:56:37 +0000204test_suite "memsubsys1" -description {
danielk19771077e3f2008-06-21 18:07:37 +0000205 Tests using pre-allocated page and scratch blocks
dan0626dfc2010-06-15 06:56:37 +0000206} -files [
207 test_set $::allquicktests -exclude ioerr5.test malloc5.test
208] -initialize {
drhd63bd752008-07-30 13:15:46 +0000209 catch {db close}
danielk19771077e3f2008-06-21 18:07:37 +0000210 sqlite3_shutdown
211 sqlite3_config_pagecache 4096 24
212 sqlite3_config_scratch 25000 1
213 sqlite3_initialize
drhbb77b752009-04-09 01:23:49 +0000214 autoinstall_test_functions
danielk19771077e3f2008-06-21 18:07:37 +0000215} -shutdown {
216 catch {db close}
217 sqlite3_shutdown
218 sqlite3_config_pagecache 0 0
219 sqlite3_config_scratch 0 0
220 sqlite3_initialize
drhbb77b752009-04-09 01:23:49 +0000221 autoinstall_test_functions
danielk19771077e3f2008-06-21 18:07:37 +0000222}
223
224# Run some tests using pre-allocated page and scratch blocks. This time
225# the allocations are too small to use in most cases.
226#
danielk197734c61e62008-08-29 12:00:20 +0000227# Both ioerr5.test and malloc5.test are excluded because they test the
228# sqlite3_soft_heap_limit() and sqlite3_release_memory() functionality.
229# This functionality is disabled if a pre-allocated page block is provided.
230#
dan0626dfc2010-06-15 06:56:37 +0000231test_suite "memsubsys2" -description {
danielk19771077e3f2008-06-21 18:07:37 +0000232 Tests using small pre-allocated page and scratch blocks
dan0626dfc2010-06-15 06:56:37 +0000233} -files [
234 test_set $::allquicktests -exclude ioerr5.test malloc5.test
235] -initialize {
drhd63bd752008-07-30 13:15:46 +0000236 catch {db close}
danielk19771077e3f2008-06-21 18:07:37 +0000237 sqlite3_shutdown
238 sqlite3_config_pagecache 512 5
239 sqlite3_config_scratch 1000 1
240 sqlite3_initialize
drhbb77b752009-04-09 01:23:49 +0000241 autoinstall_test_functions
danielk19771077e3f2008-06-21 18:07:37 +0000242} -shutdown {
243 catch {db close}
244 sqlite3_shutdown
245 sqlite3_config_pagecache 0 0
246 sqlite3_config_scratch 0 0
247 sqlite3_initialize
drhbb77b752009-04-09 01:23:49 +0000248 autoinstall_test_functions
danielk19771077e3f2008-06-21 18:07:37 +0000249}
250
drhe2a7c6e2008-08-01 15:06:30 +0000251# Run all tests with the lookaside allocator disabled.
252#
dan0626dfc2010-06-15 06:56:37 +0000253test_suite "nolookaside" -description {
drhe2a7c6e2008-08-01 15:06:30 +0000254 OOM tests with lookaside disabled
drhe2a7c6e2008-08-01 15:06:30 +0000255} -initialize {
256 catch {db close}
257 sqlite3_shutdown
258 sqlite3_config_lookaside 0 0
259 sqlite3_initialize
drhbb77b752009-04-09 01:23:49 +0000260 autoinstall_test_functions
drhe2a7c6e2008-08-01 15:06:30 +0000261} -shutdown {
262 catch {db close}
263 sqlite3_shutdown
264 sqlite3_config_lookaside 100 500
265 sqlite3_initialize
drhbb77b752009-04-09 01:23:49 +0000266 autoinstall_test_functions
dan0626dfc2010-06-15 06:56:37 +0000267} -files $::allquicktests
drhe2a7c6e2008-08-01 15:06:30 +0000268
danielk19771077e3f2008-06-21 18:07:37 +0000269# Run some tests in SQLITE_CONFIG_SINGLETHREAD mode.
270#
dan0626dfc2010-06-15 06:56:37 +0000271test_suite "singlethread" -description {
danielk19771077e3f2008-06-21 18:07:37 +0000272 Tests run in SQLITE_CONFIG_SINGLETHREAD mode
273} -initialize {
drh04df18d2009-01-06 14:50:11 +0000274 catch {db close}
275 sqlite3_shutdown
276 catch {sqlite3_config singlethread}
drhbb77b752009-04-09 01:23:49 +0000277 sqlite3_initialize
278 autoinstall_test_functions
dan0626dfc2010-06-15 06:56:37 +0000279} -files {
danielk19771077e3f2008-06-21 18:07:37 +0000280 delete.test delete2.test insert.test rollback.test select1.test
281 select2.test trans.test update.test vacuum.test types.test
282 types2.test types3.test
283} -shutdown {
drh04df18d2009-01-06 14:50:11 +0000284 catch {db close}
285 sqlite3_shutdown
286 catch {sqlite3_config serialized}
drhbb77b752009-04-09 01:23:49 +0000287 sqlite3_initialize
288 autoinstall_test_functions
danielk19771077e3f2008-06-21 18:07:37 +0000289}
290
dan0626dfc2010-06-15 06:56:37 +0000291test_suite "nomutex" -description {
drh039963a2008-09-03 00:43:15 +0000292 Tests run with the SQLITE_OPEN_MULTITHREADED flag passed to sqlite3_open().
danielk19779a6284c2008-07-10 17:52:49 +0000293} -initialize {
294 rename sqlite3 sqlite3_nomutex
295 proc sqlite3 {args} {
296 if {[string range [lindex $args 0] 0 0] ne "-"} {
drhcc91e7f2008-09-03 01:08:00 +0000297 lappend args -fullmutex 0 -nomutex 1
danielk19779a6284c2008-07-10 17:52:49 +0000298 }
299 uplevel [concat sqlite3_nomutex $args]
300 }
dan0626dfc2010-06-15 06:56:37 +0000301} -files {
danielk19779a6284c2008-07-10 17:52:49 +0000302 delete.test delete2.test insert.test rollback.test select1.test
303 select2.test trans.test update.test vacuum.test types.test
304 types2.test types3.test
305} -shutdown {
306 rename sqlite3 {}
307 rename sqlite3_nomutex sqlite3
308}
309
danielk19771077e3f2008-06-21 18:07:37 +0000310# Run some tests in SQLITE_CONFIG_MULTITHREAD mode.
311#
dan0626dfc2010-06-15 06:56:37 +0000312test_suite "multithread" -description {
danielk19771077e3f2008-06-21 18:07:37 +0000313 Tests run in SQLITE_CONFIG_MULTITHREAD mode
314} -initialize {
drh04df18d2009-01-06 14:50:11 +0000315 catch {db close}
316 sqlite3_shutdown
317 catch {sqlite3_config multithread}
drhbb77b752009-04-09 01:23:49 +0000318 sqlite3_initialize
319 autoinstall_test_functions
dan0626dfc2010-06-15 06:56:37 +0000320} -files {
danielk19771077e3f2008-06-21 18:07:37 +0000321 delete.test delete2.test insert.test rollback.test select1.test
322 select2.test trans.test update.test vacuum.test types.test
323 types2.test types3.test
324} -shutdown {
drh04df18d2009-01-06 14:50:11 +0000325 catch {db close}
326 sqlite3_shutdown
327 catch {sqlite3_config serialized}
drhbb77b752009-04-09 01:23:49 +0000328 sqlite3_initialize
329 autoinstall_test_functions
danielk19771077e3f2008-06-21 18:07:37 +0000330}
331
drh039963a2008-09-03 00:43:15 +0000332# Run some tests in SQLITE_OPEN_FULLMUTEX mode.
333#
dan0626dfc2010-06-15 06:56:37 +0000334test_suite "fullmutex" -description {
drh039963a2008-09-03 00:43:15 +0000335 Tests run in SQLITE_OPEN_FULLMUTEX mode
336} -initialize {
337 rename sqlite3 sqlite3_fullmutex
338 proc sqlite3 {args} {
339 if {[string range [lindex $args 0] 0 0] ne "-"} {
drhcc91e7f2008-09-03 01:08:00 +0000340 lappend args -nomutex 0 -fullmutex 1
drh039963a2008-09-03 00:43:15 +0000341 }
342 uplevel [concat sqlite3_fullmutex $args]
343 }
dan0626dfc2010-06-15 06:56:37 +0000344} -files {
drh039963a2008-09-03 00:43:15 +0000345 delete.test delete2.test insert.test rollback.test select1.test
346 select2.test trans.test update.test vacuum.test types.test
347 types2.test types3.test
348} -shutdown {
349 rename sqlite3 {}
350 rename sqlite3_fullmutex sqlite3
351}
352
danielk19771077e3f2008-06-21 18:07:37 +0000353# Run some tests using the "onefile" demo.
354#
dan0626dfc2010-06-15 06:56:37 +0000355test_suite "onefile" -description {
danielk19771077e3f2008-06-21 18:07:37 +0000356 Run some tests using the "test_onefile.c" demo
357} -initialize {
358 rename sqlite3 sqlite3_onefile
359 proc sqlite3 {args} {
360 if {[string range [lindex $args 0] 0 0] ne "-"} {
361 lappend args -vfs fs
362 }
363 uplevel [concat sqlite3_onefile $args]
364 }
dan0626dfc2010-06-15 06:56:37 +0000365} -files {
danielk19771077e3f2008-06-21 18:07:37 +0000366 conflict.test insert.test insert2.test insert3.test
367 rollback.test select1.test select2.test select3.test
danielk19771077e3f2008-06-21 18:07:37 +0000368} -shutdown {
369 rename sqlite3 {}
370 rename sqlite3_onefile sqlite3
371}
372
373# Run some tests using UTF-16 databases.
374#
dan0626dfc2010-06-15 06:56:37 +0000375test_suite "utf16" -description {
danielk19771077e3f2008-06-21 18:07:37 +0000376 Run tests using UTF-16 databases
danielk19772dd6d802008-06-21 19:10:27 +0000377} -presql {
danielk19771077e3f2008-06-21 18:07:37 +0000378 pragma encoding = 'UTF-16'
dan0626dfc2010-06-15 06:56:37 +0000379} -files {
danielk19771077e3f2008-06-21 18:07:37 +0000380 alter.test alter3.test
381 auth.test bind.test blob.test capi2.test capi3.test collate1.test
382 collate2.test collate3.test collate4.test collate5.test collate6.test
383 conflict.test date.test delete.test expr.test fkey1.test func.test
384 hook.test index.test insert2.test insert.test interrupt.test in.test
385 intpkey.test ioerr.test join2.test join.test lastinsert.test
386 laststmtchanges.test limit.test lock2.test lock.test main.test
387 memdb.test minmax.test misc1.test misc2.test misc3.test notnull.test
388 null.test progress.test quote.test rowid.test select1.test select2.test
389 select3.test select4.test select5.test select6.test sort.test
390 subselect.test tableapi.test table.test temptable.test
391 trace.test trigger1.test trigger2.test trigger3.test
392 trigger4.test types2.test types.test unique.test update.test
393 vacuum.test view.test where.test
394}
395
396# Run some tests in exclusive locking mode.
397#
dan0626dfc2010-06-15 06:56:37 +0000398test_suite "exclusive" -description {
danielk19771077e3f2008-06-21 18:07:37 +0000399 Run tests in exclusive locking mode.
400} -presql {
401 pragma locking_mode = 'exclusive'
dan0626dfc2010-06-15 06:56:37 +0000402} -files {
danielk19771077e3f2008-06-21 18:07:37 +0000403 rollback.test select1.test select2.test
404 malloc.test ioerr.test
405}
406
drh04335882008-09-26 21:08:08 +0000407# Run some tests in exclusive locking mode with truncated journals.
408#
dan0626dfc2010-06-15 06:56:37 +0000409test_suite "exclusive-truncate" -description {
drh04335882008-09-26 21:08:08 +0000410 Run tests in exclusive locking mode and truncate journal mode.
411} -presql {
412 pragma locking_mode = 'exclusive';
413 pragma journal_mode = TRUNCATE;
dan0626dfc2010-06-15 06:56:37 +0000414} -files {
drh04335882008-09-26 21:08:08 +0000415 delete.test delete2.test insert.test rollback.test select1.test
416 select2.test update.test malloc.test ioerr.test
417}
418
danielk19771077e3f2008-06-21 18:07:37 +0000419# Run some tests in persistent journal mode.
420#
dan0626dfc2010-06-15 06:56:37 +0000421test_suite "persistent_journal" -description {
danielk19771077e3f2008-06-21 18:07:37 +0000422 Run tests in persistent-journal mode.
423} -presql {
424 pragma journal_mode = persist
dan0626dfc2010-06-15 06:56:37 +0000425} -files {
danielk19771077e3f2008-06-21 18:07:37 +0000426 delete.test delete2.test insert.test rollback.test select1.test
427 select2.test trans.test update.test vacuum.test
428}
429
drh04335882008-09-26 21:08:08 +0000430# Run some tests in truncating journal mode.
431#
dan0626dfc2010-06-15 06:56:37 +0000432test_suite "truncate_journal" -description {
drh04335882008-09-26 21:08:08 +0000433 Run tests in persistent-journal mode.
434} -presql {
435 pragma journal_mode = truncate
dan0626dfc2010-06-15 06:56:37 +0000436} -files {
drh04335882008-09-26 21:08:08 +0000437 delete.test delete2.test insert.test rollback.test select1.test
438 select2.test trans.test update.test vacuum.test
439 malloc.test ioerr.test
440}
441
danielk19771077e3f2008-06-21 18:07:37 +0000442# Run some error tests in persistent journal mode.
443#
dan0626dfc2010-06-15 06:56:37 +0000444test_suite "persistent_journal_error" -description {
danielk19771077e3f2008-06-21 18:07:37 +0000445 Run malloc.test and ioerr.test in persistent-journal mode.
446} -presql {
447 pragma journal_mode = persist
dan0626dfc2010-06-15 06:56:37 +0000448} -files {
danielk19771077e3f2008-06-21 18:07:37 +0000449 malloc.test ioerr.test
450}
451
452# Run some tests in no journal mode.
453#
dan0626dfc2010-06-15 06:56:37 +0000454test_suite "no_journal" -description {
danielk19771077e3f2008-06-21 18:07:37 +0000455 Run tests in no-journal mode.
456} -presql {
457 pragma journal_mode = persist
dan0626dfc2010-06-15 06:56:37 +0000458} -files {
danielk19771077e3f2008-06-21 18:07:37 +0000459 delete.test delete2.test insert.test rollback.test select1.test
460 select2.test trans.test update.test vacuum.test
461}
462
463# Run some error tests in no journal mode.
464#
dan0626dfc2010-06-15 06:56:37 +0000465test_suite "no_journal_error" -description {
danielk19771077e3f2008-06-21 18:07:37 +0000466 Run malloc.test and ioerr.test in no-journal mode.
467} -presql {
468 pragma journal_mode = persist
dan0626dfc2010-06-15 06:56:37 +0000469} -files {
danielk19771077e3f2008-06-21 18:07:37 +0000470 malloc.test ioerr.test
471}
472
473# Run some crash-tests in autovacuum mode.
474#
dan0626dfc2010-06-15 06:56:37 +0000475test_suite "autovacuum_crash" -description {
danielk19771077e3f2008-06-21 18:07:37 +0000476 Run crash.test in autovacuum mode.
477} -presql {
478 pragma auto_vacuum = 1
dan0626dfc2010-06-15 06:56:37 +0000479} -files crash.test
danielk19771077e3f2008-06-21 18:07:37 +0000480
481# Run some ioerr-tests in autovacuum mode.
482#
dan0626dfc2010-06-15 06:56:37 +0000483test_suite "autovacuum_ioerr" -description {
danielk19771077e3f2008-06-21 18:07:37 +0000484 Run ioerr.test in autovacuum mode.
485} -presql {
486 pragma auto_vacuum = 1
dan0626dfc2010-06-15 06:56:37 +0000487} -files ioerr.test
danielk19771077e3f2008-06-21 18:07:37 +0000488
danielk1977b3175382008-10-17 18:51:52 +0000489# Run tests with an in-memory journal.
490#
dan0626dfc2010-06-15 06:56:37 +0000491test_suite "inmemory_journal" -description {
danielk1977b3175382008-10-17 18:51:52 +0000492 Run tests with an in-memory journal file.
493} -presql {
494 pragma journal_mode = 'memory'
dan0626dfc2010-06-15 06:56:37 +0000495} -files [test_set $::allquicktests -exclude {
danielk1977b3175382008-10-17 18:51:52 +0000496 # Exclude all tests that simulate IO errors.
497 autovacuum_ioerr2.test incrvacuum_ioerr.test ioerr.test
498 ioerr.test ioerr2.test ioerr3.test ioerr4.test ioerr5.test
drh2206a2b2009-04-01 23:09:43 +0000499 vacuum3.test incrblob_err.test diskfull.test backup_ioerr.test
shanehc3b84832010-07-09 19:32:28 +0000500 e_fts3.test fts3cov.test fts3malloc.test fts3rnd.test
501 fts3snippet.test
danielk1977b3175382008-10-17 18:51:52 +0000502
503 # Exclude test scripts that use tcl IO to access journal files or count
504 # the number of fsync() calls.
505 pager.test exclusive.test jrnlmode.test sync.test misc1.test
danielk1977cb257902009-04-10 18:32:29 +0000506 journal1.test conflict.test crash8.test tkt3457.test io.test
dan37575562010-07-17 09:27:31 +0000507 journal3.test
dan01d38562010-03-08 10:32:38 +0000508
dancb354602010-07-08 09:44:42 +0000509 pager1.test async4.test corrupt.test filefmt.test pager2.test
510 corrupt5.test corruptA.test pageropt.test
511
dan01d38562010-03-08 10:32:38 +0000512 # Exclude stmt.test, which expects sub-journals to use temporary files.
513 stmt.test
drh0b944132010-05-24 20:24:38 +0000514
515 # WAL mode is different.
dan0626dfc2010-06-15 06:56:37 +0000516 wal*
517}]
danielk1977b3175382008-10-17 18:51:52 +0000518
danielk19776b39c2e2008-06-25 14:57:53 +0000519ifcapable mem3 {
dan0626dfc2010-06-15 06:56:37 +0000520 test_suite "memsys3" -description {
danielk19776b39c2e2008-06-25 14:57:53 +0000521 Run tests using the allocator in mem3.c.
daneace5272010-07-05 05:31:48 +0000522 } -files [test_set $::allquicktests -exclude {
drh8a42cbd2008-07-10 18:13:42 +0000523 autovacuum.test delete3.test manydb.test
524 bigrow.test incrblob2.test memdb.test
525 bitvec.test index2.test memsubsys1.test
526 capi3c.test ioerr.test memsubsys2.test
527 capi3.test join3.test pagesize.test
danielk19778b322822009-07-01 18:09:01 +0000528 collate5.test limit.test backup_ioerr.test
529 backup_malloc.test
dan0626dfc2010-06-15 06:56:37 +0000530 }] -initialize {
danielk19776b39c2e2008-06-25 14:57:53 +0000531 catch {db close}
532 sqlite3_reset_auto_extension
533 sqlite3_shutdown
drh7830cd42008-07-16 12:25:32 +0000534 sqlite3_config_heap 25000000 0
drhe2a7c6e2008-08-01 15:06:30 +0000535 sqlite3_config_lookaside 0 0
danielk19778b322822009-07-01 18:09:01 +0000536 ifcapable mem5 {
537 # If both memsys3 and memsys5 are enabled in the build, the call to
538 # [sqlite3_config_heap] will initialize the system to use memsys5.
539 # The following overrides this preference and installs the memsys3
540 # allocator.
541 sqlite3_install_memsys3
542 }
danielk19776b39c2e2008-06-25 14:57:53 +0000543 install_malloc_faultsim 1
544 sqlite3_initialize
545 autoinstall_test_functions
546 } -shutdown {
547 catch {db close}
danielk19776b39c2e2008-06-25 14:57:53 +0000548 sqlite3_shutdown
danielk19770d84e5b2008-06-27 14:05:24 +0000549 sqlite3_config_heap 0 0
drhe2a7c6e2008-08-01 15:06:30 +0000550 sqlite3_config_lookaside 100 500
danielk19776b39c2e2008-06-25 14:57:53 +0000551 install_malloc_faultsim 1
552 sqlite3_initialize
drhbb77b752009-04-09 01:23:49 +0000553 autoinstall_test_functions
danielk19776b39c2e2008-06-25 14:57:53 +0000554 }
danielk197757e5ea92008-06-24 19:02:55 +0000555}
556
danielk19776b39c2e2008-06-25 14:57:53 +0000557ifcapable mem5 {
dan0626dfc2010-06-15 06:56:37 +0000558 test_suite "memsys5" -description {
danielk19776b39c2e2008-06-25 14:57:53 +0000559 Run tests using the allocator in mem5.c.
daneace5272010-07-05 05:31:48 +0000560 } -files [test_set $::allquicktests -exclude {
drh8a42cbd2008-07-10 18:13:42 +0000561 autovacuum.test delete3.test manydb.test
562 bigrow.test incrblob2.test memdb.test
563 bitvec.test index2.test memsubsys1.test
564 capi3c.test ioerr.test memsubsys2.test
565 capi3.test join3.test pagesize.test
danielk1977ac8d7b32008-11-13 16:21:50 +0000566 collate5.test limit.test zeroblob.test
dan0626dfc2010-06-15 06:56:37 +0000567 }] -initialize {
danielk19776b39c2e2008-06-25 14:57:53 +0000568 catch {db close}
danielk19776b39c2e2008-06-25 14:57:53 +0000569 sqlite3_shutdown
drh7830cd42008-07-16 12:25:32 +0000570 sqlite3_config_heap 25000000 64
drhe2a7c6e2008-08-01 15:06:30 +0000571 sqlite3_config_lookaside 0 0
danielk19775099be52008-06-27 13:27:03 +0000572 install_malloc_faultsim 1
573 sqlite3_initialize
574 autoinstall_test_functions
575 } -shutdown {
576 catch {db close}
danielk19775099be52008-06-27 13:27:03 +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
danielk19775099be52008-06-27 13:27:03 +0000580 install_malloc_faultsim 1
581 sqlite3_initialize
drhbb77b752009-04-09 01:23:49 +0000582 autoinstall_test_functions
danielk19775099be52008-06-27 13:27:03 +0000583 }
584
dan0626dfc2010-06-15 06:56:37 +0000585 test_suite "memsys5-2" -description {
danielk19775099be52008-06-27 13:27:03 +0000586 Run tests using the allocator in mem5.c in a different configuration.
dan0626dfc2010-06-15 06:56:37 +0000587 } -files {
drh8a42cbd2008-07-10 18:13:42 +0000588 select1.test
danielk19775099be52008-06-27 13:27:03 +0000589 } -initialize {
590 catch {db close}
danielk19775099be52008-06-27 13:27:03 +0000591 sqlite3_shutdown
danb0c6a882010-09-02 10:08:41 +0000592 sqlite3_config_memstatus 0
drh7830cd42008-07-16 12:25:32 +0000593 sqlite3_config_heap 40000000 16
drhe2a7c6e2008-08-01 15:06:30 +0000594 sqlite3_config_lookaside 0 0
danielk19776b39c2e2008-06-25 14:57:53 +0000595 install_malloc_faultsim 1
596 sqlite3_initialize
597 autoinstall_test_functions
598 } -shutdown {
599 catch {db close}
danielk19776b39c2e2008-06-25 14:57:53 +0000600 sqlite3_shutdown
danielk19770d84e5b2008-06-27 14:05:24 +0000601 sqlite3_config_heap 0 0
drhe2a7c6e2008-08-01 15:06:30 +0000602 sqlite3_config_lookaside 100 500
danielk19776b39c2e2008-06-25 14:57:53 +0000603 install_malloc_faultsim 1
604 sqlite3_initialize
drhbb77b752009-04-09 01:23:49 +0000605 autoinstall_test_functions
danielk19776b39c2e2008-06-25 14:57:53 +0000606 }
danielk1977c66c0e12008-06-25 14:26:07 +0000607}
608
drh8a42cbd2008-07-10 18:13:42 +0000609ifcapable threadsafe {
dan0626dfc2010-06-15 06:56:37 +0000610 test_suite "no_mutex_try" -description {
drh8a42cbd2008-07-10 18:13:42 +0000611 The sqlite3_mutex_try() interface always fails
dan0626dfc2010-06-15 06:56:37 +0000612 } -files [
613 test_set $::allquicktests -exclude mutex1.test mutex2.test
614 ] -initialize {
drh8a42cbd2008-07-10 18:13:42 +0000615 catch {db close}
616 sqlite3_shutdown
617 install_mutex_counters 1
618 set ::disable_mutex_try 1
drhbb77b752009-04-09 01:23:49 +0000619 sqlite3_initialize
620 autoinstall_test_functions
drh8a42cbd2008-07-10 18:13:42 +0000621 } -shutdown {
622 catch {db close}
623 sqlite3_shutdown
624 install_mutex_counters 0
drhbb77b752009-04-09 01:23:49 +0000625 sqlite3_initialize
626 autoinstall_test_functions
drh8a42cbd2008-07-10 18:13:42 +0000627 }
628}
629
danielk1977b13dee92008-06-23 15:55:52 +0000630# run_tests "crash_safe_append" -description {
631# Run crash.test with persistent journals on a SAFE_APPEND file-system.
632# } -initialize {
633# rename crashsql sa_crashsql
634# proc crashsql {args} {
635# set options [lrange $args 0 [expr {[llength $args]-2}]]
636# lappend options -char safe_append
637# set sql [lindex $args end]
638# lappend options "
639# PRAGMA journal_mode=persistent;
640# $sql
641# "
642# set fd [open test.db-journal w]
643# puts $fd [string repeat 1234567890 100000]
644# close $fd
645# eval sa_crashsql $options
646# }
647# } -shutdown {
648# rename crashsql {}
649# rename sa_crashsql crashsql
dan0626dfc2010-06-15 06:56:37 +0000650# } -files crash.test
danielk1977b13dee92008-06-23 15:55:52 +0000651
dan0626dfc2010-06-15 06:56:37 +0000652test_suite "safe_append" -description {
danielk1977755339e2008-09-12 10:22:40 +0000653 Run some tests on a SAFE_APPEND file-system.
654} -initialize {
655 rename sqlite3 sqlite3_safeappend
656 proc sqlite3 {args} {
657 if {[string range [lindex $args 0] 0 0] ne "-"} {
658 lappend args -vfs devsym
659 }
660 uplevel [concat sqlite3_safeappend $args]
661 }
662 sqlite3_simulate_device -char safe_append
663} -shutdown {
664 rename sqlite3 {}
665 rename sqlite3_shutdown sqlite3
dan0626dfc2010-06-15 06:56:37 +0000666} -files [
667 test_set $::allquicktests shared_err.test -exclude async3.test
668]
danielk1977755339e2008-09-12 10:22:40 +0000669
drhb232c232008-11-19 01:20:26 +0000670# The set of tests to run on the alternative-pcache
671set perm-alt-pcache-testset {
672 async.test
673 attach.test
674 delete.test delete2.test
675 index.test
676 insert.test insert2.test
677 join.test join2.test
678 rollback.test
679 select1.test select2.test
680 trans.test
681 update.test
682}
683
dan2acd4c62010-07-13 14:22:39 +0000684foreach discard_rate {0 10 50 90 100} {
685 test_suite "pcache${discard_rate}" -description "
686 Alternative pcache implementation with ${discard_rate}% random discard
687 " -initialize "
688 catch {db close}
689 sqlite3_shutdown
690 sqlite3_config_alt_pcache 1 $discard_rate 1
691 sqlite3_initialize
692 autoinstall_test_functions
693 " -shutdown {
694 catch {db close}
695 sqlite3_shutdown
696 sqlite3_config_alt_pcache 0 0 0
697 sqlite3_config_lookaside 100 500
698 install_malloc_faultsim 1
699 sqlite3_initialize
700 autoinstall_test_functions
701 } -files ${perm-alt-pcache-testset}
702}
danielk1977b13dee92008-06-23 15:55:52 +0000703
dan0626dfc2010-06-15 06:56:37 +0000704test_suite "journaltest" -description {
danielk1977f3107512008-12-22 10:58:46 +0000705 Check that pages are synced before being written (test_journal.c).
706} -initialize {
danielk1977f3107512008-12-22 10:58:46 +0000707 catch {db close}
708 register_jt_vfs -default ""
709} -shutdown {
710 unregister_jt_vfs
dan0626dfc2010-06-15 06:56:37 +0000711} -files [test_set $::allquicktests -exclude {
712 wal* incrvacuum.test ioerr.test corrupt4.test io.test crash8.test
713 async4.test bigfile.test
drhfb4a6262010-05-06 19:55:57 +0000714}]
danielk1977f3107512008-12-22 10:58:46 +0000715
dan0a7a9152010-04-07 07:57:38 +0000716if {[info commands register_demovfs] != ""} {
dan0626dfc2010-06-15 06:56:37 +0000717 test_suite "demovfs" -description {
dan430e74c2010-06-07 17:47:26 +0000718 Check that the demovfs (code in test_demovfs.c) more or less works.
dan0a7a9152010-04-07 07:57:38 +0000719 } -initialize {
720 register_demovfs
721 } -shutdown {
722 unregister_demovfs
dan0626dfc2010-06-15 06:56:37 +0000723 } -files {
dan0a7a9152010-04-07 07:57:38 +0000724 insert.test insert2.test insert3.test rollback.test
725 select1.test select2.test select3.test
726 }
727}
728
dan0626dfc2010-06-15 06:56:37 +0000729test_suite "wal" -description {
dan71cb5182010-04-26 12:39:03 +0000730 Run tests with journal_mode=WAL
dan31f98fc2010-04-27 05:42:32 +0000731} -initialize {
dan430e74c2010-06-07 17:47:26 +0000732 set ::G(savepoint6_iterations) 100
dan31f98fc2010-04-27 05:42:32 +0000733} -shutdown {
dan430e74c2010-06-07 17:47:26 +0000734 unset -nocomplain ::G(savepoint6_iterations)
dan0626dfc2010-06-15 06:56:37 +0000735} -files {
dane106de62010-04-27 06:49:34 +0000736 savepoint.test savepoint2.test savepoint6.test
737 trans.test avtrans.test
dan60f9da72010-07-07 11:42:59 +0000738
739 fts3aa.test fts3ab.test fts3ac.test fts3ad.test
740 fts3ae.test fts3af.test fts3ag.test fts3ah.test
741 fts3ai.test fts3aj.test fts3ak.test fts3al.test
742 fts3am.test fts3an.test fts3ao.test fts3b.test
743 fts3c.test fts3d.test fts3e.test fts3query.test
dan71cb5182010-04-26 12:39:03 +0000744}
dan897230e2010-08-26 14:15:37 +0000745
746test_suite "rtree" -description {
747 All R-tree related tests. Provides coverage of source file rtree.c.
748} -files [glob -nocomplain $::testdir/../ext/rtree/*.test]
749
danielk19771077e3f2008-06-21 18:07:37 +0000750# End of tests
751#############################################################################
752
dan0626dfc2010-06-15 06:56:37 +0000753# run_tests NAME OPTIONS
754#
755# where available options are:
756#
dan2fce9ab2010-06-15 18:00:06 +0000757# -description TITLE
758# -initialize SCRIPT
759# -shutdown SCRIPT
760# -presql SQL
761# -files LIST-OF-FILES
762# -prefix NAME
dan0626dfc2010-06-15 06:56:37 +0000763#
764proc run_tests {name args} {
765 array set options $args
danielk19771077e3f2008-06-21 18:07:37 +0000766
dand506de02010-07-03 13:59:01 +0000767 set ::G(perm:name) $name
768 set ::G(perm:prefix) $options(-prefix)
dan0626dfc2010-06-15 06:56:37 +0000769 set ::G(perm:presql) $options(-presql)
770 set ::G(isquick) 1
771
772 uplevel $options(-initialize)
773
774 foreach file [lsort $options(-files)] {
dan897230e2010-08-26 14:15:37 +0000775 if {[file tail $file] == $file} { set file [file join $::testdir $file] }
776 slave_test_file $file
dan0626dfc2010-06-15 06:56:37 +0000777 }
778
779 uplevel $options(-shutdown)
780
781 unset ::G(perm:name)
dand506de02010-07-03 13:59:01 +0000782 unset ::G(perm:prefix)
dan0626dfc2010-06-15 06:56:37 +0000783 unset ::G(perm:presql)
784}
785
786proc run_test_suite {name} {
787 if {[info exists ::testspec($name)]==0} {
788 error "No such test suite: $name"
789 }
790 uplevel run_tests $name $::testspec($name)
791}
792
793proc help {} {
dane91a54e2010-06-15 17:44:47 +0000794 puts "Usage: $::argv0 TESTSUITE ?TESTFILE?"
795 puts ""
796 puts "Available test-suites are:"
dan0626dfc2010-06-15 06:56:37 +0000797 foreach k $::testsuitelist {
dane91a54e2010-06-15 17:44:47 +0000798 if {[info exists ::testspec($k)]==0} {
799 puts " ----------------------------------------"
800 puts ""
801 } else {
802 array set o $::testspec($k)
803 puts "Test suite: \"$k\""
804 set d [string trim $o(-description)]
805 set d [regsub {\n *} $d "\n "]
806 puts " $d"
807 puts ""
808 }
dan0626dfc2010-06-15 06:56:37 +0000809 }
810 exit -1
811}
812
813if {[info script] == $argv0} {
814 proc main {argv} {
815 if {[llength $argv]==0} {
816 help
817 } else {
818 set suite [lindex $argv 0]
819 if {[info exists ::testspec($suite)]==0} help
820 set extra ""
821 if {[llength $argv]>1} { set extra [list -files [lrange $argv 1 end]] }
822 eval run_tests $suite $::testspec($suite) $extra
823 }
824 }
825 main $argv
826 finish_test
827}
828