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