Gitiles
Code Review Sign In
gerrit.openfyde.cn / chromium.googlesource.com / chromium / deps / sqlite / refs/heads/upstream/changesetfuzz / . / test / permutations.test
blob: 6aa812e8af55fd0cf1394e83292ddc97a0d68a53 [file] [log] [blame]
danielk19771077e3f2008-06-21 18:07:37 +0000[diff] [blame]1# 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 +0000[diff] [blame]12
13set testdir [file dirname $argv0]
14source $testdir/tester.tcl
dan13a3cb82010-06-11 19:04:21 +0000[diff] [blame]15db close
danielk19771077e3f2008-06-21 18:07:37 +0000[diff] [blame]16
dan0626dfc2010-06-15 06:56:37 +0000[diff] [blame]17#-------------------------------------------------------------------------
18# test_suite NAME OPTIONS
danielk19771077e3f2008-06-21 18:07:37 +0000[diff] [blame]19#
20# where available options are:
21#
dan430e74c2010-06-07 17:47:26 +0000[diff] [blame]22# -description TITLE (default "")
danielk19771077e3f2008-06-21 18:07:37 +0000[diff] [blame]23# -initialize SCRIPT (default "")
24# -shutdown SCRIPT (default "")
danielk19771077e3f2008-06-21 18:07:37 +0000[diff] [blame]25# -presql SQL (default "")
dan0626dfc2010-06-15 06:56:37 +0000[diff] [blame]26# -files LIST-OF-FILES (default $::ALLTESTS)
dan2fce9ab2010-06-15 18:00:06 +0000[diff] [blame]27# -prefix NAME (default "$::NAME.")
dan1ce1b4a2010-12-07 14:32:28 +0000[diff] [blame]28# -dbconfig SCRIPT (default "")
dan0626dfc2010-06-15 06:56:37 +0000[diff] [blame]29#
30proc test_suite {name args} {
dan430e74c2010-06-07 17:47:26 +0000[diff] [blame]31
dan0626dfc2010-06-15 06:56:37 +0000[diff] [blame]32 set default(-shutdown) ""
33 set default(-initialize) ""
34 set default(-presql) ""
dan430e74c2010-06-07 17:47:26 +0000[diff] [blame]35 set default(-description) "no description supplied (fixme)"
dan2fce9ab2010-06-15 18:00:06 +0000[diff] [blame]36 set default(-files) ""
37 set default(-prefix) "${name}."
dan1ce1b4a2010-12-07 14:32:28 +0000[diff] [blame]38 set default(-dbconfig) ""
dan430e74c2010-06-07 17:47:26 +0000[diff] [blame]39
40 array set options [array get default]
dan0626dfc2010-06-15 06:56:37 +0000[diff] [blame]41 if {[llength $args]%2} {
42 error "uneven number of options/switches passed to test_suite"
dan430e74c2010-06-07 17:47:26 +0000[diff] [blame]43 }
dan0626dfc2010-06-15 06:56:37 +0000[diff] [blame]44 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 +0000[diff] [blame]49 }
danielk19771077e3f2008-06-21 18:07:37 +0000[diff] [blame]50
dan0626dfc2010-06-15 06:56:37 +0000[diff] [blame]51 set ::testspec($name) [array get options]
52 lappend ::testsuitelist $name
53}
dan430e74c2010-06-07 17:47:26 +0000[diff] [blame]54
dan0626dfc2010-06-15 06:56:37 +0000[diff] [blame]55#-------------------------------------------------------------------------
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 +0000[diff] [blame]68 }
dan0626dfc2010-06-15 06:56:37 +0000[diff] [blame]69 } elseif {$isExclude == 0} {
70 foreach f $a { set t($f) 1 }
drh0a846f92008-08-25 17:23:29 +0000[diff] [blame]71 } else {
dan0626dfc2010-06-15 06:56:37 +0000[diff] [blame]72 foreach f $a { array unset t $f }
dan897230e2010-08-26 14:15:37 +0000[diff] [blame]73 foreach f $a { array unset t */$f }
danielk19771077e3f2008-06-21 18:07:37 +0000[diff] [blame]74 }
75 }
76
dan0626dfc2010-06-15 06:56:37 +0000[diff] [blame]77 return [array names t]
danielk19771077e3f2008-06-21 18:07:37 +0000[diff] [blame]78}
79
dan0626dfc2010-06-15 06:56:37 +0000[diff] [blame]80#-------------------------------------------------------------------------
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 +0000[diff] [blame]85# $allquicktests
dan0626dfc2010-06-15 06:56:37 +0000[diff] [blame]86#
dan0626dfc2010-06-15 06:56:37 +0000[diff] [blame]87set alltests [list]
88foreach f [glob $testdir/*.test] { lappend alltests [file tail $f] }
dan518e3f02017-10-11 20:26:07 +0000[diff] [blame]89foreach f [glob -nocomplain \
90 $testdir/../ext/rtree/*.test \
dane82126c2016-03-01 16:02:57 +0000[diff] [blame]91 $testdir/../ext/fts5/test/*.test \
dan518e3f02017-10-11 20:26:07 +0000[diff] [blame]92 $testdir/../ext/expert/*.test \
dan4b8035e2017-07-14 11:40:48 +0000[diff] [blame]93 $testdir/../ext/lsm1/test/*.test \
94] {
dan897230e2010-08-26 14:15:37 +0000[diff] [blame]95 lappend alltests $f
96}
dan7cf7df72011-03-19 15:37:02 +0000[diff] [blame]97foreach f [glob -nocomplain $testdir/../ext/session/*.test] {
98 lappend alltests $f
99}
dan897230e2010-08-26 14:15:37 +0000[diff] [blame]100
dan0626dfc2010-06-15 06:56:37 +0000[diff] [blame]101if {$::tcl_platform(platform)!="unix"} {
102 set alltests [test_set $alltests -exclude crash.test crash2.test]
danielk1977c1def3e2008-08-30 13:25:10 +0000[diff] [blame]103}
dan0626dfc2010-06-15 06:56:37 +0000[diff] [blame]104set alltests [test_set $alltests -exclude {
105 all.test async.test quick.test veryquick.test
106 memleak.test permutations.test soak.test fts3.test
drh905da632015-06-10 18:53:09 +0000[diff] [blame]107 mallocAll.test rtree.test full.test extraquick.test
mistachkin1e8487d2018-07-22 06:25:35 +0000[diff] [blame]108 session.test rbu.test
dan0626dfc2010-06-15 06:56:37 +0000[diff] [blame]109}]
110
111set allquicktests [test_set $alltests -exclude {
112 async2.test async3.test backup_ioerr.test corrupt.test
113 corruptC.test crash.test crash2.test crash3.test crash4.test crash5.test
114 crash6.test crash7.test delete3.test e_fts3.test fts3rnd.test
115 fkey_malloc.test fuzz.test fuzz3.test fuzz_malloc.test in2.test loadext.test
dan273f3f02010-06-26 15:42:33 +0000[diff] [blame]116 misc7.test mutex2.test notify2.test onefile.test pagerfault2.test
dan0626dfc2010-06-15 06:56:37 +0000[diff] [blame]117 savepoint4.test savepoint6.test select9.test
118 speed1.test speed1p.test speed2.test speed3.test speed4.test
119 speed4p.test sqllimits1.test tkt2686.test thread001.test thread002.test
120 thread003.test thread004.test thread005.test trans2.test vacuum3.test
121 incrvacuum_ioerr.test autovacuum_crash.test btree8.test shared_err.test
dan533100d2011-12-17 08:10:34 +0000[diff] [blame]122 vtab_err.test walslow.test walcrash.test walcrash3.test
dan2aba5d92012-08-07 17:41:50 +0000[diff] [blame]123 walthread.test rtree3.test indexfault.test securedel2.test
drhdb2f9192014-05-19 23:17:33 +0000[diff] [blame]124 sort3.test sort4.test fts4growth.test fts4growth2.test
mistachkin84178632018-07-22 21:08:35 +0000[diff] [blame]125 bigsort.test walprotocol.test mmap4.test fuzzer2.test
danbe7721d2016-02-04 17:31:03 +0000[diff] [blame]126 walcrash2.test e_fkey.test backup.test
127
128 fts4merge.test fts4merge2.test fts4merge4.test fts4check.test
129 fts3cov.test fts3snippet.test fts3corrupt2.test fts3an.test
130 fts3defer.test fts4langid.test fts3sort.test fts5unicode.test
131
132 rtree4.test
dan0626dfc2010-06-15 06:56:37 +0000[diff] [blame]133}]
dan63109902010-07-05 05:54:55 +0000[diff] [blame]134if {[info exists ::env(QUICKTEST_INCLUDE)]} {
135 set allquicktests [concat $allquicktests $::env(QUICKTEST_INCLUDE)]
136}
drh4081d5d2015-01-01 23:02:01 +0000[diff] [blame]137if {[info exists ::env(QUICKTEST_OMIT)]} {
138 foreach x [split $::env(QUICKTEST_OMIT) ,] {
139 regsub -all \\y$x\\y $allquicktests {} allquicktests
140 }
141}
danielk1977c1def3e2008-08-30 13:25:10 +0000[diff] [blame]142
drhedb31cd2015-01-08 02:15:11 +0000[diff] [blame]143# If the TEST_FAILURE environment variable is set, it means that we what to
144# deliberately provoke test failures in order to test the test infrastructure.
145# Only the main.test module is needed for this.
146#
147if {[info exists ::env(TEST_FAILURE)]} {
148 set allquicktests main.test
149}
drhd63bd752008-07-30 13:15:46 +0000[diff] [blame]150
danielk19771077e3f2008-06-21 18:07:37 +0000[diff] [blame]151#############################################################################
152# Start of tests
dan0626dfc2010-06-15 06:56:37 +0000[diff] [blame]153#
154
155#-------------------------------------------------------------------------
156# Define the generic test suites:
157#
158# veryquick
159# quick
160# full
dan0626dfc2010-06-15 06:56:37 +0000[diff] [blame]161#
dane91a54e2010-06-15 17:44:47 +0000[diff] [blame]162lappend ::testsuitelist xxx
dan0626dfc2010-06-15 06:56:37 +0000[diff] [blame]163
dan2fce9ab2010-06-15 18:00:06 +0000[diff] [blame]164test_suite "veryquick" -prefix "" -description {
drh905da632015-06-10 18:53:09 +0000[diff] [blame]165 "Very" quick test suite. Runs in minutes on a workstation.
dan0626dfc2010-06-15 06:56:37 +0000[diff] [blame]166 This test suite is the same as the "quick" tests, except that some files
167 that test malloc and IO errors are omitted.
168} -files [
dane82126c2016-03-01 16:02:57 +0000[diff] [blame]169 test_set $allquicktests -exclude *malloc* *ioerr* *fault* *bigfile* *_err* \
danb6e9f7a2018-05-19 14:15:29 +0000[diff] [blame]170 *fts5corrupt* *fts5big* *fts5aj*
drh905da632015-06-10 18:53:09 +0000[diff] [blame]171]
172
173test_suite "extraquick" -prefix "" -description {
174 "Extra" quick test suite. Runs in a few minutes on a workstation.
175 This test suite is the same as the "veryquick" tests, except that
176 slower tests are omitted.
177} -files [
danbe7721d2016-02-04 17:31:03 +0000[diff] [blame]178 test_set $allquicktests -exclude *malloc* *ioerr* *fault* *bigfile* *_err* \
drh905da632015-06-10 18:53:09 +0000[diff] [blame]179 wal3.test fts4merge* sort2.test mmap1.test walcrash* \
180 percentile.test where8m.test walcksum.test savepoint3.test \
181 fuzzer1.test fuzzer3.test fts3expr3.test
dan0626dfc2010-06-15 06:56:37 +0000[diff] [blame]182]
183
drh9b4c59f2013-04-15 17:03:42 +0000[diff] [blame]184test_suite "mmap" -prefix "mm-" -description {
dane895b872014-12-31 09:52:15 +0000[diff] [blame]185 Similar to veryquick. Except with memory mapping enabled.
dan5d8a1372013-03-19 19:28:06 +0000[diff] [blame]186} -presql {
drh9b4c59f2013-04-15 17:03:42 +0000[diff] [blame]187 pragma mmap_size = 268435456;
dan5d8a1372013-03-19 19:28:06 +0000[diff] [blame]188} -files [
dan23f8a7c2014-12-31 18:08:46 +0000[diff] [blame]189 test_set $allquicktests -exclude *malloc* *ioerr* *fault* -include malloc.test
dan0626dfc2010-06-15 06:56:37 +0000[diff] [blame]190]
191
dan25568442010-12-03 10:32:06 +0000[diff] [blame]192test_suite "valgrind" -prefix "" -description {
193 Run the "veryquick" test suite with a couple of multi-process tests (that
194 fail under valgrind) omitted.
195} -files [
danbe7721d2016-02-04 17:31:03 +0000[diff] [blame]196 test_set $allquicktests -exclude *malloc* *ioerr* *fault* *_err* wal.test \
drh64134662015-01-08 22:08:57 +0000[diff] [blame]197 shell*.test crash8.test atof1.test selectG.test \
danf2f72a02017-10-19 15:17:38 +0000[diff] [blame]198 tkt-fc62af4523.test numindex1.test corruptK.test
dan25568442010-12-03 10:32:06 +0000[diff] [blame]199] -initialize {
200 set ::G(valgrind) 1
201} -shutdown {
202 unset -nocomplain ::G(valgrind)
203}
204
dan5f438122014-06-02 09:39:24 +0000[diff] [blame]205test_suite "valgrind-nolookaside" -prefix "" -description {
206 Run the "veryquick" test suite with a couple of multi-process tests (that
207 fail under valgrind) omitted.
208} -files [
danbe7721d2016-02-04 17:31:03 +0000[diff] [blame]209 test_set $allquicktests -exclude *malloc* *ioerr* *fault* *_err* \
210 wal.test atof1.test
dan5f438122014-06-02 09:39:24 +0000[diff] [blame]211] -initialize {
212 set ::G(valgrind) 1
213 catch {db close}
214 sqlite3_shutdown
215 sqlite3_config_lookaside 0 0
216 sqlite3_initialize
217 autoinstall_test_functions
218} -shutdown {
219 catch {db close}
220 sqlite3_shutdown
221 sqlite3_config_lookaside 100 500
222 sqlite3_initialize
223 autoinstall_test_functions
224 unset -nocomplain ::G(valgrind)
225}
226
227
dan2fce9ab2010-06-15 18:00:06 +0000[diff] [blame]228test_suite "quick" -prefix "" -description {
dan0626dfc2010-06-15 06:56:37 +0000[diff] [blame]229 Quick test suite. Runs in around 10 minutes on a workstation.
230} -files [
231 test_set $allquicktests
232]
233
dan2fce9ab2010-06-15 18:00:06 +0000[diff] [blame]234test_suite "full" -prefix "" -description {
dan0626dfc2010-06-15 06:56:37 +0000[diff] [blame]235 Full test suite. Takes a long time.
236} -files [
237 test_set $alltests
238] -initialize {
239 unset -nocomplain ::G(isquick)
240}
241
danea5542d2010-07-06 11:26:15 +0000[diff] [blame]242test_suite "threads" -prefix "" -description {
243 All multi-threaded tests.
244} -files {
245 notify2.test thread001.test thread002.test thread003.test
246 thread004.test thread005.test walthread.test
247}
248
dana69f7d52010-07-19 11:16:36 +0000[diff] [blame]249test_suite "fts3" -prefix "" -description {
danddf80eb2010-10-25 12:47:43 +0000[diff] [blame]250 All FTS3 tests except fts3rnd.test.
dana69f7d52010-07-19 11:16:36 +0000[diff] [blame]251} -files {
dan119fc112017-03-21 17:19:31 +0000[diff] [blame]252 fts3aa.test fts3ab.test fts3ac.test fts3ad.test
253 fts3ae.test fts3af.test fts3ag.test fts3ah.test
254 fts3ai.test fts3aj.test fts3ak.test fts3al.test
255 fts3am.test fts3an.test fts3ao.test fts3atoken.test
256 fts3auto.test fts3aux1.test fts3aux2.test fts3b.test
257 fts3comp1.test fts3conf.test fts3corrupt2.test fts3corrupt.test
dan29d77dc2018-11-03 16:51:30 +0000[diff] [blame]258 fts3corrupt4.test
dan119fc112017-03-21 17:19:31 +0000[diff] [blame]259 fts3cov.test fts3c.test fts3defer2.test fts3defer3.test
260 fts3defer.test fts3drop.test fts3d.test fts3e.test
261 fts3expr2.test fts3expr3.test fts3expr4.test fts3expr5.test
262 fts3expr.test fts3fault2.test fts3fault.test fts3first.test
263 fts3join.test fts3malloc.test fts3matchinfo.test fts3near.test
264 fts3offsets.test fts3prefix2.test fts3prefix.test fts3query.test
265 fts3shared.test fts3snippet.test fts3sort.test fts3tok1.test
266 fts3tok_err.test fts3varint.test fts4aa.test fts4check.test
267 fts4content.test fts4docid.test fts4growth2.test fts4growth.test
268 fts4incr.test fts4langid.test fts4lastrowid.test fts4merge2.test
269 fts4merge4.test fts4merge.test fts4noti.test fts4onepass.test
270 fts4opt.test fts4unicode.test
danddf47472017-04-17 13:38:09 +0000[diff] [blame]271 fts3corrupt3.test
dan624edac2017-04-17 16:07:25 +0000[diff] [blame]272 fts3misc.test
dana69f7d52010-07-19 11:16:36 +0000[diff] [blame]273}
274
dan22d43ec2014-06-25 20:28:38 +0000[diff] [blame]275test_suite "fts5" -prefix "" -description {
276 All FTS5 tests.
dane716aca2014-12-29 15:59:36 +0000[diff] [blame]277} -files [glob -nocomplain $::testdir/../ext/fts5/test/*.test]
dan22d43ec2014-06-25 20:28:38 +0000[diff] [blame]278
dan23d53882015-05-13 17:15:32 +0000[diff] [blame]279test_suite "fts5-light" -prefix "" -description {
280 All FTS5 tests.
281} -files [
282 test_set \
283 [glob -nocomplain $::testdir/../ext/fts5/test/*.test] \
284 -exclude *corrupt* *fault* *big* *fts5aj*
285]
286
dan9a947222018-06-14 19:06:36 +0000[diff] [blame]287test_suite "window" -prefix "" -description {
288 All window function related tests .
289} -files [
290 test_set [glob -nocomplain $::testdir/window*.test]
291]
292
mistachkin59541d72017-07-14 15:45:27 +0000[diff] [blame]293test_suite "lsm1" -prefix "" -description {
294 All LSM1 tests.
295} -files [glob -nocomplain $::testdir/../ext/lsm1/test/*.test]
296
dana8793422012-06-07 07:24:04 +0000[diff] [blame]297test_suite "nofaultsim" -prefix "" -description {
298 "Very" quick test suite. Runs in less than 5 minutes on a workstation.
299 This test suite is the same as the "quick" tests, except that some files
300 that test malloc and IO errors are omitted.
301} -files [
danbe7721d2016-02-04 17:31:03 +0000[diff] [blame]302 test_set $allquicktests -exclude *malloc* *ioerr* *fault* *_err*
dana8793422012-06-07 07:24:04 +0000[diff] [blame]303] -initialize {
304 catch {db close}
305 sqlite3_shutdown
306 install_malloc_faultsim 0
307 sqlite3_initialize
308 autoinstall_test_functions
309} -shutdown {
310 unset -nocomplain ::G(valgrind)
311}
danea5542d2010-07-06 11:26:15 +0000[diff] [blame]312
drhfd5874d2013-06-12 14:52:39 +0000[diff] [blame]313test_suite "queryplanner" -prefix "" -description {
314 Tests of the query planner and query optimizer
315} -files {
316 alter2.test alter3.test alter4.test alter.test analyze3.test
317 analyze4.test analyze5.test analyze6.test analyze7.test analyze8.test
drh4fe425a2013-06-12 17:08:06 +0000[diff] [blame]318 analyze.test attach2.test attach3.test attach4.test
drhfd5874d2013-06-12 14:52:39 +0000[diff] [blame]319 attach.test autoinc.test autoindex1.test between.test cast.test
320 check.test closure01.test coalesce.test collate1.test collate2.test
321 collate3.test collate4.test collate5.test collate6.test collate7.test
322 collate8.test collate9.test collateA.test colmeta.test colname.test
323 conflict.test count.test coveridxscan.test createtab.test cse.test
324 date.test dbstatus2.test dbstatus.test default.test delete2.test
325 delete3.test delete.test descidx1.test descidx2.test descidx3.test
326 distinctagg.test distinct.test e_createtable.test e_delete.test
drh4fe425a2013-06-12 17:08:06 +0000[diff] [blame]327 e_droptrigger.test e_dropview.test e_expr.test e_insert.test
drhfd5874d2013-06-12 14:52:39 +0000[diff] [blame]328 eqp.test e_reindex.test e_resolve.test e_select2.test e_select.test
329 e_update.test exists.test expr.test fkey1.test fkey2.test fkey3.test
drh4fe425a2013-06-12 17:08:06 +0000[diff] [blame]330 fkey4.test fkey5.test func2.test func3.test func.test
331 in3.test in4.test in5.test index2.test index3.test
332 index4.test index5.test indexedby.test index.test
drhfd5874d2013-06-12 14:52:39 +0000[diff] [blame]333 insert2.test insert3.test insert4.test insert5.test insert.test
334 instr.test in.test intpkey.test join2.test join3.test join4.test
335 join5.test join6.test join.test like2.test like.test limit.test
336 minmax2.test minmax3.test minmax4.test minmax.test misc1.test misc2.test
337 misc3.test misc4.test misc5.test misc6.test misc7.test orderby1.test
338 orderby2.test orderby3.test orderby4.test randexpr1.test regexp1.test
339 reindex.test rowhash.test rowid.test schema2.test schema3.test
drh4fe425a2013-06-12 17:08:06 +0000[diff] [blame]340 schema4.test schema5.test schema.test
drhfd5874d2013-06-12 14:52:39 +0000[diff] [blame]341 select1.test select2.test select3.test select4.test select5.test
342 select6.test select7.test select8.test select9.test selectA.test
343 selectB.test selectC.test selectD.test selectE.test sidedelete.test
344 sort.test spellfix.test subquery2.test subquery.test subselect.test
345 substr.test tkt-02a8e81d44.test tkt1435.test tkt1443.test tkt1444.test
346 tkt1449.test tkt1473.test tkt1501.test tkt1512.test tkt1514.test
347 tkt1536.test tkt1537.test tkt1567.test tkt1644.test tkt1667.test
348 tkt1873.test tkt2141.test tkt2192.test tkt2213.test tkt2251.test
349 tkt2285.test tkt2332.test tkt2339.test tkt2391.test tkt2409.test
350 tkt2450.test tkt2565.test tkt2640.test tkt2643.test tkt2686.test
351 tkt-26ff0c2d1e.test tkt2767.test tkt2817.test tkt2820.test tkt2822.test
352 tkt2832.test tkt2854.test tkt2920.test tkt2927.test tkt2942.test
353 tkt-2a5629202f.test tkt-2d1a5c67d.test tkt-2ea2425d34.test tkt3080.test
354 tkt3093.test tkt3121.test tkt-31338dca7e.test tkt-313723c356.test
355 tkt3201.test tkt3292.test tkt3298.test tkt3334.test tkt3346.test
356 tkt3357.test tkt3419.test tkt3424.test tkt3442.test tkt3457.test
357 tkt3461.test tkt3493.test tkt3508.test tkt3522.test tkt3527.test
358 tkt3541.test tkt3554.test tkt3581.test tkt35xx.test tkt3630.test
359 tkt3718.test tkt3731.test tkt3757.test tkt3761.test tkt3762.test
360 tkt3773.test tkt3791.test tkt3793.test tkt3810.test tkt3824.test
361 tkt3832.test tkt3838.test tkt3841.test tkt-385a5b56b9.test tkt3871.test
362 tkt3879.test tkt-38cb5df375.test tkt3911.test tkt3918.test tkt3922.test
363 tkt3929.test tkt3935.test tkt3992.test tkt3997.test tkt-3998683a16.test
364 tkt-3a77c9714e.test tkt-3fe897352e.test tkt4018.test tkt-4a03edc4c8.test
365 tkt-4dd95f6943.test tkt-54844eea3f.test tkt-5d863f876e.test
366 tkt-5e10420e8d.test tkt-5ee23731f.test tkt-6bfb98dfc0.test
367 tkt-752e1646fc.test tkt-78e04e52ea.test tkt-7a31705a7e6.test
368 tkt-7bbfb7d442.test tkt-80ba201079.test tkt-80e031a00f.test
369 tkt-8454a207b9.test tkt-91e2e8ba6f.test tkt-94c04eaadb.test
370 tkt-9d68c883.test tkt-a7b7803e.test tkt-b1d3a2e531.test
371 tkt-b351d95f9.test tkt-b72787b1.test tkt-bd484a090c.test
372 tkt-bdc6bbbb38.test tkt-c48d99d690.test tkt-cbd054fa6b.test
373 tkt-d11f09d36e.test tkt-d635236375.test tkt-d82e3f3721.test
374 tkt-f3e5abed55.test tkt-f777251dc7a.test tkt-f7b4edec.test
375 tkt-f973c7ac31.test tkt-fa7bf5ec.test tkt-fc62af4523.test
376 tkt-fc7bd6358f.test trigger1.test trigger2.test trigger3.test
377 trigger4.test trigger5.test trigger6.test trigger7.test trigger8.test
378 trigger9.test triggerA.test triggerB.test triggerC.test triggerD.test
379 types2.test types3.test types.test unique.test unordered.test
380 update.test view.test vtab1.test vtab2.test vtab3.test vtab4.test
381 vtab5.test vtab6.test vtab7.test vtab8.test vtab9.test vtab_alter.test
drh4fe425a2013-06-12 17:08:06 +0000[diff] [blame]382 vtabA.test vtabB.test vtabC.test vtabD.test vtabE.test
drhfd5874d2013-06-12 14:52:39 +0000[diff] [blame]383 vtabF.test where2.test where3.test where4.test where5.test where6.test
384 where7.test where8m.test where8.test where9.test whereA.test whereB.test
385 whereC.test whereD.test whereE.test whereF.test wherelimit.test
386 where.test
387}
388
dan30e2f0a2013-10-10 13:04:46 +0000[diff] [blame]389test_suite "vfslog" -prefix "" -description {
390 "Vfslog" quick test suite. Like "veryquick" except does not omits
391 a few tests that do not work with a version 1 VFS. And the quota* tests,
392 which do not work with a VFS that uses the pVfs argument passed to
393 sqlite3_vfs methods.
394} -files [
395 test_set $allquicktests -exclude *malloc* *ioerr* *fault* oserror.test \
396 pager1.test syscall.test sysfault.test tkt3457.test quota* superlock* \
397 wal* mmap*
398]
399
dan4da30f82017-07-22 16:58:47 +0000[diff] [blame]400test_suite "atomic-batch-write" -prefix "" -description {
401 Like veryquick.test, but must be run on a file-system that supports
402 atomic-batch-writes. Tests that depend on the journal file being present
403 are omitted.
404} -files [
405 test_set $allquicktests -exclude *malloc* *ioerr* *fault* *bigfile* *_err* \
406 *fts5corrupt* *fts5big* *fts5aj* \
407 crash8.test delete_db.test \
408 exclusive.test journal3.test \
409 journal1.test \
410 jrnlmode.test jrnlmode2.test \
411 lock4.test pager1.test \
412 pager3.test sharedA.test \
413 symlink.test stmt.test \
414 sync.test sync2.test \
415 tempdb.test tkt3457.test \
416 vacuum5.test wal2.test \
417 walmode.test zerodamage.test
418] -initialize {
419 if {[atomic_batch_write test.db]==0} {
420 error "File system does NOT support atomic-batch-write"
421 }
422}
423
dane91a54e2010-06-15 17:44:47 +0000[diff] [blame]424lappend ::testsuitelist xxx
dan0626dfc2010-06-15 06:56:37 +0000[diff] [blame]425#-------------------------------------------------------------------------
426# Define the coverage related test suites:
427#
428# coverage-wal
dan0626dfc2010-06-15 06:56:37 +0000[diff] [blame]429#
430test_suite "coverage-wal" -description {
431 Coverage tests for file wal.c.
432} -files {
danf43d7fc2010-07-03 10:00:00 +0000[diff] [blame]433 wal.test wal2.test wal3.test walmode.test
434 walbak.test walhook.test walcrash2.test walcksum.test
dan8c408002010-11-01 17:38:24 +0000[diff] [blame]435 walfault.test walbig.test walnoshm.test
dan28f9b0b2011-02-07 16:24:39 +0000[diff] [blame]436 wal5.test
dan0626dfc2010-06-15 06:56:37 +0000[diff] [blame]437}
438
dane91a54e2010-06-15 17:44:47 +0000[diff] [blame]439test_suite "coverage-pager" -description {
440 Coverage tests for file pager.c.
441} -files {
danf43d7fc2010-07-03 10:00:00 +0000[diff] [blame]442 pager1.test pager2.test pagerfault.test pagerfault2.test
443 walfault.test walbak.test journal2.test tkt-9d68c883.test
dane91a54e2010-06-15 17:44:47 +0000[diff] [blame]444}
dan0626dfc2010-06-15 06:56:37 +0000[diff] [blame]445
danb49d1042013-09-02 18:58:11 +0000[diff] [blame]446test_suite "coverage-analyze" -description {
447 Coverage tests for file analyze.c.
448} -files {
449 analyze3.test analyze4.test analyze5.test analyze6.test
450 analyze7.test analyze8.test analyze9.test analyzeA.test
danaf0d8bc2013-09-04 16:38:42 +0000[diff] [blame]451 analyze.test analyzeB.test mallocA.test
danb49d1042013-09-02 18:58:11 +0000[diff] [blame]452}
453
dan0d51def2014-05-03 14:28:14 +0000[diff] [blame]454test_suite "coverage-sorter" -description {
455 Coverage tests for file vdbesort.c.
456} -files {
457 sort.test sortfault.test
458}
459
dan0626dfc2010-06-15 06:56:37 +0000[diff] [blame]460
dane91a54e2010-06-15 17:44:47 +0000[diff] [blame]461lappend ::testsuitelist xxx
dan0626dfc2010-06-15 06:56:37 +0000[diff] [blame]462#-------------------------------------------------------------------------
463# Define the permutation test suites:
464#
danielk19771077e3f2008-06-21 18:07:37 +0000[diff] [blame]465
drhb2a0f752017-08-28 15:51:35 +0000[diff] [blame]466# Run some tests using pre-allocated page blocks.
danielk19771077e3f2008-06-21 18:07:37 +0000[diff] [blame]467#
dan4c5aeec2013-05-16 19:15:07 +0000[diff] [blame]468# mmap1.test is excluded because a good number of its tests depend on
469# the page-cache being larger than the database. But this permutation
470# causes the effective limit on the page-cache to be just 24 pages.
471#
dan0626dfc2010-06-15 06:56:37 +0000[diff] [blame]472test_suite "memsubsys1" -description {
drhb2a0f752017-08-28 15:51:35 +0000[diff] [blame]473 Tests using pre-allocated page blocks
dan0626dfc2010-06-15 06:56:37 +0000[diff] [blame]474} -files [
dan4c5aeec2013-05-16 19:15:07 +0000[diff] [blame]475 test_set $::allquicktests -exclude ioerr5.test malloc5.test mmap1.test
dan0626dfc2010-06-15 06:56:37 +0000[diff] [blame]476] -initialize {
dan03bc5252015-07-24 14:17:17 +0000[diff] [blame]477 test_set_config_pagecache 4096 24
danielk19771077e3f2008-06-21 18:07:37 +0000[diff] [blame]478 catch {db close}
479 sqlite3_shutdown
danielk19771077e3f2008-06-21 18:07:37 +0000[diff] [blame]480 sqlite3_initialize
drhbb77b752009-04-09 01:23:49 +0000[diff] [blame]481 autoinstall_test_functions
danielk19771077e3f2008-06-21 18:07:37 +0000[diff] [blame]482} -shutdown {
dan03bc5252015-07-24 14:17:17 +0000[diff] [blame]483 test_restore_config_pagecache
danielk19771077e3f2008-06-21 18:07:37 +0000[diff] [blame]484 catch {db close}
485 sqlite3_shutdown
danielk19771077e3f2008-06-21 18:07:37 +0000[diff] [blame]486 sqlite3_initialize
drhbb77b752009-04-09 01:23:49 +0000[diff] [blame]487 autoinstall_test_functions
danielk19771077e3f2008-06-21 18:07:37 +0000[diff] [blame]488}
489
drhb2a0f752017-08-28 15:51:35 +0000[diff] [blame]490# Run some tests using pre-allocated page blocks. This time
danielk19771077e3f2008-06-21 18:07:37 +0000[diff] [blame]491# the allocations are too small to use in most cases.
492#
danielk197734c61e62008-08-29 12:00:20 +0000[diff] [blame]493# Both ioerr5.test and malloc5.test are excluded because they test the
494# sqlite3_soft_heap_limit() and sqlite3_release_memory() functionality.
495# This functionality is disabled if a pre-allocated page block is provided.
496#
dan0626dfc2010-06-15 06:56:37 +0000[diff] [blame]497test_suite "memsubsys2" -description {
drhb2a0f752017-08-28 15:51:35 +0000[diff] [blame]498 Tests using small pre-allocated page blocks
dan0626dfc2010-06-15 06:56:37 +0000[diff] [blame]499} -files [
500 test_set $::allquicktests -exclude ioerr5.test malloc5.test
501] -initialize {
dan03bc5252015-07-24 14:17:17 +0000[diff] [blame]502 test_set_config_pagecache 512 5
drhd63bd752008-07-30 13:15:46 +0000[diff] [blame]503 catch {db close}
danielk19771077e3f2008-06-21 18:07:37 +0000[diff] [blame]504 sqlite3_shutdown
danielk19771077e3f2008-06-21 18:07:37 +0000[diff] [blame]505 sqlite3_initialize
drhbb77b752009-04-09 01:23:49 +0000[diff] [blame]506 autoinstall_test_functions
danielk19771077e3f2008-06-21 18:07:37 +0000[diff] [blame]507} -shutdown {
dan03bc5252015-07-24 14:17:17 +0000[diff] [blame]508 test_restore_config_pagecache
danielk19771077e3f2008-06-21 18:07:37 +0000[diff] [blame]509 catch {db close}
510 sqlite3_shutdown
danielk19771077e3f2008-06-21 18:07:37 +0000[diff] [blame]511 sqlite3_initialize
drhbb77b752009-04-09 01:23:49 +0000[diff] [blame]512 autoinstall_test_functions
danielk19771077e3f2008-06-21 18:07:37 +0000[diff] [blame]513}
514
drhe2a7c6e2008-08-01 15:06:30 +0000[diff] [blame]515# Run all tests with the lookaside allocator disabled.
516#
dan0626dfc2010-06-15 06:56:37 +0000[diff] [blame]517test_suite "nolookaside" -description {
drhe2a7c6e2008-08-01 15:06:30 +0000[diff] [blame]518 OOM tests with lookaside disabled
drhe2a7c6e2008-08-01 15:06:30 +0000[diff] [blame]519} -initialize {
520 catch {db close}
521 sqlite3_shutdown
522 sqlite3_config_lookaside 0 0
523 sqlite3_initialize
drhbb77b752009-04-09 01:23:49 +0000[diff] [blame]524 autoinstall_test_functions
drhe2a7c6e2008-08-01 15:06:30 +0000[diff] [blame]525} -shutdown {
526 catch {db close}
527 sqlite3_shutdown
528 sqlite3_config_lookaside 100 500
529 sqlite3_initialize
drhbb77b752009-04-09 01:23:49 +0000[diff] [blame]530 autoinstall_test_functions
dan0626dfc2010-06-15 06:56:37 +0000[diff] [blame]531} -files $::allquicktests
drhe2a7c6e2008-08-01 15:06:30 +0000[diff] [blame]532
danielk19771077e3f2008-06-21 18:07:37 +0000[diff] [blame]533# Run some tests in SQLITE_CONFIG_SINGLETHREAD mode.
534#
dan0626dfc2010-06-15 06:56:37 +0000[diff] [blame]535test_suite "singlethread" -description {
danielk19771077e3f2008-06-21 18:07:37 +0000[diff] [blame]536 Tests run in SQLITE_CONFIG_SINGLETHREAD mode
537} -initialize {
drh04df18d2009-01-06 14:50:11 +0000[diff] [blame]538 catch {db close}
539 sqlite3_shutdown
540 catch {sqlite3_config singlethread}
drhbb77b752009-04-09 01:23:49 +0000[diff] [blame]541 sqlite3_initialize
542 autoinstall_test_functions
dan0626dfc2010-06-15 06:56:37 +0000[diff] [blame]543} -files {
danielk19771077e3f2008-06-21 18:07:37 +0000[diff] [blame]544 delete.test delete2.test insert.test rollback.test select1.test
545 select2.test trans.test update.test vacuum.test types.test
546 types2.test types3.test
547} -shutdown {
drh04df18d2009-01-06 14:50:11 +0000[diff] [blame]548 catch {db close}
549 sqlite3_shutdown
550 catch {sqlite3_config serialized}
drhbb77b752009-04-09 01:23:49 +0000[diff] [blame]551 sqlite3_initialize
552 autoinstall_test_functions
danielk19771077e3f2008-06-21 18:07:37 +0000[diff] [blame]553}
554
dan0626dfc2010-06-15 06:56:37 +0000[diff] [blame]555test_suite "nomutex" -description {
drh039963a2008-09-03 00:43:15 +0000[diff] [blame]556 Tests run with the SQLITE_OPEN_MULTITHREADED flag passed to sqlite3_open().
danielk19779a6284c2008-07-10 17:52:49 +0000[diff] [blame]557} -initialize {
danb1e1a0f2018-09-18 16:06:42 +0000[diff] [blame]558 set ::G(perm:sqlite3_args) [list -fullmutex 0 -nomutex 1]
dan0626dfc2010-06-15 06:56:37 +0000[diff] [blame]559} -files {
danielk19779a6284c2008-07-10 17:52:49 +0000[diff] [blame]560 delete.test delete2.test insert.test rollback.test select1.test
561 select2.test trans.test update.test vacuum.test types.test
562 types2.test types3.test
danb1e1a0f2018-09-18 16:06:42 +0000[diff] [blame]563}
danielk19779a6284c2008-07-10 17:52:49 +0000[diff] [blame]564
danielk19771077e3f2008-06-21 18:07:37 +0000[diff] [blame]565# Run some tests in SQLITE_CONFIG_MULTITHREAD mode.
566#
dan0626dfc2010-06-15 06:56:37 +0000[diff] [blame]567test_suite "multithread" -description {
danielk19771077e3f2008-06-21 18:07:37 +0000[diff] [blame]568 Tests run in SQLITE_CONFIG_MULTITHREAD mode
569} -initialize {
drh04df18d2009-01-06 14:50:11 +0000[diff] [blame]570 catch {db close}
571 sqlite3_shutdown
572 catch {sqlite3_config multithread}
drhbb77b752009-04-09 01:23:49 +0000[diff] [blame]573 sqlite3_initialize
574 autoinstall_test_functions
dan0626dfc2010-06-15 06:56:37 +0000[diff] [blame]575} -files {
danielk19771077e3f2008-06-21 18:07:37 +0000[diff] [blame]576 delete.test delete2.test insert.test rollback.test select1.test
577 select2.test trans.test update.test vacuum.test types.test
dandfea4532014-05-06 15:38:07 +0000[diff] [blame]578 types2.test types3.test sort4.test
danielk19771077e3f2008-06-21 18:07:37 +0000[diff] [blame]579} -shutdown {
drh04df18d2009-01-06 14:50:11 +0000[diff] [blame]580 catch {db close}
581 sqlite3_shutdown
582 catch {sqlite3_config serialized}
drhbb77b752009-04-09 01:23:49 +0000[diff] [blame]583 sqlite3_initialize
584 autoinstall_test_functions
danielk19771077e3f2008-06-21 18:07:37 +0000[diff] [blame]585}
586
drh039963a2008-09-03 00:43:15 +0000[diff] [blame]587# Run some tests in SQLITE_OPEN_FULLMUTEX mode.
588#
dan0626dfc2010-06-15 06:56:37 +0000[diff] [blame]589test_suite "fullmutex" -description {
drh039963a2008-09-03 00:43:15 +0000[diff] [blame]590 Tests run in SQLITE_OPEN_FULLMUTEX mode
591} -initialize {
danb1e1a0f2018-09-18 16:06:42 +0000[diff] [blame]592 set ::G(perm:sqlite3_args) [list -nomutex 0 -fullmutex 1]
dan0626dfc2010-06-15 06:56:37 +0000[diff] [blame]593} -files {
drh039963a2008-09-03 00:43:15 +0000[diff] [blame]594 delete.test delete2.test insert.test rollback.test select1.test
595 select2.test trans.test update.test vacuum.test types.test
596 types2.test types3.test
drh039963a2008-09-03 00:43:15 +0000[diff] [blame]597}
598
danielk19771077e3f2008-06-21 18:07:37 +0000[diff] [blame]599# Run some tests using the "onefile" demo.
600#
dan0626dfc2010-06-15 06:56:37 +0000[diff] [blame]601test_suite "onefile" -description {
danielk19771077e3f2008-06-21 18:07:37 +0000[diff] [blame]602 Run some tests using the "test_onefile.c" demo
603} -initialize {
danb1e1a0f2018-09-18 16:06:42 +0000[diff] [blame]604 set ::G(perm:sqlite3_args) [list -vfs fs]
dan0626dfc2010-06-15 06:56:37 +0000[diff] [blame]605} -files {
danielk19771077e3f2008-06-21 18:07:37 +0000[diff] [blame]606 conflict.test insert.test insert2.test insert3.test
607 rollback.test select1.test select2.test select3.test
danielk19771077e3f2008-06-21 18:07:37 +0000[diff] [blame]608}
609
610# Run some tests using UTF-16 databases.
611#
dan0626dfc2010-06-15 06:56:37 +0000[diff] [blame]612test_suite "utf16" -description {
danielk19771077e3f2008-06-21 18:07:37 +0000[diff] [blame]613 Run tests using UTF-16 databases
danielk19772dd6d802008-06-21 19:10:27 +0000[diff] [blame]614} -presql {
danielk19771077e3f2008-06-21 18:07:37 +0000[diff] [blame]615 pragma encoding = 'UTF-16'
dan0626dfc2010-06-15 06:56:37 +0000[diff] [blame]616} -files {
danielk19771077e3f2008-06-21 18:07:37 +0000[diff] [blame]617 alter.test alter3.test
dan22d73b12013-08-16 14:48:23 +0000[diff] [blame]618 analyze.test analyze3.test analyze4.test analyze5.test analyze6.test
dan8ff2d952013-09-05 18:40:29 +0000[diff] [blame]619 analyze7.test analyze8.test analyze9.test analyzeA.test analyzeB.test
danielk19771077e3f2008-06-21 18:07:37 +0000[diff] [blame]620 auth.test bind.test blob.test capi2.test capi3.test collate1.test
621 collate2.test collate3.test collate4.test collate5.test collate6.test
622 conflict.test date.test delete.test expr.test fkey1.test func.test
623 hook.test index.test insert2.test insert.test interrupt.test in.test
624 intpkey.test ioerr.test join2.test join.test lastinsert.test
625 laststmtchanges.test limit.test lock2.test lock.test main.test
626 memdb.test minmax.test misc1.test misc2.test misc3.test notnull.test
627 null.test progress.test quote.test rowid.test select1.test select2.test
628 select3.test select4.test select5.test select6.test sort.test
629 subselect.test tableapi.test table.test temptable.test
630 trace.test trigger1.test trigger2.test trigger3.test
631 trigger4.test types2.test types.test unique.test update.test
632 vacuum.test view.test where.test
danb78b83a2016-03-02 17:57:53 +0000[diff] [blame]633 bestindex1.test
danielk19771077e3f2008-06-21 18:07:37 +0000[diff] [blame]634}
635
636# Run some tests in exclusive locking mode.
637#
dan0626dfc2010-06-15 06:56:37 +0000[diff] [blame]638test_suite "exclusive" -description {
danielk19771077e3f2008-06-21 18:07:37 +0000[diff] [blame]639 Run tests in exclusive locking mode.
640} -presql {
641 pragma locking_mode = 'exclusive'
dan0626dfc2010-06-15 06:56:37 +0000[diff] [blame]642} -files {
danielk19771077e3f2008-06-21 18:07:37 +0000[diff] [blame]643 rollback.test select1.test select2.test
644 malloc.test ioerr.test
645}
646
drh04335882008-09-26 21:08:08 +0000[diff] [blame]647# Run some tests in exclusive locking mode with truncated journals.
648#
dan0626dfc2010-06-15 06:56:37 +0000[diff] [blame]649test_suite "exclusive-truncate" -description {
drh04335882008-09-26 21:08:08 +0000[diff] [blame]650 Run tests in exclusive locking mode and truncate journal mode.
651} -presql {
652 pragma locking_mode = 'exclusive';
653 pragma journal_mode = TRUNCATE;
dan0626dfc2010-06-15 06:56:37 +0000[diff] [blame]654} -files {
drh04335882008-09-26 21:08:08 +0000[diff] [blame]655 delete.test delete2.test insert.test rollback.test select1.test
656 select2.test update.test malloc.test ioerr.test
657}
658
danielk19771077e3f2008-06-21 18:07:37 +0000[diff] [blame]659# Run some tests in persistent journal mode.
660#
dan0626dfc2010-06-15 06:56:37 +0000[diff] [blame]661test_suite "persistent_journal" -description {
danielk19771077e3f2008-06-21 18:07:37 +0000[diff] [blame]662 Run tests in persistent-journal mode.
663} -presql {
664 pragma journal_mode = persist
dan0626dfc2010-06-15 06:56:37 +0000[diff] [blame]665} -files {
danielk19771077e3f2008-06-21 18:07:37 +0000[diff] [blame]666 delete.test delete2.test insert.test rollback.test select1.test
667 select2.test trans.test update.test vacuum.test
668}
669
drh04335882008-09-26 21:08:08 +0000[diff] [blame]670# Run some tests in truncating journal mode.
671#
dan0626dfc2010-06-15 06:56:37 +0000[diff] [blame]672test_suite "truncate_journal" -description {
drh04335882008-09-26 21:08:08 +0000[diff] [blame]673 Run tests in persistent-journal mode.
674} -presql {
675 pragma journal_mode = truncate
dan0626dfc2010-06-15 06:56:37 +0000[diff] [blame]676} -files {
drh04335882008-09-26 21:08:08 +0000[diff] [blame]677 delete.test delete2.test insert.test rollback.test select1.test
678 select2.test trans.test update.test vacuum.test
679 malloc.test ioerr.test
680}
681
danielk19771077e3f2008-06-21 18:07:37 +0000[diff] [blame]682# Run some error tests in persistent journal mode.
683#
dan0626dfc2010-06-15 06:56:37 +0000[diff] [blame]684test_suite "persistent_journal_error" -description {
danielk19771077e3f2008-06-21 18:07:37 +0000[diff] [blame]685 Run malloc.test and ioerr.test in persistent-journal mode.
686} -presql {
687 pragma journal_mode = persist
dan0626dfc2010-06-15 06:56:37 +0000[diff] [blame]688} -files {
danielk19771077e3f2008-06-21 18:07:37 +0000[diff] [blame]689 malloc.test ioerr.test
690}
691
692# Run some tests in no journal mode.
693#
dan0626dfc2010-06-15 06:56:37 +0000[diff] [blame]694test_suite "no_journal" -description {
danielk19771077e3f2008-06-21 18:07:37 +0000[diff] [blame]695 Run tests in no-journal mode.
696} -presql {
697 pragma journal_mode = persist
dan0626dfc2010-06-15 06:56:37 +0000[diff] [blame]698} -files {
danielk19771077e3f2008-06-21 18:07:37 +0000[diff] [blame]699 delete.test delete2.test insert.test rollback.test select1.test
700 select2.test trans.test update.test vacuum.test
701}
702
703# Run some error tests in no journal mode.
704#
dan0626dfc2010-06-15 06:56:37 +0000[diff] [blame]705test_suite "no_journal_error" -description {
danielk19771077e3f2008-06-21 18:07:37 +0000[diff] [blame]706 Run malloc.test and ioerr.test in no-journal mode.
707} -presql {
708 pragma journal_mode = persist
dan0626dfc2010-06-15 06:56:37 +0000[diff] [blame]709} -files {
danielk19771077e3f2008-06-21 18:07:37 +0000[diff] [blame]710 malloc.test ioerr.test
711}
712
713# Run some crash-tests in autovacuum mode.
714#
dan0626dfc2010-06-15 06:56:37 +0000[diff] [blame]715test_suite "autovacuum_crash" -description {
danielk19771077e3f2008-06-21 18:07:37 +0000[diff] [blame]716 Run crash.test in autovacuum mode.
717} -presql {
718 pragma auto_vacuum = 1
dan0626dfc2010-06-15 06:56:37 +0000[diff] [blame]719} -files crash.test
danielk19771077e3f2008-06-21 18:07:37 +0000[diff] [blame]720
721# Run some ioerr-tests in autovacuum mode.
722#
dan0626dfc2010-06-15 06:56:37 +0000[diff] [blame]723test_suite "autovacuum_ioerr" -description {
danielk19771077e3f2008-06-21 18:07:37 +0000[diff] [blame]724 Run ioerr.test in autovacuum mode.
725} -presql {
726 pragma auto_vacuum = 1
dan0626dfc2010-06-15 06:56:37 +0000[diff] [blame]727} -files ioerr.test
danielk19771077e3f2008-06-21 18:07:37 +0000[diff] [blame]728
danielk1977b3175382008-10-17 18:51:52 +0000[diff] [blame]729# Run tests with an in-memory journal.
730#
dan0626dfc2010-06-15 06:56:37 +0000[diff] [blame]731test_suite "inmemory_journal" -description {
danielk1977b3175382008-10-17 18:51:52 +0000[diff] [blame]732 Run tests with an in-memory journal file.
733} -presql {
734 pragma journal_mode = 'memory'
dan0626dfc2010-06-15 06:56:37 +0000[diff] [blame]735} -files [test_set $::allquicktests -exclude {
danielk1977b3175382008-10-17 18:51:52 +0000[diff] [blame]736 # Exclude all tests that simulate IO errors.
drh85979cd2015-11-04 13:03:36 +0000[diff] [blame]737 autovacuum_ioerr2.test cffault.test incrvacuum_ioerr.test ioerr.test
danielk1977b3175382008-10-17 18:51:52 +0000[diff] [blame]738 ioerr.test ioerr2.test ioerr3.test ioerr4.test ioerr5.test
drh2206a2b2009-04-01 23:09:43 +0000[diff] [blame]739 vacuum3.test incrblob_err.test diskfull.test backup_ioerr.test
shanehc3b84832010-07-09 19:32:28 +0000[diff] [blame]740 e_fts3.test fts3cov.test fts3malloc.test fts3rnd.test
dan14cee382016-04-28 14:54:54 +0000[diff] [blame]741 fts3snippet.test mmapfault.test sessionfault.test sessionfault2.test
danielk1977b3175382008-10-17 18:51:52 +0000[diff] [blame]742
743 # Exclude test scripts that use tcl IO to access journal files or count
744 # the number of fsync() calls.
745 pager.test exclusive.test jrnlmode.test sync.test misc1.test
danielk1977cb257902009-04-10 18:32:29 +0000[diff] [blame]746 journal1.test conflict.test crash8.test tkt3457.test io.test
drh8b0228f2011-08-02 20:14:55 +0000[diff] [blame]747 journal3.test 8_3_names.test
dan01d38562010-03-08 10:32:38 +0000[diff] [blame]748
dancb354602010-07-08 09:44:42 +0000[diff] [blame]749 pager1.test async4.test corrupt.test filefmt.test pager2.test
750 corrupt5.test corruptA.test pageropt.test
751
dan01d38562010-03-08 10:32:38 +0000[diff] [blame]752 # Exclude stmt.test, which expects sub-journals to use temporary files.
drh85979cd2015-11-04 13:03:36 +0000[diff] [blame]753 stmt.test symlink.test
drh0b944132010-05-24 20:24:38 +0000[diff] [blame]754
dan6b4e9a82012-01-13 10:51:52 +0000[diff] [blame]755 zerodamage.test
756
drh0b944132010-05-24 20:24:38 +0000[diff] [blame]757 # WAL mode is different.
drhb5a2d552015-05-29 15:15:40 +0000[diff] [blame]758 wal* tkt-2d1a5c67d.test backcompat.test e_wal* rowallock.test
danee7de912016-05-16 14:35:15 +0000[diff] [blame]759
760 # This test does not work as the "PRAGMA journal_mode = memory"
761 # statement switches the database out of wal mode at inopportune
762 # times.
763 snapshot_fault.test
danb3906812016-09-21 17:47:59 +0000[diff] [blame]764
765 # This test assumes a journal file is created on disk.
766 delete_db.test
dan18b20c92017-02-07 19:36:14 +0000[diff] [blame]767
768 # This test depends on a successful recovery from the pager error
769 # state. Which is not possible with an in-memory journal
770 fts5fault1.test
dan0626dfc2010-06-15 06:56:37 +0000[diff] [blame]771}]
danielk1977b3175382008-10-17 18:51:52 +0000[diff] [blame]772
danielk19776b39c2e2008-06-25 14:57:53 +0000[diff] [blame]773ifcapable mem3 {
dan0626dfc2010-06-15 06:56:37 +0000[diff] [blame]774 test_suite "memsys3" -description {
danielk19776b39c2e2008-06-25 14:57:53 +0000[diff] [blame]775 Run tests using the allocator in mem3.c.
daneace5272010-07-05 05:31:48 +0000[diff] [blame]776 } -files [test_set $::allquicktests -exclude {
drh8a42cbd2008-07-10 18:13:42 +0000[diff] [blame]777 autovacuum.test delete3.test manydb.test
778 bigrow.test incrblob2.test memdb.test
779 bitvec.test index2.test memsubsys1.test
780 capi3c.test ioerr.test memsubsys2.test
781 capi3.test join3.test pagesize.test
danielk19778b322822009-07-01 18:09:01 +0000[diff] [blame]782 collate5.test limit.test backup_ioerr.test
783 backup_malloc.test
dan0626dfc2010-06-15 06:56:37 +0000[diff] [blame]784 }] -initialize {
danielk19776b39c2e2008-06-25 14:57:53 +0000[diff] [blame]785 catch {db close}
786 sqlite3_reset_auto_extension
787 sqlite3_shutdown
drh7830cd42008-07-16 12:25:32 +0000[diff] [blame]788 sqlite3_config_heap 25000000 0
drhe2a7c6e2008-08-01 15:06:30 +0000[diff] [blame]789 sqlite3_config_lookaside 0 0
danielk19778b322822009-07-01 18:09:01 +0000[diff] [blame]790 ifcapable mem5 {
791 # If both memsys3 and memsys5 are enabled in the build, the call to
792 # [sqlite3_config_heap] will initialize the system to use memsys5.
793 # The following overrides this preference and installs the memsys3
794 # allocator.
795 sqlite3_install_memsys3
796 }
danielk19776b39c2e2008-06-25 14:57:53 +0000[diff] [blame]797 install_malloc_faultsim 1
798 sqlite3_initialize
799 autoinstall_test_functions
800 } -shutdown {
801 catch {db close}
danielk19776b39c2e2008-06-25 14:57:53 +0000[diff] [blame]802 sqlite3_shutdown
danielk19770d84e5b2008-06-27 14:05:24 +0000[diff] [blame]803 sqlite3_config_heap 0 0
drhe2a7c6e2008-08-01 15:06:30 +0000[diff] [blame]804 sqlite3_config_lookaside 100 500
danielk19776b39c2e2008-06-25 14:57:53 +0000[diff] [blame]805 install_malloc_faultsim 1
806 sqlite3_initialize
drhbb77b752009-04-09 01:23:49 +0000[diff] [blame]807 autoinstall_test_functions
danielk19776b39c2e2008-06-25 14:57:53 +0000[diff] [blame]808 }
danielk197757e5ea92008-06-24 19:02:55 +0000[diff] [blame]809}
810
danielk19776b39c2e2008-06-25 14:57:53 +0000[diff] [blame]811ifcapable mem5 {
dan0626dfc2010-06-15 06:56:37 +0000[diff] [blame]812 test_suite "memsys5" -description {
danielk19776b39c2e2008-06-25 14:57:53 +0000[diff] [blame]813 Run tests using the allocator in mem5.c.
daneace5272010-07-05 05:31:48 +0000[diff] [blame]814 } -files [test_set $::allquicktests -exclude {
drh8a42cbd2008-07-10 18:13:42 +0000[diff] [blame]815 autovacuum.test delete3.test manydb.test
816 bigrow.test incrblob2.test memdb.test
817 bitvec.test index2.test memsubsys1.test
818 capi3c.test ioerr.test memsubsys2.test
819 capi3.test join3.test pagesize.test
danielk1977ac8d7b32008-11-13 16:21:50 +0000[diff] [blame]820 collate5.test limit.test zeroblob.test
dan0626dfc2010-06-15 06:56:37 +0000[diff] [blame]821 }] -initialize {
danielk19776b39c2e2008-06-25 14:57:53 +0000[diff] [blame]822 catch {db close}
danielk19776b39c2e2008-06-25 14:57:53 +0000[diff] [blame]823 sqlite3_shutdown
drh7830cd42008-07-16 12:25:32 +0000[diff] [blame]824 sqlite3_config_heap 25000000 64
drhe2a7c6e2008-08-01 15:06:30 +0000[diff] [blame]825 sqlite3_config_lookaside 0 0
danielk19775099be52008-06-27 13:27:03 +0000[diff] [blame]826 install_malloc_faultsim 1
827 sqlite3_initialize
828 autoinstall_test_functions
829 } -shutdown {
830 catch {db close}
danielk19775099be52008-06-27 13:27:03 +0000[diff] [blame]831 sqlite3_shutdown
danielk19770d84e5b2008-06-27 14:05:24 +0000[diff] [blame]832 sqlite3_config_heap 0 0
drhe2a7c6e2008-08-01 15:06:30 +0000[diff] [blame]833 sqlite3_config_lookaside 100 500
danielk19775099be52008-06-27 13:27:03 +0000[diff] [blame]834 install_malloc_faultsim 1
835 sqlite3_initialize
drhbb77b752009-04-09 01:23:49 +0000[diff] [blame]836 autoinstall_test_functions
danielk19775099be52008-06-27 13:27:03 +0000[diff] [blame]837 }
838
dan0626dfc2010-06-15 06:56:37 +0000[diff] [blame]839 test_suite "memsys5-2" -description {
danielk19775099be52008-06-27 13:27:03 +0000[diff] [blame]840 Run tests using the allocator in mem5.c in a different configuration.
dan0626dfc2010-06-15 06:56:37 +0000[diff] [blame]841 } -files {
drh8a42cbd2008-07-10 18:13:42 +0000[diff] [blame]842 select1.test
danielk19775099be52008-06-27 13:27:03 +0000[diff] [blame]843 } -initialize {
844 catch {db close}
danielk19775099be52008-06-27 13:27:03 +0000[diff] [blame]845 sqlite3_shutdown
danb0c6a882010-09-02 10:08:41 +0000[diff] [blame]846 sqlite3_config_memstatus 0
drh7830cd42008-07-16 12:25:32 +0000[diff] [blame]847 sqlite3_config_heap 40000000 16
drhe2a7c6e2008-08-01 15:06:30 +0000[diff] [blame]848 sqlite3_config_lookaside 0 0
danielk19776b39c2e2008-06-25 14:57:53 +0000[diff] [blame]849 install_malloc_faultsim 1
850 sqlite3_initialize
851 autoinstall_test_functions
852 } -shutdown {
853 catch {db close}
danielk19776b39c2e2008-06-25 14:57:53 +0000[diff] [blame]854 sqlite3_shutdown
danielk19770d84e5b2008-06-27 14:05:24 +0000[diff] [blame]855 sqlite3_config_heap 0 0
drhe2a7c6e2008-08-01 15:06:30 +0000[diff] [blame]856 sqlite3_config_lookaside 100 500
danielk19776b39c2e2008-06-25 14:57:53 +0000[diff] [blame]857 install_malloc_faultsim 1
858 sqlite3_initialize
drhbb77b752009-04-09 01:23:49 +0000[diff] [blame]859 autoinstall_test_functions
danielk19776b39c2e2008-06-25 14:57:53 +0000[diff] [blame]860 }
danielk1977c66c0e12008-06-25 14:26:07 +0000[diff] [blame]861}
862
drh8a42cbd2008-07-10 18:13:42 +0000[diff] [blame]863ifcapable threadsafe {
dan0626dfc2010-06-15 06:56:37 +0000[diff] [blame]864 test_suite "no_mutex_try" -description {
drh8a42cbd2008-07-10 18:13:42 +0000[diff] [blame]865 The sqlite3_mutex_try() interface always fails
dan0626dfc2010-06-15 06:56:37 +0000[diff] [blame]866 } -files [
867 test_set $::allquicktests -exclude mutex1.test mutex2.test
868 ] -initialize {
drh8a42cbd2008-07-10 18:13:42 +0000[diff] [blame]869 catch {db close}
870 sqlite3_shutdown
871 install_mutex_counters 1
872 set ::disable_mutex_try 1
drhbb77b752009-04-09 01:23:49 +0000[diff] [blame]873 sqlite3_initialize
874 autoinstall_test_functions
drh8a42cbd2008-07-10 18:13:42 +0000[diff] [blame]875 } -shutdown {
876 catch {db close}
877 sqlite3_shutdown
878 install_mutex_counters 0
drhbb77b752009-04-09 01:23:49 +0000[diff] [blame]879 sqlite3_initialize
880 autoinstall_test_functions
drh8a42cbd2008-07-10 18:13:42 +0000[diff] [blame]881 }
882}
883
danielk1977b13dee92008-06-23 15:55:52 +0000[diff] [blame]884# run_tests "crash_safe_append" -description {
885# Run crash.test with persistent journals on a SAFE_APPEND file-system.
886# } -initialize {
887# rename crashsql sa_crashsql
888# proc crashsql {args} {
889# set options [lrange $args 0 [expr {[llength $args]-2}]]
890# lappend options -char safe_append
891# set sql [lindex $args end]
892# lappend options "
893# PRAGMA journal_mode=persistent;
894# $sql
895# "
896# set fd [open test.db-journal w]
897# puts $fd [string repeat 1234567890 100000]
898# close $fd
899# eval sa_crashsql $options
900# }
901# } -shutdown {
902# rename crashsql {}
903# rename sa_crashsql crashsql
dan0626dfc2010-06-15 06:56:37 +0000[diff] [blame]904# } -files crash.test
danielk1977b13dee92008-06-23 15:55:52 +0000[diff] [blame]905
dan0626dfc2010-06-15 06:56:37 +0000[diff] [blame]906test_suite "safe_append" -description {
danielk1977755339e2008-09-12 10:22:40 +0000[diff] [blame]907 Run some tests on a SAFE_APPEND file-system.
908} -initialize {
danb1e1a0f2018-09-18 16:06:42 +0000[diff] [blame]909 set ::G(perm:sqlite3_args) [list -vfs devsym]
danielk1977755339e2008-09-12 10:22:40 +0000[diff] [blame]910 sqlite3_simulate_device -char safe_append
dan0626dfc2010-06-15 06:56:37 +0000[diff] [blame]911} -files [
912 test_set $::allquicktests shared_err.test -exclude async3.test
913]
danielk1977755339e2008-09-12 10:22:40 +0000[diff] [blame]914
drhb232c232008-11-19 01:20:26 +0000[diff] [blame]915# The set of tests to run on the alternative-pcache
916set perm-alt-pcache-testset {
917 async.test
918 attach.test
919 delete.test delete2.test
920 index.test
921 insert.test insert2.test
922 join.test join2.test
923 rollback.test
924 select1.test select2.test
925 trans.test
926 update.test
927}
928
dan2acd4c62010-07-13 14:22:39 +0000[diff] [blame]929foreach discard_rate {0 10 50 90 100} {
930 test_suite "pcache${discard_rate}" -description "
931 Alternative pcache implementation with ${discard_rate}% random discard
932 " -initialize "
933 catch {db close}
934 sqlite3_shutdown
935 sqlite3_config_alt_pcache 1 $discard_rate 1
936 sqlite3_initialize
937 autoinstall_test_functions
938 " -shutdown {
939 catch {db close}
940 sqlite3_shutdown
941 sqlite3_config_alt_pcache 0 0 0
942 sqlite3_config_lookaside 100 500
943 install_malloc_faultsim 1
944 sqlite3_initialize
945 autoinstall_test_functions
946 } -files ${perm-alt-pcache-testset}
947}
danielk1977b13dee92008-06-23 15:55:52 +0000[diff] [blame]948
dan0626dfc2010-06-15 06:56:37 +0000[diff] [blame]949test_suite "journaltest" -description {
danielk1977f3107512008-12-22 10:58:46 +0000[diff] [blame]950 Check that pages are synced before being written (test_journal.c).
951} -initialize {
danielk1977f3107512008-12-22 10:58:46 +0000[diff] [blame]952 catch {db close}
953 register_jt_vfs -default ""
954} -shutdown {
955 unregister_jt_vfs
dan0626dfc2010-06-15 06:56:37 +0000[diff] [blame]956} -files [test_set $::allquicktests -exclude {
957 wal* incrvacuum.test ioerr.test corrupt4.test io.test crash8.test
dan05accd22016-04-27 18:54:49 +0000[diff] [blame]958 async4.test bigfile.test backcompat.test e_wal* fstat.test mmap2.test
959 pager1.test syscall.test tkt3457.test *malloc* mmap* multiplex* nolock*
960 pager2.test *fault* rowal* snapshot* superlock* symlink.test
danb3906812016-09-21 17:47:59 +0000[diff] [blame]961 delete_db.test
drhfb4a6262010-05-06 19:55:57 +0000[diff] [blame]962}]
danielk1977f3107512008-12-22 10:58:46 +0000[diff] [blame]963
dan0a7a9152010-04-07 07:57:38 +0000[diff] [blame]964if {[info commands register_demovfs] != ""} {
dan0626dfc2010-06-15 06:56:37 +0000[diff] [blame]965 test_suite "demovfs" -description {
dan430e74c2010-06-07 17:47:26 +0000[diff] [blame]966 Check that the demovfs (code in test_demovfs.c) more or less works.
dan0a7a9152010-04-07 07:57:38 +0000[diff] [blame]967 } -initialize {
968 register_demovfs
969 } -shutdown {
970 unregister_demovfs
dan0626dfc2010-06-15 06:56:37 +0000[diff] [blame]971 } -files {
dan0a7a9152010-04-07 07:57:38 +0000[diff] [blame]972 insert.test insert2.test insert3.test rollback.test
973 select1.test select2.test select3.test
974 }
975}
976
dan0626dfc2010-06-15 06:56:37 +0000[diff] [blame]977test_suite "wal" -description {
dan71cb5182010-04-26 12:39:03 +0000[diff] [blame]978 Run tests with journal_mode=WAL
dan31f98fc2010-04-27 05:42:32 +0000[diff] [blame]979} -initialize {
dan430e74c2010-06-07 17:47:26 +0000[diff] [blame]980 set ::G(savepoint6_iterations) 100
dan31f98fc2010-04-27 05:42:32 +0000[diff] [blame]981} -shutdown {
dan430e74c2010-06-07 17:47:26 +0000[diff] [blame]982 unset -nocomplain ::G(savepoint6_iterations)
dan0626dfc2010-06-15 06:56:37 +0000[diff] [blame]983} -files {
dane106de62010-04-27 06:49:34 +0000[diff] [blame]984 savepoint.test savepoint2.test savepoint6.test
985 trans.test avtrans.test
dan60f9da72010-07-07 11:42:59 +0000[diff] [blame]986
987 fts3aa.test fts3ab.test fts3ac.test fts3ad.test
988 fts3ae.test fts3af.test fts3ag.test fts3ah.test
989 fts3ai.test fts3aj.test fts3ak.test fts3al.test
990 fts3am.test fts3an.test fts3ao.test fts3b.test
991 fts3c.test fts3d.test fts3e.test fts3query.test
dan71cb5182010-04-26 12:39:03 +0000[diff] [blame]992}
dan897230e2010-08-26 14:15:37 +0000[diff] [blame]993
994test_suite "rtree" -description {
995 All R-tree related tests. Provides coverage of source file rtree.c.
996} -files [glob -nocomplain $::testdir/../ext/rtree/*.test]
997
dan7cf7df72011-03-19 15:37:02 +0000[diff] [blame]998test_suite "session" -description {
999 All session module related tests.
1000} -files [glob -nocomplain $::testdir/../ext/session/*.test]
1001
dan35e28582013-07-02 20:23:40 +0000[diff] [blame]1002test_suite "session_eec" -description {
1003 All session module related tests with sqlite3_extended_result_codes() set.
1004} -files [
1005 glob -nocomplain $::testdir/../ext/session/*.test
1006] -dbconfig {
1007 sqlite3_extended_result_codes $::dbhandle 1
1008}
1009
drhf1a08ad2014-09-27 20:45:48 +0000[diff] [blame]1010test_suite "session_strm" -description {
danef7a6302014-09-23 20:39:55 +0000[diff] [blame]1011 All session module related tests using the streaming APIs.
1012} -files [
1013 glob -nocomplain $::testdir/../ext/session/*.test
1014] -dbconfig {
1015 set ::sqlite3session_streams 1
1016}
1017
drhcfb8f8d2015-07-23 20:44:49 +0000[diff] [blame]1018test_suite "rbu" -description {
1019 RBU tests.
dan93fdbfa2014-09-19 18:08:39 +0000[diff] [blame]1020} -files [
drhcfb8f8d2015-07-23 20:44:49 +0000[diff] [blame]1021 test_set [glob -nocomplain $::testdir/../ext/rbu/*.test] -exclude rbu.test
dan93fdbfa2014-09-19 18:08:39 +0000[diff] [blame]1022]
1023
dan1ce1b4a2010-12-07 14:32:28 +0000[diff] [blame]1024test_suite "no_optimization" -description {
1025 Run test scripts with optimizations disabled using the
1026 sqlite3_test_control(SQLITE_TESTCTRL_OPTIMIZATIONS) interface.
1027} -files {
1028 where.test where2.test where3.test where4.test where5.test
1029 where6.test where7.test where8.test where9.test
1030 whereA.test whereB.test wherelimit.test
1031 select1.test select2.test select3.test select4.test select5.test
1032 select7.test select8.test selectA.test selectC.test
1033} -dbconfig {
1034 optimization_control $::dbhandle all 0
1035}
1036
danc431fd52011-06-27 16:55:50 +0000[diff] [blame]1037test_suite "prepare" -description {
1038 Run tests with the db connection using sqlite3_prepare() instead of _v2().
1039} -dbconfig {
drh8544d432017-10-13 16:01:36 +0000[diff] [blame]1040 $::dbhandle version -use-legacy-prepare 1
danc431fd52011-06-27 16:55:50 +0000[diff] [blame]1041 #$::dbhandle cache size 0
1042} -files [
dana50b3092017-07-15 06:35:15 +0000[diff] [blame]1043 test_set $allquicktests -exclude *malloc* *ioerr* *fault* \
1044 stmtvtab1.test index9.test
danc431fd52011-06-27 16:55:50 +0000[diff] [blame]1045]
1046
dan2e3a5a82018-04-16 21:12:42 +0000[diff] [blame]1047test_suite "sorterref" -prefix "" -description {
1048 Run the "veryquick" test suite with SQLITE_CONFIG_SORTERREF_SIZE set
1049 to 0 so that sorter-references are used whenever possible.
1050} -files [
1051 test_set $allquicktests -exclude *malloc* *ioerr* *fault* *bigfile* *_err* \
1052 *fts5corrupt* *fts5big* *fts5aj*
1053] -initialize {
1054 catch {db close}
1055 sqlite3_shutdown
1056 sqlite3_config_sorterref 0
1057 sqlite3_initialize
1058 autoinstall_test_functions
1059} -shutdown {
1060 catch {db close}
1061 sqlite3_shutdown
1062 sqlite3_config_sorterref -1
1063 sqlite3_initialize
1064 autoinstall_test_functions
1065}
1066
danielk19771077e3f2008-06-21 18:07:37 +0000[diff] [blame]1067# End of tests
1068#############################################################################
1069
dan0626dfc2010-06-15 06:56:37 +0000[diff] [blame]1070# run_tests NAME OPTIONS
1071#
1072# where available options are:
1073#
dan2fce9ab2010-06-15 18:00:06 +0000[diff] [blame]1074# -description TITLE
1075# -initialize SCRIPT
1076# -shutdown SCRIPT
dan2fce9ab2010-06-15 18:00:06 +0000[diff] [blame]1077# -files LIST-OF-FILES
1078# -prefix NAME
danb1e1a0f2018-09-18 16:06:42 +0000[diff] [blame]1079# -dbconfig SCRIPT
dan0626dfc2010-06-15 06:56:37 +0000[diff] [blame]1080#
1081proc run_tests {name args} {
danb1e1a0f2018-09-18 16:06:42 +0000[diff] [blame]1082 set options(-initialize) ""
1083 set options(-shutdown) ""
1084 set options(-prefix) ""
1085 set options(-dbconfig) ""
dan7d0fa142018-11-07 11:56:23 +0000[diff] [blame]1086 set options(-presql) ""
danb1e1a0f2018-09-18 16:06:42 +0000[diff] [blame]1087
dan0626dfc2010-06-15 06:56:37 +0000[diff] [blame]1088 array set options $args
danielk19771077e3f2008-06-21 18:07:37 +0000[diff] [blame]1089
dand506de02010-07-03 13:59:01 +0000[diff] [blame]1090 set ::G(perm:name) $name
1091 set ::G(perm:prefix) $options(-prefix)
dan0626dfc2010-06-15 06:56:37 +0000[diff] [blame]1092 set ::G(isquick) 1
dan1ce1b4a2010-12-07 14:32:28 +0000[diff] [blame]1093 set ::G(perm:dbconfig) $options(-dbconfig)
dan7d0fa142018-11-07 11:56:23 +0000[diff] [blame]1094 set ::G(perm:presql) $options(-presql)
dan0626dfc2010-06-15 06:56:37 +0000[diff] [blame]1095
dan0626dfc2010-06-15 06:56:37 +0000[diff] [blame]1096 foreach file [lsort $options(-files)] {
dan05accd22016-04-27 18:54:49 +0000[diff] [blame]1097 uplevel $options(-initialize)
dan897230e2010-08-26 14:15:37 +0000[diff] [blame]1098 if {[file tail $file] == $file} { set file [file join $::testdir $file] }
1099 slave_test_file $file
dan05accd22016-04-27 18:54:49 +0000[diff] [blame]1100 uplevel $options(-shutdown)
danb1e1a0f2018-09-18 16:06:42 +0000[diff] [blame]1101
1102 unset -nocomplain ::G(perm:sqlite3_args)
dan0626dfc2010-06-15 06:56:37 +0000[diff] [blame]1103 }
1104
dan0626dfc2010-06-15 06:56:37 +0000[diff] [blame]1105 unset ::G(perm:name)
dand506de02010-07-03 13:59:01 +0000[diff] [blame]1106 unset ::G(perm:prefix)
dan1ce1b4a2010-12-07 14:32:28 +0000[diff] [blame]1107 unset ::G(perm:dbconfig)
dan7d0fa142018-11-07 11:56:23 +0000[diff] [blame]1108 unset ::G(perm:presql)
dan0626dfc2010-06-15 06:56:37 +0000[diff] [blame]1109}
1110
1111proc run_test_suite {name} {
1112 if {[info exists ::testspec($name)]==0} {
1113 error "No such test suite: $name"
1114 }
1115 uplevel run_tests $name $::testspec($name)
1116}
1117
1118proc help {} {
dane91a54e2010-06-15 17:44:47 +0000[diff] [blame]1119 puts "Usage: $::argv0 TESTSUITE ?TESTFILE?"
1120 puts ""
1121 puts "Available test-suites are:"
danb1e1a0f2018-09-18 16:06:42 +0000[diff] [blame]1122
1123 set iPos 0
dan0626dfc2010-06-15 06:56:37 +0000[diff] [blame]1124 foreach k $::testsuitelist {
danb1e1a0f2018-09-18 16:06:42 +0000[diff] [blame]1125 if {[info exists ::testspec($k)]} {
1126 switch $iPos {
1127 0 {
1128 puts ""
1129 puts -nonewline " [format %-30s $k]"
1130 }
1131
1132 1 {
1133 puts -nonewline [format %-30s $k]
1134 }
1135
1136 2 {
1137 puts -nonewline $k
1138 }
1139 }
1140
1141 set iPos [expr (($iPos+1) % 3)]
dane91a54e2010-06-15 17:44:47 +0000[diff] [blame]1142 }
dan0626dfc2010-06-15 06:56:37 +0000[diff] [blame]1143 }
danb1e1a0f2018-09-18 16:06:42 +0000[diff] [blame]1144 puts ""
dan0626dfc2010-06-15 06:56:37 +0000[diff] [blame]1145 exit -1
1146}
1147
drha5809362016-03-14 21:26:25 +0000[diff] [blame]1148if {[file tail $argv0] == "permutations.test"} {
dan0626dfc2010-06-15 06:56:37 +0000[diff] [blame]1149 proc main {argv} {
1150 if {[llength $argv]==0} {
1151 help
1152 } else {
danb1e1a0f2018-09-18 16:06:42 +0000[diff] [blame]1153
1154 # See if the first argument is a named test-suite.
1155 #
drha5809362016-03-14 21:26:25 +0000[diff] [blame]1156 set suite [file tail [lindex $argv 0]]
danb1e1a0f2018-09-18 16:06:42 +0000[diff] [blame]1157 if {[info exists ::testspec($suite)]} {
1158 set S $::testspec($suite)
1159 set i 1
1160 } else {
1161 set S [list]
1162 set i 0
1163 }
1164
dan0626dfc2010-06-15 06:56:37 +0000[diff] [blame]1165 set extra ""
danb1e1a0f2018-09-18 16:06:42 +0000[diff] [blame]1166 if {$i < [llength $argv] && [string range [lindex $argv $i] 0 0]!="-" } {
1167 set files [list]
1168 for {} {$i < [llength $argv]} {incr i} {
1169 set pattern [string map {% *} [lindex $argv $i]]
1170 if {[string range $pattern 0 0]=="-"} break
1171 foreach f $::alltests {
1172 set tail [file tail $f]
1173 if {[lsearch $files $f]<0 && [string match $pattern $tail]} {
1174 lappend files $f
1175 }
1176 }
1177 }
1178 set extra [list -files $files]
1179 }
1180
1181 eval run_tests $suite $S $extra
dan0626dfc2010-06-15 06:56:37 +0000[diff] [blame]1182 }
1183 }
1184 main $argv
1185 finish_test
1186}