blob: f1fb74fe614a0d232bcfe6659c1593991253833e [file] [log] [blame]
danielk19771077e3f2008-06-21 18:07:37 +00001# 2008 June 21
2#
3# The author disclaims copyright to this source code. In place of
4# a legal notice, here is a blessing:
5#
6# May you do good and not evil.
7# May you find forgiveness for yourself and forgive others.
8# May you share freely, never taking more than you give.
9#
10#***********************************************************************
11#
danielk19771077e3f2008-06-21 18:07:37 +000012
13set testdir [file dirname $argv0]
14source $testdir/tester.tcl
dan13a3cb82010-06-11 19:04:21 +000015db close
danielk19771077e3f2008-06-21 18:07:37 +000016
dan0626dfc2010-06-15 06:56:37 +000017#-------------------------------------------------------------------------
18# test_suite NAME OPTIONS
danielk19771077e3f2008-06-21 18:07:37 +000019#
20# where available options are:
21#
dan430e74c2010-06-07 17:47:26 +000022# -description TITLE (default "")
danielk19771077e3f2008-06-21 18:07:37 +000023# -initialize SCRIPT (default "")
24# -shutdown SCRIPT (default "")
danielk19771077e3f2008-06-21 18:07:37 +000025# -presql SQL (default "")
dan0626dfc2010-06-15 06:56:37 +000026# -files LIST-OF-FILES (default $::ALLTESTS)
dan2fce9ab2010-06-15 18:00:06 +000027# -prefix NAME (default "$::NAME.")
dan0626dfc2010-06-15 06:56:37 +000028#
29proc test_suite {name args} {
dan430e74c2010-06-07 17:47:26 +000030
dan0626dfc2010-06-15 06:56:37 +000031 set default(-shutdown) ""
32 set default(-initialize) ""
33 set default(-presql) ""
dan430e74c2010-06-07 17:47:26 +000034 set default(-description) "no description supplied (fixme)"
dan2fce9ab2010-06-15 18:00:06 +000035 set default(-files) ""
36 set default(-prefix) "${name}."
dan430e74c2010-06-07 17:47:26 +000037
38 array set options [array get default]
dan0626dfc2010-06-15 06:56:37 +000039 if {[llength $args]%2} {
40 error "uneven number of options/switches passed to test_suite"
dan430e74c2010-06-07 17:47:26 +000041 }
dan0626dfc2010-06-15 06:56:37 +000042 foreach {k v} $args {
43 set o [array names options ${k}*]
44 if {[llength $o]>1} { error "ambiguous option: $k" }
45 if {[llength $o]==0} { error "unknown option: $k" }
46 set options([lindex $o 0]) $v
drh0a846f92008-08-25 17:23:29 +000047 }
danielk19771077e3f2008-06-21 18:07:37 +000048
dan0626dfc2010-06-15 06:56:37 +000049 set ::testspec($name) [array get options]
50 lappend ::testsuitelist $name
dane91a54e2010-06-15 17:44:47 +000051
dan0626dfc2010-06-15 06:56:37 +000052}
dan430e74c2010-06-07 17:47:26 +000053
dan0626dfc2010-06-15 06:56:37 +000054#-------------------------------------------------------------------------
55# test_set ARGS...
56#
57proc test_set {args} {
58 set isExclude 0
59 foreach a $args {
60 if {[string match -* $a]} {
61 switch -- $a {
62 -include { set isExclude 0 }
63 -exclude { set isExclude 1 }
64 default {
65 error "Unknown switch: $a"
66 }
danielk1977c1def3e2008-08-30 13:25:10 +000067 }
dan0626dfc2010-06-15 06:56:37 +000068 } elseif {$isExclude == 0} {
69 foreach f $a { set t($f) 1 }
drh0a846f92008-08-25 17:23:29 +000070 } else {
dan0626dfc2010-06-15 06:56:37 +000071 foreach f $a { array unset t $f }
danielk19771077e3f2008-06-21 18:07:37 +000072 }
73 }
74
dan0626dfc2010-06-15 06:56:37 +000075 return [array names t]
danielk19771077e3f2008-06-21 18:07:37 +000076}
77
dan0626dfc2010-06-15 06:56:37 +000078#-------------------------------------------------------------------------
79# Set up the following global list variables containing the names of
80# various test scripts:
81#
82# $alltests
dan2fce9ab2010-06-15 18:00:06 +000083# $allquicktests
dan0626dfc2010-06-15 06:56:37 +000084#
dan0626dfc2010-06-15 06:56:37 +000085set alltests [list]
86foreach f [glob $testdir/*.test] { lappend alltests [file tail $f] }
87if {$::tcl_platform(platform)!="unix"} {
88 set alltests [test_set $alltests -exclude crash.test crash2.test]
danielk1977c1def3e2008-08-30 13:25:10 +000089}
dan0626dfc2010-06-15 06:56:37 +000090set alltests [test_set $alltests -exclude {
91 all.test async.test quick.test veryquick.test
92 memleak.test permutations.test soak.test fts3.test
93 mallocAll.test
94}]
95
96set allquicktests [test_set $alltests -exclude {
97 async2.test async3.test backup_ioerr.test corrupt.test
98 corruptC.test crash.test crash2.test crash3.test crash4.test crash5.test
99 crash6.test crash7.test delete3.test e_fts3.test fts3rnd.test
100 fkey_malloc.test fuzz.test fuzz3.test fuzz_malloc.test in2.test loadext.test
dan273f3f02010-06-26 15:42:33 +0000101 misc7.test mutex2.test notify2.test onefile.test pagerfault2.test
dan0626dfc2010-06-15 06:56:37 +0000102 savepoint4.test savepoint6.test select9.test
103 speed1.test speed1p.test speed2.test speed3.test speed4.test
104 speed4p.test sqllimits1.test tkt2686.test thread001.test thread002.test
105 thread003.test thread004.test thread005.test trans2.test vacuum3.test
106 incrvacuum_ioerr.test autovacuum_crash.test btree8.test shared_err.test
107 vtab_err.test walslow.test walcrash.test
dan273f3f02010-06-26 15:42:33 +0000108 walthread.test
dan0626dfc2010-06-15 06:56:37 +0000109}]
dan63109902010-07-05 05:54:55 +0000110if {[info exists ::env(QUICKTEST_INCLUDE)]} {
111 set allquicktests [concat $allquicktests $::env(QUICKTEST_INCLUDE)]
112}
danielk1977c1def3e2008-08-30 13:25:10 +0000113
danielk19771077e3f2008-06-21 18:07:37 +0000114#############################################################################
115# Start of tests
dan0626dfc2010-06-15 06:56:37 +0000116#
117
118#-------------------------------------------------------------------------
119# Define the generic test suites:
120#
121# veryquick
122# quick
123# full
dan0626dfc2010-06-15 06:56:37 +0000124#
dane91a54e2010-06-15 17:44:47 +0000125lappend ::testsuitelist xxx
dan0626dfc2010-06-15 06:56:37 +0000126
dan2fce9ab2010-06-15 18:00:06 +0000127test_suite "veryquick" -prefix "" -description {
dan0626dfc2010-06-15 06:56:37 +0000128 "Very" quick test suite. Runs in less than 5 minutes on a workstation.
129 This test suite is the same as the "quick" tests, except that some files
130 that test malloc and IO errors are omitted.
131} -files [
dan68928b62010-06-22 13:46:43 +0000132 test_set $allquicktests -exclude *malloc* *ioerr* *fault*
dan0626dfc2010-06-15 06:56:37 +0000133]
134
dan2fce9ab2010-06-15 18:00:06 +0000135test_suite "quick" -prefix "" -description {
dan0626dfc2010-06-15 06:56:37 +0000136 Quick test suite. Runs in around 10 minutes on a workstation.
137} -files [
138 test_set $allquicktests
139]
140
dan2fce9ab2010-06-15 18:00:06 +0000141test_suite "full" -prefix "" -description {
dan0626dfc2010-06-15 06:56:37 +0000142 Full test suite. Takes a long time.
143} -files [
144 test_set $alltests
145] -initialize {
146 unset -nocomplain ::G(isquick)
147}
148
danea5542d2010-07-06 11:26:15 +0000149test_suite "threads" -prefix "" -description {
150 All multi-threaded tests.
151} -files {
152 notify2.test thread001.test thread002.test thread003.test
153 thread004.test thread005.test walthread.test
154}
155
dana69f7d52010-07-19 11:16:36 +0000156test_suite "fts3" -prefix "" -description {
157 All FTS3 tests except fts3malloc.test and fts3rnd.test.
158} -files {
159 fts3aa.test fts3ab.test fts3ac.test fts3ad.test fts3ae.test
160 fts3af.test fts3ag.test fts3ah.test fts3ai.test fts3aj.test
161 fts3ak.test fts3al.test fts3am.test fts3an.test fts3ao.test
162 fts3atoken.test fts3b.test fts3c.test fts3cov.test fts3d.test
163 fts3e.test fts3expr.test fts3expr2.test fts3near.test
164 fts3query.test fts3snippet.test
165}
166
danea5542d2010-07-06 11:26:15 +0000167
dane91a54e2010-06-15 17:44:47 +0000168lappend ::testsuitelist xxx
dan0626dfc2010-06-15 06:56:37 +0000169#-------------------------------------------------------------------------
170# Define the coverage related test suites:
171#
172# coverage-wal
dan0626dfc2010-06-15 06:56:37 +0000173#
174test_suite "coverage-wal" -description {
175 Coverage tests for file wal.c.
176} -files {
danf43d7fc2010-07-03 10:00:00 +0000177 wal.test wal2.test wal3.test walmode.test
178 walbak.test walhook.test walcrash2.test walcksum.test
danbd0e9072010-07-07 09:48:44 +0000179 walfault.test walbig.test
dan0626dfc2010-06-15 06:56:37 +0000180}
181
dane91a54e2010-06-15 17:44:47 +0000182test_suite "coverage-pager" -description {
183 Coverage tests for file pager.c.
184} -files {
danf43d7fc2010-07-03 10:00:00 +0000185 pager1.test pager2.test pagerfault.test pagerfault2.test
186 walfault.test walbak.test journal2.test tkt-9d68c883.test
dane91a54e2010-06-15 17:44:47 +0000187}
dan0626dfc2010-06-15 06:56:37 +0000188
189
dane91a54e2010-06-15 17:44:47 +0000190lappend ::testsuitelist xxx
dan0626dfc2010-06-15 06:56:37 +0000191#-------------------------------------------------------------------------
192# Define the permutation test suites:
193#
danielk19771077e3f2008-06-21 18:07:37 +0000194
195# Run some tests using pre-allocated page and scratch blocks.
196#
dan0626dfc2010-06-15 06:56:37 +0000197test_suite "memsubsys1" -description {
danielk19771077e3f2008-06-21 18:07:37 +0000198 Tests using pre-allocated page and scratch blocks
dan0626dfc2010-06-15 06:56:37 +0000199} -files [
200 test_set $::allquicktests -exclude ioerr5.test malloc5.test
201] -initialize {
drhd63bd752008-07-30 13:15:46 +0000202 catch {db close}
danielk19771077e3f2008-06-21 18:07:37 +0000203 sqlite3_shutdown
204 sqlite3_config_pagecache 4096 24
205 sqlite3_config_scratch 25000 1
206 sqlite3_initialize
drhbb77b752009-04-09 01:23:49 +0000207 autoinstall_test_functions
danielk19771077e3f2008-06-21 18:07:37 +0000208} -shutdown {
209 catch {db close}
210 sqlite3_shutdown
211 sqlite3_config_pagecache 0 0
212 sqlite3_config_scratch 0 0
213 sqlite3_initialize
drhbb77b752009-04-09 01:23:49 +0000214 autoinstall_test_functions
danielk19771077e3f2008-06-21 18:07:37 +0000215}
216
217# Run some tests using pre-allocated page and scratch blocks. This time
218# the allocations are too small to use in most cases.
219#
danielk197734c61e62008-08-29 12:00:20 +0000220# Both ioerr5.test and malloc5.test are excluded because they test the
221# sqlite3_soft_heap_limit() and sqlite3_release_memory() functionality.
222# This functionality is disabled if a pre-allocated page block is provided.
223#
dan0626dfc2010-06-15 06:56:37 +0000224test_suite "memsubsys2" -description {
danielk19771077e3f2008-06-21 18:07:37 +0000225 Tests using small pre-allocated page and scratch blocks
dan0626dfc2010-06-15 06:56:37 +0000226} -files [
227 test_set $::allquicktests -exclude ioerr5.test malloc5.test
228] -initialize {
drhd63bd752008-07-30 13:15:46 +0000229 catch {db close}
danielk19771077e3f2008-06-21 18:07:37 +0000230 sqlite3_shutdown
231 sqlite3_config_pagecache 512 5
232 sqlite3_config_scratch 1000 1
233 sqlite3_initialize
drhbb77b752009-04-09 01:23:49 +0000234 autoinstall_test_functions
danielk19771077e3f2008-06-21 18:07:37 +0000235} -shutdown {
236 catch {db close}
237 sqlite3_shutdown
238 sqlite3_config_pagecache 0 0
239 sqlite3_config_scratch 0 0
240 sqlite3_initialize
drhbb77b752009-04-09 01:23:49 +0000241 autoinstall_test_functions
danielk19771077e3f2008-06-21 18:07:37 +0000242}
243
drhe2a7c6e2008-08-01 15:06:30 +0000244# Run all tests with the lookaside allocator disabled.
245#
dan0626dfc2010-06-15 06:56:37 +0000246test_suite "nolookaside" -description {
drhe2a7c6e2008-08-01 15:06:30 +0000247 OOM tests with lookaside disabled
drhe2a7c6e2008-08-01 15:06:30 +0000248} -initialize {
249 catch {db close}
250 sqlite3_shutdown
251 sqlite3_config_lookaside 0 0
252 sqlite3_initialize
drhbb77b752009-04-09 01:23:49 +0000253 autoinstall_test_functions
drhe2a7c6e2008-08-01 15:06:30 +0000254} -shutdown {
255 catch {db close}
256 sqlite3_shutdown
257 sqlite3_config_lookaside 100 500
258 sqlite3_initialize
drhbb77b752009-04-09 01:23:49 +0000259 autoinstall_test_functions
dan0626dfc2010-06-15 06:56:37 +0000260} -files $::allquicktests
drhe2a7c6e2008-08-01 15:06:30 +0000261
danielk19771077e3f2008-06-21 18:07:37 +0000262# Run some tests in SQLITE_CONFIG_SINGLETHREAD mode.
263#
dan0626dfc2010-06-15 06:56:37 +0000264test_suite "singlethread" -description {
danielk19771077e3f2008-06-21 18:07:37 +0000265 Tests run in SQLITE_CONFIG_SINGLETHREAD mode
266} -initialize {
drh04df18d2009-01-06 14:50:11 +0000267 catch {db close}
268 sqlite3_shutdown
269 catch {sqlite3_config singlethread}
drhbb77b752009-04-09 01:23:49 +0000270 sqlite3_initialize
271 autoinstall_test_functions
dan0626dfc2010-06-15 06:56:37 +0000272} -files {
danielk19771077e3f2008-06-21 18:07:37 +0000273 delete.test delete2.test insert.test rollback.test select1.test
274 select2.test trans.test update.test vacuum.test types.test
275 types2.test types3.test
276} -shutdown {
drh04df18d2009-01-06 14:50:11 +0000277 catch {db close}
278 sqlite3_shutdown
279 catch {sqlite3_config serialized}
drhbb77b752009-04-09 01:23:49 +0000280 sqlite3_initialize
281 autoinstall_test_functions
danielk19771077e3f2008-06-21 18:07:37 +0000282}
283
dan0626dfc2010-06-15 06:56:37 +0000284test_suite "nomutex" -description {
drh039963a2008-09-03 00:43:15 +0000285 Tests run with the SQLITE_OPEN_MULTITHREADED flag passed to sqlite3_open().
danielk19779a6284c2008-07-10 17:52:49 +0000286} -initialize {
287 rename sqlite3 sqlite3_nomutex
288 proc sqlite3 {args} {
289 if {[string range [lindex $args 0] 0 0] ne "-"} {
drhcc91e7f2008-09-03 01:08:00 +0000290 lappend args -fullmutex 0 -nomutex 1
danielk19779a6284c2008-07-10 17:52:49 +0000291 }
292 uplevel [concat sqlite3_nomutex $args]
293 }
dan0626dfc2010-06-15 06:56:37 +0000294} -files {
danielk19779a6284c2008-07-10 17:52:49 +0000295 delete.test delete2.test insert.test rollback.test select1.test
296 select2.test trans.test update.test vacuum.test types.test
297 types2.test types3.test
298} -shutdown {
299 rename sqlite3 {}
300 rename sqlite3_nomutex sqlite3
301}
302
danielk19771077e3f2008-06-21 18:07:37 +0000303# Run some tests in SQLITE_CONFIG_MULTITHREAD mode.
304#
dan0626dfc2010-06-15 06:56:37 +0000305test_suite "multithread" -description {
danielk19771077e3f2008-06-21 18:07:37 +0000306 Tests run in SQLITE_CONFIG_MULTITHREAD mode
307} -initialize {
drh04df18d2009-01-06 14:50:11 +0000308 catch {db close}
309 sqlite3_shutdown
310 catch {sqlite3_config multithread}
drhbb77b752009-04-09 01:23:49 +0000311 sqlite3_initialize
312 autoinstall_test_functions
dan0626dfc2010-06-15 06:56:37 +0000313} -files {
danielk19771077e3f2008-06-21 18:07:37 +0000314 delete.test delete2.test insert.test rollback.test select1.test
315 select2.test trans.test update.test vacuum.test types.test
316 types2.test types3.test
317} -shutdown {
drh04df18d2009-01-06 14:50:11 +0000318 catch {db close}
319 sqlite3_shutdown
320 catch {sqlite3_config serialized}
drhbb77b752009-04-09 01:23:49 +0000321 sqlite3_initialize
322 autoinstall_test_functions
danielk19771077e3f2008-06-21 18:07:37 +0000323}
324
drh039963a2008-09-03 00:43:15 +0000325# Run some tests in SQLITE_OPEN_FULLMUTEX mode.
326#
dan0626dfc2010-06-15 06:56:37 +0000327test_suite "fullmutex" -description {
drh039963a2008-09-03 00:43:15 +0000328 Tests run in SQLITE_OPEN_FULLMUTEX mode
329} -initialize {
330 rename sqlite3 sqlite3_fullmutex
331 proc sqlite3 {args} {
332 if {[string range [lindex $args 0] 0 0] ne "-"} {
drhcc91e7f2008-09-03 01:08:00 +0000333 lappend args -nomutex 0 -fullmutex 1
drh039963a2008-09-03 00:43:15 +0000334 }
335 uplevel [concat sqlite3_fullmutex $args]
336 }
dan0626dfc2010-06-15 06:56:37 +0000337} -files {
drh039963a2008-09-03 00:43:15 +0000338 delete.test delete2.test insert.test rollback.test select1.test
339 select2.test trans.test update.test vacuum.test types.test
340 types2.test types3.test
341} -shutdown {
342 rename sqlite3 {}
343 rename sqlite3_fullmutex sqlite3
344}
345
danielk19771077e3f2008-06-21 18:07:37 +0000346# Run some tests using the "onefile" demo.
347#
dan0626dfc2010-06-15 06:56:37 +0000348test_suite "onefile" -description {
danielk19771077e3f2008-06-21 18:07:37 +0000349 Run some tests using the "test_onefile.c" demo
350} -initialize {
351 rename sqlite3 sqlite3_onefile
352 proc sqlite3 {args} {
353 if {[string range [lindex $args 0] 0 0] ne "-"} {
354 lappend args -vfs fs
355 }
356 uplevel [concat sqlite3_onefile $args]
357 }
dan0626dfc2010-06-15 06:56:37 +0000358} -files {
danielk19771077e3f2008-06-21 18:07:37 +0000359 conflict.test insert.test insert2.test insert3.test
360 rollback.test select1.test select2.test select3.test
danielk19771077e3f2008-06-21 18:07:37 +0000361} -shutdown {
362 rename sqlite3 {}
363 rename sqlite3_onefile sqlite3
364}
365
366# Run some tests using UTF-16 databases.
367#
dan0626dfc2010-06-15 06:56:37 +0000368test_suite "utf16" -description {
danielk19771077e3f2008-06-21 18:07:37 +0000369 Run tests using UTF-16 databases
danielk19772dd6d802008-06-21 19:10:27 +0000370} -presql {
danielk19771077e3f2008-06-21 18:07:37 +0000371 pragma encoding = 'UTF-16'
dan0626dfc2010-06-15 06:56:37 +0000372} -files {
danielk19771077e3f2008-06-21 18:07:37 +0000373 alter.test alter3.test
374 auth.test bind.test blob.test capi2.test capi3.test collate1.test
375 collate2.test collate3.test collate4.test collate5.test collate6.test
376 conflict.test date.test delete.test expr.test fkey1.test func.test
377 hook.test index.test insert2.test insert.test interrupt.test in.test
378 intpkey.test ioerr.test join2.test join.test lastinsert.test
379 laststmtchanges.test limit.test lock2.test lock.test main.test
380 memdb.test minmax.test misc1.test misc2.test misc3.test notnull.test
381 null.test progress.test quote.test rowid.test select1.test select2.test
382 select3.test select4.test select5.test select6.test sort.test
383 subselect.test tableapi.test table.test temptable.test
384 trace.test trigger1.test trigger2.test trigger3.test
385 trigger4.test types2.test types.test unique.test update.test
386 vacuum.test view.test where.test
387}
388
389# Run some tests in exclusive locking mode.
390#
dan0626dfc2010-06-15 06:56:37 +0000391test_suite "exclusive" -description {
danielk19771077e3f2008-06-21 18:07:37 +0000392 Run tests in exclusive locking mode.
393} -presql {
394 pragma locking_mode = 'exclusive'
dan0626dfc2010-06-15 06:56:37 +0000395} -files {
danielk19771077e3f2008-06-21 18:07:37 +0000396 rollback.test select1.test select2.test
397 malloc.test ioerr.test
398}
399
drh04335882008-09-26 21:08:08 +0000400# Run some tests in exclusive locking mode with truncated journals.
401#
dan0626dfc2010-06-15 06:56:37 +0000402test_suite "exclusive-truncate" -description {
drh04335882008-09-26 21:08:08 +0000403 Run tests in exclusive locking mode and truncate journal mode.
404} -presql {
405 pragma locking_mode = 'exclusive';
406 pragma journal_mode = TRUNCATE;
dan0626dfc2010-06-15 06:56:37 +0000407} -files {
drh04335882008-09-26 21:08:08 +0000408 delete.test delete2.test insert.test rollback.test select1.test
409 select2.test update.test malloc.test ioerr.test
410}
411
danielk19771077e3f2008-06-21 18:07:37 +0000412# Run some tests in persistent journal mode.
413#
dan0626dfc2010-06-15 06:56:37 +0000414test_suite "persistent_journal" -description {
danielk19771077e3f2008-06-21 18:07:37 +0000415 Run tests in persistent-journal mode.
416} -presql {
417 pragma journal_mode = persist
dan0626dfc2010-06-15 06:56:37 +0000418} -files {
danielk19771077e3f2008-06-21 18:07:37 +0000419 delete.test delete2.test insert.test rollback.test select1.test
420 select2.test trans.test update.test vacuum.test
421}
422
drh04335882008-09-26 21:08:08 +0000423# Run some tests in truncating journal mode.
424#
dan0626dfc2010-06-15 06:56:37 +0000425test_suite "truncate_journal" -description {
drh04335882008-09-26 21:08:08 +0000426 Run tests in persistent-journal mode.
427} -presql {
428 pragma journal_mode = truncate
dan0626dfc2010-06-15 06:56:37 +0000429} -files {
drh04335882008-09-26 21:08:08 +0000430 delete.test delete2.test insert.test rollback.test select1.test
431 select2.test trans.test update.test vacuum.test
432 malloc.test ioerr.test
433}
434
danielk19771077e3f2008-06-21 18:07:37 +0000435# Run some error tests in persistent journal mode.
436#
dan0626dfc2010-06-15 06:56:37 +0000437test_suite "persistent_journal_error" -description {
danielk19771077e3f2008-06-21 18:07:37 +0000438 Run malloc.test and ioerr.test in persistent-journal mode.
439} -presql {
440 pragma journal_mode = persist
dan0626dfc2010-06-15 06:56:37 +0000441} -files {
danielk19771077e3f2008-06-21 18:07:37 +0000442 malloc.test ioerr.test
443}
444
445# Run some tests in no journal mode.
446#
dan0626dfc2010-06-15 06:56:37 +0000447test_suite "no_journal" -description {
danielk19771077e3f2008-06-21 18:07:37 +0000448 Run tests in no-journal mode.
449} -presql {
450 pragma journal_mode = persist
dan0626dfc2010-06-15 06:56:37 +0000451} -files {
danielk19771077e3f2008-06-21 18:07:37 +0000452 delete.test delete2.test insert.test rollback.test select1.test
453 select2.test trans.test update.test vacuum.test
454}
455
456# Run some error tests in no journal mode.
457#
dan0626dfc2010-06-15 06:56:37 +0000458test_suite "no_journal_error" -description {
danielk19771077e3f2008-06-21 18:07:37 +0000459 Run malloc.test and ioerr.test in no-journal mode.
460} -presql {
461 pragma journal_mode = persist
dan0626dfc2010-06-15 06:56:37 +0000462} -files {
danielk19771077e3f2008-06-21 18:07:37 +0000463 malloc.test ioerr.test
464}
465
466# Run some crash-tests in autovacuum mode.
467#
dan0626dfc2010-06-15 06:56:37 +0000468test_suite "autovacuum_crash" -description {
danielk19771077e3f2008-06-21 18:07:37 +0000469 Run crash.test in autovacuum mode.
470} -presql {
471 pragma auto_vacuum = 1
dan0626dfc2010-06-15 06:56:37 +0000472} -files crash.test
danielk19771077e3f2008-06-21 18:07:37 +0000473
474# Run some ioerr-tests in autovacuum mode.
475#
dan0626dfc2010-06-15 06:56:37 +0000476test_suite "autovacuum_ioerr" -description {
danielk19771077e3f2008-06-21 18:07:37 +0000477 Run ioerr.test in autovacuum mode.
478} -presql {
479 pragma auto_vacuum = 1
dan0626dfc2010-06-15 06:56:37 +0000480} -files ioerr.test
danielk19771077e3f2008-06-21 18:07:37 +0000481
danielk1977b3175382008-10-17 18:51:52 +0000482# Run tests with an in-memory journal.
483#
dan0626dfc2010-06-15 06:56:37 +0000484test_suite "inmemory_journal" -description {
danielk1977b3175382008-10-17 18:51:52 +0000485 Run tests with an in-memory journal file.
486} -presql {
487 pragma journal_mode = 'memory'
dan0626dfc2010-06-15 06:56:37 +0000488} -files [test_set $::allquicktests -exclude {
danielk1977b3175382008-10-17 18:51:52 +0000489 # Exclude all tests that simulate IO errors.
490 autovacuum_ioerr2.test incrvacuum_ioerr.test ioerr.test
491 ioerr.test ioerr2.test ioerr3.test ioerr4.test ioerr5.test
drh2206a2b2009-04-01 23:09:43 +0000492 vacuum3.test incrblob_err.test diskfull.test backup_ioerr.test
shanehc3b84832010-07-09 19:32:28 +0000493 e_fts3.test fts3cov.test fts3malloc.test fts3rnd.test
494 fts3snippet.test
danielk1977b3175382008-10-17 18:51:52 +0000495
496 # Exclude test scripts that use tcl IO to access journal files or count
497 # the number of fsync() calls.
498 pager.test exclusive.test jrnlmode.test sync.test misc1.test
danielk1977cb257902009-04-10 18:32:29 +0000499 journal1.test conflict.test crash8.test tkt3457.test io.test
dan37575562010-07-17 09:27:31 +0000500 journal3.test
dan01d38562010-03-08 10:32:38 +0000501
dancb354602010-07-08 09:44:42 +0000502 pager1.test async4.test corrupt.test filefmt.test pager2.test
503 corrupt5.test corruptA.test pageropt.test
504
dan01d38562010-03-08 10:32:38 +0000505 # Exclude stmt.test, which expects sub-journals to use temporary files.
506 stmt.test
drh0b944132010-05-24 20:24:38 +0000507
508 # WAL mode is different.
dan0626dfc2010-06-15 06:56:37 +0000509 wal*
510}]
danielk1977b3175382008-10-17 18:51:52 +0000511
danielk19776b39c2e2008-06-25 14:57:53 +0000512ifcapable mem3 {
dan0626dfc2010-06-15 06:56:37 +0000513 test_suite "memsys3" -description {
danielk19776b39c2e2008-06-25 14:57:53 +0000514 Run tests using the allocator in mem3.c.
daneace5272010-07-05 05:31:48 +0000515 } -files [test_set $::allquicktests -exclude {
drh8a42cbd2008-07-10 18:13:42 +0000516 autovacuum.test delete3.test manydb.test
517 bigrow.test incrblob2.test memdb.test
518 bitvec.test index2.test memsubsys1.test
519 capi3c.test ioerr.test memsubsys2.test
520 capi3.test join3.test pagesize.test
danielk19778b322822009-07-01 18:09:01 +0000521 collate5.test limit.test backup_ioerr.test
522 backup_malloc.test
dan0626dfc2010-06-15 06:56:37 +0000523 }] -initialize {
danielk19776b39c2e2008-06-25 14:57:53 +0000524 catch {db close}
525 sqlite3_reset_auto_extension
526 sqlite3_shutdown
drh7830cd42008-07-16 12:25:32 +0000527 sqlite3_config_heap 25000000 0
drhe2a7c6e2008-08-01 15:06:30 +0000528 sqlite3_config_lookaside 0 0
danielk19778b322822009-07-01 18:09:01 +0000529 ifcapable mem5 {
530 # If both memsys3 and memsys5 are enabled in the build, the call to
531 # [sqlite3_config_heap] will initialize the system to use memsys5.
532 # The following overrides this preference and installs the memsys3
533 # allocator.
534 sqlite3_install_memsys3
535 }
danielk19776b39c2e2008-06-25 14:57:53 +0000536 install_malloc_faultsim 1
537 sqlite3_initialize
538 autoinstall_test_functions
539 } -shutdown {
540 catch {db close}
danielk19776b39c2e2008-06-25 14:57:53 +0000541 sqlite3_shutdown
danielk19770d84e5b2008-06-27 14:05:24 +0000542 sqlite3_config_heap 0 0
drhe2a7c6e2008-08-01 15:06:30 +0000543 sqlite3_config_lookaside 100 500
danielk19776b39c2e2008-06-25 14:57:53 +0000544 install_malloc_faultsim 1
545 sqlite3_initialize
drhbb77b752009-04-09 01:23:49 +0000546 autoinstall_test_functions
danielk19776b39c2e2008-06-25 14:57:53 +0000547 }
danielk197757e5ea92008-06-24 19:02:55 +0000548}
549
danielk19776b39c2e2008-06-25 14:57:53 +0000550ifcapable mem5 {
dan0626dfc2010-06-15 06:56:37 +0000551 test_suite "memsys5" -description {
danielk19776b39c2e2008-06-25 14:57:53 +0000552 Run tests using the allocator in mem5.c.
daneace5272010-07-05 05:31:48 +0000553 } -files [test_set $::allquicktests -exclude {
drh8a42cbd2008-07-10 18:13:42 +0000554 autovacuum.test delete3.test manydb.test
555 bigrow.test incrblob2.test memdb.test
556 bitvec.test index2.test memsubsys1.test
557 capi3c.test ioerr.test memsubsys2.test
558 capi3.test join3.test pagesize.test
danielk1977ac8d7b32008-11-13 16:21:50 +0000559 collate5.test limit.test zeroblob.test
dan0626dfc2010-06-15 06:56:37 +0000560 }] -initialize {
danielk19776b39c2e2008-06-25 14:57:53 +0000561 catch {db close}
danielk19776b39c2e2008-06-25 14:57:53 +0000562 sqlite3_shutdown
drh7830cd42008-07-16 12:25:32 +0000563 sqlite3_config_heap 25000000 64
drhe2a7c6e2008-08-01 15:06:30 +0000564 sqlite3_config_lookaside 0 0
danielk19775099be52008-06-27 13:27:03 +0000565 install_malloc_faultsim 1
566 sqlite3_initialize
567 autoinstall_test_functions
568 } -shutdown {
569 catch {db close}
danielk19775099be52008-06-27 13:27:03 +0000570 sqlite3_shutdown
danielk19770d84e5b2008-06-27 14:05:24 +0000571 sqlite3_config_heap 0 0
drhe2a7c6e2008-08-01 15:06:30 +0000572 sqlite3_config_lookaside 100 500
danielk19775099be52008-06-27 13:27:03 +0000573 install_malloc_faultsim 1
574 sqlite3_initialize
drhbb77b752009-04-09 01:23:49 +0000575 autoinstall_test_functions
danielk19775099be52008-06-27 13:27:03 +0000576 }
577
dan0626dfc2010-06-15 06:56:37 +0000578 test_suite "memsys5-2" -description {
danielk19775099be52008-06-27 13:27:03 +0000579 Run tests using the allocator in mem5.c in a different configuration.
dan0626dfc2010-06-15 06:56:37 +0000580 } -files {
drh8a42cbd2008-07-10 18:13:42 +0000581 select1.test
danielk19775099be52008-06-27 13:27:03 +0000582 } -initialize {
583 catch {db close}
danielk19775099be52008-06-27 13:27:03 +0000584 sqlite3_shutdown
drh7830cd42008-07-16 12:25:32 +0000585 sqlite3_config_heap 40000000 16
drhe2a7c6e2008-08-01 15:06:30 +0000586 sqlite3_config_lookaside 0 0
danielk19776b39c2e2008-06-25 14:57:53 +0000587 install_malloc_faultsim 1
588 sqlite3_initialize
589 autoinstall_test_functions
590 } -shutdown {
591 catch {db close}
danielk19776b39c2e2008-06-25 14:57:53 +0000592 sqlite3_shutdown
danielk19770d84e5b2008-06-27 14:05:24 +0000593 sqlite3_config_heap 0 0
drhe2a7c6e2008-08-01 15:06:30 +0000594 sqlite3_config_lookaside 100 500
danielk19776b39c2e2008-06-25 14:57:53 +0000595 install_malloc_faultsim 1
596 sqlite3_initialize
drhbb77b752009-04-09 01:23:49 +0000597 autoinstall_test_functions
danielk19776b39c2e2008-06-25 14:57:53 +0000598 }
danielk1977c66c0e12008-06-25 14:26:07 +0000599}
600
drh8a42cbd2008-07-10 18:13:42 +0000601ifcapable threadsafe {
dan0626dfc2010-06-15 06:56:37 +0000602 test_suite "no_mutex_try" -description {
drh8a42cbd2008-07-10 18:13:42 +0000603 The sqlite3_mutex_try() interface always fails
dan0626dfc2010-06-15 06:56:37 +0000604 } -files [
605 test_set $::allquicktests -exclude mutex1.test mutex2.test
606 ] -initialize {
drh8a42cbd2008-07-10 18:13:42 +0000607 catch {db close}
608 sqlite3_shutdown
609 install_mutex_counters 1
610 set ::disable_mutex_try 1
drhbb77b752009-04-09 01:23:49 +0000611 sqlite3_initialize
612 autoinstall_test_functions
drh8a42cbd2008-07-10 18:13:42 +0000613 } -shutdown {
614 catch {db close}
615 sqlite3_shutdown
616 install_mutex_counters 0
drhbb77b752009-04-09 01:23:49 +0000617 sqlite3_initialize
618 autoinstall_test_functions
drh8a42cbd2008-07-10 18:13:42 +0000619 }
620}
621
danielk1977b13dee92008-06-23 15:55:52 +0000622# run_tests "crash_safe_append" -description {
623# Run crash.test with persistent journals on a SAFE_APPEND file-system.
624# } -initialize {
625# rename crashsql sa_crashsql
626# proc crashsql {args} {
627# set options [lrange $args 0 [expr {[llength $args]-2}]]
628# lappend options -char safe_append
629# set sql [lindex $args end]
630# lappend options "
631# PRAGMA journal_mode=persistent;
632# $sql
633# "
634# set fd [open test.db-journal w]
635# puts $fd [string repeat 1234567890 100000]
636# close $fd
637# eval sa_crashsql $options
638# }
639# } -shutdown {
640# rename crashsql {}
641# rename sa_crashsql crashsql
dan0626dfc2010-06-15 06:56:37 +0000642# } -files crash.test
danielk1977b13dee92008-06-23 15:55:52 +0000643
dan0626dfc2010-06-15 06:56:37 +0000644test_suite "safe_append" -description {
danielk1977755339e2008-09-12 10:22:40 +0000645 Run some tests on a SAFE_APPEND file-system.
646} -initialize {
647 rename sqlite3 sqlite3_safeappend
648 proc sqlite3 {args} {
649 if {[string range [lindex $args 0] 0 0] ne "-"} {
650 lappend args -vfs devsym
651 }
652 uplevel [concat sqlite3_safeappend $args]
653 }
654 sqlite3_simulate_device -char safe_append
655} -shutdown {
656 rename sqlite3 {}
657 rename sqlite3_shutdown sqlite3
dan0626dfc2010-06-15 06:56:37 +0000658} -files [
659 test_set $::allquicktests shared_err.test -exclude async3.test
660]
danielk1977755339e2008-09-12 10:22:40 +0000661
drhb232c232008-11-19 01:20:26 +0000662# The set of tests to run on the alternative-pcache
663set perm-alt-pcache-testset {
664 async.test
665 attach.test
666 delete.test delete2.test
667 index.test
668 insert.test insert2.test
669 join.test join2.test
670 rollback.test
671 select1.test select2.test
672 trans.test
673 update.test
674}
675
dan2acd4c62010-07-13 14:22:39 +0000676foreach discard_rate {0 10 50 90 100} {
677 test_suite "pcache${discard_rate}" -description "
678 Alternative pcache implementation with ${discard_rate}% random discard
679 " -initialize "
680 catch {db close}
681 sqlite3_shutdown
682 sqlite3_config_alt_pcache 1 $discard_rate 1
683 sqlite3_initialize
684 autoinstall_test_functions
685 " -shutdown {
686 catch {db close}
687 sqlite3_shutdown
688 sqlite3_config_alt_pcache 0 0 0
689 sqlite3_config_lookaside 100 500
690 install_malloc_faultsim 1
691 sqlite3_initialize
692 autoinstall_test_functions
693 } -files ${perm-alt-pcache-testset}
694}
danielk1977b13dee92008-06-23 15:55:52 +0000695
dan0626dfc2010-06-15 06:56:37 +0000696test_suite "journaltest" -description {
danielk1977f3107512008-12-22 10:58:46 +0000697 Check that pages are synced before being written (test_journal.c).
698} -initialize {
danielk1977f3107512008-12-22 10:58:46 +0000699 catch {db close}
700 register_jt_vfs -default ""
701} -shutdown {
702 unregister_jt_vfs
dan0626dfc2010-06-15 06:56:37 +0000703} -files [test_set $::allquicktests -exclude {
704 wal* incrvacuum.test ioerr.test corrupt4.test io.test crash8.test
705 async4.test bigfile.test
drhfb4a6262010-05-06 19:55:57 +0000706}]
danielk1977f3107512008-12-22 10:58:46 +0000707
dan0a7a9152010-04-07 07:57:38 +0000708if {[info commands register_demovfs] != ""} {
dan0626dfc2010-06-15 06:56:37 +0000709 test_suite "demovfs" -description {
dan430e74c2010-06-07 17:47:26 +0000710 Check that the demovfs (code in test_demovfs.c) more or less works.
dan0a7a9152010-04-07 07:57:38 +0000711 } -initialize {
712 register_demovfs
713 } -shutdown {
714 unregister_demovfs
dan0626dfc2010-06-15 06:56:37 +0000715 } -files {
dan0a7a9152010-04-07 07:57:38 +0000716 insert.test insert2.test insert3.test rollback.test
717 select1.test select2.test select3.test
718 }
719}
720
dan0626dfc2010-06-15 06:56:37 +0000721test_suite "wal" -description {
dan71cb5182010-04-26 12:39:03 +0000722 Run tests with journal_mode=WAL
dan31f98fc2010-04-27 05:42:32 +0000723} -initialize {
dan430e74c2010-06-07 17:47:26 +0000724 set ::G(savepoint6_iterations) 100
dan31f98fc2010-04-27 05:42:32 +0000725} -shutdown {
dan430e74c2010-06-07 17:47:26 +0000726 unset -nocomplain ::G(savepoint6_iterations)
dan0626dfc2010-06-15 06:56:37 +0000727} -files {
dane106de62010-04-27 06:49:34 +0000728 savepoint.test savepoint2.test savepoint6.test
729 trans.test avtrans.test
dan60f9da72010-07-07 11:42:59 +0000730
731 fts3aa.test fts3ab.test fts3ac.test fts3ad.test
732 fts3ae.test fts3af.test fts3ag.test fts3ah.test
733 fts3ai.test fts3aj.test fts3ak.test fts3al.test
734 fts3am.test fts3an.test fts3ao.test fts3b.test
735 fts3c.test fts3d.test fts3e.test fts3query.test
dan71cb5182010-04-26 12:39:03 +0000736}
danielk19771077e3f2008-06-21 18:07:37 +0000737# End of tests
738#############################################################################
739
dan0626dfc2010-06-15 06:56:37 +0000740# run_tests NAME OPTIONS
741#
742# where available options are:
743#
dan2fce9ab2010-06-15 18:00:06 +0000744# -description TITLE
745# -initialize SCRIPT
746# -shutdown SCRIPT
747# -presql SQL
748# -files LIST-OF-FILES
749# -prefix NAME
dan0626dfc2010-06-15 06:56:37 +0000750#
751proc run_tests {name args} {
752 array set options $args
danielk19771077e3f2008-06-21 18:07:37 +0000753
dand506de02010-07-03 13:59:01 +0000754 set ::G(perm:name) $name
755 set ::G(perm:prefix) $options(-prefix)
dan0626dfc2010-06-15 06:56:37 +0000756 set ::G(perm:presql) $options(-presql)
757 set ::G(isquick) 1
758
759 uplevel $options(-initialize)
760
761 foreach file [lsort $options(-files)] {
shanehdecd09c2010-07-09 18:43:40 +0000762 slave_test_file $::testdir/$file
dan0626dfc2010-06-15 06:56:37 +0000763 }
764
765 uplevel $options(-shutdown)
766
767 unset ::G(perm:name)
dand506de02010-07-03 13:59:01 +0000768 unset ::G(perm:prefix)
dan0626dfc2010-06-15 06:56:37 +0000769 unset ::G(perm:presql)
770}
771
772proc run_test_suite {name} {
773 if {[info exists ::testspec($name)]==0} {
774 error "No such test suite: $name"
775 }
776 uplevel run_tests $name $::testspec($name)
777}
778
779proc help {} {
dane91a54e2010-06-15 17:44:47 +0000780 puts "Usage: $::argv0 TESTSUITE ?TESTFILE?"
781 puts ""
782 puts "Available test-suites are:"
dan0626dfc2010-06-15 06:56:37 +0000783 foreach k $::testsuitelist {
dane91a54e2010-06-15 17:44:47 +0000784 if {[info exists ::testspec($k)]==0} {
785 puts " ----------------------------------------"
786 puts ""
787 } else {
788 array set o $::testspec($k)
789 puts "Test suite: \"$k\""
790 set d [string trim $o(-description)]
791 set d [regsub {\n *} $d "\n "]
792 puts " $d"
793 puts ""
794 }
dan0626dfc2010-06-15 06:56:37 +0000795 }
796 exit -1
797}
798
799if {[info script] == $argv0} {
800 proc main {argv} {
801 if {[llength $argv]==0} {
802 help
803 } else {
804 set suite [lindex $argv 0]
805 if {[info exists ::testspec($suite)]==0} help
806 set extra ""
807 if {[llength $argv]>1} { set extra [list -files [lrange $argv 1 end]] }
808 eval run_tests $suite $::testspec($suite) $extra
809 }
810 }
811 main $argv
812 finish_test
813}
814