blob: 92eb2eec0714880978627c69bf3e76c68657612d [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.")
dan1ce1b4a2010-12-07 14:32:28 +000028# -dbconfig SCRIPT (default "")
dan0626dfc2010-06-15 06:56:37 +000029#
30proc test_suite {name args} {
dan430e74c2010-06-07 17:47:26 +000031
dan0626dfc2010-06-15 06:56:37 +000032 set default(-shutdown) ""
33 set default(-initialize) ""
34 set default(-presql) ""
dan430e74c2010-06-07 17:47:26 +000035 set default(-description) "no description supplied (fixme)"
dan2fce9ab2010-06-15 18:00:06 +000036 set default(-files) ""
37 set default(-prefix) "${name}."
dan1ce1b4a2010-12-07 14:32:28 +000038 set default(-dbconfig) ""
dan430e74c2010-06-07 17:47:26 +000039
40 array set options [array get default]
dan0626dfc2010-06-15 06:56:37 +000041 if {[llength $args]%2} {
42 error "uneven number of options/switches passed to test_suite"
dan430e74c2010-06-07 17:47:26 +000043 }
dan0626dfc2010-06-15 06:56:37 +000044 foreach {k v} $args {
45 set o [array names options ${k}*]
46 if {[llength $o]>1} { error "ambiguous option: $k" }
47 if {[llength $o]==0} { error "unknown option: $k" }
48 set options([lindex $o 0]) $v
drh0a846f92008-08-25 17:23:29 +000049 }
danielk19771077e3f2008-06-21 18:07:37 +000050
dan0626dfc2010-06-15 06:56:37 +000051 set ::testspec($name) [array get options]
52 lappend ::testsuitelist $name
53}
dan430e74c2010-06-07 17:47:26 +000054
dan0626dfc2010-06-15 06:56:37 +000055#-------------------------------------------------------------------------
56# test_set ARGS...
57#
58proc test_set {args} {
59 set isExclude 0
60 foreach a $args {
61 if {[string match -* $a]} {
62 switch -- $a {
63 -include { set isExclude 0 }
64 -exclude { set isExclude 1 }
65 default {
66 error "Unknown switch: $a"
67 }
danielk1977c1def3e2008-08-30 13:25:10 +000068 }
dan0626dfc2010-06-15 06:56:37 +000069 } elseif {$isExclude == 0} {
70 foreach f $a { set t($f) 1 }
drh0a846f92008-08-25 17:23:29 +000071 } else {
dan0626dfc2010-06-15 06:56:37 +000072 foreach f $a { array unset t $f }
dan897230e2010-08-26 14:15:37 +000073 foreach f $a { array unset t */$f }
danielk19771077e3f2008-06-21 18:07:37 +000074 }
75 }
76
dan0626dfc2010-06-15 06:56:37 +000077 return [array names t]
danielk19771077e3f2008-06-21 18:07:37 +000078}
79
dan0626dfc2010-06-15 06:56:37 +000080#-------------------------------------------------------------------------
81# Set up the following global list variables containing the names of
82# various test scripts:
83#
84# $alltests
dan2fce9ab2010-06-15 18:00:06 +000085# $allquicktests
dan0626dfc2010-06-15 06:56:37 +000086#
dan0626dfc2010-06-15 06:56:37 +000087set alltests [list]
88foreach f [glob $testdir/*.test] { lappend alltests [file tail $f] }
dane82126c2016-03-01 16:02:57 +000089foreach f [glob -nocomplain \
dane82126c2016-03-01 16:02:57 +000090 $testdir/../ext/rtree/*.test \
91 $testdir/../ext/fts5/test/*.test \
92] {
dan897230e2010-08-26 14:15:37 +000093 lappend alltests $f
94}
dan7cf7df72011-03-19 15:37:02 +000095foreach f [glob -nocomplain $testdir/../ext/session/*.test] {
96 lappend alltests $f
97}
dan897230e2010-08-26 14:15:37 +000098
dan0626dfc2010-06-15 06:56:37 +000099if {$::tcl_platform(platform)!="unix"} {
100 set alltests [test_set $alltests -exclude crash.test crash2.test]
danielk1977c1def3e2008-08-30 13:25:10 +0000101}
dan0626dfc2010-06-15 06:56:37 +0000102set alltests [test_set $alltests -exclude {
103 all.test async.test quick.test veryquick.test
104 memleak.test permutations.test soak.test fts3.test
drh905da632015-06-10 18:53:09 +0000105 mallocAll.test rtree.test full.test extraquick.test
drh60c97e62015-06-11 18:01:29 +0000106 session.test
dan0626dfc2010-06-15 06:56:37 +0000107}]
108
109set allquicktests [test_set $alltests -exclude {
110 async2.test async3.test backup_ioerr.test corrupt.test
111 corruptC.test crash.test crash2.test crash3.test crash4.test crash5.test
112 crash6.test crash7.test delete3.test e_fts3.test fts3rnd.test
113 fkey_malloc.test fuzz.test fuzz3.test fuzz_malloc.test in2.test loadext.test
dan273f3f02010-06-26 15:42:33 +0000114 misc7.test mutex2.test notify2.test onefile.test pagerfault2.test
dan0626dfc2010-06-15 06:56:37 +0000115 savepoint4.test savepoint6.test select9.test
116 speed1.test speed1p.test speed2.test speed3.test speed4.test
117 speed4p.test sqllimits1.test tkt2686.test thread001.test thread002.test
118 thread003.test thread004.test thread005.test trans2.test vacuum3.test
119 incrvacuum_ioerr.test autovacuum_crash.test btree8.test shared_err.test
dan533100d2011-12-17 08:10:34 +0000120 vtab_err.test walslow.test walcrash.test walcrash3.test
dan2aba5d92012-08-07 17:41:50 +0000121 walthread.test rtree3.test indexfault.test securedel2.test
drhdb2f9192014-05-19 23:17:33 +0000122 sort3.test sort4.test fts4growth.test fts4growth2.test
danbe7721d2016-02-04 17:31:03 +0000123 bigsort.test rbu.test walprotocol.test mmap4.test fuzzer2.test
124 walcrash2.test e_fkey.test backup.test
125
126 fts4merge.test fts4merge2.test fts4merge4.test fts4check.test
127 fts3cov.test fts3snippet.test fts3corrupt2.test fts3an.test
128 fts3defer.test fts4langid.test fts3sort.test fts5unicode.test
129
130 rtree4.test
dan0626dfc2010-06-15 06:56:37 +0000131}]
dan63109902010-07-05 05:54:55 +0000132if {[info exists ::env(QUICKTEST_INCLUDE)]} {
133 set allquicktests [concat $allquicktests $::env(QUICKTEST_INCLUDE)]
134}
drh4081d5d2015-01-01 23:02:01 +0000135if {[info exists ::env(QUICKTEST_OMIT)]} {
136 foreach x [split $::env(QUICKTEST_OMIT) ,] {
137 regsub -all \\y$x\\y $allquicktests {} allquicktests
138 }
139}
danielk1977c1def3e2008-08-30 13:25:10 +0000140
drhedb31cd2015-01-08 02:15:11 +0000141# If the TEST_FAILURE environment variable is set, it means that we what to
142# deliberately provoke test failures in order to test the test infrastructure.
143# Only the main.test module is needed for this.
144#
145if {[info exists ::env(TEST_FAILURE)]} {
146 set allquicktests main.test
147}
drhd63bd752008-07-30 13:15:46 +0000148
danielk19771077e3f2008-06-21 18:07:37 +0000149#############################################################################
150# Start of tests
dan0626dfc2010-06-15 06:56:37 +0000151#
152
153#-------------------------------------------------------------------------
154# Define the generic test suites:
155#
156# veryquick
157# quick
158# full
dan0626dfc2010-06-15 06:56:37 +0000159#
dane91a54e2010-06-15 17:44:47 +0000160lappend ::testsuitelist xxx
dan0626dfc2010-06-15 06:56:37 +0000161
dan2fce9ab2010-06-15 18:00:06 +0000162test_suite "veryquick" -prefix "" -description {
drh905da632015-06-10 18:53:09 +0000163 "Very" quick test suite. Runs in minutes on a workstation.
dan0626dfc2010-06-15 06:56:37 +0000164 This test suite is the same as the "quick" tests, except that some files
165 that test malloc and IO errors are omitted.
166} -files [
dane82126c2016-03-01 16:02:57 +0000167 test_set $allquicktests -exclude *malloc* *ioerr* *fault* *bigfile* *_err* \
168 *fts5corrupt* *fts5big* *fts5aj*
drh905da632015-06-10 18:53:09 +0000169]
170
171test_suite "extraquick" -prefix "" -description {
172 "Extra" quick test suite. Runs in a few minutes on a workstation.
173 This test suite is the same as the "veryquick" tests, except that
174 slower tests are omitted.
175} -files [
danbe7721d2016-02-04 17:31:03 +0000176 test_set $allquicktests -exclude *malloc* *ioerr* *fault* *bigfile* *_err* \
drh905da632015-06-10 18:53:09 +0000177 wal3.test fts4merge* sort2.test mmap1.test walcrash* \
178 percentile.test where8m.test walcksum.test savepoint3.test \
179 fuzzer1.test fuzzer3.test fts3expr3.test
dan0626dfc2010-06-15 06:56:37 +0000180]
181
drh9b4c59f2013-04-15 17:03:42 +0000182test_suite "mmap" -prefix "mm-" -description {
dane895b872014-12-31 09:52:15 +0000183 Similar to veryquick. Except with memory mapping enabled.
dan5d8a1372013-03-19 19:28:06 +0000184} -presql {
drh9b4c59f2013-04-15 17:03:42 +0000185 pragma mmap_size = 268435456;
dan5d8a1372013-03-19 19:28:06 +0000186} -files [
dan23f8a7c2014-12-31 18:08:46 +0000187 test_set $allquicktests -exclude *malloc* *ioerr* *fault* -include malloc.test
dan0626dfc2010-06-15 06:56:37 +0000188]
189
dan25568442010-12-03 10:32:06 +0000190test_suite "valgrind" -prefix "" -description {
191 Run the "veryquick" test suite with a couple of multi-process tests (that
192 fail under valgrind) omitted.
193} -files [
danbe7721d2016-02-04 17:31:03 +0000194 test_set $allquicktests -exclude *malloc* *ioerr* *fault* *_err* wal.test \
drh64134662015-01-08 22:08:57 +0000195 shell*.test crash8.test atof1.test selectG.test \
drh51675f22015-11-06 20:04:08 +0000196 tkt-fc62af4523.test numindex1.test
dan25568442010-12-03 10:32:06 +0000197] -initialize {
198 set ::G(valgrind) 1
199} -shutdown {
200 unset -nocomplain ::G(valgrind)
201}
202
dan5f438122014-06-02 09:39:24 +0000203test_suite "valgrind-nolookaside" -prefix "" -description {
204 Run the "veryquick" test suite with a couple of multi-process tests (that
205 fail under valgrind) omitted.
206} -files [
danbe7721d2016-02-04 17:31:03 +0000207 test_set $allquicktests -exclude *malloc* *ioerr* *fault* *_err* \
208 wal.test atof1.test
dan5f438122014-06-02 09:39:24 +0000209] -initialize {
210 set ::G(valgrind) 1
211 catch {db close}
212 sqlite3_shutdown
213 sqlite3_config_lookaside 0 0
214 sqlite3_initialize
215 autoinstall_test_functions
216} -shutdown {
217 catch {db close}
218 sqlite3_shutdown
219 sqlite3_config_lookaside 100 500
220 sqlite3_initialize
221 autoinstall_test_functions
222 unset -nocomplain ::G(valgrind)
223}
224
225
dan2fce9ab2010-06-15 18:00:06 +0000226test_suite "quick" -prefix "" -description {
dan0626dfc2010-06-15 06:56:37 +0000227 Quick test suite. Runs in around 10 minutes on a workstation.
228} -files [
229 test_set $allquicktests
230]
231
dan2fce9ab2010-06-15 18:00:06 +0000232test_suite "full" -prefix "" -description {
dan0626dfc2010-06-15 06:56:37 +0000233 Full test suite. Takes a long time.
234} -files [
235 test_set $alltests
236] -initialize {
237 unset -nocomplain ::G(isquick)
238}
239
danea5542d2010-07-06 11:26:15 +0000240test_suite "threads" -prefix "" -description {
241 All multi-threaded tests.
242} -files {
243 notify2.test thread001.test thread002.test thread003.test
244 thread004.test thread005.test walthread.test
245}
246
dana69f7d52010-07-19 11:16:36 +0000247test_suite "fts3" -prefix "" -description {
danddf80eb2010-10-25 12:47:43 +0000248 All FTS3 tests except fts3rnd.test.
dana69f7d52010-07-19 11:16:36 +0000249} -files {
dan119fc112017-03-21 17:19:31 +0000250 fts3aa.test fts3ab.test fts3ac.test fts3ad.test
251 fts3ae.test fts3af.test fts3ag.test fts3ah.test
252 fts3ai.test fts3aj.test fts3ak.test fts3al.test
253 fts3am.test fts3an.test fts3ao.test fts3atoken.test
254 fts3auto.test fts3aux1.test fts3aux2.test fts3b.test
255 fts3comp1.test fts3conf.test fts3corrupt2.test fts3corrupt.test
256 fts3cov.test fts3c.test fts3defer2.test fts3defer3.test
257 fts3defer.test fts3drop.test fts3d.test fts3e.test
258 fts3expr2.test fts3expr3.test fts3expr4.test fts3expr5.test
259 fts3expr.test fts3fault2.test fts3fault.test fts3first.test
260 fts3join.test fts3malloc.test fts3matchinfo.test fts3near.test
261 fts3offsets.test fts3prefix2.test fts3prefix.test fts3query.test
262 fts3shared.test fts3snippet.test fts3sort.test fts3tok1.test
263 fts3tok_err.test fts3varint.test fts4aa.test fts4check.test
264 fts4content.test fts4docid.test fts4growth2.test fts4growth.test
265 fts4incr.test fts4langid.test fts4lastrowid.test fts4merge2.test
266 fts4merge4.test fts4merge.test fts4noti.test fts4onepass.test
267 fts4opt.test fts4unicode.test
danddf47472017-04-17 13:38:09 +0000268 fts3corrupt3.test
dan624edac2017-04-17 16:07:25 +0000269 fts3misc.test
dana69f7d52010-07-19 11:16:36 +0000270}
271
dan22d43ec2014-06-25 20:28:38 +0000272test_suite "fts5" -prefix "" -description {
273 All FTS5 tests.
dane716aca2014-12-29 15:59:36 +0000274} -files [glob -nocomplain $::testdir/../ext/fts5/test/*.test]
dan22d43ec2014-06-25 20:28:38 +0000275
dan23d53882015-05-13 17:15:32 +0000276test_suite "fts5-light" -prefix "" -description {
277 All FTS5 tests.
278} -files [
279 test_set \
280 [glob -nocomplain $::testdir/../ext/fts5/test/*.test] \
281 -exclude *corrupt* *fault* *big* *fts5aj*
282]
283
dana8793422012-06-07 07:24:04 +0000284test_suite "nofaultsim" -prefix "" -description {
285 "Very" quick test suite. Runs in less than 5 minutes on a workstation.
286 This test suite is the same as the "quick" tests, except that some files
287 that test malloc and IO errors are omitted.
288} -files [
danbe7721d2016-02-04 17:31:03 +0000289 test_set $allquicktests -exclude *malloc* *ioerr* *fault* *_err*
dana8793422012-06-07 07:24:04 +0000290] -initialize {
291 catch {db close}
292 sqlite3_shutdown
293 install_malloc_faultsim 0
294 sqlite3_initialize
295 autoinstall_test_functions
296} -shutdown {
297 unset -nocomplain ::G(valgrind)
298}
danea5542d2010-07-06 11:26:15 +0000299
drhfd5874d2013-06-12 14:52:39 +0000300test_suite "queryplanner" -prefix "" -description {
301 Tests of the query planner and query optimizer
302} -files {
303 alter2.test alter3.test alter4.test alter.test analyze3.test
304 analyze4.test analyze5.test analyze6.test analyze7.test analyze8.test
drh4fe425a2013-06-12 17:08:06 +0000305 analyze.test attach2.test attach3.test attach4.test
drhfd5874d2013-06-12 14:52:39 +0000306 attach.test autoinc.test autoindex1.test between.test cast.test
307 check.test closure01.test coalesce.test collate1.test collate2.test
308 collate3.test collate4.test collate5.test collate6.test collate7.test
309 collate8.test collate9.test collateA.test colmeta.test colname.test
310 conflict.test count.test coveridxscan.test createtab.test cse.test
311 date.test dbstatus2.test dbstatus.test default.test delete2.test
312 delete3.test delete.test descidx1.test descidx2.test descidx3.test
313 distinctagg.test distinct.test e_createtable.test e_delete.test
drh4fe425a2013-06-12 17:08:06 +0000314 e_droptrigger.test e_dropview.test e_expr.test e_insert.test
drhfd5874d2013-06-12 14:52:39 +0000315 eqp.test e_reindex.test e_resolve.test e_select2.test e_select.test
316 e_update.test exists.test expr.test fkey1.test fkey2.test fkey3.test
drh4fe425a2013-06-12 17:08:06 +0000317 fkey4.test fkey5.test func2.test func3.test func.test
318 in3.test in4.test in5.test index2.test index3.test
319 index4.test index5.test indexedby.test index.test
drhfd5874d2013-06-12 14:52:39 +0000320 insert2.test insert3.test insert4.test insert5.test insert.test
321 instr.test in.test intpkey.test join2.test join3.test join4.test
322 join5.test join6.test join.test like2.test like.test limit.test
323 minmax2.test minmax3.test minmax4.test minmax.test misc1.test misc2.test
324 misc3.test misc4.test misc5.test misc6.test misc7.test orderby1.test
325 orderby2.test orderby3.test orderby4.test randexpr1.test regexp1.test
326 reindex.test rowhash.test rowid.test schema2.test schema3.test
drh4fe425a2013-06-12 17:08:06 +0000327 schema4.test schema5.test schema.test
drhfd5874d2013-06-12 14:52:39 +0000328 select1.test select2.test select3.test select4.test select5.test
329 select6.test select7.test select8.test select9.test selectA.test
330 selectB.test selectC.test selectD.test selectE.test sidedelete.test
331 sort.test spellfix.test subquery2.test subquery.test subselect.test
332 substr.test tkt-02a8e81d44.test tkt1435.test tkt1443.test tkt1444.test
333 tkt1449.test tkt1473.test tkt1501.test tkt1512.test tkt1514.test
334 tkt1536.test tkt1537.test tkt1567.test tkt1644.test tkt1667.test
335 tkt1873.test tkt2141.test tkt2192.test tkt2213.test tkt2251.test
336 tkt2285.test tkt2332.test tkt2339.test tkt2391.test tkt2409.test
337 tkt2450.test tkt2565.test tkt2640.test tkt2643.test tkt2686.test
338 tkt-26ff0c2d1e.test tkt2767.test tkt2817.test tkt2820.test tkt2822.test
339 tkt2832.test tkt2854.test tkt2920.test tkt2927.test tkt2942.test
340 tkt-2a5629202f.test tkt-2d1a5c67d.test tkt-2ea2425d34.test tkt3080.test
341 tkt3093.test tkt3121.test tkt-31338dca7e.test tkt-313723c356.test
342 tkt3201.test tkt3292.test tkt3298.test tkt3334.test tkt3346.test
343 tkt3357.test tkt3419.test tkt3424.test tkt3442.test tkt3457.test
344 tkt3461.test tkt3493.test tkt3508.test tkt3522.test tkt3527.test
345 tkt3541.test tkt3554.test tkt3581.test tkt35xx.test tkt3630.test
346 tkt3718.test tkt3731.test tkt3757.test tkt3761.test tkt3762.test
347 tkt3773.test tkt3791.test tkt3793.test tkt3810.test tkt3824.test
348 tkt3832.test tkt3838.test tkt3841.test tkt-385a5b56b9.test tkt3871.test
349 tkt3879.test tkt-38cb5df375.test tkt3911.test tkt3918.test tkt3922.test
350 tkt3929.test tkt3935.test tkt3992.test tkt3997.test tkt-3998683a16.test
351 tkt-3a77c9714e.test tkt-3fe897352e.test tkt4018.test tkt-4a03edc4c8.test
352 tkt-4dd95f6943.test tkt-54844eea3f.test tkt-5d863f876e.test
353 tkt-5e10420e8d.test tkt-5ee23731f.test tkt-6bfb98dfc0.test
354 tkt-752e1646fc.test tkt-78e04e52ea.test tkt-7a31705a7e6.test
355 tkt-7bbfb7d442.test tkt-80ba201079.test tkt-80e031a00f.test
356 tkt-8454a207b9.test tkt-91e2e8ba6f.test tkt-94c04eaadb.test
357 tkt-9d68c883.test tkt-a7b7803e.test tkt-b1d3a2e531.test
358 tkt-b351d95f9.test tkt-b72787b1.test tkt-bd484a090c.test
359 tkt-bdc6bbbb38.test tkt-c48d99d690.test tkt-cbd054fa6b.test
360 tkt-d11f09d36e.test tkt-d635236375.test tkt-d82e3f3721.test
361 tkt-f3e5abed55.test tkt-f777251dc7a.test tkt-f7b4edec.test
362 tkt-f973c7ac31.test tkt-fa7bf5ec.test tkt-fc62af4523.test
363 tkt-fc7bd6358f.test trigger1.test trigger2.test trigger3.test
364 trigger4.test trigger5.test trigger6.test trigger7.test trigger8.test
365 trigger9.test triggerA.test triggerB.test triggerC.test triggerD.test
366 types2.test types3.test types.test unique.test unordered.test
367 update.test view.test vtab1.test vtab2.test vtab3.test vtab4.test
368 vtab5.test vtab6.test vtab7.test vtab8.test vtab9.test vtab_alter.test
drh4fe425a2013-06-12 17:08:06 +0000369 vtabA.test vtabB.test vtabC.test vtabD.test vtabE.test
drhfd5874d2013-06-12 14:52:39 +0000370 vtabF.test where2.test where3.test where4.test where5.test where6.test
371 where7.test where8m.test where8.test where9.test whereA.test whereB.test
372 whereC.test whereD.test whereE.test whereF.test wherelimit.test
373 where.test
374}
375
dan30e2f0a2013-10-10 13:04:46 +0000376test_suite "vfslog" -prefix "" -description {
377 "Vfslog" quick test suite. Like "veryquick" except does not omits
378 a few tests that do not work with a version 1 VFS. And the quota* tests,
379 which do not work with a VFS that uses the pVfs argument passed to
380 sqlite3_vfs methods.
381} -files [
382 test_set $allquicktests -exclude *malloc* *ioerr* *fault* oserror.test \
383 pager1.test syscall.test sysfault.test tkt3457.test quota* superlock* \
384 wal* mmap*
385]
386
dane91a54e2010-06-15 17:44:47 +0000387lappend ::testsuitelist xxx
dan0626dfc2010-06-15 06:56:37 +0000388#-------------------------------------------------------------------------
389# Define the coverage related test suites:
390#
391# coverage-wal
dan0626dfc2010-06-15 06:56:37 +0000392#
393test_suite "coverage-wal" -description {
394 Coverage tests for file wal.c.
395} -files {
danf43d7fc2010-07-03 10:00:00 +0000396 wal.test wal2.test wal3.test walmode.test
397 walbak.test walhook.test walcrash2.test walcksum.test
dan8c408002010-11-01 17:38:24 +0000398 walfault.test walbig.test walnoshm.test
dan28f9b0b2011-02-07 16:24:39 +0000399 wal5.test
dan0626dfc2010-06-15 06:56:37 +0000400}
401
dane91a54e2010-06-15 17:44:47 +0000402test_suite "coverage-pager" -description {
403 Coverage tests for file pager.c.
404} -files {
danf43d7fc2010-07-03 10:00:00 +0000405 pager1.test pager2.test pagerfault.test pagerfault2.test
406 walfault.test walbak.test journal2.test tkt-9d68c883.test
dane91a54e2010-06-15 17:44:47 +0000407}
dan0626dfc2010-06-15 06:56:37 +0000408
danb49d1042013-09-02 18:58:11 +0000409test_suite "coverage-analyze" -description {
410 Coverage tests for file analyze.c.
411} -files {
412 analyze3.test analyze4.test analyze5.test analyze6.test
413 analyze7.test analyze8.test analyze9.test analyzeA.test
danaf0d8bc2013-09-04 16:38:42 +0000414 analyze.test analyzeB.test mallocA.test
danb49d1042013-09-02 18:58:11 +0000415}
416
dan0d51def2014-05-03 14:28:14 +0000417test_suite "coverage-sorter" -description {
418 Coverage tests for file vdbesort.c.
419} -files {
420 sort.test sortfault.test
421}
422
dan0626dfc2010-06-15 06:56:37 +0000423
dane91a54e2010-06-15 17:44:47 +0000424lappend ::testsuitelist xxx
dan0626dfc2010-06-15 06:56:37 +0000425#-------------------------------------------------------------------------
426# Define the permutation test suites:
427#
danielk19771077e3f2008-06-21 18:07:37 +0000428
429# Run some tests using pre-allocated page and scratch blocks.
430#
dan4c5aeec2013-05-16 19:15:07 +0000431# mmap1.test is excluded because a good number of its tests depend on
432# the page-cache being larger than the database. But this permutation
433# causes the effective limit on the page-cache to be just 24 pages.
434#
dan0626dfc2010-06-15 06:56:37 +0000435test_suite "memsubsys1" -description {
danielk19771077e3f2008-06-21 18:07:37 +0000436 Tests using pre-allocated page and scratch blocks
dan0626dfc2010-06-15 06:56:37 +0000437} -files [
dan4c5aeec2013-05-16 19:15:07 +0000438 test_set $::allquicktests -exclude ioerr5.test malloc5.test mmap1.test
dan0626dfc2010-06-15 06:56:37 +0000439] -initialize {
dan03bc5252015-07-24 14:17:17 +0000440 test_set_config_pagecache 4096 24
danielk19771077e3f2008-06-21 18:07:37 +0000441 catch {db close}
442 sqlite3_shutdown
danielk19771077e3f2008-06-21 18:07:37 +0000443 sqlite3_config_scratch 25000 1
444 sqlite3_initialize
drhbb77b752009-04-09 01:23:49 +0000445 autoinstall_test_functions
danielk19771077e3f2008-06-21 18:07:37 +0000446} -shutdown {
dan03bc5252015-07-24 14:17:17 +0000447 test_restore_config_pagecache
danielk19771077e3f2008-06-21 18:07:37 +0000448 catch {db close}
449 sqlite3_shutdown
danielk19771077e3f2008-06-21 18:07:37 +0000450 sqlite3_config_scratch 0 0
451 sqlite3_initialize
drhbb77b752009-04-09 01:23:49 +0000452 autoinstall_test_functions
danielk19771077e3f2008-06-21 18:07:37 +0000453}
454
455# Run some tests using pre-allocated page and scratch blocks. This time
456# the allocations are too small to use in most cases.
457#
danielk197734c61e62008-08-29 12:00:20 +0000458# Both ioerr5.test and malloc5.test are excluded because they test the
459# sqlite3_soft_heap_limit() and sqlite3_release_memory() functionality.
460# This functionality is disabled if a pre-allocated page block is provided.
461#
dan0626dfc2010-06-15 06:56:37 +0000462test_suite "memsubsys2" -description {
danielk19771077e3f2008-06-21 18:07:37 +0000463 Tests using small pre-allocated page and scratch blocks
dan0626dfc2010-06-15 06:56:37 +0000464} -files [
465 test_set $::allquicktests -exclude ioerr5.test malloc5.test
466] -initialize {
dan03bc5252015-07-24 14:17:17 +0000467 test_set_config_pagecache 512 5
drhd63bd752008-07-30 13:15:46 +0000468 catch {db close}
danielk19771077e3f2008-06-21 18:07:37 +0000469 sqlite3_shutdown
danielk19771077e3f2008-06-21 18:07:37 +0000470 sqlite3_config_scratch 1000 1
471 sqlite3_initialize
drhbb77b752009-04-09 01:23:49 +0000472 autoinstall_test_functions
danielk19771077e3f2008-06-21 18:07:37 +0000473} -shutdown {
dan03bc5252015-07-24 14:17:17 +0000474 test_restore_config_pagecache
danielk19771077e3f2008-06-21 18:07:37 +0000475 catch {db close}
476 sqlite3_shutdown
danielk19771077e3f2008-06-21 18:07:37 +0000477 sqlite3_config_scratch 0 0
478 sqlite3_initialize
drhbb77b752009-04-09 01:23:49 +0000479 autoinstall_test_functions
danielk19771077e3f2008-06-21 18:07:37 +0000480}
481
drhe2a7c6e2008-08-01 15:06:30 +0000482# Run all tests with the lookaside allocator disabled.
483#
dan0626dfc2010-06-15 06:56:37 +0000484test_suite "nolookaside" -description {
drhe2a7c6e2008-08-01 15:06:30 +0000485 OOM tests with lookaside disabled
drhe2a7c6e2008-08-01 15:06:30 +0000486} -initialize {
487 catch {db close}
488 sqlite3_shutdown
489 sqlite3_config_lookaside 0 0
490 sqlite3_initialize
drhbb77b752009-04-09 01:23:49 +0000491 autoinstall_test_functions
drhe2a7c6e2008-08-01 15:06:30 +0000492} -shutdown {
493 catch {db close}
494 sqlite3_shutdown
495 sqlite3_config_lookaside 100 500
496 sqlite3_initialize
drhbb77b752009-04-09 01:23:49 +0000497 autoinstall_test_functions
dan0626dfc2010-06-15 06:56:37 +0000498} -files $::allquicktests
drhe2a7c6e2008-08-01 15:06:30 +0000499
danielk19771077e3f2008-06-21 18:07:37 +0000500# Run some tests in SQLITE_CONFIG_SINGLETHREAD mode.
501#
dan0626dfc2010-06-15 06:56:37 +0000502test_suite "singlethread" -description {
danielk19771077e3f2008-06-21 18:07:37 +0000503 Tests run in SQLITE_CONFIG_SINGLETHREAD mode
504} -initialize {
drh04df18d2009-01-06 14:50:11 +0000505 catch {db close}
506 sqlite3_shutdown
507 catch {sqlite3_config singlethread}
drhbb77b752009-04-09 01:23:49 +0000508 sqlite3_initialize
509 autoinstall_test_functions
dan0626dfc2010-06-15 06:56:37 +0000510} -files {
danielk19771077e3f2008-06-21 18:07:37 +0000511 delete.test delete2.test insert.test rollback.test select1.test
512 select2.test trans.test update.test vacuum.test types.test
513 types2.test types3.test
514} -shutdown {
drh04df18d2009-01-06 14:50:11 +0000515 catch {db close}
516 sqlite3_shutdown
517 catch {sqlite3_config serialized}
drhbb77b752009-04-09 01:23:49 +0000518 sqlite3_initialize
519 autoinstall_test_functions
danielk19771077e3f2008-06-21 18:07:37 +0000520}
521
dan0626dfc2010-06-15 06:56:37 +0000522test_suite "nomutex" -description {
drh039963a2008-09-03 00:43:15 +0000523 Tests run with the SQLITE_OPEN_MULTITHREADED flag passed to sqlite3_open().
danielk19779a6284c2008-07-10 17:52:49 +0000524} -initialize {
525 rename sqlite3 sqlite3_nomutex
526 proc sqlite3 {args} {
527 if {[string range [lindex $args 0] 0 0] ne "-"} {
drhcc91e7f2008-09-03 01:08:00 +0000528 lappend args -fullmutex 0 -nomutex 1
danielk19779a6284c2008-07-10 17:52:49 +0000529 }
530 uplevel [concat sqlite3_nomutex $args]
531 }
dan0626dfc2010-06-15 06:56:37 +0000532} -files {
danielk19779a6284c2008-07-10 17:52:49 +0000533 delete.test delete2.test insert.test rollback.test select1.test
534 select2.test trans.test update.test vacuum.test types.test
535 types2.test types3.test
536} -shutdown {
537 rename sqlite3 {}
538 rename sqlite3_nomutex sqlite3
539}
540
danielk19771077e3f2008-06-21 18:07:37 +0000541# Run some tests in SQLITE_CONFIG_MULTITHREAD mode.
542#
dan0626dfc2010-06-15 06:56:37 +0000543test_suite "multithread" -description {
danielk19771077e3f2008-06-21 18:07:37 +0000544 Tests run in SQLITE_CONFIG_MULTITHREAD mode
545} -initialize {
drh04df18d2009-01-06 14:50:11 +0000546 catch {db close}
547 sqlite3_shutdown
548 catch {sqlite3_config multithread}
drhbb77b752009-04-09 01:23:49 +0000549 sqlite3_initialize
550 autoinstall_test_functions
dan0626dfc2010-06-15 06:56:37 +0000551} -files {
danielk19771077e3f2008-06-21 18:07:37 +0000552 delete.test delete2.test insert.test rollback.test select1.test
553 select2.test trans.test update.test vacuum.test types.test
dandfea4532014-05-06 15:38:07 +0000554 types2.test types3.test sort4.test
danielk19771077e3f2008-06-21 18:07:37 +0000555} -shutdown {
drh04df18d2009-01-06 14:50:11 +0000556 catch {db close}
557 sqlite3_shutdown
558 catch {sqlite3_config serialized}
drhbb77b752009-04-09 01:23:49 +0000559 sqlite3_initialize
560 autoinstall_test_functions
danielk19771077e3f2008-06-21 18:07:37 +0000561}
562
drh039963a2008-09-03 00:43:15 +0000563# Run some tests in SQLITE_OPEN_FULLMUTEX mode.
564#
dan0626dfc2010-06-15 06:56:37 +0000565test_suite "fullmutex" -description {
drh039963a2008-09-03 00:43:15 +0000566 Tests run in SQLITE_OPEN_FULLMUTEX mode
567} -initialize {
568 rename sqlite3 sqlite3_fullmutex
569 proc sqlite3 {args} {
570 if {[string range [lindex $args 0] 0 0] ne "-"} {
drhcc91e7f2008-09-03 01:08:00 +0000571 lappend args -nomutex 0 -fullmutex 1
drh039963a2008-09-03 00:43:15 +0000572 }
573 uplevel [concat sqlite3_fullmutex $args]
574 }
dan0626dfc2010-06-15 06:56:37 +0000575} -files {
drh039963a2008-09-03 00:43:15 +0000576 delete.test delete2.test insert.test rollback.test select1.test
577 select2.test trans.test update.test vacuum.test types.test
578 types2.test types3.test
579} -shutdown {
580 rename sqlite3 {}
581 rename sqlite3_fullmutex sqlite3
582}
583
danielk19771077e3f2008-06-21 18:07:37 +0000584# Run some tests using the "onefile" demo.
585#
dan0626dfc2010-06-15 06:56:37 +0000586test_suite "onefile" -description {
danielk19771077e3f2008-06-21 18:07:37 +0000587 Run some tests using the "test_onefile.c" demo
588} -initialize {
589 rename sqlite3 sqlite3_onefile
590 proc sqlite3 {args} {
591 if {[string range [lindex $args 0] 0 0] ne "-"} {
592 lappend args -vfs fs
593 }
594 uplevel [concat sqlite3_onefile $args]
595 }
dan0626dfc2010-06-15 06:56:37 +0000596} -files {
danielk19771077e3f2008-06-21 18:07:37 +0000597 conflict.test insert.test insert2.test insert3.test
598 rollback.test select1.test select2.test select3.test
danielk19771077e3f2008-06-21 18:07:37 +0000599} -shutdown {
600 rename sqlite3 {}
601 rename sqlite3_onefile sqlite3
602}
603
604# Run some tests using UTF-16 databases.
605#
dan0626dfc2010-06-15 06:56:37 +0000606test_suite "utf16" -description {
danielk19771077e3f2008-06-21 18:07:37 +0000607 Run tests using UTF-16 databases
danielk19772dd6d802008-06-21 19:10:27 +0000608} -presql {
danielk19771077e3f2008-06-21 18:07:37 +0000609 pragma encoding = 'UTF-16'
dan0626dfc2010-06-15 06:56:37 +0000610} -files {
danielk19771077e3f2008-06-21 18:07:37 +0000611 alter.test alter3.test
dan22d73b12013-08-16 14:48:23 +0000612 analyze.test analyze3.test analyze4.test analyze5.test analyze6.test
dan8ff2d952013-09-05 18:40:29 +0000613 analyze7.test analyze8.test analyze9.test analyzeA.test analyzeB.test
danielk19771077e3f2008-06-21 18:07:37 +0000614 auth.test bind.test blob.test capi2.test capi3.test collate1.test
615 collate2.test collate3.test collate4.test collate5.test collate6.test
616 conflict.test date.test delete.test expr.test fkey1.test func.test
617 hook.test index.test insert2.test insert.test interrupt.test in.test
618 intpkey.test ioerr.test join2.test join.test lastinsert.test
619 laststmtchanges.test limit.test lock2.test lock.test main.test
620 memdb.test minmax.test misc1.test misc2.test misc3.test notnull.test
621 null.test progress.test quote.test rowid.test select1.test select2.test
622 select3.test select4.test select5.test select6.test sort.test
623 subselect.test tableapi.test table.test temptable.test
624 trace.test trigger1.test trigger2.test trigger3.test
625 trigger4.test types2.test types.test unique.test update.test
626 vacuum.test view.test where.test
danb78b83a2016-03-02 17:57:53 +0000627 bestindex1.test
danielk19771077e3f2008-06-21 18:07:37 +0000628}
629
630# Run some tests in exclusive locking mode.
631#
dan0626dfc2010-06-15 06:56:37 +0000632test_suite "exclusive" -description {
danielk19771077e3f2008-06-21 18:07:37 +0000633 Run tests in exclusive locking mode.
634} -presql {
635 pragma locking_mode = 'exclusive'
dan0626dfc2010-06-15 06:56:37 +0000636} -files {
danielk19771077e3f2008-06-21 18:07:37 +0000637 rollback.test select1.test select2.test
638 malloc.test ioerr.test
639}
640
drh04335882008-09-26 21:08:08 +0000641# Run some tests in exclusive locking mode with truncated journals.
642#
dan0626dfc2010-06-15 06:56:37 +0000643test_suite "exclusive-truncate" -description {
drh04335882008-09-26 21:08:08 +0000644 Run tests in exclusive locking mode and truncate journal mode.
645} -presql {
646 pragma locking_mode = 'exclusive';
647 pragma journal_mode = TRUNCATE;
dan0626dfc2010-06-15 06:56:37 +0000648} -files {
drh04335882008-09-26 21:08:08 +0000649 delete.test delete2.test insert.test rollback.test select1.test
650 select2.test update.test malloc.test ioerr.test
651}
652
danielk19771077e3f2008-06-21 18:07:37 +0000653# Run some tests in persistent journal mode.
654#
dan0626dfc2010-06-15 06:56:37 +0000655test_suite "persistent_journal" -description {
danielk19771077e3f2008-06-21 18:07:37 +0000656 Run tests in persistent-journal mode.
657} -presql {
658 pragma journal_mode = persist
dan0626dfc2010-06-15 06:56:37 +0000659} -files {
danielk19771077e3f2008-06-21 18:07:37 +0000660 delete.test delete2.test insert.test rollback.test select1.test
661 select2.test trans.test update.test vacuum.test
662}
663
drh04335882008-09-26 21:08:08 +0000664# Run some tests in truncating journal mode.
665#
dan0626dfc2010-06-15 06:56:37 +0000666test_suite "truncate_journal" -description {
drh04335882008-09-26 21:08:08 +0000667 Run tests in persistent-journal mode.
668} -presql {
669 pragma journal_mode = truncate
dan0626dfc2010-06-15 06:56:37 +0000670} -files {
drh04335882008-09-26 21:08:08 +0000671 delete.test delete2.test insert.test rollback.test select1.test
672 select2.test trans.test update.test vacuum.test
673 malloc.test ioerr.test
674}
675
danielk19771077e3f2008-06-21 18:07:37 +0000676# Run some error tests in persistent journal mode.
677#
dan0626dfc2010-06-15 06:56:37 +0000678test_suite "persistent_journal_error" -description {
danielk19771077e3f2008-06-21 18:07:37 +0000679 Run malloc.test and ioerr.test in persistent-journal mode.
680} -presql {
681 pragma journal_mode = persist
dan0626dfc2010-06-15 06:56:37 +0000682} -files {
danielk19771077e3f2008-06-21 18:07:37 +0000683 malloc.test ioerr.test
684}
685
686# Run some tests in no journal mode.
687#
dan0626dfc2010-06-15 06:56:37 +0000688test_suite "no_journal" -description {
danielk19771077e3f2008-06-21 18:07:37 +0000689 Run tests in no-journal mode.
690} -presql {
691 pragma journal_mode = persist
dan0626dfc2010-06-15 06:56:37 +0000692} -files {
danielk19771077e3f2008-06-21 18:07:37 +0000693 delete.test delete2.test insert.test rollback.test select1.test
694 select2.test trans.test update.test vacuum.test
695}
696
697# Run some error tests in no journal mode.
698#
dan0626dfc2010-06-15 06:56:37 +0000699test_suite "no_journal_error" -description {
danielk19771077e3f2008-06-21 18:07:37 +0000700 Run malloc.test and ioerr.test in no-journal mode.
701} -presql {
702 pragma journal_mode = persist
dan0626dfc2010-06-15 06:56:37 +0000703} -files {
danielk19771077e3f2008-06-21 18:07:37 +0000704 malloc.test ioerr.test
705}
706
707# Run some crash-tests in autovacuum mode.
708#
dan0626dfc2010-06-15 06:56:37 +0000709test_suite "autovacuum_crash" -description {
danielk19771077e3f2008-06-21 18:07:37 +0000710 Run crash.test in autovacuum mode.
711} -presql {
712 pragma auto_vacuum = 1
dan0626dfc2010-06-15 06:56:37 +0000713} -files crash.test
danielk19771077e3f2008-06-21 18:07:37 +0000714
715# Run some ioerr-tests in autovacuum mode.
716#
dan0626dfc2010-06-15 06:56:37 +0000717test_suite "autovacuum_ioerr" -description {
danielk19771077e3f2008-06-21 18:07:37 +0000718 Run ioerr.test in autovacuum mode.
719} -presql {
720 pragma auto_vacuum = 1
dan0626dfc2010-06-15 06:56:37 +0000721} -files ioerr.test
danielk19771077e3f2008-06-21 18:07:37 +0000722
danielk1977b3175382008-10-17 18:51:52 +0000723# Run tests with an in-memory journal.
724#
dan0626dfc2010-06-15 06:56:37 +0000725test_suite "inmemory_journal" -description {
danielk1977b3175382008-10-17 18:51:52 +0000726 Run tests with an in-memory journal file.
727} -presql {
728 pragma journal_mode = 'memory'
dan0626dfc2010-06-15 06:56:37 +0000729} -files [test_set $::allquicktests -exclude {
danielk1977b3175382008-10-17 18:51:52 +0000730 # Exclude all tests that simulate IO errors.
drh85979cd2015-11-04 13:03:36 +0000731 autovacuum_ioerr2.test cffault.test incrvacuum_ioerr.test ioerr.test
danielk1977b3175382008-10-17 18:51:52 +0000732 ioerr.test ioerr2.test ioerr3.test ioerr4.test ioerr5.test
drh2206a2b2009-04-01 23:09:43 +0000733 vacuum3.test incrblob_err.test diskfull.test backup_ioerr.test
shanehc3b84832010-07-09 19:32:28 +0000734 e_fts3.test fts3cov.test fts3malloc.test fts3rnd.test
dan14cee382016-04-28 14:54:54 +0000735 fts3snippet.test mmapfault.test sessionfault.test sessionfault2.test
danielk1977b3175382008-10-17 18:51:52 +0000736
737 # Exclude test scripts that use tcl IO to access journal files or count
738 # the number of fsync() calls.
739 pager.test exclusive.test jrnlmode.test sync.test misc1.test
danielk1977cb257902009-04-10 18:32:29 +0000740 journal1.test conflict.test crash8.test tkt3457.test io.test
drh8b0228f2011-08-02 20:14:55 +0000741 journal3.test 8_3_names.test
dan01d38562010-03-08 10:32:38 +0000742
dancb354602010-07-08 09:44:42 +0000743 pager1.test async4.test corrupt.test filefmt.test pager2.test
744 corrupt5.test corruptA.test pageropt.test
745
dan01d38562010-03-08 10:32:38 +0000746 # Exclude stmt.test, which expects sub-journals to use temporary files.
drh85979cd2015-11-04 13:03:36 +0000747 stmt.test symlink.test
drh0b944132010-05-24 20:24:38 +0000748
dan6b4e9a82012-01-13 10:51:52 +0000749 zerodamage.test
750
drh0b944132010-05-24 20:24:38 +0000751 # WAL mode is different.
drhb5a2d552015-05-29 15:15:40 +0000752 wal* tkt-2d1a5c67d.test backcompat.test e_wal* rowallock.test
danee7de912016-05-16 14:35:15 +0000753
754 # This test does not work as the "PRAGMA journal_mode = memory"
755 # statement switches the database out of wal mode at inopportune
756 # times.
757 snapshot_fault.test
danb3906812016-09-21 17:47:59 +0000758
759 # This test assumes a journal file is created on disk.
760 delete_db.test
dan18b20c92017-02-07 19:36:14 +0000761
762 # This test depends on a successful recovery from the pager error
763 # state. Which is not possible with an in-memory journal
764 fts5fault1.test
dan0626dfc2010-06-15 06:56:37 +0000765}]
danielk1977b3175382008-10-17 18:51:52 +0000766
danielk19776b39c2e2008-06-25 14:57:53 +0000767ifcapable mem3 {
dan0626dfc2010-06-15 06:56:37 +0000768 test_suite "memsys3" -description {
danielk19776b39c2e2008-06-25 14:57:53 +0000769 Run tests using the allocator in mem3.c.
daneace5272010-07-05 05:31:48 +0000770 } -files [test_set $::allquicktests -exclude {
drh8a42cbd2008-07-10 18:13:42 +0000771 autovacuum.test delete3.test manydb.test
772 bigrow.test incrblob2.test memdb.test
773 bitvec.test index2.test memsubsys1.test
774 capi3c.test ioerr.test memsubsys2.test
775 capi3.test join3.test pagesize.test
danielk19778b322822009-07-01 18:09:01 +0000776 collate5.test limit.test backup_ioerr.test
777 backup_malloc.test
dan0626dfc2010-06-15 06:56:37 +0000778 }] -initialize {
danielk19776b39c2e2008-06-25 14:57:53 +0000779 catch {db close}
780 sqlite3_reset_auto_extension
781 sqlite3_shutdown
drh7830cd42008-07-16 12:25:32 +0000782 sqlite3_config_heap 25000000 0
drhe2a7c6e2008-08-01 15:06:30 +0000783 sqlite3_config_lookaside 0 0
danielk19778b322822009-07-01 18:09:01 +0000784 ifcapable mem5 {
785 # If both memsys3 and memsys5 are enabled in the build, the call to
786 # [sqlite3_config_heap] will initialize the system to use memsys5.
787 # The following overrides this preference and installs the memsys3
788 # allocator.
789 sqlite3_install_memsys3
790 }
danielk19776b39c2e2008-06-25 14:57:53 +0000791 install_malloc_faultsim 1
792 sqlite3_initialize
793 autoinstall_test_functions
794 } -shutdown {
795 catch {db close}
danielk19776b39c2e2008-06-25 14:57:53 +0000796 sqlite3_shutdown
danielk19770d84e5b2008-06-27 14:05:24 +0000797 sqlite3_config_heap 0 0
drhe2a7c6e2008-08-01 15:06:30 +0000798 sqlite3_config_lookaside 100 500
danielk19776b39c2e2008-06-25 14:57:53 +0000799 install_malloc_faultsim 1
800 sqlite3_initialize
drhbb77b752009-04-09 01:23:49 +0000801 autoinstall_test_functions
danielk19776b39c2e2008-06-25 14:57:53 +0000802 }
danielk197757e5ea92008-06-24 19:02:55 +0000803}
804
danielk19776b39c2e2008-06-25 14:57:53 +0000805ifcapable mem5 {
dan0626dfc2010-06-15 06:56:37 +0000806 test_suite "memsys5" -description {
danielk19776b39c2e2008-06-25 14:57:53 +0000807 Run tests using the allocator in mem5.c.
daneace5272010-07-05 05:31:48 +0000808 } -files [test_set $::allquicktests -exclude {
drh8a42cbd2008-07-10 18:13:42 +0000809 autovacuum.test delete3.test manydb.test
810 bigrow.test incrblob2.test memdb.test
811 bitvec.test index2.test memsubsys1.test
812 capi3c.test ioerr.test memsubsys2.test
813 capi3.test join3.test pagesize.test
danielk1977ac8d7b32008-11-13 16:21:50 +0000814 collate5.test limit.test zeroblob.test
dan0626dfc2010-06-15 06:56:37 +0000815 }] -initialize {
danielk19776b39c2e2008-06-25 14:57:53 +0000816 catch {db close}
danielk19776b39c2e2008-06-25 14:57:53 +0000817 sqlite3_shutdown
drh7830cd42008-07-16 12:25:32 +0000818 sqlite3_config_heap 25000000 64
drhe2a7c6e2008-08-01 15:06:30 +0000819 sqlite3_config_lookaside 0 0
danielk19775099be52008-06-27 13:27:03 +0000820 install_malloc_faultsim 1
821 sqlite3_initialize
822 autoinstall_test_functions
823 } -shutdown {
824 catch {db close}
danielk19775099be52008-06-27 13:27:03 +0000825 sqlite3_shutdown
danielk19770d84e5b2008-06-27 14:05:24 +0000826 sqlite3_config_heap 0 0
drhe2a7c6e2008-08-01 15:06:30 +0000827 sqlite3_config_lookaside 100 500
danielk19775099be52008-06-27 13:27:03 +0000828 install_malloc_faultsim 1
829 sqlite3_initialize
drhbb77b752009-04-09 01:23:49 +0000830 autoinstall_test_functions
danielk19775099be52008-06-27 13:27:03 +0000831 }
832
dan0626dfc2010-06-15 06:56:37 +0000833 test_suite "memsys5-2" -description {
danielk19775099be52008-06-27 13:27:03 +0000834 Run tests using the allocator in mem5.c in a different configuration.
dan0626dfc2010-06-15 06:56:37 +0000835 } -files {
drh8a42cbd2008-07-10 18:13:42 +0000836 select1.test
danielk19775099be52008-06-27 13:27:03 +0000837 } -initialize {
838 catch {db close}
danielk19775099be52008-06-27 13:27:03 +0000839 sqlite3_shutdown
danb0c6a882010-09-02 10:08:41 +0000840 sqlite3_config_memstatus 0
drh7830cd42008-07-16 12:25:32 +0000841 sqlite3_config_heap 40000000 16
drhe2a7c6e2008-08-01 15:06:30 +0000842 sqlite3_config_lookaside 0 0
danielk19776b39c2e2008-06-25 14:57:53 +0000843 install_malloc_faultsim 1
844 sqlite3_initialize
845 autoinstall_test_functions
846 } -shutdown {
847 catch {db close}
danielk19776b39c2e2008-06-25 14:57:53 +0000848 sqlite3_shutdown
danielk19770d84e5b2008-06-27 14:05:24 +0000849 sqlite3_config_heap 0 0
drhe2a7c6e2008-08-01 15:06:30 +0000850 sqlite3_config_lookaside 100 500
danielk19776b39c2e2008-06-25 14:57:53 +0000851 install_malloc_faultsim 1
852 sqlite3_initialize
drhbb77b752009-04-09 01:23:49 +0000853 autoinstall_test_functions
danielk19776b39c2e2008-06-25 14:57:53 +0000854 }
danielk1977c66c0e12008-06-25 14:26:07 +0000855}
856
drh8a42cbd2008-07-10 18:13:42 +0000857ifcapable threadsafe {
dan0626dfc2010-06-15 06:56:37 +0000858 test_suite "no_mutex_try" -description {
drh8a42cbd2008-07-10 18:13:42 +0000859 The sqlite3_mutex_try() interface always fails
dan0626dfc2010-06-15 06:56:37 +0000860 } -files [
861 test_set $::allquicktests -exclude mutex1.test mutex2.test
862 ] -initialize {
drh8a42cbd2008-07-10 18:13:42 +0000863 catch {db close}
864 sqlite3_shutdown
865 install_mutex_counters 1
866 set ::disable_mutex_try 1
drhbb77b752009-04-09 01:23:49 +0000867 sqlite3_initialize
868 autoinstall_test_functions
drh8a42cbd2008-07-10 18:13:42 +0000869 } -shutdown {
870 catch {db close}
871 sqlite3_shutdown
872 install_mutex_counters 0
drhbb77b752009-04-09 01:23:49 +0000873 sqlite3_initialize
874 autoinstall_test_functions
drh8a42cbd2008-07-10 18:13:42 +0000875 }
876}
877
danielk1977b13dee92008-06-23 15:55:52 +0000878# run_tests "crash_safe_append" -description {
879# Run crash.test with persistent journals on a SAFE_APPEND file-system.
880# } -initialize {
881# rename crashsql sa_crashsql
882# proc crashsql {args} {
883# set options [lrange $args 0 [expr {[llength $args]-2}]]
884# lappend options -char safe_append
885# set sql [lindex $args end]
886# lappend options "
887# PRAGMA journal_mode=persistent;
888# $sql
889# "
890# set fd [open test.db-journal w]
891# puts $fd [string repeat 1234567890 100000]
892# close $fd
893# eval sa_crashsql $options
894# }
895# } -shutdown {
896# rename crashsql {}
897# rename sa_crashsql crashsql
dan0626dfc2010-06-15 06:56:37 +0000898# } -files crash.test
danielk1977b13dee92008-06-23 15:55:52 +0000899
dan0626dfc2010-06-15 06:56:37 +0000900test_suite "safe_append" -description {
danielk1977755339e2008-09-12 10:22:40 +0000901 Run some tests on a SAFE_APPEND file-system.
902} -initialize {
903 rename sqlite3 sqlite3_safeappend
904 proc sqlite3 {args} {
905 if {[string range [lindex $args 0] 0 0] ne "-"} {
906 lappend args -vfs devsym
907 }
908 uplevel [concat sqlite3_safeappend $args]
909 }
910 sqlite3_simulate_device -char safe_append
911} -shutdown {
912 rename sqlite3 {}
913 rename sqlite3_shutdown sqlite3
dan0626dfc2010-06-15 06:56:37 +0000914} -files [
915 test_set $::allquicktests shared_err.test -exclude async3.test
916]
danielk1977755339e2008-09-12 10:22:40 +0000917
drhb232c232008-11-19 01:20:26 +0000918# The set of tests to run on the alternative-pcache
919set perm-alt-pcache-testset {
920 async.test
921 attach.test
922 delete.test delete2.test
923 index.test
924 insert.test insert2.test
925 join.test join2.test
926 rollback.test
927 select1.test select2.test
928 trans.test
929 update.test
930}
931
dan2acd4c62010-07-13 14:22:39 +0000932foreach discard_rate {0 10 50 90 100} {
933 test_suite "pcache${discard_rate}" -description "
934 Alternative pcache implementation with ${discard_rate}% random discard
935 " -initialize "
936 catch {db close}
937 sqlite3_shutdown
938 sqlite3_config_alt_pcache 1 $discard_rate 1
939 sqlite3_initialize
940 autoinstall_test_functions
941 " -shutdown {
942 catch {db close}
943 sqlite3_shutdown
944 sqlite3_config_alt_pcache 0 0 0
945 sqlite3_config_lookaside 100 500
946 install_malloc_faultsim 1
947 sqlite3_initialize
948 autoinstall_test_functions
949 } -files ${perm-alt-pcache-testset}
950}
danielk1977b13dee92008-06-23 15:55:52 +0000951
dan0626dfc2010-06-15 06:56:37 +0000952test_suite "journaltest" -description {
danielk1977f3107512008-12-22 10:58:46 +0000953 Check that pages are synced before being written (test_journal.c).
954} -initialize {
danielk1977f3107512008-12-22 10:58:46 +0000955 catch {db close}
956 register_jt_vfs -default ""
957} -shutdown {
958 unregister_jt_vfs
dan0626dfc2010-06-15 06:56:37 +0000959} -files [test_set $::allquicktests -exclude {
960 wal* incrvacuum.test ioerr.test corrupt4.test io.test crash8.test
dan05accd22016-04-27 18:54:49 +0000961 async4.test bigfile.test backcompat.test e_wal* fstat.test mmap2.test
962 pager1.test syscall.test tkt3457.test *malloc* mmap* multiplex* nolock*
963 pager2.test *fault* rowal* snapshot* superlock* symlink.test
danb3906812016-09-21 17:47:59 +0000964 delete_db.test
drhfb4a6262010-05-06 19:55:57 +0000965}]
danielk1977f3107512008-12-22 10:58:46 +0000966
dan0a7a9152010-04-07 07:57:38 +0000967if {[info commands register_demovfs] != ""} {
dan0626dfc2010-06-15 06:56:37 +0000968 test_suite "demovfs" -description {
dan430e74c2010-06-07 17:47:26 +0000969 Check that the demovfs (code in test_demovfs.c) more or less works.
dan0a7a9152010-04-07 07:57:38 +0000970 } -initialize {
971 register_demovfs
972 } -shutdown {
973 unregister_demovfs
dan0626dfc2010-06-15 06:56:37 +0000974 } -files {
dan0a7a9152010-04-07 07:57:38 +0000975 insert.test insert2.test insert3.test rollback.test
976 select1.test select2.test select3.test
977 }
978}
979
dan0626dfc2010-06-15 06:56:37 +0000980test_suite "wal" -description {
dan71cb5182010-04-26 12:39:03 +0000981 Run tests with journal_mode=WAL
dan31f98fc2010-04-27 05:42:32 +0000982} -initialize {
dan430e74c2010-06-07 17:47:26 +0000983 set ::G(savepoint6_iterations) 100
dan31f98fc2010-04-27 05:42:32 +0000984} -shutdown {
dan430e74c2010-06-07 17:47:26 +0000985 unset -nocomplain ::G(savepoint6_iterations)
dan0626dfc2010-06-15 06:56:37 +0000986} -files {
dane106de62010-04-27 06:49:34 +0000987 savepoint.test savepoint2.test savepoint6.test
988 trans.test avtrans.test
dan60f9da72010-07-07 11:42:59 +0000989
990 fts3aa.test fts3ab.test fts3ac.test fts3ad.test
991 fts3ae.test fts3af.test fts3ag.test fts3ah.test
992 fts3ai.test fts3aj.test fts3ak.test fts3al.test
993 fts3am.test fts3an.test fts3ao.test fts3b.test
994 fts3c.test fts3d.test fts3e.test fts3query.test
dan71cb5182010-04-26 12:39:03 +0000995}
dan897230e2010-08-26 14:15:37 +0000996
997test_suite "rtree" -description {
998 All R-tree related tests. Provides coverage of source file rtree.c.
999} -files [glob -nocomplain $::testdir/../ext/rtree/*.test]
1000
dan7cf7df72011-03-19 15:37:02 +00001001test_suite "session" -description {
1002 All session module related tests.
1003} -files [glob -nocomplain $::testdir/../ext/session/*.test]
1004
dan35e28582013-07-02 20:23:40 +00001005test_suite "session_eec" -description {
1006 All session module related tests with sqlite3_extended_result_codes() set.
1007} -files [
1008 glob -nocomplain $::testdir/../ext/session/*.test
1009] -dbconfig {
1010 sqlite3_extended_result_codes $::dbhandle 1
1011}
1012
drhf1a08ad2014-09-27 20:45:48 +00001013test_suite "session_strm" -description {
danef7a6302014-09-23 20:39:55 +00001014 All session module related tests using the streaming APIs.
1015} -files [
1016 glob -nocomplain $::testdir/../ext/session/*.test
1017] -dbconfig {
1018 set ::sqlite3session_streams 1
1019}
1020
drhcfb8f8d2015-07-23 20:44:49 +00001021test_suite "rbu" -description {
1022 RBU tests.
dan93fdbfa2014-09-19 18:08:39 +00001023} -files [
drhcfb8f8d2015-07-23 20:44:49 +00001024 test_set [glob -nocomplain $::testdir/../ext/rbu/*.test] -exclude rbu.test
dan93fdbfa2014-09-19 18:08:39 +00001025]
1026
dan1ce1b4a2010-12-07 14:32:28 +00001027test_suite "no_optimization" -description {
1028 Run test scripts with optimizations disabled using the
1029 sqlite3_test_control(SQLITE_TESTCTRL_OPTIMIZATIONS) interface.
1030} -files {
1031 where.test where2.test where3.test where4.test where5.test
1032 where6.test where7.test where8.test where9.test
1033 whereA.test whereB.test wherelimit.test
1034 select1.test select2.test select3.test select4.test select5.test
1035 select7.test select8.test selectA.test selectC.test
1036} -dbconfig {
1037 optimization_control $::dbhandle all 0
1038}
1039
danc431fd52011-06-27 16:55:50 +00001040test_suite "prepare" -description {
1041 Run tests with the db connection using sqlite3_prepare() instead of _v2().
1042} -dbconfig {
1043 db_use_legacy_prepare $::dbhandle 1
1044 #$::dbhandle cache size 0
1045} -files [
1046 test_set $allquicktests -exclude *malloc* *ioerr* *fault*
1047]
1048
danielk19771077e3f2008-06-21 18:07:37 +00001049# End of tests
1050#############################################################################
1051
dan0626dfc2010-06-15 06:56:37 +00001052# run_tests NAME OPTIONS
1053#
1054# where available options are:
1055#
dan2fce9ab2010-06-15 18:00:06 +00001056# -description TITLE
1057# -initialize SCRIPT
1058# -shutdown SCRIPT
1059# -presql SQL
1060# -files LIST-OF-FILES
1061# -prefix NAME
dan0626dfc2010-06-15 06:56:37 +00001062#
1063proc run_tests {name args} {
1064 array set options $args
danielk19771077e3f2008-06-21 18:07:37 +00001065
dand506de02010-07-03 13:59:01 +00001066 set ::G(perm:name) $name
1067 set ::G(perm:prefix) $options(-prefix)
dan0626dfc2010-06-15 06:56:37 +00001068 set ::G(perm:presql) $options(-presql)
1069 set ::G(isquick) 1
dan1ce1b4a2010-12-07 14:32:28 +00001070 set ::G(perm:dbconfig) $options(-dbconfig)
dan0626dfc2010-06-15 06:56:37 +00001071
dan0626dfc2010-06-15 06:56:37 +00001072 foreach file [lsort $options(-files)] {
dan05accd22016-04-27 18:54:49 +00001073 uplevel $options(-initialize)
dan897230e2010-08-26 14:15:37 +00001074 if {[file tail $file] == $file} { set file [file join $::testdir $file] }
1075 slave_test_file $file
dan05accd22016-04-27 18:54:49 +00001076 uplevel $options(-shutdown)
dan0626dfc2010-06-15 06:56:37 +00001077 }
1078
dan0626dfc2010-06-15 06:56:37 +00001079 unset ::G(perm:name)
dand506de02010-07-03 13:59:01 +00001080 unset ::G(perm:prefix)
dan0626dfc2010-06-15 06:56:37 +00001081 unset ::G(perm:presql)
dan1ce1b4a2010-12-07 14:32:28 +00001082 unset ::G(perm:dbconfig)
dan0626dfc2010-06-15 06:56:37 +00001083}
1084
1085proc run_test_suite {name} {
1086 if {[info exists ::testspec($name)]==0} {
1087 error "No such test suite: $name"
1088 }
1089 uplevel run_tests $name $::testspec($name)
1090}
1091
1092proc help {} {
dane91a54e2010-06-15 17:44:47 +00001093 puts "Usage: $::argv0 TESTSUITE ?TESTFILE?"
1094 puts ""
1095 puts "Available test-suites are:"
dan0626dfc2010-06-15 06:56:37 +00001096 foreach k $::testsuitelist {
dane91a54e2010-06-15 17:44:47 +00001097 if {[info exists ::testspec($k)]==0} {
1098 puts " ----------------------------------------"
1099 puts ""
1100 } else {
1101 array set o $::testspec($k)
1102 puts "Test suite: \"$k\""
1103 set d [string trim $o(-description)]
1104 set d [regsub {\n *} $d "\n "]
1105 puts " $d"
1106 puts ""
1107 }
dan0626dfc2010-06-15 06:56:37 +00001108 }
1109 exit -1
1110}
1111
drha5809362016-03-14 21:26:25 +00001112if {[file tail $argv0] == "permutations.test"} {
dan0626dfc2010-06-15 06:56:37 +00001113 proc main {argv} {
1114 if {[llength $argv]==0} {
1115 help
1116 } else {
drha5809362016-03-14 21:26:25 +00001117 set suite [file tail [lindex $argv 0]]
dan0626dfc2010-06-15 06:56:37 +00001118 if {[info exists ::testspec($suite)]==0} help
1119 set extra ""
1120 if {[llength $argv]>1} { set extra [list -files [lrange $argv 1 end]] }
1121 eval run_tests $suite $::testspec($suite) $extra
1122 }
1123 }
1124 main $argv
1125 finish_test
1126}