SQLite

Checklist For SQLite 3.10.0
Login
2016-01-06 17:07:29 drhok+
80b. tclsh multitest.tcl --omit test-ex
0 failures on 27 th3makes and 135174584 tests in (23:18:59) 2 cores on sqlite-imac SQLite 3.10.0 2016-01-05 03:39:52 a855697719e288c908ddb7950d32fd17ef546509
2016-01-06 11:05:16 drhok
30. Documentation review:
2016-01-06 11:05:16 drhok
30c. Release accouncement in "news.html".
2016-01-06 11:05:16 drhok
30i. Check new/changed documentation for spelling and gramatical mistakes.
2016-01-06 10:47:45 drhok
80. Tests for platform Mac OS X (x86):
2016-01-06 10:47:40 drhok
80b. tclsh multitest.tcl --omit test-ex
Passed without the "--omit test-ex" option. Retesting with the latest code. "test-ex" is still running and all else passed.
2016-01-06 10:46:49 drhok
80d. tclsh releasetest.tcl --platform Failure-Detection - all failures detected
2016-01-06 03:54:29 mistachkinok
110. Tests for platform Windows (other):
2016-01-06 03:54:24 mistachkinok
110f. th3make msvc.rc wp81.rc min.rc - Windows Phone 8.1
0 errors out of 1506194 tests in 3174.583 seconds. 32-bit little-endian, SQLite 3.10.0 2016-01-05 03:39:52 a855697719e288c908ddb7950d32fd17ef546509
2016-01-06 02:33:28 mistachkinpending
110f. th3make msvc.rc wp81.rc min.rc - Windows Phone 8.1
2016-01-06 02:32:42 mistachkinok
110d. th3make msvc.rc winrt.rc min.rc - Windows Runtime 8.1
0 errors out of 1507192 tests in 3065.743 seconds. 32-bit little-endian, SQLite 3.10.0 2016-01-05 03:39:52 a855697719e288c908ddb7950d32fd17ef546509
2016-01-06 02:10:42 mistachkinpending
110d. th3make msvc.rc winrt.rc min.rc - Windows Runtime 8.1
2016-01-06 01:52:02 drhok
190. ZIPVFS tests:
2016-01-06 01:51:56 drhok
190b. th3make zipvfs.rc test.rc
On tallis th3: 0 errors out of 8300119 tests in 1795.320 seconds. 64-bit little-endian th3: SQLite 3.10.0 2016-01-05 03:39:52 a855697719e288c908ddb7950d32fd17ef546509
2016-01-06 01:13:37 drhok
190c. th3make zipvfs.rc memdebug.rc
On tallis: th3: 0 errors out of 8300151 tests in 4427.651 seconds. 64-bit little-endian th3: SQLite 3.10.0 2016-01-05 03:39:52 a855697719e288c908ddb7950d32fd17ef546509
2016-01-06 01:13:31 drhpending+
190c. th3make zipvfs.rc memdebug.rc
On tallis: th3: 0 errors out of 8300151 tests in 4427.651 seconds. 64-bit little-endian th3: SQLite 3.10.0 2016-01-05 03:39:52 a855697719e288c908ddb7950d32fd17ef546509
2016-01-06 00:36:37 drhok
230. Run performance tests comparing the new SQLite release against the previous release and/or a release from one year ago. Document and justify any performance decrease.
2016-01-06 00:36:28 drhok
230f. One or more of the above on Windows.
speedtest1-3.9.2: 9.126s speedtest1-trunk: 9.079s
2016-01-06 00:32:34 drhok
300. Tests for the sessions branch with macros SQLITE_ENABLE_SESSION and SQLITE_ENABLE_PREUPDATE_HOOK.
2016-01-06 00:32:25 drhok+
300f. testfixture test/session.test
On tallis: 0 errors out of 46275 tests On poulenc: 0 errors out of 49174 tests
2016-01-06 00:31:01 drhok
190h. At least one of the above on Windows.
2016-01-06 00:29:16 drhok
230g. One or more of the above on Mac OS X.
2016-01-06 00:29:10 drhok
230b. The TH3 speed tests.
trunk: 6.074s 3.9/.2: 6.336s
2016-01-06 00:09:38 drhok
300d. make test (on Windows)
0 errors out of 166094 tests
2016-01-06 00:08:38 drhok
230e. One or more of the above on Linux.
2016-01-06 00:08:31 drhok
230d. ./speedtest1 --nosync --size 25 --trace 2>x.txt
time ./sqlite3 x.db <x.txt >/dev/null
trunk 2448 billion cycles. 3.9.2: 2508 billion cycles.
2016-01-06 00:05:25 drhok
230a. The Tcl "speed*.test" scripts.
trunk: 5.038s, 3975681 uS 3.9.2: 5.104s, 4035488 uS
2016-01-06 00:01:42 drhok+
230c. The "speedtest1" program.
trunk: 1.143 billion cycles. 3.9.2: 1.177 billion cycles. (trunk is 2.9% faster) 2015-01-01: 1.368 billion cycles. (trunk is 16.4% faster)
2016-01-05 23:58:53 drhok
230c. The "speedtest1" program.
3.9.2: 1.177 billion cycles. trunk: 1.143 billion cycles. 2.9% faster.
2016-01-05 23:54:09 mistachkinok
110g. th3make msvc.rc wince.rc min.rc - Windows Embedded Compact 2013 - When tests are going to be run on the [Hyper-V based] emulator, no-mmap.rc must be used as well.
0 errors out of 1513648 tests in 3641.753 seconds. 32-bit little-endian, SQLite 3.10.0 2016-01-05 03:39:52 a855697719e288c908ddb7950d32fd17ef546509
2016-01-05 23:47:02 drhpending
190c. th3make zipvfs.rc memdebug.rc
2016-01-05 23:46:58 drhpending
190h. At least one of the above on Windows.
2016-01-05 23:45:33 drhok
80c. tclsh multitest.tcl --scenario failures - all failures detected
2016-01-05 23:35:54 drhok
100. Tests for platform Windows 7.0/8.x (x86):
2016-01-05 23:35:42 drhok
100j. Verify that EXEs and DLLs generated using MSVC contain the correct version number, product name, description, and copyright as resources.
2016-01-05 23:33:16 drhok
100h. nmake /f makefile.msc WIN32HEAP=1 DEBUG=4 fulltestonly
1 errors out of 1190109 tests !Failures on these tests: selectG-100 The failure was a timing test. win7dev is a slow box, so that is OK.
2016-01-05 22:52:01 mistachkinpending
110g. th3make msvc.rc wince.rc min.rc - Windows Embedded Compact 2013 - When tests are going to be run on the [Hyper-V based] emulator, no-mmap.rc must be used as well.
2016-01-05 22:47:13 mistachkinok
110e. th3make msvc.rc wp80.rc min.rc - Windows Phone 8.0
0 errors out of 1506200 tests in 941.807 seconds. 32-bit little-endian, SQLite 3.10.0 2016-01-05 03:39:52 a855697719e288c908ddb7950d32fd17ef546509
2016-01-05 21:56:24 mistachkinpending
110e. th3make msvc.rc wp80.rc min.rc - Windows Phone 8.0
2016-01-05 21:56:03 mistachkinok
110c. th3make msvc.rc winrt.rc min.rc - Windows Runtime 8.0 (ARM)
0 errors out of 1507167 tests in 4473.884 seconds. 32-bit little-endian, SQLite 3.10.0 2016-01-05 03:39:52 a855697719e288c908ddb7950d32fd17ef546509
2016-01-05 21:07:33 mistachkinok
320. System.Data.SQLite builds and checks out using the SQLite core.
a855697719e288c908ddb7950d32fd17ef546509, Debug NetFx451 x86: 0 errors/497 tests, 1211 seconds, Release NetFx451 x86: 0 errors/497 tests, 1164 seconds, Debug NetFx451 x64: 0 errors/497 tests, 1058 seconds, Release NetFx451 x64: 0 errors/497 tests, 1043 seconds, 0 errors/24 tests (Debug NetCF20-ARM/NetCF35-ARM), 0 errors/24 tests (Release NetCF20-ARM/NetCF35-ARM)
2016-01-05 20:35:39 mistachkinpending
110c. th3make msvc.rc winrt.rc min.rc - Windows Runtime 8.0 (ARM)
2016-01-05 20:08:28 drhok
100b. tclsh multitest.tcl --omit test-ex
0 failures on 24 th3makes and 111847115 tests in (05:39:22) 3 cores on poulenc SQLite 3.10.0 2016-01-04 13:06:53 b779ca8a7580e2a0bb1176316c4540867b635229 0 failures on 25 th3makes and 124987179 tests in (08:00:00) 3 cores on poulenc SQLite 3.10.0 2016-01-05 03:39:52 a855697719e288c908ddb7950d32fd17ef546509
2016-01-05 19:05:25 mistachkinpending
320. System.Data.SQLite builds and checks out using the SQLite core.
2016-01-05 17:32:24 drhpending
100h. nmake /f makefile.msc WIN32HEAP=1 DEBUG=4 fulltestonly
2016-01-05 17:30:35 drhok
100d. tclsh test/releasetest.tcl
0 failures out of 1239833 tests in (02:50:35) 2 cores on win7dev SQLite 3.10.0 2016-01-05 03:39:52 a855697719e288c908ddb7950d32fd17ef546509
2016-01-05 15:53:01 drhok
60a. tclsh multitest.tcl
0 failures on 31 th3makes and 172598738 tests in (03:47:11) 4 cores on bella SQLite 3.10.0 2016-01-05 03:39:52 a855697719e288c908ddb7950d32fd17ef546509
2016-01-05 14:38:19 drhok+
160. Fossil updated to use the latest SQLite.
SQLite Version: 2016-01-05 03:39:52 [a855697719] (3.10.0)
2016-01-05 14:22:20 drhpending
60a. tclsh multitest.tcl
t16: fast.rc alignment4.rc..................................... FAIL (00:12:57) th3: 172 errors out of 7869327 tests in 725.723 seconds. 64-bit little-endian SQLite 3.10.0 2016-01-05 03:39:52 a855697719e288c908ddb7950d32fd17ef546509 Retesting after TH3 fixes.
2016-01-05 14:21:49 drhpending
80b. tclsh multitest.tcl --omit test-ex
Passed without the "--omit test-ex" option. Retesting with the latest code...
2016-01-05 14:21:16 drhpending
100b. tclsh multitest.tcl --omit test-ex
0 failures on 24 th3makes and 111847115 tests in (05:39:22) 3 cores on poulenc SQLite 3.10.0 2016-01-04 13:06:53 b779ca8a7580e2a0bb1176316c4540867b635229 Retesting with the latest code...
2016-01-05 14:20:17 drhpending
100d. tclsh test/releasetest.tcl
2016-01-05 13:50:55 danok
270. Verify that databases (including FTS3 and RTREE databases), rollback journals, and WAL files created by the release candidate are readable and writeable by historical versions of SQLite (as long as no unsupported features are used) and vice versa.
Tested against 3.6.4, 3.7.3 and 3.8.1 using backcompat.test.
2016-01-05 13:27:41 danok
190a. testfixture ../zipvfs/test/zipvfs.test (See test/README.txt in the ZIPVFS source tree for details.)
0 errors out of 72318 tests
2016-01-05 13:27:15 danok
70. Tests for platform Linux ARM (BeagleBoard)
2016-01-05 13:27:04 danok
70a. tclsh th3make min.rc
th3: 0 errors out of 1505814 tests in 3944.078 seconds. 32-bit little-endian th3: SQLite 3.10.0 2016-01-05 03:39:52 a855697719e288c908ddb7950d32fd17ef546509
2016-01-05 11:54:09 danok
70b. Recompile and test Fossil.
2016-01-05 11:35:53 danpending
70b. Recompile and test Fossil.
2016-01-05 11:35:41 danpending
70a. tclsh th3make min.rc
2016-01-05 11:06:41 drhok+
100e. tclsh test/releasetest.tcl --msvc
0 failures out of 1791209 tests in (04:35:33) on win7dev SQLite 3.10.0 2016-01-04 13:06:53 b779ca8a7580e2a0bb1176316c4540867b635229 0 failures out of 1790712 tests in (04:31:21) on win7dev SQLite 3.10.0 2016-01-05 03:39:52 a855697719e288c908ddb7950d32fd17ef546509
2016-01-05 10:50:02 drhok+
130b. tclsh multitest.tcl --only quick
0 failures on 7 th3makes and 11656979 tests in (02:19:27) 2 cores on sparc.sqlite.org SQLite 3.10.0 2016-01-04 13:06:53 b779ca8a7580e2a0bb1176316c4540867b635229 0 failures on 7 th3makes and 11663019 tests in (02:19:55) 2 cores on sparc.sqlite.org SQLite 3.10.0 2016-01-05 03:39:52 a855697719e288c908ddb7950d32fd17ef546509
2016-01-05 10:48:50 drhok+
60c. tclsh releasetest.tcl
0 failures out of 9573534 tests in (02:14:33) 3 cores on bella SQLite 3.10.0 2016-01-04 13:06:53 b779ca8a7580e2a0bb1176316c4540867b635229 0 failures out of 9573530 tests in (03:19:13) 3 cores on tallis SQLite 3.10.0 2016-01-05 03:39:52 a855697719e288c908ddb7950d32fd17ef546509
2016-01-05 10:47:59 drhfail
60a. tclsh multitest.tcl
t16: fast.rc alignment4.rc..................................... FAIL (00:12:57) th3: 172 errors out of 7869327 tests in 725.723 seconds. 64-bit little-endian SQLite 3.10.0 2016-01-05 03:39:52 a855697719e288c908ddb7950d32fd17ef546509
2016-01-05 10:45:56 drhok+
80a. tclsh releasetest.tcl
0 failures out of 4438603 tests in (04:00:17) 4 cores on macpro-2015 SQLite 3.10.0 2016-01-05 03:39:52 a855697719e288c908ddb7950d32fd17ef546509
2016-01-05 05:49:59 danok
80b. tclsh multitest.tcl --omit test-ex
Passed without the "--omit test-ex" option.
2016-01-05 04:52:10 mistachkinok+
110b. th3make msvc.rc winrt.rc min.rc - Windows Runtime 8.0 (x86)
0 errors out of 1507190 tests in 695.385 seconds. 32-bit little-endian, SQLite 3.10.0 2016-01-05 03:39:52 a855697719e288c908ddb7950d32fd17ef546509
2016-01-05 04:26:38 drhok+
130a. make test
0 errors out of 139782 tests a855697719e288c908ddb7950d32fd17ef546509 2016-01-05 03:39:52 UTC
2016-01-05 03:08:10 mistachkinok
110b. th3make msvc.rc winrt.rc min.rc - Windows Runtime 8.0 (x86)
0 errors out of 1507167 tests in 674.880 seconds. 32-bit little-endian, SQLite 3.10.0 2016-01-05 01:48:29 ac27f38eef7a241d56124c263d9f8c91f372a77f
2016-01-05 02:27:29 mistachkinpending
110b. th3make msvc.rc winrt.rc min.rc - Windows Runtime 8.0 (x86)
2016-01-05 00:38:53 drhok
300c. tclsh th3make session.rc quick.rc -valgrind
On tallis th3: 0 errors out of 1584781 tests in 12278.168 seconds. 64-bit little-endian th3: SQLite 3.10.0 2016-01-04 19:02:47 c785cd7813e4ef6d6f2cb362a0f822713db6bcea
2016-01-05 00:37:38 drhok
140. Sqllogictest:
2016-01-05 00:37:31 drhok
140d. tclsh run-all.tcl - on windows
0 errors out of 11879758 tests and 1244 invocations in 3588 seconds
2016-01-04 23:50:40 drhok
300a. tclsh th3make session.rc test.rc (on Windows)
th3: 0 errors out of 5980974 tests in 2377.245 seconds. 64-bit little-endian th3: SQLite 3.10.0 2016-01-04 19:02:47 c785cd7813e4ef6d6f2cb362a0f822713db6bcea
2016-01-04 23:42:10 mistachkinprelim
110b. th3make msvc.rc winrt.rc min.rc - Windows Runtime 8.0 (x86)
2016-01-04 23:20:37 mistachkinpending
110b. th3make msvc.rc winrt.rc min.rc - Windows Runtime 8.0 (x86)
2016-01-04 23:20:30 mistachkinfail
110b. th3make msvc.rc winrt.rc min.rc - Windows Runtime 8.0 (x86)
2016-01-04 23:00:50 drhok
200. NX-Devkit compiles and runs tclsh th3make test.rc nx_compress.o without error.
th3: 0 errors out of 6874656 tests in 1171.196 seconds. 64-bit little-endian th3: SQLite 3.10.0 2016-01-04 13:06:53 b779ca8a7580e2a0bb1176316c4540867b635229
2016-01-04 22:43:53 drhpending
140d. tclsh run-all.tcl - on windows
2016-01-04 22:35:36 drhok
100i. sh tool/symbols-mingw.sh - no incorrect exports or dependencies
2016-01-04 22:28:42 mistachkinretest
110b. th3make msvc.rc winrt.rc min.rc - Windows Runtime 8.0 (x86)
2016-01-04 22:28:33 mistachkin---
110b. th3make msvc.rc winrt.rc min.rc - Windows Runtime 8.0 (x86)
2016-01-04 22:26:42 drhok
100g. nmake /f makefile.msc MEMDEBUG=1 DEBUG=3 fulltestonly
0 errors out of 1187445 tests
2016-01-04 22:24:09 drhpending
200. NX-Devkit compiles and runs tclsh th3make test.rc nx_compress.o without error.
2016-01-04 22:15:50 drhok
140c. tclsh run-all.tcl - on unix
0 errors out of 11879758 tests and 1244 invocations in 829 seconds
2016-01-04 22:14:36 drhok
130. Tests for platform Solaris (SPARC):
2016-01-04 22:14:32 drhok
130b. tclsh multitest.tcl --only quick
0 failures on 7 th3makes and 11656979 tests in (02:19:27) 2 cores on sparc.mikeowens.ws SQLite 3.10.0 2016-01-04 13:06:53 b779ca8a7580e2a0bb1176316c4540867b635229
2016-01-04 22:14:26 drhpending+
130b. tclsh multitest.tcl --only quick
0 failures on 7 th3makes and 11656979 tests in (02:19:27) 2 cores on sparc.mikeowens.ws SQLite 3.10.0 2016-01-04 13:06:53 b779ca8a7580e2a0bb1176316c4540867b635229
2016-01-04 21:56:36 mistachkinpending
110b. th3make msvc.rc winrt.rc min.rc - Windows Runtime 8.0 (x86)
2016-01-04 21:08:10 drhpending
140c. tclsh run-all.tcl - on unix
2016-01-04 21:07:58 drhpending
130b. tclsh multitest.tcl --only quick
2016-01-04 21:07:44 drhpending
100g. nmake /f makefile.msc MEMDEBUG=1 DEBUG=3 fulltestonly
2016-01-04 21:07:30 drhpending
300c. tclsh th3make session.rc quick.rc -valgrind
2016-01-04 21:04:31 drhok
140b. No SQLite compiler warnings.
2016-01-04 21:04:27 drhok
140a. Checked in latest SQLite amalgamation.
2016-01-04 21:01:41 drhok
160. Fossil updated to use the latest SQLite.
2016-01-04 21:01:41 drhok
160a. No SQLite compiler warnings.
2016-01-04 21:01:41 drhok
160b. Used on active websites with no issues.
2016-01-04 20:58:16 danok
70a. tclsh th3make min.rc
th3: 0 errors out of 1504898 tests in 4010.450 seconds. 32-bit little-endian th3: SQLite 3.10.0 2016-01-04 13:06:53 b779ca8a7580e2a0bb1176316c4540867b635229
2016-01-04 20:58:10 danpending++
70a. tclsh th3make min.rc
th3: 0 errors out of 1504898 tests in 4010.450 seconds. 32-bit little-endian th3: SQLite 3.10.0 2016-01-04 13:06:53 b779ca8a7580e2a0bb1176316c4540867b635229
2016-01-04 20:55:29 drhok
120. Tests for platform OpenBSD (x86):
2016-01-04 20:55:25 drhok
120b. th3make quick.rc
th3: 0 errors out of 1595295 tests in 3032.345 seconds. 32-bit little-endian th3: SQLite 3.10.0 2016-01-04 13:06:53 b779ca8a7580e2a0bb1176316c4540867b635229 On devio.us
2016-01-04 20:54:22 drhok
300b. tclsh th3make session.rc test.rc (on Unix)
th3: 0 errors out of 7869713 tests in 2038.577 seconds. 64-bit little-endian th3: SQLite 3.10.0 2016-01-04 19:02:47 c785cd7813e4ef6d6f2cb362a0f822713db6bcea On tallis
2016-01-04 20:52:31 drhok
290. Build and verify correct operation of sqlite3_analyzer on:
2016-01-04 20:52:26 drhok
290d. Windows (MinGW)
2016-01-04 20:42:37 drhok
290e. Windows (MSVC)
2016-01-04 20:41:20 drhok
260. Verify that the amalgamation builds are byte-for-byte identical on all workstation platforms.
2016-01-04 20:41:14 drhok
260e. Windows using NMAKE.
e93cb629805890bc9bd932866d4e1961bec1e3c6 sqlite3.c 9dcb0f25b628d8186d4906a51f1fdd7d9333d270 sqlite3.h
2016-01-04 20:39:33 drhok
260d. Windows using native MinGW.
e93cb629805890bc9bd932866d4e1961bec1e3c6 sqlite3.c 9dcb0f25b628d8186d4906a51f1fdd7d9333d270 sqlite3.h
2016-01-04 20:32:53 drhok
110a. th3make msvc.rc test.rc - Windows 7.0/8.x (x64)
On poulenc th3: 0 errors out of 5984202 tests in 3322.500 seconds. 64-bit little-endian th3: SQLite 3.10.0 2016-01-04 13:06:53 b779ca8a7580e2a0bb1176316c4540867b635229
2016-01-04 20:31:22 drhok
100a. th3make msvc.rc test.rc /RTC1
On poulenc th3: 0 errors out of 5984202 tests in 3322.500 seconds. 64-bit little-endian th3: SQLite 3.10.0 2016-01-04 13:06:53 b779ca8a7580e2a0bb1176316c4540867b635229
2016-01-04 20:27:00 drhok
190f. At least one of the above on Linux.
2016-01-04 20:26:50 drhok
190d. th3make zipvfs.rc quick.rc -valgrind
th3: 0 errors out of 2114492 tests in 9901.674 seconds. 64-bit little-endian th3: SQLite 3.10.0 2016-01-04 13:06:53 b779ca8a7580e2a0bb1176316c4540867b635229 No valgrind errors Run on bella
2016-01-04 20:19:31 danok
80a. tclsh releasetest.tcl
2016-01-04 20:17:16 drhok
280. Cross-platform tests. Verify the ability of databases, WAL files, and rollback journals to be copied and used between 32-bit and 64-bit systems and between big-endian and little-endian systems.
2016-01-04 20:17:12 drhok
280e. 64-little to 32-big, ZIPVFS database.
2016-01-04 20:09:20 drhok
300f. testfixture test/session.test
On tallis 0 errors out of 46275 tests
2016-01-04 20:07:04 drhok
280f. 64-little to 32-big, CEROD database.
2016-01-04 20:04:23 drhok
280d. 64-little to 32-big, SEE database.
2016-01-04 20:00:23 drhok
280b. 32-big to 64-little, WAL.
2016-01-04 19:59:38 drhok
280c. 32-big to 64-little, rollback.
2016-01-04 19:59:33 drhok
280a. 32-big to 64-little, database.
2016-01-04 19:57:21 danpending
190a. testfixture ../zipvfs/test/zipvfs.test (See test/README.txt in the ZIPVFS source tree for details.)
2016-01-04 19:50:00 danok
220a. Linux
2016-01-04 19:49:54 danok
220. TEA archive builds correctly and runs:
2016-01-04 19:48:29 drhok
120a. make test
shell1-5.0... Error: failed with byte E0 mismatch All else passed - we'll let this one slide.
2016-01-04 19:47:51 danok
220b. Mac OS X
2016-01-04 19:47:29 danok
210. Amalgamation autoconf tarball.
2016-01-04 19:47:22 danok
210c. Works on Mac OS X.
2016-01-04 19:42:43 danok
210b. Works on Linux.
2016-01-04 19:42:31 danok
210a. Builds.
2016-01-04 19:31:34 danok
70b. Recompile and test Fossil.
2016-01-04 19:31:22 danpending+
70a. tclsh th3make min.rc
2016-01-04 19:22:34 danpending
70a. tclsh th3make min.rc
2016-01-04 19:13:09 drhok
190g. At least one of the above on Mac OS X.
2016-01-04 19:13:04 drhok
190e. th3make zipvfs.rc quick.rc
On sqlite-imac th3: 0 errors out of 2102375 tests in 1079.729 seconds. 64-bit little-endian th3: SQLite 3.10.0 2016-01-04 13:06:53 b779ca8a7580e2a0bb1176316c4540867b635229
2016-01-04 19:12:03 drhok
180. SEE tests using TH3:
2016-01-04 19:11:58 drhok
180j. At least one of the above on Windows.
2016-01-04 19:11:46 drhok
180d. see-rc4.c
quick.rc on poulenc th3: 0 errors out of 1577352 tests in 581.528 seconds. 64-bit little-endian th3: SQLite 3.10.0 2016-01-04 13:06:53 b779ca8a7580e2a0bb1176316c4540867b635229
2016-01-04 19:03:55 drhok
130a. make test
0 errors out of 139783 tests
2016-01-04 19:02:44 drhok
300e. make test (on Unix)
2016-01-04 19:01:11 drhok
60. Tests for platform Linux x86_64:
2016-01-04 19:01:07 drhok
60b. Check the "multitest.tcl" log files for undetected errors.
2016-01-04 18:59:50 drhok
60a. tclsh multitest.tcl
0 failures on 31 th3makes and 172378110 tests in (05:35:53) 3 cores on tallis SQLite 3.10.0 2016-01-04 13:06:53 b779ca8a7580e2a0bb1176316c4540867b635229
2016-01-04 18:55:38 drhok
90. Tests for platform Mac OS X 10.2 (PPC):
2016-01-04 18:55:32 drhok
90a. tclsh th3make quick.rc
th3: 24 errors out of 1507032 tests in 4150.012 seconds. 32-bit big-endian th3: SQLite 3.10.0 2016-01-04 13:06:53 b779ca8a7580e2a0bb1176316c4540867b635229 All 24 errors are in ctime03.1.6.1 or ctime03.1.6.2 - configuration differences between the target and the code generator host.
2016-01-04 18:50:10 drhok
100c. tclsh multitest.tcl --scenario failures - verify failures detected
2016-01-04 18:49:02 drhok
100b. tclsh multitest.tcl --omit test-ex
0 failures on 24 th3makes and 111847115 tests in (05:39:22) 3 cores on poulenc SQLite 3.10.0 2016-01-04 13:06:53 b779ca8a7580e2a0bb1176316c4540867b635229
2016-01-04 18:44:12 drhok
180i. At least one of the above on Mac OS X.
2016-01-04 18:44:04 drhok
180b. see-aes128-ofb.c
quick.rc on sqlite-imac th3: 0 errors out of 1553041 tests in 743.005 seconds. 64-bit little-endian th3: SQLite 3.10.0 2016-01-04 13:06:53 b779ca8a7580e2a0bb1176316c4540867b635229
2016-01-04 18:25:10 drhok
180c. see-aes256-ofb.c
quick.rc on bella th3: 0 errors out of 1563087 tests in 214.871 seconds. 64-bit little-endian th3: SQLite 3.10.0 2016-01-04 13:06:53 b779ca8a7580e2a0bb1176316c4540867b635229
2016-01-04 18:21:35 drhok
130c. Recompile and test Fossil.
2016-01-04 18:21:27 drhok
130d. Verify that Fossil repositories are cross-platform with x86/x64.
2016-01-04 18:21:00 drhok
290c. Solaris (SPARC)
2016-01-04 18:18:04 drhok
260f. Solaris (SPARC) using autoconf.
e93cb629805890bc9bd932866d4e1961bec1e3c6 sqlite3.c 9dcb0f25b628d8186d4906a51f1fdd7d9333d270 sqlite3.h
2016-01-04 18:13:16 drhok
180f. At least one of the above using "test.rc".
2016-01-04 18:13:11 drhok
180e. see-aes128-ccm.c
test.rc on bella th3: 0 errors out of 7834982 tests in 2522.602 seconds. 64-bit little-endian th3: SQLite 3.10.0 2016-01-04 13:06:53 b779ca8a7580e2a0bb1176316c4540867b635229
2016-01-04 18:05:35 drhok
100f. tclsh releasetest.tcl --platform Failure-Detection - all failures detected
2016-01-04 18:02:09 drhok
100e. tclsh test/releasetest.tcl --msvc
0 failures out of 1791209 tests in (04:35:33) on win7dev SQLite 3.10.0 2016-01-04 13:06:53 b779ca8a7580e2a0bb1176316c4540867b635229
2016-01-04 17:50:35 drhok
260c. OpenBSD
e93cb629805890bc9bd932866d4e1961bec1e3c6 sqlite3.c 9dcb0f25b628d8186d4906a51f1fdd7d9333d270 sqlite3.h
2016-01-04 17:48:36 drhok
260a. Linux
e93cb629805890bc9bd932866d4e1961bec1e3c6 sqlite3.c 9dcb0f25b628d8186d4906a51f1fdd7d9333d270 sqlite3.h
2016-01-04 17:48:12 drhok
260b. Mac OS X
e93cb629805890bc9bd932866d4e1961bec1e3c6 sqlite3.c 9dcb0f25b628d8186d4906a51f1fdd7d9333d270 sqlite3.h
2016-01-04 17:41:38 drhok
290b. Mac OS X
2016-01-04 17:41:33 drhok
290f. A database containing WITHOUT ROWID tables.
2016-01-04 17:40:28 drhok
290a. Linux
2016-01-04 17:38:30 drhok
150. Build using the configure/make in main source tree.
2016-01-04 17:38:26 drhok
150b. Verify the correct version numbers have been installed.
2016-01-04 17:38:22 drhok
150a. Make sure that autoconf has been run to update the configure script.
2016-01-04 17:24:01 drhok
90c. Verify that Fossil repositories are cross-platform with x86/x64.
2016-01-04 17:20:51 drhok
90b. Recompile and test Fossil.
sqlite-version: 2015-12-24 14:53:27 [7c7b7f2630] (3.10.0)
2016-01-04 17:18:33 drhok
180h. At least one of the above on Linux.
2016-01-04 17:18:25 drhok
180g. At least one of the above using "memdebug.rc".
2016-01-04 17:18:17 drhok
180a. see.c
memdebug on bella. th3: 0 errors out of 7833919 tests in 4347.202 seconds. 64-bit little-endian th3: SQLite 3.10.0 2016-01-04 13:06:53 b779ca8a7580e2a0bb1176316c4540867b635229
2016-01-04 16:30:42 drhok
170. CEROD tests in the "test/" subdirectory.
2016-01-04 16:26:58 drhok
60e. tclsh multitest.tcl --scenario failures - all failures detected
2016-01-04 15:55:43 drhok
310. Verify that the "sqlite3-all.c" build target works and that the resulting "sqlite3-all.c" file and its include files ("sqlite3-?.c") compile and run the same as the single-file amalgamation.
2016-01-04 15:53:33 drhok
50. OMIT, ENABLE, and DISABLE options:
2016-01-04 15:53:29 drhok
50a. tclsh ../tool/omittest.tcl -skip_run -target libsqlite3.a
2016-01-04 15:37:37 drhok
60f. tclsh releasetest.tcl --platform Failure-Detection - all failures detected
2016-01-04 15:27:20 drhok
60d. Check the "releasetest.tcl" log files for undetected errors.
2016-01-04 15:24:55 drhok
60c. tclsh releasetest.tcl
0 failures out of 9573534 tests in (02:14:33) 3 cores on bella SQLite 3.10.0 2016-01-04 13:06:53 b779ca8a7580e2a0bb1176316c4540867b635229
2016-01-04 14:02:12 drhok
250. Compute the size of a standard build (gcc -Os -c sqlite3.c) and and record the size change in the comments.
2016-01-04 14:02:02 drhok
250b. Versus the trunk from 12 months ago.
2015-01-04: 454177 trunk: 463959 2.2% larger
2016-01-04 13:57:27 drhok
250a. Versus the previous release.
3.9.2: 463691 trunk: 463959 0.05% larger.
2016-01-04 13:53:04 drhok
240. Run make wordcount; bash run-wordcount.bash $OPTIONS with options:
2016-01-04 13:53:00 drhok
240b. bash run-wordcount.sh sqlite3.c --cachesize 5 --nosync
2016-01-04 13:51:36 drhok
240a. bash run-wordcount.sh sqlite3.c
2016-01-04 12:27:42 drhok+
40b. Mac OS X GCC -Wall -Wextra (the "tool/warnings.sh" script)
Warnings on the "Android Configuration" but that does not apply for Mac. Need to update the script, though.
2016-01-04 12:19:32 drhok+
40e. Windows (64-bit) MSVC using option /W4
2016-01-04 12:19:28 drhok+
40d. Windows (32-bit) MSVC using option /W4
2016-01-04 12:19:01 drhok+
40a. Linux GCC -Wall -Wextra (the "tool/warnings.sh" script)
2016-01-04 11:57:31 drhprelim+
60c. tclsh releasetest.tcl
0 failures on 31 th3makes and 172377273 tests in (05:32:03) 3 cores on bella SQLite 3.10.0 2016-01-04 04:41:13 73e3355004b8b7ce2e1bb937725f429795528a4f
2016-01-04 03:54:15 drhok
40. Compiler warning checks.
2016-01-04 03:52:58 drhok
60g. sh tool/symbols.sh - no incorrect exports or dependencies
2016-01-04 03:51:21 drhok
40e. Windows (64-bit) MSVC using option /W4
2016-01-04 03:51:16 drhok
40d. Windows (32-bit) MSVC using option /W4
2016-01-04 03:32:30 drhok
40c. OpenBSD GCC using options -Wall
2016-01-04 03:21:34 drhok
40b. Mac OS X GCC -Wall -Wextra (the "tool/warnings.sh" script)
Warnings on the "Android Configuration" but that does not apply for Mac. Need to update the script, though.
2016-01-04 02:43:20 drhok
40a. Linux GCC -Wall -Wextra (the "tool/warnings.sh" script)
2016-01-04 02:42:24 drhok
20. Source code change review. fossil diff --from release --to trunk
2016-01-04 02:42:15 drhok
20j. Verify that the list of APIs exposed via the extension header is up-to-date (sqlite3ext.h).
2016-01-04 02:42:00 drhok
20i. Verify that source code contains no tabs and that surplus whitespace has been removed.
2016-01-04 02:41:29 drhok
20h. Check all calls to memory allocation routines to ensure that size computations are 64-bit clean. Suggested regular expression for search: /(Re|M)alloc[FORZa-z]*(/
Remember to make structural improvements to make this step easier at the beginning of the next change cycle.
2016-01-04 02:02:15 drhok
20g. Check all calls to sqlite3OsRead() and sqlite3OsWrite() to ensure that offset computations are 64-bit clean.
2016-01-04 01:52:43 drhok
20k. Significant compile-time options are recognized by the sqlite3_compileoption_used() interface.
2016-01-04 01:51:58 drhok
20f. Variables and functions have been renamed to reflect changes in their use.
2016-01-04 01:51:54 drhok
20e. Comments have been updated to reflect code changes.
2016-01-04 01:51:50 drhok
20d. New code complies with design rules.
2016-01-04 01:51:46 drhok
20c. New code complies with style guidelines.
2016-01-04 01:51:42 drhok
20b. All significant changes are mentioned in the "changes" log of the documentation.
2016-01-04 01:51:37 drhok
20a. No stray changes.
2016-01-04 00:17:24 drhok
30h. Test metrics are up-to-date (testing.html).
2016-01-04 00:17:20 drhok
30g. Database footprint is up-to-date (features.html).
2016-01-04 00:17:17 drhok
30f. The compile-time options are all up-to-date (compile.html).
2016-01-04 00:17:13 drhok
30e. Requirements marks are up-to-date in both documentation and source code.
2016-01-04 00:17:08 drhok
30d. No unresolved hyperlinks in the documentation build.
2016-01-04 00:17:03 drhok
30b. Release announcement in "changes.in".
2016-01-04 00:16:56 drhok
30a. Latest release on the "index.html" page.
2016-01-04 00:16:42 drhok
10. Test procedure review.
2016-01-04 00:16:38 drhok
10c. Review this checklist for completeness and accuracy.
2016-01-04 00:16:30 drhok
10b. Review "multitest.tcl" and "alignment*.rc" scripts in TH3 for completeness.
2016-01-04 00:16:25 drhok
10a. Review the "test/releasetest.tcl" script for completeness and accuracy.
2016-01-03 22:35:15 drhprelim++
100e. tclsh test/releasetest.tcl --msvc
0 failures out of 1793856 tests in (02:00:31) on poulenc SQLite 3.10.0 2016-01-03 11:27:47 76f5efa68728d899a63a74f2528dfd0c497aa5f0
2016-01-03 21:13:59 drhprelim+
100b. tclsh multitest.tcl --omit test-ex
0 failures on 25 th3make runs and 124734877 tests in (07:54:17) SQLite 3.10.0 2016-01-01 16:42:09 3e852804c85a5c9f4c4ffafd55d03af6d19fe5cc
2016-01-03 17:04:23 drhprelim
100b. tclsh multitest.tcl --omit test-ex
0 failures on 25 th3make runs and 124734877 tests in (07:54:17) SQLite 3.10.0 2016-01-01 16:42:09 3e852804c85a5c9f4c4ffafd55d03af6d19fe5cc
2016-01-03 16:59:24 drhprelim+
100e. tclsh test/releasetest.tcl --msvc
0 failures out of 1793856 tests in (02:00:31) on poulenc SQLite 3.10.0 2016-01-03 11:27:47 76f5efa68728d899a63a74f2528dfd0c497aa5f0
2016-01-03 10:49:59 drhprelim+
60a. tclsh multitest.tcl
0 failures on 31 th3make runs and 172246807 tests in (12:13:01) SQLite 3.10.0 2016-01-02 05:00:31 2047d2deabf2021ea05d620c3dd4919448027b11
2016-01-01 22:02:41 drhprelim+
200. NX-Devkit compiles and runs tclsh th3make test.rc nx_compress.o without error.
th3: 0 errors out of 6874700 tests in 1199.379 seconds. 64-bit little-endian th3: SQLite 3.10.0 2016-01-01 16:42:09 3e852804c85a5c9f4c4ffafd55d03af6d19fe5cc
2016-01-01 22:02:25 drhprelim
200. NX-Devkit compiles and runs tclsh th3make test.rc nx_compress.o without error.
2016-01-01 21:50:07 drhprelim
130b. tclsh multitest.tcl --only quick
0 failures on 7 th3make runs and 11657119 tests in (04:07:40) SQLite 3.10.0 2016-01-01 16:42:09 3e852804c85a5c9f4c4ffafd55d03af6d19fe5cc
2016-01-01 17:53:35 drhprelim
300e. make test (on Unix)
2016-01-01 17:51:12 drhprelim
310. Verify that the "sqlite3-all.c" build target works and that the resulting "sqlite3-all.c" file and its include files ("sqlite3-?.c") compile and run the same as the single-file amalgamation.
2016-01-01 17:50:18 drhprelim
50a. tclsh ../tool/omittest.tcl -skip_run -target libsqlite3.a
2016-01-01 17:34:26 drhprelim
130a. make test
2016-01-01 15:08:04 drhprelim
80a. tclsh releasetest.tcl
2016-01-01 13:13:59 drhprelim
130c. Recompile and test Fossil.
2015-12-31 23:21:21 drhprelim
190e. th3make zipvfs.rc quick.rc
th3: 0 errors out of 2114990 tests in 304.510 seconds. 64-bit little-endian th3: SQLite 3.10.0 2015-12-31 22:29:36 d41d4d7396fba60895535f21c438f8c75e7b2097
2015-12-31 19:00:21 drhprelim
100e. tclsh test/releasetest.tcl --msvc
0 failures out of 1793811 tests in (02:01:02) SQLite 3.10.0 2015-12-31 15:34:03 9c392c1019ee15f27c8e05b41246d2844f91f6c0
2015-12-31 18:51:30 drhprelim
140c. tclsh run-all.tcl - on unix
0 errors out of 11879758 tests and 1244 invocations in 858 seconds
2015-12-31 18:49:58 drhprelim
170. CEROD tests in the "test/" subdirectory.
2015-12-31 18:42:59 drhprelim
240a. bash run-wordcount.sh sqlite3.c
2015-12-31 18:35:30 drhprelim
90b. Recompile and test Fossil.
2015-12-31 18:25:47 drhprelim
40a. Linux GCC -Wall -Wextra (the "tool/warnings.sh" script)
2015-12-31 16:32:50 drhprelim
160. Fossil updated to use the latest SQLite.
2015-12-31 13:12:20 drhprelim
60a. tclsh multitest.tcl
0 failures on 31 th3make runs and 172209933 tests in (08:23:05) SQLite 3.10.0 2015-12-31 04:34:26 7a0b9413fa94d3f4fa9751ddf9b213a1238954f1
2015-12-31 13:11:58 drhprelim
60c. tclsh releasetest.tcl
0 failures out of 9573076 tests in (03:36:26) SQLite 3.10.0 2015-12-31 04:34:26 7a0b9413fa94d3f4fa9751ddf9b213a1238954f1