SQLite

Release Checklist For SQLite 3.33.0
Login
2020-08-14 09:49:56 drhok
22. Amalgamation autoconf tarball.
2020-08-14 09:49:53 drhok
22d. Works on Windows MinGW
2020-08-14 09:47:50 drhok
10. Tests for platform Windows:
2020-08-14 09:47:48 drhok
10c. tclsh multitest.tcl --msvc --scenario failures - verify failures detected
2020-08-14 09:42:54 drhok
23. TEA archive builds correctly and runs:
2020-08-14 09:42:51 drhok
23d. Windows MSVC
2020-08-14 09:39:56 drhok
22e. Works on Windows MSVC
2020-08-14 09:36:50 drhok
10g. Verify that EXEs and DLLs generated using MSVC contain the correct version number, product name, description, and copyright as resources.
2020-08-14 09:35:54 drhok
27. Compare performance to the previous release using kvtest.
2020-08-14 09:35:51 drhok
27c. Windows
2020-08-14 09:34:42 drhok
25. Performance tests using speedtest1 --testset rtree
2020-08-14 09:34:39 drhok
25b. Windows
2020-08-14 09:33:20 drhok
24. Performance tests using speedtest1 compared against the previous release and a release from about one year ago.
2020-08-14 09:33:17 drhok
24c. Windows
2020-08-14 09:30:47 drhok
28. Use the ".selftest" command of the shell to verify that legacy database files are readable and cross-platform
2020-08-14 09:30:45 drhok
28d. Windows
2020-08-14 09:28:33 drhok
19. SEE tests using TH3:
2020-08-14 09:28:27 drhok
19n. At least one of the above on Windows.
2020-08-14 09:28:19 drhok
19h. see-aes256-cryptoapi.c
th3: 8cae07ad2697c727f8c81ae54dc333b81c85e2b578fd33f9789ff7ac84ed522a 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 2083439 tests. 961.475 seconds on SQLiteWin10 64-bit little-endian th3: SQLite 3.33.0 2020-08-09 18:02:03 525c8b50a8640c508e2aaf91f99b27518698a47d749a77cd1dc73e3c668de6a9
2020-08-14 09:03:04 drhok
15. Sqllogictest:
2020-08-14 09:02:55 drhok
15d. tclsh run-all.tcl - on windows
0 errors out of 11879758 tests and 1244 invocations in 3305 seconds
2020-08-14 00:58:29 drhok
10b. tclsh multitest.tcl --msvc --quick on x86
0 failures on 16 th3makes and 27196991 tests in (02:23:29) 2 cores on SQLiteWin10 SQLite 3.33.0 2020-08-12 16:19:12 f6cffa2d50bfebe5b025f412b7a49b7fdafb798aaf1ddc80e6656ccd1f012a7f
2020-08-13 22:29:24 drhok
10a. tclsh multitest.tcl --msvc --quick on x64
0 failures on 16 th3makes and 27526725 tests in (02:10:45) 2 cores on SQLiteWin10 SQLite 3.33.0 2020-08-12 16:19:12 f6cffa2d50bfebe5b025f412b7a49b7fdafb798aaf1ddc80e6656ccd1f012a7f
2020-08-13 20:27:00 drhok
1. Test procedure review.
2020-08-13 20:26:58 drhok
1a. Review the "test/wapptest.tcl" script for completeness and accuracy.
2020-08-13 20:26:56 drhok
1b. Review "multitest.tcl" and "alignment*.rc" scripts in TH3 for completeness.
2020-08-13 20:26:53 drhok
1c. Review this checklist for completeness and accuracy.
2020-08-13 20:26:48 drhok
3. Documentation review:
2020-08-13 20:26:44 drhok
3c. Release accouncement in "news.html".
2020-08-13 20:21:12 drhok
3i. Check new/changed documentation for spelling and gramatical mistakes.
2020-08-13 20:13:15 drhok
3h. Test metrics are up-to-date (testing.html).
2020-08-13 20:09:05 drhok
3f. The compile-time options are all up-to-date (compile.html).
2020-08-13 19:55:05 drhok
3g. Database footprint is up-to-date (features.html).
2020-08-13 19:52:39 drhok
29. Verify that the performance and size measurement spreadsheet in the documentation (misc/speed-size-graph.ods) is up-to-date.
2020-08-13 19:46:32 drhok
6. Tests for platform Linux x86_64:
2020-08-13 19:45:56 drhok
6g. CC=clang CFLAGS='-fsanitize=address,undefined' ./configure --enable-debug --enable-all && make test
No issues were found in SQLite itself, but there are difficult issues in the test infrastructure. We will address those for the next release cycle. For this release, the test is "deemed pass".
2020-08-13 19:45:35 drhok
6g. CC=clang CFLAGS='-fsanitize=address,undefined' ./configure --enable-debug --enable-all && make test
No issues were found in SQLite itself, but there are difficult issues in the test infrastructure. We will address those for the next release cycle. For this release, the test is "deemed pass".
2020-08-13 19:45:23 drhok
6g. CC=clang CFLAGS='-fsanitize=address,undefined' ./configure --enable-debug --enable-all && make test
No issues were found in SQLite itself, but there are difficult issues in the test infrastructure. We will address those for the next release cycle. For this release, the test is "deemed pass".
2020-08-13 19:33:18 danok
20. ZIPVFS tests:
2020-08-13 19:33:15 danok
20g. At least one of the above on Mac OS X.
2020-08-13 19:33:12 danok
20c. th3make zipvfs.rc memdebug.rc
th3: 0 errors in 10016192 tests. 10557.855 seconds on Dans-iMac.local 64-bit little-endian th3: SQLite 3.33.0 2020-08-12 16:19:12 f6cffa2d50bfebe5b025f412b7a49b7fdafb798
2020-08-13 19:33:04 danpending
20c. th3make zipvfs.rc memdebug.rc
th3: 0 errors in 10016192 tests. 10557.855 seconds on Dans-iMac.local 64-bit little-endian th3: SQLite 3.33.0 2020-08-12 16:19:12 f6cffa2d50bfebe5b025f412b7a49b7fdafb798
2020-08-13 19:25:59 drhok
19e. see-aes128-ccm.c
th3: 0 errors in 2062692 tests. 295.582 seconds on abby 64-bit little-endian th3: SQLite 3.33.0 2020-08-09 18:02:03 525c8b50a8640c508e2aaf91f99b27518698a47d749a77cd1dc73e3c668de6a9
2020-08-13 19:16:04 danok
33. Build and verify sqldiff
2020-08-13 19:15:59 danok
33c. Windows
2020-08-13 19:15:47 danok
32. Build and verify correct operation of sqlite3_analyzer on:
2020-08-13 19:15:44 danok
32c. Windows
2020-08-13 19:04:46 drhok
19c. see-aes256-ofb.c
th3: 0 errors in 2062649 tests. 268.910 seconds on abby 64-bit little-endian th3: SQLite 3.33.0 2020-08-09 18:02:03 525c8b50a8640c508e2aaf91f99b27518698a47d749a77cd1dc73e3c668de6a9
2020-08-13 18:58:28 drhok
19d. see-rc4.c
th3: 8cae07ad2697c727f8c81ae54dc333b81c85e2b578fd33f9789ff7ac84ed522a th3: ./th3make see.rc quick.rc th3: mkth3.tcl -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 2062689 tests. 317.337 seconds on abby 64-bit little-endian th3: SQLite 3.33.0 2020-08-09 18:02:03 525c8b50a8640c508e2aaf91f99b27518698a47d749a77cd1dc73e3c668de6a9
2020-08-13 18:39:43 drhok
28b. Linux
2020-08-13 18:38:26 danok
20h. At least one of the above on Windows.
2020-08-13 18:38:20 danok
20b. th3make zipvfs.rc test.rc
th3: 0 errors in 10438140 tests. 7207.843 seconds on DESKTOP-C1KR53M 32-bit little-endian th3: SQLite 3.33.0 2020-08-12 16:19:12 f6cffa2d50bfebe5b025f412b7a49b7fdafb798aaf1ddc80e6656ccd1f012a7f
2020-08-13 18:36:08 drhok
27a. Linux
2020-08-13 18:32:29 drhok
25a. Linux
2020-08-13 18:31:45 drhok
24a. Linux
2020-08-13 18:25:48 drhok
28c. Mac
2020-08-13 18:16:02 drhok
27b. Mac
2020-08-13 18:12:57 danok
11. Tests for platform OpenBSD (x86):
2020-08-13 18:12:52 danok
11b. th3make quick.rc
th3: 2 errors in 2085568 tests. 762.152 seconds on obsd.my.domain 32-bit little-endianth3: SQLite 3.33.0 2020-08-12 16:19:12 f6cffa2d50bfebe5b025f412b7a49b7fdafb798aaf1ddc80e6656ccd1f012a7f Errors are because OpenBSD builds disable mmap and memdb03.test requires it.
2020-08-13 18:12:39 danreview
11b. th3make quick.rc
th3: 2 errors in 2085568 tests. 762.152 seconds on obsd.my.domain 32-bit little-endianth3: SQLite 3.33.0 2020-08-12 16:19:12 f6cffa2d50bfebe5b025f412b7a49b7fdafb798aaf1ddc80e6656ccd1f012a7f Errors are because OpenBSD builds disable mmap and memdb03.test requires it.
2020-08-13 18:11:05 danok
37. Website built procedures
2020-08-13 18:11:01 danok
37b. All build products work on their target platforms
2020-08-13 18:10:56 danok
37a. Compile-time options for build products have been updated as necessary
2020-08-13 18:09:34 drhok
24b. Mac
2020-08-13 18:06:37 drhok
23c. Mac OS X
2020-08-13 18:03:49 drhok
22c. Works on Mac OS X.
2020-08-13 17:59:05 drhok
19k. At least one of the above with option -DSQLITE_DIRECT_OVERFLOW_READ.
2020-08-13 17:58:53 drhok
19a. see.c
th3: 8cae07ad2697c727f8c81ae54dc333b81c85e2b578fd33f9789ff7ac84ed522a th3: ./th3make see.rc quick.rc -DSQLITE_DIRECT_OVERFLOW_READ th3: mkth3.tcl -DSQLITE_HAS_CODEC -DSQLITE_DEBUG -DSQLITE_ENABLE_BYTECODE_VTAB -DSQLITE_ENABLE_DESERIALIZE -DSQLITE_ENABLE_JSON1 -DSQLITE_ENABLE_STMTVTAB -DSQLITE_DIRECT_OVERFLOW_READ cfg/c?.cfg cfg/wal1.cfg cfg/f2fs.cfg coverage.testplan cov1/?*.test th3: 0 errors in 2049634 tests. 313.520 seconds on SQLite-iMac-2018 64-bit little-endian th3: SQLite 3.33.0 2020-08-09 18:02:03 525c8b50a8640c508e2aaf91f99b27518698a47d749a77cd1dc73e3c668de6a9
2020-08-13 17:52:07 danok
8. Tests for platform Mac OS X:
2020-08-13 17:52:03 danok
8a. tclsh test/wapptest.tcl -noui
SQLite 2020-08-12 16:19:12 f6cffa2d50bfebe5b025f412b7a49b7fdafb798aaf1ddc80e6656ccd1f012a7f 0 errors out of 4899084 tests on Dans-iMac.local Darwin 64-bit little-endian
2020-08-13 17:50:09 drhok
19m. At least one of the above on Mac OS X.
2020-08-13 17:49:59 drhok
19f. see-cccrypt.c
th3: 8cae07ad2697c727f8c81ae54dc333b81c85e2b578fd33f9789ff7ac84ed522a th3: ./th3make see.rc quick.rc th3: mkth3.tcl -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 2047286 tests. 310.865 seconds on SQLite-iMac-2018 64-bit little-endian th3: SQLite 3.33.0 2020-08-09 18:02:03 525c8b50a8640c508e2aaf91f99b27518698a47d749a77cd1dc73e3c668de6a9
2020-08-13 17:10:40 danok
35. Run the rbu/run_rbu_tests.tcl script in the test-dbs project on Linux.
All tests report "round trip successful"
2020-08-13 16:54:00 drhok
19i. At least one of the above using "test.rc".
2020-08-13 16:53:53 drhok
19g. see-aes256-openssl.c
th3: 8cae07ad2697c727f8c81ae54dc333b81c85e2b578fd33f9789ff7ac84ed522a th3: ./th3make see.rc test.rc -lcrypto th3: mkth3.tcl -DSQLITE_HAS_CODEC -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 cfg/?*.cfg extra1/?*.cfg bugs/?*.test cov1/?*.test extra1/?*.test fts/?*.test req1/?*.test demo/?*.test th3: 0 errors in 10456383 tests. 2297.577 seconds on abby 64-bit little-endian th3: SQLite 3.33.0 2020-08-09 18:02:03 525c8b50a8640c508e2aaf91f99b27518698a47d749a77cd1dc73e3c668de6a9
2020-08-13 16:53:45 drhpending
19g. see-aes256-openssl.c
th3: 8cae07ad2697c727f8c81ae54dc333b81c85e2b578fd33f9789ff7ac84ed522a th3: ./th3make see.rc test.rc -lcrypto th3: mkth3.tcl -DSQLITE_HAS_CODEC -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 cfg/?*.cfg extra1/?*.cfg bugs/?*.test cov1/?*.test extra1/?*.test fts/?*.test req1/?*.test demo/?*.test th3: 0 errors in 10456383 tests. 2297.577 seconds on abby 64-bit little-endian th3: SQLite 3.33.0 2020-08-09 18:02:03 525c8b50a8640c508e2aaf91f99b27518698a47d749a77cd1dc73e3c668de6a9
2020-08-13 16:43:31 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.7.3 and 3.8.2 using backcompat.test: SQLite 2020-08-12 16:19:12 f6cffa2d50bfebe5b025f412b7a49b7fdafb798aaf1ddc80e6656ccd1f012a7f 0 errors out of 265 tests on darkstar Linux 64-bit little-endian
2020-08-13 16:39:14 danpending
20b. th3make zipvfs.rc test.rc
2020-08-13 16:37:46 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 2020-08-12 16:19:12 f6cffa2d50bfebe5b025f412b7a49b7fdafb798aaf1ddc80e6656ccd1f012a7f 0 errors out of 247457 tests on darkstar Linux 64-bit little-endian
2020-08-13 16:33:31 danok
10d. tclsh test/wapptest.tcl --msvc -noui
0 errors from 3226378 tests in 8 configurations. SQLite version 3.33.0 2020-08-12 16:19:12 f6cffa2d50bfebe5b025f412b7a49b7fdafb798aaf1ddc80e6656ccd1f012a7f
2020-08-13 16:28:15 danpending
20c. th3make zipvfs.rc memdebug.rc
2020-08-13 16:19:33 danpending
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"
2020-08-13 16:15:24 danreview
11b. th3make quick.rc
th3: 2 errors in 2085568 tests. 762.152 seconds on obsd.my.domain 32-bit little-endianth3: SQLite 3.33.0 2020-08-12 16:19:12 f6cffa2d50bfebe5b025f412b7a49b7fdafb798aaf1ddc80e6656ccd1f012a7f Errors are because OpenBSD builds disable mmap and memdb03.test requires it.
2020-08-13 15:59:43 danok
16. Build using the configure/make in main source tree.
2020-08-13 15:59:39 danok
16b. Verify the correct version numbers have been installed.
Correct: SQLite version 3.33.0 2020-08-12 16:19:12
2020-08-13 15:58:17 danok
11a. make test
SQLite 2020-08-12 16:19:12 f6cffa2d50bfebe5b025f412b7a49b7fdafb798aaf1ddc80e6656ccd1f012a7f 0 errors out of 248430 tests on obsd.my.domain OpenBSD 32-bit little-endian
2020-08-13 15:56:26 danok
20d. th3make zipvfs.rc quick.rc -valgrind
th3: f6cffa2d50bfebe5b025f412b7a49b7fdafb798aaf1ddc80e6656ccd1f012a7f th3: ./th3make zipvfs.rc quick.rc -valgrind th3: mkth3.tcl -DSQLITE_ENABLE_ZIPVFS -DZIPVFS_OMIT_DEPRECATED -DSQLITE_DEBUG -DSQLITE_ENABLE_BYTECODE_VTAB -DSQLITE_ENABLE_DESERIALIZE -DSQLITE_ENABLE_JSON1 -DSQLITE_ENABLE_STMTVTAB -DTH3_OMIT_MISUSE -DTH3_LOWMEM zipvfs/?*.cfg cfg/c?.cfg cfg/wal1.cfg cfg/f2fs.cfg coverage.testplan zipvfs/?*.test cov1/?*.test th3: 0 errors in 3267261 tests. 73304.585 seconds on darkstar 64-bit little-endian th3: SQLite 3.33.0 2020-08-12 16:19:12 f6cffa2d50bfebe5b025f412b7a49b7fdafb798aaf1ddc80e6656ccd1f012a7f ==845== ERROR SUMMARY: 0 errors from 0 contexts (suppressed: 0 from 0) ==845== in use at exit: 32 bytes in 1 blocks
2020-08-13 15:38:50 danok
16a. Make sure that autoconf has been run to update the configure script.
It has. For version 3.33.0
2020-08-13 15:29:40 danpending
11b. th3make quick.rc
2020-08-13 15:27:34 danpending
11a. make test
2020-08-13 15:18:14 danok
10f. sh tool/symbols-mingw.sh - no incorrect exports or dependencies
All looks correct.
2020-08-13 14:43:47 danpending
10d. tclsh test/wapptest.tcl --msvc -noui
2020-08-13 14:41:52 danok
10e. tclsh test/wapptest.tcl --msvc --platform Failure-Detection -noui - all failures detected
7 errors from 99 tests in 3 configurations. All configurations failed: SQLite version 3.33.0 2020-08-12 16:19:12 f6cffa2d50bfebe5b025f412b7a49b7fdafb798aaf1ddc80e6656ccd1f012a7f
2020-08-13 14:33:32 danpending
8a. tclsh test/wapptest.tcl -noui
2020-08-13 14:33:02 danok
8d. tclsh test/wapptest.tcl -platform Failure-Detection -noui - all failures detected
All configurations failed: 8 errors from 197 tests in 7 configurations. SQLite version 3.33.0 2020-08-12 16:19:12 f6cffa2d50bfebe5b025f412b7a49b7fdafb798aaf1ddc80e6656ccd1f012a7f
2020-08-13 11:52:12 drhpending
19g. see-aes256-openssl.c
2020-08-13 11:36:12 drhok
19l. At least one of the above on Linux.
2020-08-13 11:36:09 drhok
19j. At least one of the above using "memdebug.rc".
2020-08-13 11:36:05 drhok
19b. see-aes128-ofb.c
th3: mkth3.tcl -DSQLITE_HAS_CODEC -DSQLITE_DEBUG -DSQLITE_MEMDEBUG cfg/?*.cfg extra1/?*.cfg bugs/?*.test cov1/?*.test extra1/?*.test fts/?*.test req1/?*.test th3: 0 errors in 10011849 tests. 6167.358 seconds on abby 64-bit little-endian th3: SQLite 3.33.0 2020-08-09 18:02:03 525c8b50a8640c508e2aaf91f99b27518698a47d749a77cd1dc73e3c668de6a9
2020-08-13 09:42:33 drhok
8b. tclsh multitest.tcl
0 failures on 39 th3makes and 194979670 tests in (12:05:44) 2 cores on SQLite-iMac-2018.local SQLite 3.33.0 2020-08-12 16:19:12 f6cffa2d50bfebe5b025f412b7a49b7fdafb798aaf1ddc80e6656ccd1f012a7f
2020-08-12 23:40:22 drhok
18. CEROD tests in the "test/" subdirectory.
2020-08-12 20:29:09 drhok
7. Tests for platform Linux ARM (BeagleBoard or RaspberryPI)
2020-08-12 20:29:06 drhok
7a. tclsh th3make min.rc
th3: mkth3.tcl cfg/c?.cfg cfg/wal1.cfg cfg/f2fs.cfg coverage.testplan cov1/?*.test th3: 0 errors in 1750798 tests. 3833.785 seconds on raspberrypi 32-bit little-endian th3: SQLite 3.33.0 2020-08-12 16:19:12 f6cffa2d50bfebe5b025f412b7a49b7fdafb798aa
2020-08-12 20:13:37 drhok
23b. Linux
2020-08-12 20:13:34 drhok
23a. Verify that the SQLite version number is correct in autoconf/tea/configure.ac
2020-08-12 20:06:51 danok
20f. At least one of the above on Linux.
2020-08-12 20:06:42 danok
20e. th3make zipvfs.rc quick.rc
th3: ./th3make zipvfs.rc quick.rc th3: 0 errors in 3269093 tests. 652.406 seconds on darkstar 64-bit little-endian th3: SQLite 3.33.0 2020-08-12 16:19:12 f6cffa2d50bfebe5b025f412b7a49b7fdafb798aaf1ddc80e6656ccd1f012a7f
2020-08-12 20:00:46 drhok
6h. Test the reuse-schema branch with ./configure --enable-all && make "OPTS=-DSQLITE_ENABLE_SHARED_SCHEMA" test.
0 errors out of 294720 tests on bella Linux 64-bit little-endian All memory allocations freed - no leaks
2020-08-12 20:00:06 drhpending
8b. tclsh multitest.tcl
Prior errors caused by accidentally using an older version of TH3. Restarting...
2020-08-12 19:57:13 drhok
21. NDS-Devkit testing
2020-08-12 19:57:08 drhok
21c. Verify the "NDS DevKit" version number shown at the end of the test
2020-08-12 19:57:02 drhok
21b. Test using: tclsh th3make test.rc nds_devkit.rc
th3: 0 errors in 9129048 tests. 2035.795 seconds on udell 64-bit little-endian th3: NDS DevKit 3.33.0 2020-08-12 19:09:59 479cfe33349d2f6b th3: SQLite 3.33.0 2020-08-11 14:55:17 b1a77b7eade14d58b3ccd50b98c2ffb6362d093f2cde2bd178ea62cef2cb8d9f
2020-08-12 19:52:12 drhpending
6h. Test the reuse-schema branch with ./configure --enable-all && make "OPTS=-DSQLITE_ENABLE_SHARED_SCHEMA" test.
2020-08-12 19:50:38 drhfail
8b. tclsh multitest.tcl
t15: quick.rc ~UNTESTABLE ~EXTRA_IFNULLROW..................... FAIL (00:01:49) th3: 21 errors in 717249 tests. 73.048 seconds on SQLite-iMac-2018 64-bit l
2020-08-12 19:48:30 drhfail
6g. CC=clang CFLAGS='-fsanitize=address,undefined' ./configure --enable-debug --enable-all && make test
Memory leak detected in session tests.
2020-08-12 19:32:33 danpending
20d. th3make zipvfs.rc quick.rc -valgrind
2020-08-12 19:25:51 danpending
20e. th3make zipvfs.rc quick.rc
2020-08-12 19:18:26 drhpending
6g. CC=clang CFLAGS='-fsanitize=address,undefined' ./configure --enable-debug --enable-all && make test
2020-08-12 19:17:42 drhok
6f. sh tool/symbols.sh - no incorrect exports or dependencies
2020-08-12 19:17:08 drhok
6e. tclsh test/wapptest.tcl --platform Failure-Detection -noui - all failures detected
2020-08-12 19:15:54 drhpending
8b. tclsh multitest.tcl
2020-08-12 19:15:29 drhok
8c. tclsh multitest.tcl --scenario failures - all failures detected
2020-08-12 19:14:08 drhpending
6e. tclsh test/wapptest.tcl --platform Failure-Detection -noui - all failures detected
2020-08-12 19:13:29 drhok
6d. tclsh multitest.tcl --scenario failures - all failures detected
2020-08-12 19:13:00 drhpending
21b. Test using: tclsh th3make test.rc nds_devkit.rc
2020-08-12 19:11:27 drhok
21a. Merge all trunk enhancements into the reuse-schema branch and use that branch to update the devkit.
2020-08-12 19:10:38 drhok
6c. tclsh multitest.tcl --scenario obscure
0 failures on 2 th3makes and 4187982 tests in (00:09:48) on bella SQLite 3.33.0 2020-08-12 16:19:12 f6cffa2d50bfebe5b025f412b7a49b7fdafb798aaf1ddc80e6656ccd1f012a7f
2020-08-12 19:07:21 drhok
33b. Mac
2020-08-12 19:04:41 drhok
32b. Mac OS X
2020-08-12 19:01:13 drhpending
6c. tclsh multitest.tcl --scenario obscure
2020-08-12 18:59:24 drhok
17. Fossil updated to use the latest SQLite.
2020-08-12 18:59:22 drhok
17c. fossil all test-integrity -d
2020-08-12 18:59:15 drhok
17b. Used on active websites with no issues.
2020-08-12 18:59:13 drhok
17a. No SQLite compiler warnings.
2020-08-12 18:59:03 drhok
13. Trunk changes merged and verified on active branches:
2020-08-12 18:58:59 drhok
13f. reuse-schema (from trunk)
2020-08-12 18:58:55 drhok
13e. begin-concurrent-pnu-wal2 (from wal2)
2020-08-12 18:58:50 drhok
13d. wal2 (from trunk)
2020-08-12 18:58:46 drhok
13c. begin-concurrent-report (from begin-concurrent-pnu)
2020-08-12 18:58:39 drhok
13b. begin-concurrent-pnu (from trunk)
2020-08-12 18:58:34 drhok
13a. begin-concurrent (from trunk)
2020-08-12 18:57:50 danok
20a. testfixture ../zipvfs/test/zipvfs.test (See test/README.txt for details)
SQLite 2020-08-11 18:17:04 bc1590f32fc4e2696b4126bd0302cb6405031dd4f55b86f3f1611f7f39299f85 0 errors out of 74286 tests on darkstar Linux 64-bit little-endian
2020-08-12 18:55:34 drhpending
7a. tclsh th3make min.rc
2020-08-12 18:55:29 drhok
7b. Recompile and test Fossil.
2020-08-12 18:55:18 drhpending
10a. tclsh multitest.tcl --msvc --quick on x64
2020-08-12 18:11:03 drhok
6b. tclsh test/wapptest.tcl -noui
0 errors from 11218226 tests in 17 configurations. SQLite version 3.33.0 2020-08-11 18:17:04 bc1590f32fc4e2696b4126bd0302cb6405031dd4f55b86f3f1611f7f3929alt1 0 errors from 11218098 tests in 17 configurations. SQLite version 3.33.0 2020-08-12 16:19:12 f6cffa2d50bfebe5b025f412b7a49b7fdafb798aaf1ddc80e6656ccd1f012a7f
2020-08-11 23:42:09 drhok
6b. tclsh test/wapptest.tcl -noui
0 errors from 11218226 tests in 17 configurations. SQLite version 3.33.0 2020-08-11 18:17:04 bc1590f32fc4e2696b4126bd0302cb6405031dd4f55b86f3f1611f7f3929alt1
2020-08-11 19:40:20 drhok
22b. Works on Linux.
2020-08-11 19:40:17 drhok
22a. Builds.
2020-08-11 19:37:52 drhok
15c. tclsh run-all.tcl - on unix
0 errors out of 11879758 tests and 1244 invocations in 899 seconds
2020-08-11 19:37:39 drhok
15b. No SQLite compiler warnings.
2020-08-11 19:37:36 drhok
15a. Checked in latest SQLite amalgamation.
2020-08-11 18:24:59 drhok
2. Source code change review. fossil diff --from release --to trunk
2020-08-11 18:24:56 drhok
2j. Verify that the list of APIs exposed via the extension header is up-to-date (sqlite3ext.h).
2020-08-11 18:24:27 drhok
2i. Verify that source code contains no tabs and that surplus whitespace has been removed.
2020-08-11 18:24:20 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]*(/
2020-08-11 18:19:18 drhok
2g. Check all calls to sqlite3OsRead() and sqlite3OsWrite() to ensure that offset computations are 64-bit clean.
2020-08-11 17:34:26 drhok
2k. Significant compile-time options are recognized by the sqlite3_compileoption_used() interface.
2020-08-11 17:34:12 drhok
2f. Variables and functions have been renamed to reflect changes in their use.
2020-08-11 17:34:10 drhok
2d. New code complies with design rules.
2020-08-11 17:34:07 drhok
2c. New code complies with style guidelines.
2020-08-11 17:34:05 drhok
2b. All significant changes are mentioned in the "changes" log of the documentation.
2020-08-11 17:34:03 drhok
2a. No stray changes.
2020-08-11 17:33:58 drhok
2e. Comments have been updated to reflect code changes.
2020-08-11 17:33:52 drhok
2l. Compare sqlite3.c and sqlite3.h against the previous release.
2020-08-10 21:01:43 drhok
5. OMIT, ENABLE, and DISABLE options:
2020-08-10 21:01:41 drhok
5a. tclsh ../tool/omittest.tcl -skip_run -target libsqlite3.a
2020-08-10 20:02:08 drhok
14. Dbsqlfuzz tests
2020-08-10 20:02:06 drhok
14a. valgrind fuzzcheck $CORPUS --spinner
2020-08-10 20:01:42 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.
2020-08-10 20:00:23 drhok
34. Build the "atrc" test program and run "./atrc $DB | ./sqlite3 $DB" against multiple databases, visually verify the result
2020-08-10 19:58:39 drhok
26. Run make wordcount and do tests on current and prior versions:
2020-08-10 19:58:36 drhok
26b. rm -f wc.db && ./wordcount wc.db $BIGTEXT --all --cachesize 5 --nosync
2020-08-10 18:23:25 drhok
26a. rm -f wc.db && ./wordcount wc.db $BIGTEXT --all
2020-08-10 15:26:51 drhok
30. Verify that the amalgamation builds are byte-for-byte identical on all workstation platforms.
2020-08-10 15:26:46 drhok
30b. Mac OS X
597f3be205c44a7b6b6fc335503939d6b0b31a5294b387a2e83a4e4e9fd1a973 sqlite3.c 38dc065e14f56c4de4a1c6e77001c6cdf83f6cef87fd7ded73fb38c9dc713d4d sqlite3.h
2020-08-10 15:25:53 drhok
30d. Windows using native MinGW.
597f3be205c44a7b6b6fc335503939d6b0b31a5294b387a2e83a4e4e9fd1a973 sqlite3.c 38dc065e14f56c4de4a1c6e77001c6cdf83f6cef87fd7ded73fb38c9dc713d4d sqlite3.h
2020-08-10 15:25:21 drhok
30e. Windows using NMAKE.
597f3be205c44a7b6b6fc335503939d6b0b31a5294b387a2e83a4e4e9fd1a973 sqlite3.c 38dc065e14f56c4de4a1c6e77001c6cdf83f6cef87fd7ded73fb38c9dc713d4d sqlite3.h
2020-08-10 15:22:51 drhok
30c. Mac OS X (PPC)
597f3be205c44a7b6b6fc335503939d6b0b31a5294b387a2e83a4e4e9fd1a973 sqlite3.c 38dc065e14f56c4de4a1c6e77001c6cdf83f6cef87fd7ded73fb38c9dc713d4d sqlite3.h
2020-08-10 15:22:40 drhok
30a. Linux
597f3be205c44a7b6b6fc335503939d6b0b31a5294b387a2e83a4e4e9fd1a973 sqlite3.c 38dc065e14f56c4de4a1c6e77001c6cdf83f6cef87fd7ded73fb38c9dc713d4d sqlite3.h
2020-08-10 15:20:21 drhok
9. Tests for platform Mac OS X 10.5 (PPC):
2020-08-10 15:20:18 drhok
9a. .selftest checks (see below)
2020-08-10 15:20:06 drhok
33a. Linux
2020-08-10 15:18:46 drhok
28a. iBook PPC
2020-08-10 15:18:05 drhok
32a. Linux
2020-08-10 14:59:26 drhok
4. Compiler warning checks.
2020-08-10 14:59:23 drhok
4b. Mac OS X GCC -Wall -Wextra (the "tool/warnings.sh" script)
2020-08-10 14:33:10 drhok
4a. Linux GCC -Wall -Wextra (the "tool/warnings.sh" script)
2020-08-09 13:52:23 drhok
9c. Verify that Fossil repositories are cross-platform with x86/x64.
2020-08-09 13:52:16 drhok
9b. Recompile and test Fossil.
2020-08-09 12:57:17 drhok
3e. Requirements marks are up-to-date in both documentation and source code.
2020-08-09 12:57:13 drhok
3d. No unresolved hyperlinks in the documentation build.
2020-08-09 12:57:10 drhok
3b. Release announcement in "changes.in".
2020-08-09 12:57:07 drhok
3a. Latest release on the "index.html" page.
2020-08-09 00:35:18 drhok
6a. tclsh multitest.tcl
0 failures on 44 th3makes and 241392447 tests in (04:03:54) 5 cores on abby SQLite 3.33.0 2020-08-08 20:15:16 13d2fed760e7d0def573c56b7181f45622b0ed78d61952a6de901f96949d074e