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