SQLite

Release Checklist for SQLite 3.36.0
Login
2021-06-18 18:35:19 drhok
3. Documentation review:
2021-06-18 18:35:17 drhok
3c. Release accouncement in "news.html".
2021-06-18 06:19:16 danok
20. ZIPVFS tests:
2021-06-18 06:19:14 danok
20d. th3make zipvfs.rc quick.rc -valgrind
th3: 0 errors in 3529104 tests. 33323.719 seconds on darkstar 64-bit little-endian th3: SQLite 3.36.0 2021-06-16 19:23:24 7bd55eee1ac63cf6d5699ce85bc5a29bf51afdf7a80bce44937fa833947a40f4 ==29503== ERROR SUMMARY: 0 errors from 0 contexts (suppressed: 0 from 0)
2021-06-18 06:19:09 danpending
20d. th3make zipvfs.rc quick.rc -valgrind
th3: 0 errors in 3529104 tests. 33323.719 seconds on darkstar 64-bit little-endian th3: SQLite 3.36.0 2021-06-16 19:23:24 7bd55eee1ac63cf6d5699ce85bc5a29bf51afdf7a80bce44937fa833947a40f4 ==29503== ERROR SUMMARY: 0 errors from 0 contexts (suppressed: 0 from 0)
2021-06-18 00:10:28 drhok
3h. Test metrics are up-to-date (testing.html).
2021-06-18 00:10:14 drhok
3g. Database footprint is up-to-date (features.html).
2021-06-18 00:09:59 drhok
3f. The compile-time options are all up-to-date (compile.html).
2021-06-18 00:09:54 drhok
3b. Release announcement in "changes.in".
2021-06-18 00:09:47 drhok
3a. Latest release on the "index.html" page.
2021-06-17 22:42:12 drhok
1. Test procedure review.
2021-06-17 22:42:10 drhok
1c. Review this checklist for completeness and accuracy.
2021-06-17 22:42:07 drhok
1b. Review "multitest.tcl" and "alignment*.rc" scripts in TH3 for completeness.
2021-06-17 22:42:04 drhok
1a. Review the "test/wapptest.tcl" script for completeness and accuracy.
2021-06-17 22:41:55 drhok
29. Verify that the performance and size measurement spreadsheet in the documentation (misc/speed-size-graph.ods) is up-to-date.
2021-06-17 20:25:06 drhok
21. NDS-Devkit testing
2021-06-17 20:25:03 drhok
21c. Verify the "NDS DevKit" version number shown at the end of the test
2021-06-17 20:25:00 drhok
21b. Test using: tclsh th3make test.rc nds_devkit.rc
th3: 0aba411cf1bbc94c5ede988272f6249cae1cb31f42f583de470f12a043b113a4 th3: ./th3make test.rc nds_devkit.rc th3: mkth3.tcl -DSQLITE_DEBUG -DSQLITE_ENABLE_EXPENSIVE_ASSERT -DSQLITE_ENABLE_WHERETRACE -DSQLITE_ENABLE_BYTECODE_VTAB -DSQLITE_ENABLE_DBPAGE_VTAB -DSQLITE_ENABLE_DBSTAT_VTAB -DSQLITE_ENABLE_DESERIALIZE -DSQLITE_ENABLE_JSON1 -DSQLITE_ENABLE_STMTVTAB -DNDS_ENABLE_EXTENSIONS -DNDS_ENABLE_COMPRESS -DSQLITE_ENABLE_SHARED_SCHEMA -DSQLITE_SECURE_DELETE nx_compress.c cfg/?*.cfg extra1/?*.cfg bugs/?*.test cov1/?*.test extra1/?*.test fts/?*.test req1/?*.test demo/?*.test th3: 0 errors in 9653142 tests. 3042.221 seconds on bella 64-bit little-endian th3: NDS DevKit 3.36.0 2021-06-17 17:49:48 34ead61dccbe5cdb th3: SQLite 3.36.0 2021-06-17 17:26:53 92d8f967c9a7e4005c63703af8075b3d2ae5aa43c6b5bc6e599735dc4479bef6
2021-06-17 19:35:46 drhok
23. TEA archive builds correctly and runs:
2021-06-17 19:35:43 drhok
23d. Windows MSVC
2021-06-17 19:34:09 drhok
22. Amalgamation autoconf tarball.
2021-06-17 19:34:05 drhok
22e. Works on Windows MSVC
2021-06-17 19:26:57 drhok
19. SEE tests using TH3:
2021-06-17 19:26:47 drhok
19o. At least one of the above on Windows.
2021-06-17 19:26:42 drhok
19h. see-aes256-cryptoapi.c
th3: 0baa7e47470dc9e3ef790b1a0284d6905f695c3e88b7ad81bb57b1c6945e3cd7 th3: th3make msvc.rc see.rc quick.rc th3: mkth3.tcl -D_CRT_SECURE_NO_DEPRECATE -D_CRT_SECURE_NO_WARNINGS -D_CRT_NONSTDC_NO_DEPRECATE -D_CRT_NONSTDC_NO_WARNINGS -DSQLITE_HAS_CODEC -DSQLITE_DEBUG -DSQLITE_ENABLE_BYTECODE_VTAB -DSQLITE_ENABLE_DESERIALIZE -DSQLITE_ENABLE_JSON1 -DSQLITE_ENABLE_STMTVTAB cfg/c?.cfg cfg/wal1.cfg cfg/f2fs.cfg coverage.testplan cov1/?*.test th3: 0 errors in 2269338 tests. 801.169 seconds on SQLiteWin10 64-bit little-endian th3: SQLite 3.36.0 2021-06-17 14:56:25 f829b89d875178becbda99c679f769a9196a235f1996fdab2abc47c9dce4f573
2021-06-17 18:26:50 drhpending
19h. see-aes256-cryptoapi.c
2021-06-17 18:24:45 drhok
15. Sqllogictest:
2021-06-17 18:24:41 drhok
15d. tclsh run-all.tcl - on windows
0 errors out of 11879758 tests and 1244 invocations in 2035 seconds
2021-06-17 18:24:35 drhpending
15d. tclsh run-all.tcl - on windows
0 errors out of 11879758 tests and 1244 invocations in 2035 seconds
2021-06-17 18:23:43 drhok
19g. see-aes256-openssl.c
th3: 0 errors in 2262448 tests. 285.482 seconds on abby 64-bit little-endian th3: SQLite 3.36.0 2021-06-17 14:56:25 f829b89d875178becbda99c679f769a9196a235f1996fdab2abc47c9dce4f573
2021-06-17 18:13:00 drhok
19d. see-rc4.c
th3: 0 errors in 2262495 tests. 761.221 seconds on bella 64-bit little-endian th3: SQLite 3.36.0 2021-06-17 14:56:25 f829b89d875178becbda99c679f769a9196a235f1996fdab2abc47c9dce4f573
2021-06-17 18:10:45 danok
22d. Works on Windows MinGW
2021-06-17 18:08:07 drhok
19c. see-aes256-ofb.c
th3: 0 errors in 2262440 tests. 321.275 seconds on abby 64-bit little-endian th3: SQLite 3.36.0 2021-06-17 14:56:25 f829b89d875178becbda99c679f769a9196a235f1996fdab2abc47c9dce4f573
2021-06-17 18:00:28 drhok
19l. At least one of the above with option -DSQLITE_DIRECT_OVERFLOW_READ.
2021-06-17 18:00:25 drhok
19e. see-aes128-ccm.c
th3: 0 errors in 2264856 tests. 349.053 seconds on abby 64-bit little-endian th3: SQLite 3.36.0 2021-06-17 14:56:25 f829b89d875178becbda99c679f769a9196a235f1996fdab2abc47c9dce4f573
2021-06-17 17:55:58 drhpending
21b. Test using: tclsh th3make test.rc nds_devkit.rc
2021-06-17 17:55:50 drhok
21a. Merge all trunk enhancements into the reuse-schema branch and use that branch to update the devkit.
2021-06-17 17:53:12 drhok
19m. At least one of the above on Linux.
2021-06-17 17:53:09 drhok
19k. At least one of the above using "memdebug.rc".
2021-06-17 17:53:02 drhok
19a. see.c
th3: 0 errors in 10583619 tests. 8397.996 seconds on abby 64-bit little-endian th3: SQLite 3.36.0 2021-06-17 14:56:25 f829b89d875178becbda99c679f769a9196a235f1996fdab2abc47c9dce4f573
2021-06-17 17:44:59 drhok
13. Trunk changes merged and verified on active branches:
2021-06-17 17:44:57 drhok
13e. begin-concurrent-pnu-wal2 (from wal2)
2021-06-17 17:44:55 danok
37. Website built procedures
2021-06-17 17:44:52 danok
37d. All build products work on their target platforms
2021-06-17 17:43:53 danok
20g. At least one of the above on Mac OS X.
(c) on OSX.
2021-06-17 17:43:39 drhpending
15d. tclsh run-all.tcl - on windows
2021-06-17 17:43:39 danok
20c. th3make zipvfs.rc memdebug.rc
th3: 0 errors in 10588320 tests. 12542.770 seconds on Dans-iMac.local 64-bit little-endian th3: SQLite 3.36.0 2021-06-16 19:23:24 7bd55eee1ac63cf6d5699ce85bc5a29bf51afdf7a80bce44937fa833947a40f4
2021-06-17 17:40:23 drhok
14. Dbsqlfuzz tests
2021-06-17 17:40:18 drhok
14i. Win10/MSVC: fuzzcheck $CORPUS -spinner
fuzzcheck: 0 errors out of 57676 tests in 113.081 seconds SQLite 3.36.0 2021-06-16 19:23:24 7bd55eee1ac63cf6d5699ce85bc5a29bf51afdf7a80bce44937fa833947a40f4
2021-06-17 17:38:20 drhok
13c. begin-concurrent-report (from begin-concurrent-pnu)
2021-06-17 17:32:52 drhok
10. Tests for platform Windows:
2021-06-17 17:32:48 drhok
10f. sh tool/symbols-mingw.sh - no incorrect exports or dependencies
2021-06-17 17:31:00 drhok
13b. begin-concurrent-pnu (from trunk)
2021-06-17 17:30:58 drhok
13a. begin-concurrent (from trunk)
2021-06-17 17:27:25 drhok
13d. wal2 (from trunk)
2021-06-17 17:27:22 drh---
13e. begin-concurrent-pnu-wal2 (from wal2)
2021-06-17 17:27:01 drhok
13f. reuse-schema (from trunk)
2021-06-17 17:25:45 drhok
10g. Verify that EXEs and DLLs generated using MSVC contain the correct version number, product name, description, and copyright as resources.
2021-06-17 17:25:13 danok
3i. Check new/changed documentation for spelling and gramatical mistakes.
Checked for those.
2021-06-17 17:23:13 drhok
10c. tclsh multitest.tcl --msvc --scenario failures - verify failures detected
2021-06-17 17:20:59 drhok
10b. tclsh multitest.tcl --msvc --quick on x86
0 failures on 16 th3makes and 29822332 tests in (02:11:47) 2 cores on SQLiteWin10 SQLite 3.36.0 2021-06-16 19:23:24 7bd55eee1ac63cf6d5699ce85bc5a29bf51afdf7a80bce44937fa833947a40f4
2021-06-17 17:19:45 drhok
13e. begin-concurrent-pnu-wal2 (from wal2)
2021-06-17 17:03:17 danok
37c. Compile-time options for build products have been updated as necessary
2021-06-17 17:02:46 danok
37b. tools/mkmsvcmin.tcl has been run to update the MSVC makefiles in autoconf
autoconf/Makefile.msc matches the current output of tool/mkmsvcmin.tcl
2021-06-17 16:59:12 danok
37a. Compile-time options in builds/products_build.sh in the supportdb repository has been updated to align with any changes to the default makefiles.
The only changes to main.mk and Makefile.in since 3.35.0 are test related.
2021-06-17 16:46:53 danpending
20c. th3make zipvfs.rc memdebug.rc
2021-06-17 16:46:47 danpending
20d. th3make zipvfs.rc quick.rc -valgrind
2021-06-17 16:42:59 drhok
6. Tests for platform Linux x86_64:
2021-06-17 16:42:57 drhok
6f. sh tool/symbols.sh - no incorrect exports or dependencies
2021-06-17 16:42:36 drhpending
10b. tclsh multitest.tcl --msvc --quick on x86
2021-06-17 16:41:51 drhok
6i. CC=clang CFLAGS='-fsanitize=thread' ./configure && make threadtest5 && ./threadtest5
2021-06-17 16:41:04 drhok
8. Tests for platform Mac OS X:
2021-06-17 16:41:00 drhok
8c. tclsh multitest.tcl --scenario failures - all failures detected
2021-06-17 16:38:02 drhok
23c. Mac OS X
2021-06-17 16:36:48 drhok
22c. Works on Mac OS X.
2021-06-17 16:33:11 drhok
19i. Verify that builds work with -DSQLITE_ENABLE_UPDATE_DELETE_LIMIT
2021-06-17 16:33:07 drhok
19f. see-cccrypt.c
th3: 0 errors in 2243567 tests. 391.520 seconds on SQLite-iMac-2018 64-bit little-endian th3: SQLite 3.36.0 2021-06-17 14:56:25 f829b89d875178becbda99c679f769a9196a235f1996fdab2abc47c9dce4f573
2021-06-17 16:32:47 drhok
23b. Linux
2021-06-17 16:32:45 drhok
23a. Verify that the SQLite version number is correct in autoconf/tea/configure.ac
2021-06-17 16:31:09 drhok
22b. Works on Linux.
2021-06-17 16:31:04 drhok
22a. Builds.
2021-06-17 16:22:06 drhok
19n. At least one of the above on Mac OS X.
2021-06-17 16:22:02 drhok
19j. At least one of the above using "test.rc".
2021-06-17 16:21:58 drhok
19b. see-aes128-ofb.c
th3: 0 errors in 8588044 tests. 4017.318 seconds on SQLite-iMac-2018 64-bit little-endian th3: SQLite 3.36.0 2021-06-17 14:56:25 f829b89d875178becbda99c679f769a9196a235f1996fdab2abc47c9dce4f573
2021-06-17 16:15:46 danok
20h. At least one of the above on Windows.
(d) on Windows.
2021-06-17 16:15:24 danok
20b. th3make zipvfs.rc test.rc
th3: 0 errors in 10995913 tests. 7506.868 seconds on DESKTOP-C1KR53M 32-bit little-endian th3: SQLite 3.36.0 2021-06-16 19:23:24 7bd55eee1ac63cf6d5699ce85bc5a29bf51afdf7a80bce44937fa833947a40f4
2021-06-17 15:17:40 danok
6h. Test the reuse-schema branch with ./configure --enable-all && make "OPTS=-DSQLITE_ENABLE_SHARED_SCHEMA" test.
SQLite 2021-06-14 14:35:33 f21a53fb4141eaeca2fb33b25bbadfad4e461b0ed1a3526f54a42316f3dd5d9b 0 errors out of 296162 tests on darkstar Linux 64-bit little-endian
2021-06-17 15:07:16 drhok
18. CEROD tests in the "test/" subdirectory.
2021-06-17 15:02:53 drhok
13h. client-see (in the see-base repository)
2021-06-17 14:59:08 danok
16. Build using the configure/make in main source tree.
2021-06-17 14:59:06 danok
16a. Make sure that autoconf has been run to update the configure script.
2021-06-17 14:59:04 danok
16b. Verify the correct version numbers have been installed.
3.36.0 installed.
2021-06-17 14:57:29 drhok
15c. tclsh run-all.tcl - on unix
0 errors out of 11879758 tests and 1244 invocations in 786 seconds
2021-06-17 14:56:30 drhok
13g. see (in the see-base repository)
2021-06-17 14:50:26 drhok
14h. Mac: fuzzcheck $CORPUS --spinner
fuzzcheck: 0 errors out of 57676 tests in 156.479 seconds SQLite 3.36.0 2021-06-16 19:23:24 7bd55eee1ac63cf6d5699ce85bc5a29bf51afdf7a80bce44937fa833947a40f4
2021-06-17 14:44:53 drhok
15a. Checked in latest SQLite amalgamation.
2021-06-17 14:44:31 drhok
14g. CFLAGS='-Os -g -DSQLITE_VDBE_COVERAGE' make -e clean fuzzcheck && ./fuzzcheck $CORPUS --spinner
fuzzcheck: 0 errors out of 57676 tests in 117.131 seconds SQLite 3.36.0 2021-06-16 19:23:24 7bd55eee1ac63cf6d5699ce85bc5a29bf51afdf7a80bce44937fa833947a40f4
2021-06-17 14:41:41 drhok
15b. No SQLite compiler warnings.
2021-06-17 13:56:30 danok
20f. At least one of the above on Linux.
(a) and (e) on Linux.
2021-06-17 13:53:47 danok
20e. th3make zipvfs.rc quick.rc
th3: 0 errors in 3545642 tests. 654.330 seconds on darkstar 64-bit little-endian th3: SQLite 3.36.0 2021-06-16 19:23:24 7bd55eee1ac63cf6d5699ce85bc5a29bf51afdf7a80bce44937fa833947a40f4
2021-06-17 11:30:04 danok
11. Tests for platform OpenBSD (x86):
2021-06-17 11:30:01 danok
11b. th3make quick.rc
th3: 0 errors in 2295116 tests. 2532.140 seconds on obsd.home.com 32-bit little-endian th3: SQLite 3.36.0 2021-06-16 19:23:24 7bd55eee1ac63cf6d5699ce85bc5a29bf51afdf7a80bce44937fa833947a40f4
2021-06-17 11:19:15 danok
10e. tclsh test/wapptest.tcl --msvc --platform Failure-Detection -noui - all failures detected
All tests report failures: 7 errors from 99 tests in 3 configurations. SQLite version 3.36.0 2021-06-16 19:23:24 7bd55eee1ac63cf6d5699ce85bc5a29bf51afdf7a80bce44937fa833947a40f4
2021-06-17 11:14:57 danok
8d. tclsh test/wapptest.tcl -platform Failure-Detection -noui - all failures detected
All tests report failures: 8 errors from 197 tests in 7 configurations. SQLite version 3.36.0 2021-06-16 19:23:24 7bd55eee1ac63cf6d5699ce85bc5a29bf51afdf7a80bce44937fa833947a40f4
2021-06-17 11:04:01 danok
6e. tclsh test/wapptest.tcl --platform Failure-Detection -noui - all failures detected
All tests report failures: 10 errors from 393 tests in 7 configurations. SQLite version 3.36.0 2021-06-16 19:23:24 7bd55eee1ac63cf6d5699ce85bc5a29bf51afdf7a80bce44937fa833947a40f4
2021-06-17 10:50:30 drhok
14c. valgrind fuzzcheck $CORPUS --spinner
20210615.db: 57676/57676 fuzzcheck: 0 errors out of 57676 tests in 3022.910 seconds SQLite 3.36.0 2021-06-16 19:23:24 7bd55eee1ac63cf6d5699ce85bc5a29bf51afdf7a80bce44937fa833947a40f4
2021-06-17 10:50:09 drhok
14d. CC=clang CFLAGS='-Os -g -fsanitize=undefined' make -e clean fuzzcheck && ./fuzzcheck $CORPUS --spinner
20210615.db: 57676/57676 fuzzcheck: 0 errors out of 57676 tests in 158.518 seconds
2021-06-17 10:49:30 drhok
14e. CC=clang CFLAGS='-Os -g -fsanitize=address' make -e clean fuzzcheck && ./fuzzcheck $CORPUS --spinner
20210615.db: 57676/57676 fuzzcheck: 0 errors out of 57676 tests in 291.119 seconds
2021-06-17 10:49:10 drhok
14f. CC=clang CFLAGS='-Os -g -fsanitize=memory' make -e clean fuzzcheck && ./fuzzcheck $CORPUS --spinner
20210615.db: 57676/57676 fuzzcheck: 0 errors out of 57676 tests in 343.759 seconds
2021-06-17 01:05:21 drhok
14b. Check-in CORPUS as an unversioned file in the dbsqlfuzz repository
2021-06-17 01:00:16 drhok
14a. Develop a new CORPUS database by running dbsqlfuzz for days and at least 100 million iterations
2021-06-17 00:59:39 drhok
8b. tclsh multitest.tcl --quick
0 failures on 16 th3makes and 30207836 tests in (00:59:30) 2 cores on SQLite-iMac-2018.local SQLite 3.36.0 2021-06-16 19:23:24 7bd55eee1ac63cf6d5699ce85bc5a29bf51afdf7a80bce44937fa833947a40f4
2021-06-17 00:54:27 drhok
6g. CC=clang CFLAGS='-fsanitize=address,undefined' ./configure --enable-debug --enable-all && make test
SQLite 2021-06-16 19:23:24 7bd55eee1ac63cf6d5699ce85bc5a29bf51afdf7a80bce44937fa833947a40f4 0 errors out of 296781 tests on abby Linux 64-bit little-endian All memory allocations freed - no leaks
2021-06-16 23:46:55 drhok
6d. tclsh multitest.tcl --scenario failures - all failures detected
2021-06-16 23:39:10 drhok
6c. tclsh multitest.tcl --scenario obscure
0 failures on 2 th3makes and 4608842 tests in (00:10:23) on abby SQLite 3.36.0 2021-06-16 19:23:24 7bd55eee1ac63cf6d5699ce85bc5a29bf51afdf7a80bce
2021-06-16 23:22:25 drhok
6a. tclsh multitest.tcl
0 failures on 44 th3makes and 254412505 tests in (03:17:54) 8 cores on abby SQLite 3.36.0 2021-06-16 19:23:24 7bd55eee1ac63cf6d5699ce85bc5a29bf51afdf7a80bce44937fa833947a40f4
2021-06-16 22:11:38 drhok
7. Tests for platform Linux ARM (BeagleBoard or RaspberryPI)
2021-06-16 22:11:36 drhok
7a. tclsh th3make min.rc -DTH3_LOWMEM --unobfuscated
th3: 04f4dda3a460f3f37fa9e5eb5e87a64370c96c1a7d1bcbcf4e2acf15b8d3943b th3: ./th3make min.rc -DTH3_LOWMEM --stop --unobfuscated th3: mkth3.tcl -DTH3_LOWMEM cfg/c?.cfg cfg/wal1.cfg cfg/f2fs.cfg coverage.testplan cov1/?*.test th3: 0 errors in 1921477 tests. 4797.480 seconds on raspberrypi 32-bit little-endian th3: SQLite 3.36.0 2021-06-16 16:56:56 75e53215fe436999cdc70434c6ae96d3ce6642c71528cce9f5715fe1b1b81876
2021-06-16 20:56:11 danok
11a. make test
OpenBSD obsd.home.com 6.8 GENERIC#427 i386 SQLite 2021-06-16 19:23:24 7bd55eee1ac63cf6d5699ce85bc5a29bf51afdf7a80bce44937fa833947a40f4 0 errors out of 249974 tests on obsd.home.com OpenBSD 32-bit little-endian
2021-06-16 20:18:06 danok
12. On an F2FS filesystem with the F2FS_FEATURE_ATOMIC_WRITE feature, test with: $(TOP)/configure && make test OPTS="-DSQLITE_ENABLE_BATCH_ATOMIC_WRITE -DSQLITE_DEBUG -DSQLITE_NO_SYNC"
SQLite 2021-06-16 19:23:24 7bd55eee1ac63cf6d5699ce85bc5a29bf51afdf7a80bce44937fa833947a40f4 0 errors out of 248688 tests on darkstar Linux 64-bit little-endian
2021-06-16 19:22:40 drhok
10a. tclsh multitest.tcl --msvc --quick on x64
0 failures on 16 th3makes and 30011829 tests in (01:46:10) 3 cores on SQLiteWin10 SQLite 3.36.0 2021-06-16 15:56:09 9f69af4dbcb273519fa87b7868f3792560fb71b192f4ffe53b8b465334da5ae4
2021-06-16 19:14:50 danok
20a. testfixture ../zipvfs/test/zipvfs.test (See test/README.md for details)
SQLite 2021-06-16 16:56:56 75e53215fe436999cdc70434c6ae96d3ce6642c71528cce9f5715fe1b1b81876 0 errors out of 70030 tests on darkstar Linux 64-bit little-endian SQLite 2021-06-16 18:58:01 c3036c28259c1375cd2c480c9ca0ce7f9aa1e952be4f110dde49b2b7d72a43b7 0 errors out of 250694 tests on darkstar Linux 64-bit little-endian
2021-06-16 18:48:28 danok
10d. tclsh test/wapptest.tcl --msvc -noui --debug
0 errors from 3239816 tests in 8 configurations. SQLite version 3.36.0 2021-06-16 16:56:56 75e53215fe436999cdc70434c6ae96d3ce6642c71528cce9f5715fe1b1b81876
2021-06-16 18:03:21 drhok
5. OMIT, ENABLE, and DISABLE options:
2021-06-16 18:03:19 drhok
5a. tclsh ../tool/omittest.tcl -skip_run -target libsqlite3.a
0 errors out of 11879758 tests and 1244 invocations in 805 seconds (abby)
2021-06-16 18:02:30 drhok
7b. Recompile and test Fossil.
2021-06-16 17:51:09 danok
8a. tclsh test/wapptest.tcl -noui --debug
0 errors from 6531037 tests in 6 configurations. SQLite version 3.36.0 2021-06-16 13:26:40 f8d7ac0104b76555142ce0d32714594f42d19b311dce2f77f42f92756b5e0c93
2021-06-16 17:47:13 drhok
4. Compiler warning checks.
2021-06-16 17:47:11 drhok
4a. Linux GCC -Wall -Wextra (the "tool/warnings.sh" script)
2021-06-16 17:46:17 danok
31. 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.8.2 and 3.7.3 using backcompat.test. SQLite 2021-06-16 16:56:56 75e53215fe436999cdc70434c6ae96d3ce6642c71528cce9f5715fe1b1b81876 0 errors out of 265 tests on darkstar Linux 64-bit little-endian
2021-06-16 17:45:46 drhok
26. Run make wordcount and do tests on current and prior versions:
2021-06-16 17:45:44 drhok
26b. rm -f wc.db && ./wordcount wc.db $BIGTEXT --all --cachesize 5 --nosync
2021-06-16 17:44:26 danok
35. Run the rbu/run_rbu_tests.tcl script in the test-dbs project on Linux.
All tests report "round trip test successful". Version "75e53215 (21-06-16 16:56))"
2021-06-16 17:42:16 drhok
26a. rm -f wc.db && ./wordcount wc.db $BIGTEXT --all
2021-06-16 17:38:35 drhok
33. Build and verify sqldiff
2021-06-16 17:38:33 drhok
33a. Linux
2021-06-16 17:38:11 drhok
32. Build and verify correct operation of sqlite3_analyzer on:
2021-06-16 17:38:09 drhok
32a. Linux
2021-06-16 17:36:05 drhok
27. Compare performance to the previous release using kvtest.
2021-06-16 17:36:03 drhok
27a. Linux
2021-06-16 17:34:27 drhok
25. Performance tests using speedtest1 --testset rtree
2021-06-16 17:34:24 drhok
25a. Linux
2021-06-16 17:32:09 drhok
24. Performance tests using speedtest1 compared against the previous release and a release from about one year ago.
2021-06-16 17:32:06 drhok
24a. Linux
2021-06-16 17:19:07 danok
6b. tclsh test/wapptest.tcl -noui --debug
0 errors from 16937366 tests in 34 configurations. SQLite version 3.36.0 2021-06-16 13:26:40 f8d7ac0104b76555142ce0d32714594f42d19b311dce2f77f42f92756b5e0c93
2021-06-16 17:04:47 drhok
33b. Mac
2021-06-16 17:04:17 drhok
32b. Mac OS X
2021-06-16 17:02:08 drhok
28. Use the ".selftest" command of the shell to verify that legacy database files are readable and cross-platform
2021-06-16 17:02:05 drhok
28c. Mac
2021-06-16 16:59:19 drhok
27b. Mac
2021-06-16 16:57:13 drhok
24b. Mac
2021-06-16 16:52:45 drhok
17. Fossil updated to use the latest SQLite.
2021-06-16 16:52:43 drhok
17c. fossil all test-integrity -d
2021-06-16 16:52:40 drhok
17b. Used on active websites with no issues.
2021-06-16 16:52:38 drhok
17a. No SQLite compiler warnings.
2021-06-16 16:51:55 drhok
4b. Mac OS X GCC -Wall -Wextra (the "tool/warnings.sh" script)
2021-06-16 16:45:44 drhok
28b. Linux
2021-06-16 16:44:21 drhok
34. Build the "atrc" test program and run "./atrc $DB | ./sqlite3 $DB" against multiple databases, visually verify the result
2021-06-16 16:42:49 drhok
36. 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.
2021-06-16 16:40:41 drhok
28d. Windows
2021-06-16 16:38:13 drhok
27c. Windows
2021-06-16 16:35:16 drhok
25b. Windows
2021-06-16 16:33:17 drhok
24c. Windows
2021-06-16 16:04:58 drhok
33c. Windows
2021-06-16 16:04:09 drhok
32c. Windows
2021-06-16 16:02:57 drhok
30. Verify that the amalgamation builds are byte-for-byte identical on all workstation platforms.
2021-06-16 16:02:54 drhok
30d. Windows using native MinGW.
9cec760d07bcef7445396d484ef1fd3d67b3a7493003027722cf994aafd7eff5 sqlite3.c 4f3c85bd9069b5cc9bc69b333df8d024f70c994bfa4020b129e7f0b279b3ae8d sqlite3.h e3d5d81ed1f7ea794af15a96567007a6b20d9b7aa789d0be5eba8a621bf33873 shell.c
2021-06-16 16:00:31 drhok
30e. Windows using NMAKE.
9cec760d07bcef7445396d484ef1fd3d67b3a7493003027722cf994aafd7eff5 sqlite3.c 4f3c85bd9069b5cc9bc69b333df8d024f70c994bfa4020b129e7f0b279b3ae8d sqlite3.h e3d5d81ed1f7ea794af15a96567007a6b20d9b7aa789d0be5eba8a621bf33873 shell.c
2021-06-16 15:59:57 drhok
30b. Mac OS X
9cec760d07bcef7445396d484ef1fd3d67b3a7493003027722cf994aafd7eff5 sqlite3.c 4f3c85bd9069b5cc9bc69b333df8d024f70c994bfa4020b129e7f0b279b3ae8d sqlite3.h e3d5d81ed1f7ea794af15a96567007a6b20d9b7aa789d0be5eba8a621bf33873 shell.c
2021-06-16 15:59:20 drhok
30c. Mac OS X (PPC)
9cec760d07bcef7445396d484ef1fd3d67b3a7493003027722cf994aafd7eff5 sqlite3.c 4f3c85bd9069b5cc9bc69b333df8d024f70c994bfa4020b129e7f0b279b3ae8d sqlite3.h e3d5d81ed1f7ea794af15a96567007a6b20d9b7aa789d0be5eba8a621bf33873 shell.c
2021-06-16 15:58:59 drhok
30a. Linux
9cec760d07bcef7445396d484ef1fd3d67b3a7493003027722cf994aafd7eff5 sqlite3.c 4f3c85bd9069b5cc9bc69b333df8d024f70c994bfa4020b129e7f0b279b3ae8d sqlite3.h e3d5d81ed1f7ea794af15a96567007a6b20d9b7aa789d0be5eba8a621bf33873 shell.c
2021-06-16 15:51:16 drh---
30a. Linux
2021-06-16 15:51:03 drh---
30c. Mac OS X (PPC)
2021-06-16 15:46:42 drhok
30a. Linux
268a1c206190168e21b1f65b066f922a2c5486f66bd68545f434d8c92185867b sqlite3.c 23018dd6c316bdc51d25db8bf00e2eed952db5810bc025e30509fc7fb56717e9 sqlite3.h e3d5d81ed1f7ea794af15a96567007a6b20d9b7aa789d0be5eba8a621bf33873 shell.c
2021-06-16 15:46:29 drhok
30c. Mac OS X (PPC)
b51ca0e1d90acb811502741bc86d4874265dd48abcde47b7c7ce5a4eefae6eb6 sqlite3.c 0cf4e1295eb6fc1d138ec01bb61111a915d4ebbad9c017114f1a951c66bb1a99 sqlite3.h e3d5d81ed1f7ea794af15a96567007a6b20d9b7aa789d0be5eba8a621bf33873 shell.c
2021-06-16 15:42:04 drhok
28a. iBook PPC
2021-06-16 15:41:31 drhok
9. Tests for platform Mac OS X 10.5 (PPC):
2021-06-16 15:41:28 drhok
9c. Verify that Fossil repositories are cross-platform with x86/x64.
2021-06-16 15:41:25 drhok
9b. Recompile and test Fossil.
2021-06-16 15:41:22 drhok
9a. .selftest checks (see below)
2021-06-16 15:15:00 danok
6b. tclsh test/wapptest.tcl -noui --debug
0 errors from 16936996 tests in 34 configurations. SQLite version 3.36.0 2021-06-14 14:52:27 3ddfe9ae55e6d0d922fbc209768b2ac4a4792f0f63af9a8fb53d66a4b8f1d94b
2021-06-16 12:27:11 drhok
3e. Requirements marks are up-to-date in both documentation and source code. Do this early so that necessary code changes are well validated by subsequent checklist items.
2021-06-16 12:27:07 drhok
3d. No unresolved hyperlinks in the documentation build.
2021-06-16 11:36:46 drhok
2. Source code change review. fossil diff --from release --to trunk
2021-06-16 11:36:43 drhok
2l. Compare sqlite3.c and sqlite3.h against the previous release.
2021-06-16 11:36:40 drhok
2k. Significant compile-time options are recognized by the sqlite3_compileoption_used() interface.
2021-06-16 11:36:35 drhok
2j. Verify that the list of APIs exposed via the extension header is up-to-date (sqlite3ext.h).
2021-06-16 11:36:31 drhok
2i. Verify that source code contains no tabs and that surplus whitespace has been removed.
2021-06-16 11:33:01 drhok
2h. 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]*(/
2021-06-16 11:12:03 drhok
2g. Check all calls to sqlite3OsRead() and sqlite3OsWrite() to ensure that offset computations are 64-bit clean.
2021-06-16 11:10:20 drhok
2f. Variables and functions have been renamed to reflect changes in their use.
2021-06-16 11:10:17 drhok
2e. Comments have been updated to reflect code changes.
2021-06-16 11:10:14 drhok
2d. New code complies with design rules.
2021-06-16 11:10:11 drhok
2c. New code complies with style guidelines.
2021-06-16 11:10:09 drhok
2b. All significant changes are mentioned in the "changes" log of the documentation.
2021-06-16 11:10:06 drhok
2a. No stray changes.