SQLite

Checklist For SQLite 3.20.0
Login
2017-08-01 02:36:09 drhok+++
60a. tclsh multitest.tcl (take care to update ../th3private)
0 failures on 42 th3makes and 183908644 tests in (05:57:02) 3 cores on bella SQLite 3.20.0 2017-07-25 15:12:01 f39cb76b3347baba22f2c329e74036710b64620414433a952de8d44da79ba8d9 0 failures on 42 th3makes and 183916539 tests in (07:42:01) 2 cores on bella SQLite 3.20.0 2017-07-27 18:43:13 2dfcd9a8ecdf0ddd8e044d820639830c6171141c588cf0224255af85c64cf79c 0 failures on 42 th3makes and 183916038 tests in (06:12:44) 3 cores on bella SQLite 3.20.0 2017-07-30 20:30:36 5c8cb1ff5da872fb5ab3f77f678b9df3b68525433f6d5d918f2911a5622bdd14 0 failures on 42 th3makes and 184112802 tests in (07:28:41) 2 cores on bella SQLite 3.20.0 2017-07-31 17:40:15 be0e24a0293f31b81fc5608a1d5aa1e57d3f5f7dddef6b368ae2e207bbdaf44c
2017-07-31 20:44:59 drhok+
40b. Mac OS X GCC -Wall -Wextra (the "tool/warnings.sh" script)
2017-07-31 20:42:52 drhok++
40a. Linux GCC -Wall -Wextra (the "tool/warnings.sh" script)
2017-07-31 20:42:21 drhok+
40e. Windows (64-bit) MSVC using option /W4 (nmake /f makefile.msc)
2017-07-31 20:42:16 drhok+
40d. Windows (32-bit) MSVC using option /W4 (nmake /f makefile.msc)
2017-07-31 20:40:06 drhok+
100f. nmake /f makefile.msc MEMDEBUG=1 DEBUG=3 test
SQLite 2017-07-25 15:12:01 f39cb76b3347baba22f2c329e74036710b64620414433a952de8d44da79ba8d9 0 errors out of 114421 tests on DESKTOP-8U9G1N8 Windows NT 64-bit little-endian SQLite 2017-07-31 20:06:21 96ff1675721c744b5c1173a99fc2ad3a2df64ca8e931738e3a87c72a6f8b1e72 0 errors out of 114406 tests on DESKTOP-8U9G1N8 Windows NT 64-bit little-endian
2017-07-31 20:12:46 drhok+++
100d. tclsh test/releasetest.tcl --msvc
0 failures out of 1986814 tests in (02:10:19) on DESKTOP-8U9G1N8 SQLite 3.20.0 2017-07-25 15:12:01 f39cb76b3347baba22f2c329e74036710b64620414433a952de8d44da79ba8d9 0 failures out of 1986770 tests in (02:10:39) on DESKTOP-8U9G1N8 SQLite 3.20.0 2017-07-27 18:43:13 2dfcd9a8ecdf0ddd8e044d820639830c6171141c588cf0224255af85c64cf79c 0 failures out of 1986820 tests in (02:10:05) on DESKTOP-8U9G1N8 SQLite 3.20.0 2017-07-30 20:30:36 5c8cb1ff5da872fb5ab3f77f678b9df3b68525433f6d5d918f2911a5622bdd14 0 failures out of 1986799 tests in (02:11:16) on DESKTOP-8U9G1N8 SQLite 3.20.0 2017-07-31 17:40:15 be0e24a0293f31b81fc5608a1d5aa1e57d3f5f7dddef6b368ae2e207bbdaf44c
2017-07-31 02:51:24 drhok++
100d. tclsh test/releasetest.tcl --msvc
0 failures out of 1986814 tests in (02:10:19) on DESKTOP-8U9G1N8 SQLite 3.20.0 2017-07-25 15:12:01 f39cb76b3347baba22f2c329e74036710b64620414433a952de8d44da79ba8d9 0 failures out of 1986770 tests in (02:10:39) on DESKTOP-8U9G1N8 SQLite 3.20.0 2017-07-27 18:43:13 2dfcd9a8ecdf0ddd8e044d820639830c6171141c588cf0224255af85c64cf79c 0 failures out of 1986820 tests in (02:10:05) on DESKTOP-8U9G1N8 SQLite 3.20.0 2017-07-30 20:30:36 5c8cb1ff5da872fb5ab3f77f678b9df3b68525433f6d5d918f2911a5622bdd14
2017-07-31 02:47:16 drhok++
60a. tclsh multitest.tcl (take care to update ../th3private)
0 failures on 42 th3makes and 183908644 tests in (05:57:02) 3 cores on bella SQLite 3.20.0 2017-07-25 15:12:01 f39cb76b3347baba22f2c329e74036710b64620414433a952de8d44da79ba8d9 0 failures on 42 th3makes and 183916539 tests in (07:42:01) 2 cores on bella SQLite 3.20.0 2017-07-27 18:43:13 2dfcd9a8ecdf0ddd8e044d820639830c6171141c588cf0224255af85c64cf79c 0 failures on 42 th3makes and 183916038 tests in (06:12:44) 3 cores on bella SQLite 3.20.0 2017-07-30 20:30:36 5c8cb1ff5da872fb5ab3f77f678b9df3b68525433f6d5d918f2911a5622bdd14
2017-07-28 10:35:58 drhok+
80b. tclsh multitest.tcl (after updating th3private)
0 failures on 37 th3makes and 148487304 tests in (09:24:53) 2 cores on macpro01 SQLite 3.20.0 2017-07-25 15:12:01 f39cb76b3347baba22f2c329e74036710b64620414433a952de8d44da79ba8d9 0 failures on 37 th3makes and 148497516 tests in (07:59:30) 3 cores on macpro01 SQLite 3.20.0 2017-07-27 18:43:13 2dfcd9a8ecdf0ddd8e044d820639830c6171141c588cf0224255af85c64cf79c
2017-07-28 02:54:49 drhok+
60a. tclsh multitest.tcl (take care to update ../th3private)
0 failures on 42 th3makes and 183908644 tests in (05:57:02) 3 cores on bella SQLite 3.20.0 2017-07-25 15:12:01 f39cb76b3347baba22f2c329e74036710b64620414433a952de8d44da79ba8d9 0 failures on 42 th3makes and 183916539 tests in (07:42:01) 2 cores on bella SQLite 3.20.0 2017-07-27 18:43:13 2dfcd9a8ecdf0ddd8e044d820639830c6171141c588cf0224255af85c64cf79c
2017-07-28 00:57:29 drhok+
140. Fossil updated to use the latest SQLite.
2017-07-28 00:57:22 drhok+
140b. Used on active websites with no issues.
2017-07-28 00:57:19 drhok+
140a. No SQLite compiler warnings.
2017-07-28 00:42:28 drhok+
40a. Linux GCC -Wall -Wextra (the "tool/warnings.sh" script)
Retest on 2dfcd9a8ecdf0ddd8e044d820639830c6171141
2017-07-28 00:39:59 drhok+
100b. tclsh multitest.tcl --msvc --quick on x86
0 failures on 15 th3makes and 20951037 tests in (01:11:00) 3 cores on DESKTOP-8U9G1N8 SQLite 3.20.0 2017-07-25 15:12:01 f39cb76b3347baba22f2c329e74036710b64620414433a952de8d44da79ba8d9 ON x64: 0 failures on 15 th3makes and 20763072 tests in (01:54:29) on DESKTOP-8U9G1N8 SQLite 3.20.0 2017-07-27 18:43:13 2dfcd9a8ecdf0ddd8e044d820639830c6171141c588cf0224255af85c64cf79c
2017-07-28 00:36:44 drhok+
100d. tclsh test/releasetest.tcl --msvc
0 failures out of 1986814 tests in (02:10:19) on DESKTOP-8U9G1N8 SQLite 3.20.0 2017-07-25 15:12:01 f39cb76b3347baba22f2c329e74036710b64620414433a952de8d44da79ba8d9 0 failures out of 1986770 tests in (02:10:39) on DESKTOP-8U9G1N8 SQLite 3.20.0 2017-07-27 18:43:13 2dfcd9a8ecdf0ddd8e044d820639830c6171141c588cf0224255af85c64cf79c
2017-07-27 09:28:20 danok
190. ZIPVFS tests:
2017-07-27 09:28:08 danok
190d. th3make zipvfs.rc quick.rc -valgrind
th3: 0 errors in 2821613 tests. 24585.089 seconds on darkstar 64-bit little-endian th3: SQLite 3.20.0 2017-07-25 15:12:01 f39cb76b3347baba22f2c329e74036710b64620414433a952de8d44da79ba8d9
2017-07-26 17:42:36 drhok
190h. At least one of the above on Windows.
2017-07-26 17:42:23 drhok
190b. th3make zipvfs.rc test.rc
th3: 0 errors in 8033488 tests. 4685.085 seconds on DESKTOP-8U9G1N8 64-bit little-endian th3: SQLite 3.20.0 2017-07-25 15:12:01 f39cb76b3347baba22f2c329e74036710b64620414433a952de8d44da79ba8d9
2017-07-26 17:26:01 drhok
30. Documentation review:
2017-07-26 17:25:57 drhok
30i. Check new/changed documentation for spelling and gramatical mistakes.
2017-07-26 17:25:53 drhok
30c. Release accouncement in "news.html".
2017-07-26 16:59:19 drhok+
330. Run the rbu/run_rbu_tests.tcl script in the test-dbs project on Linux.
2017-07-26 16:52:48 danok
300. 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 using backcompat.test against 3.8.2 and 3.7.3. SQLite 2017-07-25 15:12:01 f39cb76b3347baba22f2c329e74036710b64620414433a952de8d44da79ba8d9 0 errors out of 265 tests on darkstar Linux 64-bit little-endian
2017-07-26 16:52:42 dan---+
300. 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 using backcompat.test against 3.8.2 and 3.7.3. SQLite 2017-07-25 15:12:01 f39cb76b3347baba22f2c329e74036710b64620414433a952de8d44da79ba8d9 0 errors out of 265 tests on darkstar Linux 64-bit little-endian
2017-07-26 16:44:12 danok
330. Run the rbu/run_rbu_tests.tcl script in the test-dbs project on Linux.
All tests pass.
2017-07-26 16:20:02 drhok
240. Performance tests using speedtest1 --testset rtree
2017-07-26 16:19:58 drhok
240b. Windows
2017-07-26 16:18:32 drhok
230. Performance tests using speedtest1 compared against the previous release and a release from about one year ago.
2017-07-26 16:18:28 drhok
230d. Windows
2017-07-26 16:17:09 drhok
260. Compare performance to the previous release using kvtest.
2017-07-26 16:17:06 drhok
260d. Windows
2017-07-26 16:13:38 drhok
100. Tests for platform Windows:
2017-07-26 16:13:30 drhok
100h. sh tool/symbols-mingw.sh - no incorrect exports or dependencies
2017-07-26 16:12:10 drhok
200. NDS-Devkit testing
2017-07-26 16:12:05 drhok
200c. Verify the "NDS DevKit" version number shown at the end of the test
2017-07-26 16:11:14 drhok
200b. Test using: tclsh th3make test.rc nds_devkit.rc
th3: 0 errors in 7061459 tests. 1166.711 seconds on bella 64-bit little-endian th3: NDS DevKit 3.20.0 2017-07-26 15:49:12 75b78758aa285553 th3: SQLite 3.20.0 2017-07-25 15:12:01 f39cb76b3347baba22f2c329e74036710b64620414433a952de8d44da79ba8d9
2017-07-26 16:10:03 drhok
100i. Verify that EXEs and DLLs generated using MSVC contain the correct version number, product name, description, and copyright as resources.
2017-07-26 16:09:17 drhok
100g. nmake /f makefile.msc WIN32HEAP=1 DEBUG=4 test
SQLite 2017-07-25 15:12:01 f39cb76b3347baba22f2c329e74036710b64620414433a952de8d44da79ba8d9 0 errors out of 115460 tests on DESKTOP-8U9G1N8 Windows NT 64-bit little-endian
2017-07-26 16:08:51 danok
190c. th3make zipvfs.rc memdebug.rc
th3: 0 errors in 10032199 tests. 8557.638 seconds on darkstar 64-bit little-endian th3: SQLite 3.20.0 2017-07-25 15:12:01 f39cb76b3347baba22f2c329e74036710b64620414433a952de8d44da79ba8d9
2017-07-26 16:04:21 danok
190f. At least one of the above on Linux.
(a) on Linux
2017-07-26 16:04:09 dan---+
190f. At least one of the above on Linux.
(a) on Linux
2017-07-26 15:51:18 drhok
100f. nmake /f makefile.msc MEMDEBUG=1 DEBUG=3 test
SQLite 2017-07-25 15:12:01 f39cb76b3347baba22f2c329e74036710b64620414433a952de8d44da79ba8d9 0 errors out of 114421 tests on DESKTOP-8U9G1N8 Windows NT 64-bit little-endian
2017-07-26 15:50:41 drhok+
200a. Verify that devkit sources are up-to-date with SQLite and ZIPVFS by running update-src.sh and mkdevkit.tcl in the sbin subdirectory of the devkit source tree. Record nds_sqlite3.[ch] hashes in the comment.
aba55eb8642d5a07f44086b2c4219c5ee12ebb847a141c995bd2972422aabb0c nds_sqlite3.c 63bf8f0fd39cb183e4c8c9e04891d86e7d90d7a3edec27255bbce9dbb62f3651 nds_sqlite3.h
2017-07-26 15:45:05 drhok
200a. Verify that devkit sources are up-to-date with SQLite and ZIPVFS by running update-src.sh and mkdevkit.tcl in the sbin subdirectory of the devkit source tree. Record nds_sqlite3.[ch] hashes in the comment.
82c679960ff4c5698c8956a51b2e3179324dacb540b43a53c910bb8fdbdd54e4 nds_sqlite3.c 0f734904cf978a906383132015ee11a13740b1010d2a545f896cd5c0756127be nds_sqlite3.h
2017-07-26 15:39:54 drhok
100e. tclsh releasetest.tcl --platform Failure-Detection - all failures detected
2017-07-26 15:25:47 drhok
100d. tclsh test/releasetest.tcl --msvc
0 failures out of 1986814 tests in (02:10:19) on DESKTOP-8U9G1N8 SQLite 3.20.0 2017-07-25 15:12:01 f39cb76b3347baba22f2c329e74036710b64620414433a952de8d44da79ba8d9
2017-07-26 15:24:50 drhok
220. TEA archive builds correctly and runs:
2017-07-26 15:24:47 drhok
220b. Mac OS X
2017-07-26 15:12:22 drhok
260b. Linux
2017-07-26 15:10:46 drhok
240a. Linux
2017-07-26 15:08:08 danok
190g. At least one of the above on Mac OS X.
(e) ran on OSX.
2017-07-26 15:07:51 danok
190e. th3make zipvfs.rc quick.rc
On OSX. th3: 0 errors in 2800811 tests. 1619.771 seconds on Chanphen-Kruatawongs-iMac.local 64-bit little-endian th3: SQLite 3.20.0 2017-07-25 15:12:01 f39cb76b3347baba22f2c329e74036710b64620414433a952de8d44da79ba8d9
2017-07-26 15:07:02 drhok
30h. Test metrics are up-to-date (testing.html).
2017-07-26 14:56:06 drhok
20. Source code change review. fossil diff --from release --to trunk
2017-07-26 14:56:03 drhok
20l. Compare sqlite3.c and sqlite3.h against the previous release.
2017-07-26 14:55:57 drhok
20k. Significant compile-time options are recognized by the sqlite3_compileoption_used() interface.
2017-07-26 14:55:51 drhok
20j. Verify that the list of APIs exposed via the extension header is up-to-date (sqlite3ext.h).
2017-07-26 14:55:48 drh---+
20j. Verify that the list of APIs exposed via the extension header is up-to-date (sqlite3ext.h).
2017-07-26 14:55:38 drhok
20i. Verify that source code contains no tabs and that surplus whitespace has been removed.
2017-07-26 14:55:00 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]*(/
2017-07-26 14:54:56 drhok
20g. Check all calls to sqlite3OsRead() and sqlite3OsWrite() to ensure that offset computations are 64-bit clean.
2017-07-26 14:54:51 drhok
20f. Variables and functions have been renamed to reflect changes in their use.
2017-07-26 14:54:47 drhok
20e. Comments have been updated to reflect code changes.
2017-07-26 14:54:38 drhok
20d. New code complies with design rules.
2017-07-26 14:54:35 drhok
20c. New code complies with style guidelines.
2017-07-26 14:54:32 drhok
20b. All significant changes are mentioned in the "changes" log of the documentation.
2017-07-26 14:54:28 drhok
20a. No stray changes.
2017-07-26 14:46:53 drhok
30g. Database footprint is up-to-date (features.html).
2017-07-26 14:46:42 drhok
30f. The compile-time options are all up-to-date (compile.html).
2017-07-26 14:12:42 danpending
190e. th3make zipvfs.rc quick.rc
On OSX.
2017-07-26 13:54:01 danok
190i. th3make zipvfs-cov.rc - verify full coverage
th3: 0 errors in 1246782 tests. 382.653 seconds on darkstar 64-bit little-endian th3: SQLite 3.20.0 2017-07-25 15:12:01 f39cb76b3347baba22f2c329e74036710b64620414433a952de8d44da79ba8d9 Statement coverage: 100.00% hit 1590 missed 0 total 1590 Branch coverage: 100.00% hit 941 missed 0 total 941
2017-07-26 13:48:17 drhok
220a. Linux
2017-07-26 13:44:28 drhok
210. Amalgamation autoconf tarball.
2017-07-26 13:44:01 drhok
210d. Works on Windows MinGW
2017-07-26 13:37:26 drhok
210e. Works on Windows MSVC
2017-07-26 13:33:32 drhok
210c. Works on Mac OS X.
2017-07-26 13:29:16 drhok
210b. Works on Linux.
2017-07-26 13:27:22 drhok
210a. Builds.
2017-07-26 13:26:00 drhok
260a. Android
2017-07-26 13:23:23 drhok
230a. Android
2017-07-26 13:22:47 drhok
170. SEE tests using TH3:
2017-07-26 13:22:40 drh---+
170. SEE tests using TH3:
2017-07-26 13:22:32 drhok
170k. At least one of the above on Windows.
2017-07-26 13:22:19 drhok
170d. see-rc4.c
th3: 0 errors in 1707357 tests. 1345.545 seconds on win7dev 64-bit little-endian th3: SQLite 3.20.0 2017-07-25 15:12:01 f39cb76b3347baba22f2c329e74036710b64620414433a952de8d44da79ba8d9
2017-07-26 13:17:14 drhok
230c. Mac
2017-07-26 13:08:52 drhok
100b. tclsh multitest.tcl --msvc --quick on x86
0 failures on 15 th3makes and 20951037 tests in (01:11:00) 3 cores on DESKTOP-8U9G1N8 SQLite 3.20.0 2017-07-25 15:12:01 f39cb76b3347baba22f2c329e74036710b64620414433a952de8d44da79ba8d9
2017-07-26 12:56:15 drhok
40. Compiler warning checks.
2017-07-26 12:56:11 drhok
40c. OpenBSD GCC using options -Wall
2017-07-26 12:34:37 drhok
150. Rebuild and use Firefox with the latest SQLite
2017-07-26 12:34:32 drhok
150d. ./mach web-platform-tests IndexedDB
2017-07-26 12:32:23 drhok
150c. ./mach xpcshell-test dom/indexedDB
2017-07-26 12:29:45 drhok
150b. ./mach mochitest dom/indexedDB
2017-07-26 12:27:49 drhok
170e. see-aes128-ccm.c
th3: 0 errors in 1703766 tests. 253.431 seconds on bella 64-bit little-endian th3: SQLite 3.20.0 2017-07-25 15:12:01 f39cb76b3347baba22f2c329e74036710b64620414433a952de8d44da79ba8d9
2017-07-26 12:19:54 drhok
170c. see-aes256-ofb.c
th3: 0 errors in 1703529 tests. 226.680 seconds on bella 64-bit little-endian th3: SQLite 3.20.0 2017-07-25 15:12:01 f39cb76b3347baba22f2c329e74036710b64620414433a952de8d44da79ba8d9 F
2017-07-26 12:15:37 drhok
170f. see-cccrypt.c
th3: 0 errors in 1687321 tests. 254.223 seconds on macpro01 64-bit little-endian th3: SQLite 3.20.0 2017-07-25 15:12:01 f39cb76b3347baba22f2c329e74036710b64620414433a952de8d44da79ba8d9
2017-07-26 12:14:18 drhok
180. SEE using configure; make test
2017-07-26 12:14:15 drhok
180a. Linux
2017-07-26 12:01:53 drhok
170a. see.c
th3: 0 errors in 8206243 tests. 4616.974 seconds on bella 64-bit little-endian th3: SQLite 3.20.0 2017-07-25 15:12:01 f39cb76b3347baba22f2c329e74036710b64620414433a952de8d44da79ba8d9
2017-07-26 12:01:46 drhok
170i. At least one of the above on Linux.
2017-07-26 12:01:41 drhok
170h. At least one of the above using "memdebug.rc".
2017-07-26 12:01:36 drhpending+
170a. see.c
th3: 0 errors in 8206243 tests. 4616.974 seconds on bella 64-bit little-endian th3: SQLite 3.20.0 2017-07-25 15:12:01 f39cb76b3347baba22f2c329e74036710b64620414433a952de8d44da79ba8d9
2017-07-26 11:49:33 danpending
190i. th3make zipvfs-cov.rc - verify full coverage
2017-07-26 11:49:23 danpending
190d. th3make zipvfs.rc quick.rc -valgrind
2017-07-26 11:47:26 danpending
190c. th3make zipvfs.rc memdebug.rc
2017-07-26 11:45:33 drhpending
170f. see-cccrypt.c
2017-07-26 11:44:52 drhok
170g. At least one of the above using "test.rc".
2017-07-26 11:44:45 drhok
170j. At least one of the above on Mac OS X.
2017-07-26 11:44:38 drhok
170b. see-aes128-ofb.c
th3: 0 errors in 6433213 tests. 2766.653 seconds on macpro01 64-bit little-endian th3: SQLite 3.20.0 2017-07-25 15:12:01 f39cb76b3347baba22f2c329e74036710b64620414433a952de8d44da79ba8d9
2017-07-26 11:44:02 danok
190a. testfixture ../zipvfs/test/zipvfs.test (See test/README.txt for details)
SQLite 2017-07-25 15:12:01 f39cb76b3347baba22f2c329e74036710b64620414433a952de8d44da79ba8d9 0 errors out of 85603 tests on darkstar Linux 64-bit little-endian
2017-07-26 11:10:34 danpending
190a. testfixture ../zipvfs/test/zipvfs.test (See test/README.txt for details)
2017-07-26 11:05:48 danok
110. Tests for platform OpenBSD (x86):
2017-07-26 11:05:40 danok
110b. th3make quick.rc
th3: 0 errors in 1746226 tests. 720.718 seconds on obsd.my.domain 32-bit little-endian th3: SQLite 3.20.0 2017-07-25 15:12:01 f39cb76b3347baba22f2c329e74036710b64620414433a952de8d44da79ba8d9
2017-07-26 11:05:17 danok+
110a. make test
SQLite 2017-07-25 15:12:01 f39cb76b3347baba22f2c329e74036710b64620414433a952de8d44da79ba8d9 0 errors out of 141991 tests on wolfman.devio.us OpenBSD 32-bit little-endian Also SQLite 2017-07-25 15:12:01 f39cb76b3347baba22f2c329e74036710b64620414433a952de8d44da79ba8d9 0 errors out of 141709 tests on obsd.my.domain OpenBSD 32-bit little-endian
2017-07-26 10:58:49 drhok
110a. make test
SQLite 2017-07-25 15:12:01 f39cb76b3347baba22f2c329e74036710b64620414433a952de8d44da79ba8d9 0 errors out of 141991 tests on wolfman.devio.us OpenBSD 32-bit little-endian
2017-07-26 10:57:57 drhok
160. CEROD tests in the "test/" subdirectory.
2017-07-26 10:47:05 drhpending
170j. At least one of the above on Mac OS X.
2017-07-26 10:47:00 drhpending
170g. At least one of the above using "test.rc".
2017-07-26 10:46:53 drhpending
170b. see-aes128-ofb.c
2017-07-26 10:44:44 drhok
180b. Mac
SQLite 2017-07-25 15:12:01 f39cb76b3347baba22f2c329e74036710b64620414433a952de8d44da79ba8d9 0 errors out of 141069 tests on macpro01 Darwin 64-bit little-endian
2017-07-26 10:43:43 danpending
110b. th3make quick.rc
2017-07-26 10:43:34 danpending+
110a. make test
2017-07-26 10:32:21 drhpending
110a. make test
2017-07-26 10:32:13 drhpending
180b. Mac
2017-07-26 10:26:28 drhpending
170i. At least one of the above on Linux.
2017-07-26 10:26:22 drhpending
170h. At least one of the above using "memdebug.rc".
2017-07-26 10:26:15 drhpending
170a. see.c
2017-07-26 10:22:50 drhok
80. Tests for platform Mac OS X:
2017-07-26 10:22:44 drhok
80d. tclsh releasetest.tcl --platform Failure-Detection - all failures detected
18 failures out of 394 tests in (00:07:04) on macpro01 SQLite 3.20.0 2017-07-25 15:12:01 f39cb76b3347baba22f2c329e74036710b64620414433a952de8d44da79ba8d9
2017-07-26 10:12:16 drhok
100c. tclsh multitest.tcl --msvc --scenario failures - verify failures detected
2 failures on 2 th3makes and 42 tests in (00:11:52) on DESKTOP-8U9G1N8 SQLite 3.20.0 2017-07-25 15:12:01 f39cb76b3347baba22f2c329e74036710b64620414433a952de8d44da79ba8d9
2017-07-26 10:11:31 drhok
60. Tests for platform Linux x86_64:
2017-07-26 10:11:27 drhok
60c. tclsh multitest.tcl --scenario failures - all failures detected
5 failures on 5 th3makes and 118 tests in (00:00:32) on bella SQLite 3.20.0 2017-07-25 15:12:01 f39cb76b3347baba22f2c329e74036710b64620414433a952de8d44da79ba8d9
2017-07-26 10:11:11 drhok
80c. tclsh multitest.tcl --scenario failures - all failures detected
2 failures on 2 th3makes and 42 tests in (00:00:07) on macpro01 SQLite 3.20.0 2017-07-25 15:12:01 f39cb76b3347baba22f2c329e74036710b64620414433a952de8d44da79ba8d9
2017-07-26 09:59:17 drhok
80b. tclsh multitest.tcl (after updating th3private)
0 failures on 37 th3makes and 148487304 tests in (09:24:53) 2 cores on macpro01 SQLite 3.20.0 2017-07-25 15:12:01 f39cb76b3347baba22f2c329e74036710b64620414433a952de8d44da79ba8d9
2017-07-26 09:57:56 drhok
60a. tclsh multitest.tcl (take care to update ../th3private)
0 failures on 42 th3makes and 183908644 tests in (05:57:02) 3 cores on bella SQLite 3.20.0 2017-07-25 15:12:01 f39cb76b3347baba22f2c329e74036710b64620414433a952de8d44da79ba8d9
2017-07-26 09:57:13 drhok
100a. tclsh multitest.tcl --msvc (after updating th3private)
0 failures on 36 th3makes and 138830148 tests in (08:46:10) 3 cores on DESKTOP-8U9G1N8 SQLite 3.20.0 2017-07-25 15:12:01 f39cb76b3347baba22f2c329e74036710b64620414433a952de8d44da79ba8d9
2017-07-26 07:23:14 danok
70. Tests for platform Linux ARM (BeagleBoard)
2017-07-26 07:23:08 danok
70a. tclsh th3make min.rc
th3: 0 errors in 1621553 tests. 4811.772 seconds on beaglebone 32-bit little-endian th3: SQLite 3.20.0 2017-07-25 15:12:01 f39cb76b3347baba22f2c329e74036710b64620414433a
2017-07-26 07:22:50 danok
80a. tclsh releasetest.tcl
0 failures out of 4937873 tests in (04:09:39) 2 cores on Chanphen-Kruatawongs-iMac.local SQLite 3.20.0 2017-07-25 15:12:01 f39cb76b3347baba22f2c329e74036710b64620414433a952de8d44da79ba8d9
2017-07-25 23:08:25 drhok
310. Build and verify correct operation of sqlite3_analyzer on:
2017-07-25 23:08:21 drhok
310c. Windows (MinGW)
2017-07-25 22:50:45 drhok
90. Tests for platform Mac OS X 10.2 (PPC):
2017-07-25 22:50:41 drhok
90a. tclsh th3make quick.rc
th3: 0 errors in 885590 tests. 2807.394 seconds on crabapple.local. 32-bit big-endian th3: SQLite 3.20.0 2017-07-25 15:12:01 f39cb76b3347baba22f2c329e74036710b64620414433a952de8d44da79ba8d9 th3: 0 errors in 1103194 tests. 9452.248 seconds on crabapple.local. 32-bit big-endian th3: SQLite 3.20.0 2017-07-25 15:12:01 f39cb76b3347baba22f2c329e74036710b64620414433a952de8d44da79ba8d9
2017-07-25 21:12:21 danok
70b. Recompile and test Fossil.
[fossil all rebuild] works. [fossil clone] works.
2017-07-25 20:27:18 drhok
230b. Linux
1.144G cycles on 3.19.2 vs. 1.122G cycles on 3.20.0 - decrease of 1.9% Size changes from 491656 to 492102 - an increase of 0.09%
2017-07-25 20:22:33 drhok
130. Build using the configure/make in main source tree.
2017-07-25 20:22:33 drhok
130a. Make sure that autoconf has been run to update the configure script.
2017-07-25 20:22:33 drhok
130b. Verify the correct version numbers have been installed.
2017-07-25 20:05:19 drhok
340. 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.
2017-07-25 20:04:50 drhok
320. Build and verify sqldiff
2017-07-25 20:04:45 drhok
310b. Mac OS X
2017-07-25 20:04:41 drhok
320b. Mac
2017-07-25 20:01:37 drhok
310d. Windows (MSVC)
2017-07-25 19:50:05 drhok
250. Run make wordcount; bash run-wordcount.bash $OPTIONS with options:
2017-07-25 19:50:00 drhok
250b. bash run-wordcount.sh sqlite3.c --cachesize 5 --nosync
2017-07-25 19:47:58 drhok
250a. bash run-wordcount.sh sqlite3.c
2017-07-25 19:43:20 drhok
260c. Mac
No detectable difference
2017-07-25 19:30:09 drhok
120. Sqllogictest:
2017-07-25 19:30:04 drhok
120d. tclsh run-all.tcl - on windows
0 errors out of 11879758 tests and 1244 invocations in 2004 seconds
2017-07-25 19:01:06 drhok
120c. tclsh run-all.tcl - on unix
0 errors out of 11879758 tests and 1244 invocations in 737 seconds
2017-07-25 18:44:32 danok
60d. tclsh releasetest.tcl --platform Failure-Detection - all failures detected
All configurations report FAIL. 26 failures out of 786 tests in (00:08:58) on darkstar SQLite 3.20.0 2017-07-25 15:12:01 f39cb76b3347baba22f2c329e74036710b64620414433a952de8d44da79ba8d9
2017-07-25 18:42:29 drhok
120b. No SQLite compiler warnings.
2017-07-25 18:42:26 drhok
120a. Checked in latest SQLite amalgamation.
2017-07-25 18:33:16 drhok
270. Use the ".selftest" command of the shell to verify that legacy database files are readable and cross-platform
2017-07-25 18:33:13 drhok
270a. iBook PPC
2017-07-25 18:31:02 drhok
270c. Mac
2017-07-25 18:28:12 drhok
50. OMIT, ENABLE, and DISABLE options:
2017-07-25 18:28:08 drhok
50a. tclsh ../tool/omittest.tcl -skip_run -target libsqlite3.a
2017-07-25 18:19:13 drhok
150a. Routine use with no problems
2017-07-25 18:07:58 danok
60b. tclsh releasetest.tcl
0 failures out of 9996005 tests in (01:42:50) 3 cores on darkstar SQLite 3.20.0 2017-07-25 15:12:01 f39cb76b3347baba22f2c329e74036710b64620414433a952de8d44da79ba8d9
2017-07-25 18:01:21 drhok
90c. Verify that Fossil repositories are cross-platform with x86/x64.
2017-07-25 17:55:23 drhok
90b. Recompile and test Fossil.
2017-07-25 17:46:43 drhok
140. Fossil updated to use the latest SQLite.
2017-07-25 17:46:43 drhok
140a. No SQLite compiler warnings.
2017-07-25 17:46:43 drhok
140b. Used on active websites with no issues.
2017-07-25 17:46:43 drhok
140c. fossil all dbstat --db-check
2017-07-25 16:55:25 drhok
320c. Windows
2017-07-25 16:53:06 drhok
270d. Windows
2017-07-25 16:51:01 drhok
290. Verify that the amalgamation builds are byte-for-byte identical on all workstation platforms.
2017-07-25 16:50:54 drhok
290c. Windows using native MinGW.
6e3463de355fad4553c134e13fa4e5f97b5f6498d433ec649af096509adfdda8 sqlite3.c 247226788d6cdebd7c9564e017673306289bfff42fe0db6f6d459a56a795cc59 sqlite3.h
2017-07-25 16:49:17 drhok
270b. Linux
2017-07-25 16:48:20 drhok
280. Verify that the performance and size measurement spreadsheet in the documentation (misc/speed-size-graph.ods) is up-to-date.
2017-07-25 16:47:22 drhok
290a. Linux
6e3463de355fad4553c134e13fa4e5f97b5f6498d433ec649af096509adfdda8 sqlite3.c 247226788d6cdebd7c9564e017673306289bfff42fe0db6f6d459a56a795cc59 sqlite3.h
2017-07-25 16:47:06 drhok
290b. Mac OS X
6e3463de355fad4553c134e13fa4e5f97b5f6498d433ec649af096509adfdda8 sqlite3.c 247226788d6cdebd7c9564e017673306289bfff42fe0db6f6d459a56a795cc59 sqlite3.h
2017-07-25 16:46:32 drhok
290d. Windows using NMAKE.
6e3463de355fad4553c134e13fa4e5f97b5f6498d433ec649af096509adfdda8 sqlite3.c 247226788d6cdebd7c9564e017673306289bfff42fe0db6f6d459a56a795cc59 sqlite3.h
2017-07-25 16:44:38 drhok
310e. A database containing WITHOUT ROWID tables.
2017-07-25 16:44:28 drhok
310a. Linux
2017-07-25 16:43:14 drhok
320a. Linux
2017-07-25 15:59:35 drhok
40d. Windows (32-bit) MSVC using option /W4 (nmake /f makefile.msc)
2017-07-25 15:59:27 drhok
40e. Windows (64-bit) MSVC using option /W4 (nmake /f makefile.msc)
2017-07-25 15:53:02 drhok
40b. Mac OS X GCC -Wall -Wextra (the "tool/warnings.sh" script)
2017-07-25 15:52:53 drhok
60e. sh tool/symbols.sh - no incorrect exports or dependencies
2017-07-25 15:50:37 drhok
40a. Linux GCC -Wall -Wextra (the "tool/warnings.sh" script)
2017-07-25 15:46:40 drhok
30d. No unresolved hyperlinks in the documentation build.
2017-07-25 15:46:36 drhok
30e. Requirements marks are up-to-date in both documentation and source code.
2017-07-25 15:45:47 drhok
30b. Release announcement in "changes.in".
2017-07-25 15:45:43 drhok
30a. Latest release on the "index.html" page.
2017-07-25 15:45:29 drhok
10. Test procedure review.
2017-07-25 15:45:29 drhok
10a. Review the "test/releasetest.tcl" script for completeness and accuracy.
2017-07-25 15:45:29 drhok
10b. Review "multitest.tcl" and "alignment*.rc" scripts in TH3 for completeness.
2017-07-25 15:45:29 drhok
10c. Review this checklist for completeness and accuracy.