SQLite

Release Checklist for SQLite 3.45.0
Login
2024-01-15 16:59:15 drhok
24. ZIPVFS tests:
2024-01-15 16:59:13 drhok
24g. At least one of the above on Mac OS X.
2024-01-15 16:59:10 drhok
24c. th3make zipvfs.rc test.rc
th3: 4d023ecb2581b636d3cd8ba94d3cf9fb820e3adb346c40ea448d54cbe082a465 th3: ./th3make zipvfs.rc test.rc th3: mkth3.tcl -DSQLITE_ENABLE_ZIPVFS -DZIPVFS_OMIT_DEPRECATED -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_STMTVTAB -DSQLITE_ENABLE_RTREE zipvfs/?*.cfg cfg/?*.cfg extra1/?*.cfg zipvfs/?*.test bugs/?*.test cov1/?*.test extra1/?*.test fts/?*.test req1/?*.test demo/?*.test th3: 0 errors in 15095460 tests. 4365.978 seconds on minimac.local 64-bit little-endian th3: SQLite 3.45.0 2024-01-12 11:44:49 f47a5f4e0ce078e6cc1183e6cbb3c4013af379b496efae94863a42e5c39928ed
2024-01-15 16:49:53 drhok
23. SEE tests using TH3:
2024-01-15 16:49:50 drhok
23d. see-rc4.c
th3: 4d023ecb2581b636d3cd8ba94d3cf9fb820e3adb346c40ea448d54cbe082a465 th3: ./th3make see.rc quick.rc th3: mkth3.tcl -DSQLITE_HAS_CODEC -DSQLITE_DEBUG -DSQLITE_ENABLE_BYTECODE_VTAB -DSQLITE_ENABLE_DESERIALIZE -DSQLITE_ENABLE_STMTVTAB -DTH3_SELFCOVERAGE cfg/c?.cfg cfg/wal1.cfg cfg/f2fs.cfg coverage.testplan cov1/?*.test th3: 0 errors in 2553461 tests. 235.631 seconds on r23 64-bit little-endian th3: SQLite 3.45.0 2024-01-12 15:49:10 ccd86fd2563f66a1c8da19dfd8938dfc7d8fd7d1ea83cbea1ff59b24fe009e3c
2024-01-15 16:47:45 drhok
23c. see-aes256-ofb.c
th3: 4d023ecb2581b636d3cd8ba94d3cf9fb820e3adb346c40ea448d54cbe082a465 th3: ./th3make see.rc quick.rc th3: mkth3.tcl -DSQLITE_HAS_CODEC -DSQLITE_DEBUG -DSQLITE_ENABLE_BYTECODE_VTAB -DSQLITE_ENABLE_DESERIALIZE -DSQLITE_ENABLE_STMTVTAB -DTH3_SELFCOVERAGE cfg/c?.cfg cfg/wal1.cfg cfg/f2fs.cfg coverage.testplan cov1/?*.test th3: 0 errors in 2553386 tests. 345.150 seconds on r20 64-bit little-endian th3: SQLite 3.45.0 2024-01-12 15:49:10 ccd86fd2563f66a1c8da19dfd8938dfc7d8fd7d1ea83cbea1ff59b24fe009e3c
2024-01-15 16:46:53 drhok
23b. see-aes128-ofb.c
th3: 4d023ecb2581b636d3cd8ba94d3cf9fb820e3adb346c40ea448d54cbe082a465 th3: ./th3make see.rc quick.rc th3: mkth3.tcl -DSQLITE_HAS_CODEC -DSQLITE_DEBUG -DSQLITE_ENABLE_BYTECODE_VTAB -DSQLITE_ENABLE_DESERIALIZE -DSQLITE_ENABLE_STMTVTAB -DTH3_SELFCOVERAGE cfg/c?.cfg cfg/wal1.cfg cfg/f2fs.cfg coverage.testplan cov1/?*.test th3: 0 errors in 2553455 tests. 248.154 seconds on r21 64-bit little-endian th3: SQLite 3.45.0 2024-01-12 15:49:10 ccd86fd2563f66a1c8da19dfd8938dfc7d8fd7d1ea83cbea1ff59b24fe009e3c
2024-01-15 16:45:01 drhok
3. Documentation review:
2024-01-15 16:44:59 drhok
3h. Check new/changed documentation for spelling and gramatical mistakes.
2024-01-15 16:40:35 drhok
23j. At least one of the above using "test.rc".
2024-01-15 16:40:33 drhok
23i. Verify that builds work with -DSQLITE_ENABLE_UPDATE_DELETE_LIMIT
2024-01-15 16:40:30 drhok
23a. see.c
th3: 4d023ecb2581b636d3cd8ba94d3cf9fb820e3adb346c40ea448d54cbe082a465 th3: ./th3make see.rc test.rc -DSQLITE_ENABLE_UPDATE_DELETE_LIMIT 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_STMTVTAB -DSQLITE_ENABLE_RTREE -DSQLITE_ENABLE_UPDATE_DELETE_LIMIT cfg/?*.cfg extra1/?*.cfg bugs/?*.test cov1/?*.test extra1/?*.test fts/?*.test req1/?*.test demo/?*.test th3: 0 errors in 12917338 tests. 3676.407 seconds on r21 64-bit little-endian th3: SQLite 3.45.0 2024-01-12 15:49:10 ccd86fd2563f66a1c8da19dfd8938dfc7d8fd7d1ea83cbea1ff59b24fe009e3c
2024-01-15 16:38:54 drhok
23g. see-aes256-openssl.c
th3: 4d023ecb2581b636d3cd8ba94d3cf9fb820e3adb346c40ea448d54cbe082a465 th3: ./th3make see.rc quick.rc -lcrypto th3: mkth3.tcl -DSQLITE_HAS_CODEC -DSQLITE_DEBUG -DSQLITE_ENABLE_BYTECODE_VTAB -DSQLITE_ENABLE_DESERIALIZE -DSQLITE_ENABLE_STMTVTAB -DTH3_SELFCOVERAGE cfg/c?.cfg cfg/wal1.cfg cfg/f2fs.cfg coverage.testplan cov1/?*.test th3: 0 errors in 2553375 tests. 176.509 seconds on r23 64-bit little-endian th3: SQLite 3.45.0 2024-01-12 15:49:10 ccd86fd2563f66a1c8da19dfd8938dfc7d8fd7d1ea83cbea1ff59b24fe009e3c
2024-01-15 16:38:31 drhok
23k. At least one of the above on Linux.
2024-01-15 16:38:27 drhok
23e. see-aes128-ccm.c
Full TH3 coverage verified th3: 4d023ecb2581b636d3cd8ba94d3cf9fb820e3adb346c40ea448d54cbe082a465 th3: ./th3make see.rc quick.rc th3: mkth3.tcl -DSQLITE_HAS_CODEC -DSQLITE_DEBUG -DSQLITE_ENABLE_BYTECODE_VTAB -DSQLITE_ENABLE_DESERIALIZE -DSQLITE_ENABLE_STMTVTAB -DTH3_SELFCOVERAGE cfg/c?.cfg cfg/wal1.cfg cfg/f2fs.cfg coverage.testplan cov1/?*.test th3: 0 errors in 2553667 tests. 368.236 seconds on r20 64-bit little-endian th3: SQLite 3.45.0 2024-01-12 15:49:10 ccd86fd2563f66a1c8da19dfd8938dfc7d8fd7d1ea83cbea1ff59b24fe009e3c
2024-01-15 16:22:07 drhok
3g. Test metrics are up-to-date (testing.html).
2024-01-15 16:22:04 drhok
3f. Database footprint is up-to-date (features.html).
2024-01-15 16:21:46 drhok
3e. The compile-time options are all up-to-date (compile.html).
2024-01-15 16:18:42 drhok
2. Source code change review. fossil diff --from release --to trunk
2024-01-15 16:18:39 drhok
2f. Verify that the azProhibitedFunctions list in the safeModeAuth() function of the CLI is complete and up-to-date.
2024-01-15 16:15:10 drhok
2m. Compare sqlite3.c and sqlite3.h against the previous release.
2024-01-15 16:15:07 drhok
2l. Significant compile-time options are recognized by the sqlite3_compileoption_used() interface.
2024-01-15 16:15:03 drhok
2k. Verify that the list of APIs exposed via the extension header is up-to-date (sqlite3ext.h).
2024-01-15 16:14:29 drhok
2j. Verify that source code contains no tabs and that surplus whitespace has been removed.
2024-01-15 16:13:29 drhok
2i. 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]*(/
2024-01-15 16:13:26 drhok
2h. Check all calls to sqlite3OsRead() and sqlite3OsWrite() to ensure that offset computations are 64-bit clean.
2024-01-15 16:13:22 drhok
2g. Variables and functions have been renamed to reflect changes in their use.
2024-01-15 16:08:26 drhok
2e. Comments have been updated to reflect code changes.
2024-01-15 16:08:24 drhok
2d. New code complies with design rules.
2024-01-15 16:08:22 drhok
2c. New code complies with style guidelines.
2024-01-15 16:08:20 drhok
2b. All significant changes are mentioned in the "changes" log of the documentation.
2024-01-15 16:08:17 drhok
2a. No stray changes.
2024-01-15 16:02:04 drhok
24f. At least one of the above on Linux.
2024-01-15 16:02:00 drhok
24d. th3make zipvfs.rc quick1.rc -valgrind
th3: 4d023ecb2581b636d3cd8ba94d3cf9fb820e3adb346c40ea448d54cbe082a465 th3: ./th3make zipvfs.rc quick1.rc --valgrind th3: mkth3.tcl -DSQLITE_ENABLE_ZIPVFS -DZIPVFS_OMIT_DEPRECATED -DSQLITE_DEBUG -DSQLITE_ENABLE_BYTECODE_VTAB -DSQLITE_ENABLE_DESERIALIZE -DSQLITE_ENABLE_STMTVTAB -DTH3_OMIT_MISUSE -DTH3_LOWMEM -DLONGDOUBLE_TYPE=double zipvfs/?*.cfg {cfg/c[1234].cfg} coverage.testplan zipvfs/?*.test cov1/?*.test th3: 0 errors in 2067627 tests. 9346.286 seconds on r23 64-bit little-endian th3: SQLite 3.45.0 2024-01-12 11:44:49 f47a5f4e0ce078e6cc1183e6cbb3c4013af379b496efae94863a42e5c39928ed
2024-01-15 15:44:38 drhok
1. Test procedure review.
2024-01-15 15:44:36 drhok
1a. Review the "test/testrunner.tcl" script for completeness and accuracy.
2024-01-15 15:44:34 drhok
1b. Review "multitest.tcl" and "alignment*.rc" scripts in TH3 for completeness.
2024-01-15 15:44:32 drhok
1c. Review this checklist for completeness and accuracy.
2024-01-15 15:44:29 drhok
1d. Review dev-ops procedures and make any needed updates and corrections.
2024-01-15 15:42:42 drhok
30. Compare performance to the previous release using kvtest.
2024-01-15 15:42:40 drhok
30b. Mac
2024-01-15 15:41:58 drhok
28. Performance tests using speedtest1 compared against the previous release and a release from about one year ago.
2024-01-15 15:41:56 drhok
28c. Mac
2024-01-15 15:39:12 danok
26. Amalgamation autoconf tarball.
2024-01-15 15:38:53 danok
26c. Works on Mac OS X.
2024-01-15 15:36:03 drhok
26d. Works on Windows MSVC
2024-01-15 15:34:05 drhok
30c. Windows
2024-01-15 15:32:27 drhok
28e. Windows with --testset rtree
2024-01-15 15:31:28 drhok
28d. Windows
2024-01-15 15:30:49 drhok
23l. At least one of the above on Mac OS X.
2024-01-15 15:30:45 drhok
23f. see-cccrypt.c
th3: 4d023ecb2581b636d3cd8ba94d3cf9fb820e3adb346c40ea448d54cbe082a465 th3: ./th3make see.rc test.rc 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_STMTVTAB -DSQLITE_ENABLE_RTREE cfg/?*.cfg extra1/?*.cfg bugs/?*.test cov1/?*.test extra1/?*.test fts/?*.test req1/?*.test demo/?*.test th3: 0 errors in 12367848 tests. 3354.017 seconds on minimac.local 64-bit little-endian th3: SQLite 3.45.0 2024-01-12 15:49:10 ccd86fd2563f66a1c8da19dfd8938dfc7d8fd7d1ea83cbea1ff59b24fe009e3c
2024-01-15 15:29:09 danok
26b. Works on Linux.
2024-01-15 15:29:08 danok
26a. Builds.
2024-01-15 15:28:24 danok
26a. Builds.
2024-01-15 15:22:44 danok
27d. Windows MSVC
cd teawin ; nmake -f makefile.vc INSTALLDIR=c:PathToTcl
2024-01-15 15:22:08 danok
27. TEA archive builds correctly and runs:
2024-01-15 15:22:05 danok
27d. Windows MSVC
2024-01-15 15:16:26 danok
27c. Mac OS X
2024-01-15 15:02:32 danok
27b. Linux
2024-01-15 14:54:36 drhok
33. Verify that the performance and size measurement spreadsheet in the documentation (misc/speed-size-graph.ods) is up-to-date.
2024-01-15 14:41:01 drhok
23m. At least one of the above on Windows.
2024-01-15 14:40:57 drhok
23h. see-aes256-cryptoapi.c
th3: 4d023ecb2581b636d3cd8ba94d3cf9fb820e3adb346c40ea448d54cbe082a465 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_STMTVTAB -DTH3_SELFCOVERAGE cfg/c?.cfg cfg/wal1.cfg cfg/f2fs.cfg coverage.testplan cov1/?*.test th3: 0 errors in 2561574 tests. 667.606 seconds on w23 64-bit little-endian th3: SQLite 3.45.0 2024-01-12 15:49:10 ccd86fd2563f66a1c8da19dfd8938dfc7d8fd7d1ea83cbea1ff59b24fe009e3c
2024-01-15 14:40:20 drhok
22. CEROD tests in the "test/" subdirectory.
2024-01-15 14:10:32 danok
27a. Verify that the SQLite version number is correct in autoconf/tea/configure.ac
3.45.0
2024-01-15 13:18:05 drhok
24e. th3make zipvfs.rc quick.rc
2024-01-15 13:17:59 drhok
24h. At least one of the above on Windows.
th3: 25010171b8a501956837ed7d5e74ab13ce22bddadb259ef5f3b720e069817dab th3: th3make msvc.rc quick.rc zipvfs.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_DEBUG -DSQLITE_ENABLE_BYTECODE_VTAB -DSQLITE_ENABLE_DESERIALIZE -DSQLITE_ENABLE_STMTVTAB -DTH3_SELFCOVERAGE -DSQLITE_ENABLE_ZIPVFS -DZIPVFS_OMIT_DEPRECATED cfg/c?.cfg cfg/wal1.cfg cfg/f2fs.cfg coverage.testplan zipvfs/?*.cfg cov1/?*.test zipvfs/?*.test th3: 0 errors in 3987688 tests. 1277.660 seconds on w23 64-bit little-endian th3: SQLite 3.45.0 2024-01-12 11:44:49 f47a5f4e0ce078e6cc1183e6cbb3c4013af379b496efae94863a42e5c39928ed
2024-01-15 13:15:30 drhok
6. Tests for platform Linux x86_64:
2024-01-15 13:15:27 drhok
6f. ./configure --enable-debug --enable-all && make parse.c && CC=clang CFLAGS='-fsanitize=address,undefined' make -e test
SQLite 2024-01-12 11:44:49 f47a5f4e0ce078e6cc1183e6cbb3c4013af379b496efae94863a42e5c39928ed 0 errors out of 378170 tests on r23 Linux 64-bit little-endian All memory allocations freed - no leaks Maximum memory usage: 9206008 bytes Current memory usage: 0 bytes
2024-01-15 13:14:43 drhok
13. Tests for platform Windows7:
2024-01-15 13:14:40 drhok
13d. Run selftest.txt from the dbs repository
2024-01-15 13:14:10 drhok
13c. Perform a .dump on a database that contains schema elements with Unicode characters
Unicode characters display as ?
2024-01-15 13:13:55 drhok
13b. Verify that the --utf8 option does not work.
No error message is generated. But neither does it support UTF8. Is that correct?
2024-01-15 13:13:28 drhok
13a. Compile the CLI separately (on Win11) and move the 64-bit EXE to the Win7 platform.
2024-01-15 12:20:10 drhok
31. Check JSON performance
2024-01-15 12:20:08 drhok
31c. Verify that the JSON parser performance claimed in the json1.html file of the documentation is accurate
2024-01-15 12:11:53 drhok
31b. Verify JSON performance against the previous release
6.5% faster - important for this release in as much as this release is all about improvements to JSON.
2024-01-15 12:11:29 drhok
31a. Run the procedures described in test/json/README.md
2024-01-15 12:07:32 drhok
30a. Linux
2024-01-15 12:06:02 drhok
29. Run make wordcount and do tests on current and prior versions:
2024-01-15 12:06:00 drhok
29b. rm -f wc.db && ./wordcount wc.db $BIGTEXT --all --cachesize 5 --nosync
2024-01-15 12:03:38 drhok
29a. rm -f wc.db && ./wordcount wc.db $BIGTEXT --all
2024-01-15 11:59:31 drhok
28b. Linux with --testset rtree
2024-01-15 11:59:23 stephanok
15. WASM
2024-01-15 11:58:55 stephanok
15d. Click on the test links - confirm correct results.
2024-01-15 11:58:50 stephanok
15c. althttpd --enable-sab --page index.html
2024-01-15 11:58:46 stephanok
15b. (On Linux) ./configure --enable-all && cd ext/wasm && make
2024-01-15 11:58:41 stephanok
15a. Build and install Fiddle according to website maintenance instructions at https://sqlite.org/devops/doc/trunk/build/website-build.md. Run simple tests.
2024-01-15 11:41:12 danok
6k. From a read-only source tree: $SRC/configure && make mdevtest
66 bld(6/6) fuzz(18/18) tcl(2334/2334)
2024-01-15 11:40:51 drhok
28a. Linux
2024-01-15 11:38:44 danok
6j. Verify that the SQLITE_HAVE_SQLITE3R is needed when building the CLI using sqlite3r.c: ./configure --enable-all && make sqlite3r.c shell.c && gcc -DSQLITE_ENABLE_DBPAGE_VTAB -DSQLITE_HAVE_SQLITE3R sqlite3r.c shell.c -ldl -lpthread && ./a.out '' .recover
The above command works. Without -DSQLITE_HAVE_SQLITE3R, the [gcc] build fails as expected.
2024-01-15 11:21:32 danok
6g. Test the reuse-schema branch with ./configure --enable-all && make "OPTS=-DSQLITE_ENABLE_SHARED_SCHEMA" sdevtest
199 bld(6/6) fuzz(18/18) tcl(2346/2346)
2024-01-13 21:29:09 drhok
25. NDS-Devkit testing
2024-01-13 21:27:31 drhok
25c. Verify the "NDS DevKit" version number shown at the end of the test
2024-01-13 21:27:18 drhok
25b. Test using: tclsh th3make debug.rc nds_devkit.rc
2024-01-13 21:27:15 drhok
25a. Merge all trunk enhancements into the reuse-schema branch and use that branch to update the devkit.
2024-01-13 21:01:22 danok
24b. testfixture test/testrunner.tcl --zipvfs <ZIPVFS-source-directory> zipvfs
263 bld(1/1) tcl(48/48)
2024-01-13 21:01:09 danok
24b. testfixture test/testrunner.tcl --zipvfs <ZIPVFS-source-directory> zipvfs
2024-01-13 20:55:04 drhok
17. Trunk changes merged and verified on active branches. See https://sqlite.org/devops/doc/trunk/build/release-actions-drh.md for detailed instructions.
2024-01-13 20:55:01 drhok
17g. reuse-schema-see (in the see-base repository)
2024-01-13 20:50:12 danok
24a. Verify that the configure script version number agrees with the SQLite version number
2024-01-13 20:42:53 drhok
17f. client-see (in the see-base repository)
2024-01-13 20:42:50 drhok
17e. see (in the see-base repository)
2024-01-13 20:42:05 drhok
17d. reuse-schema (from trunk)
2024-01-13 20:42:03 drhok
17c. bedrock (from wal2)
2024-01-13 20:42:00 drhok
17b. wal2 (from trunk)
2024-01-13 20:41:57 drhok
17a. begin-concurrent (from trunk)
2024-01-13 20:06:28 drhok
20g. Do the above on Mac
2024-01-13 19:51:00 danok
16. 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". Check that test script "atomic2.test" really did run, and did not report "No f2fs atomic-batch-write support. Skipping tests...".
SQLite 2024-01-12 11:44:49 f47a5f4e0ce078e6cc1183e6cbb3c4013af379b496efae94863a42e5c39928ed 0 errors out of 316621 tests on ws1 Linux 64-bit little-endian
2024-01-13 19:33:32 danok
14. Tests for platform OpenBSD (x86):
2024-01-13 19:33:29 danok
14b. th3make quick.rc
th3: 0 errors in 2608978 tests. 679.847 seconds on foo.. 64-bit little-endian th3: SQLite 3.45.0 2024-01-12 11:44:49 f47a5f4e0ce078e6cc1183e6cbb3c4013af379b496efae94863a42e5c39928ed
2024-01-13 19:31:53 danok
14a. make test
SQLite 2024-01-12 11:44:49 f47a5f4e0ce078e6cc1183e6cbb3c4013af379b496efae94863a42e5c39928ed 0 errors out of 317320 tests on foo.. OpenBSD 64-bit little-endian
2024-01-13 19:21:50 drhok
20f. Do the above on Linux
2024-01-13 19:18:06 danpending
14b. th3make quick.rc
2024-01-13 19:18:03 danpending
14a. make test
2024-01-13 18:43:24 drhok
8. Tests for platform MacOS x64:
2024-01-13 18:43:21 drhok
8c. tclsh multitest.tcl --scenario failures - all failures detected
2024-01-13 18:42:56 drhok
8b. tclsh multitest.tcl --xdev
2024-01-13 18:19:35 danok
35. 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.15.0, 3.41.0 and 3.8.1.
2024-01-13 18:15:21 danok
39. Run the rbu/run_rbu_tests.tcl script in the test-dbs project on Linux.
All tests report "round trip test successful".
2024-01-13 18:02:38 danok
41. Website built procedures
2024-01-13 18:02:36 danok
41c. All build products work on their target platforms
2024-01-13 17:51:38 drhok
8a. ./configure && make verify-source releasetest
5990 bld(9/9) fuzz(27/27) make(4/4) tcl(11225/11225)
2024-01-13 17:51:07 drhok
20h. Do the above on RaspberryPi
2024-01-13 17:51:02 drhok
20i. Do the above on Windows
2024-01-13 17:50:58 drhok
20e. fossil all repack
2024-01-13 17:50:56 drhok
20d. fossil all sync --all
2024-01-13 17:40:21 drhok
12f. After updating Fossil to use the latest SQLite, verify that it compiles without warnings and that it works
2024-01-13 17:33:00 danok
41b. Compile-time options for build products have been updated as necessary
SQLITE_STRICT_SUBTYPE=1 added to default makefiles - Makefile.in and Makefile.msc.
2024-01-13 17:32:54 drhok
11. Tests for platform Windows (32-bit):
2024-01-13 17:32:51 drhok
11e. Verify that EXEs and DLLs generated using MSVC contain the correct version number, product name, description, and copyright as resources.
2024-01-13 17:32:01 danok
41a. tools/mkmsvcmin.tcl has been run to update the MSVC makefiles in autoconf
Has been run. Running it again does not modify any files.
2024-01-13 17:30:59 drhok
11d. nmake /f Makefile.msc verify-source releasetest
2441 bld(11/11) fuzz(40/40) make(5/5) tcl(7196/7196)
2024-01-13 17:29:37 drhok
12a. Review the first part of doc/compile-for-windows.md for correctness. Ensure that the local build environment is correct, especially the TCLDIR variable.
2024-01-13 17:21:50 drhok
11a. Review the "32-bit Builds" section of doc/compile-for-windows.md for accuracy and completeness and make sure the local build environment is set up accordingly, especially the TCLDIR and PATH variables.
2024-01-13 16:59:36 drhok
11b. tclsh multitest.tcl --xdev
0 failures on 7 th3makes and 4960498 tests in (00:12:03) 5 cores on w23 (32-bit) SQLite 3.45.0 2024-01-12 11:44:49 f47a5f4e0ce078e6cc1183e6cbb3c4013af379b496efae94863a42e5c39928ed
2024-01-13 16:05:11 drhok
11c. tclsh multitest.tcl --msvc --scenario failures - verify failures detected
2024-01-13 16:04:32 drhok
11b. tclsh multitest.tcl --xdev
0 failures on 7 th3makes and 4960498 tests in (00:12:03) 5 cores on w23 (32-bit) SQLite 3.45.0 2024-01-12 11:44:49 f47a5f4e0ce078e6cc1183e6cbb3c4013af379b496efae94863a42e5c39928ed
2024-01-13 13:19:20 drhok
6i. Run auxiliary test script in the /usr subdirectory of the TH3 repository
2024-01-13 13:16:47 drhok
6h. CC=clang CFLAGS='-fsanitize=thread' ./configure && make threadtest5 && ./threadtest5
2024-01-13 13:13:20 drhok
6e. sh tool/symbols.sh - no incorrect exports or dependencies
2024-01-13 12:07:43 drhok
7. Tests for platform Linux ARM (BeagleBoard or RaspberryPI)
2024-01-13 12:07:41 drhok
7b. Recompile and test Fossil.
2024-01-13 12:07:35 drhok
7a. tclsh th3make min.rc -DTH3_LOWMEM --unobfuscated
th3: b5ce91aa9076a029a14bcf6e3fd6b7f189d05af324aa5f55481f917e952e4364 th3: ./th3make min.rc -DTH3_LOWMEM --unobfuscated th3: mkth3.tcl -DTH3_LOWMEM cfg/c?.cfg cfg/wal1.cfg cfg/f2fs.cfg coverage.testplan cov1/?*.test th3: 0 errors in 2272509 tests. 1682.773 seconds on pi4 32-bit little-endian th3: SQLite 3.45.0 2024-01-12 11:44:49 f47a5f4e0ce078e6cc1183e6cbb3c4013af379b496efae94863a42e5c39928ed
2024-01-13 12:07:28 drhok
7a. tclsh th3make min.rc -DTH3_LOWMEM --unobfuscated
2024-01-12 21:02:35 drhok
40. 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.
2024-01-12 21:01:25 drhok
36. Build and verify correct operation of sqlite3_analyzer on:
2024-01-12 21:01:22 drhok
37. Build and verify sqldiff
2024-01-12 21:01:20 drhok
37b. Mac
2024-01-12 21:01:18 drhok
36b. Mac OS X
2024-01-12 20:58:25 drhok
37a. Linux
2024-01-12 20:58:22 drhok
36a. Linux
2024-01-12 20:56:47 drhok
38. Build the "atrc" test program and run "./atrc $DB | ./sqlite3 $DB" against multiple databases, visually verify the result
2024-01-12 20:51:25 drhok
37c. Windows
2024-01-12 20:51:03 drhok
36c. Windows
2024-01-12 20:45:58 drhok
20. Fossil updated to use the latest SQLite.
2024-01-12 20:45:55 drhok
20c. fossil all test-integrity -d
2024-01-12 20:44:34 drhok
10. Tests for platform MacOS (PPC):
2024-01-12 20:44:31 drhok
10c. Verify that Fossil repositories are cross-platform with x86/x64.
2024-01-12 20:44:29 drhok
10b. Recompile and test Fossil.
2024-01-12 20:44:13 drhok
21. Wapp updated to use the latest SQLite
2024-01-12 20:44:10 drhok
21a. Used on active websites with no issues
2024-01-12 20:42:19 drhok
12. Tests for platform Windows (64-bit):
2024-01-12 20:42:17 drhok
12e. Verify that EXEs and DLLs generated using MSVC contain the correct version number, product name, description, and copyright as resources.
2024-01-12 20:39:30 drhok
20b. Used on active websites with no issues.
2024-01-12 20:39:28 drhok
20a. No SQLite compiler warnings.
2024-01-12 20:38:57 drhok
19. Sqllogictest:
2024-01-12 20:38:54 drhok
19c. tclsh run-all.tcl
0 errors out of 11879758 tests and 1244 invocations in 935 seconds
2024-01-12 20:23:10 drhok
19b. No SQLite compiler warnings.
2024-01-12 20:23:08 drhok
19a. Checked in latest SQLite amalgamation.
2024-01-12 20:19:55 drhok
18. Dbsqlfuzz tests
2024-01-12 20:19:53 drhok
18c. Linux: FUZZDB=$CORPUS make run-fuzzcheck
2024-01-12 20:12:26 drhok
18e. Win10/MSVC: fuzzcheck $CORPUS -spinner
2024-01-12 19:53:30 drhok
32. Use the ".selftest" command of the shell to verify that legacy database files are readable and cross-platform
2024-01-12 19:53:28 drhok
32f. Windows 32-bit
2024-01-12 19:51:57 drhok
10a. .selftest checks (see below)
2024-01-12 19:51:46 drhok
32a. iBook PPC
2024-01-12 19:51:00 drhok
32g. Windows 64-bit
2024-01-12 19:50:54 drhok
32b. Linux x64
2024-01-12 19:50:38 drhok
34. Verify that the amalgamation builds are byte-for-byte identical on all workstation platforms.
2024-01-12 19:50:34 drhok
34f. Windows using NMAKE.
579523c9fd89163b0b9094165d5662e9c7708f11ddc962e8227ca44bedb91359 sqlite3.c a5507c5647ffcc36b22f0e3ca521ae8d308e8afbed54c8f23fedea0ba93a38e3 sqlite3.h
2024-01-12 19:49:30 drhok
32c. Linux ARM
2024-01-12 19:48:11 drhok
32d. Mac x64
2024-01-12 19:46:35 drhok
34c. Mac OS X
579523c9fd89163b0b9094165d5662e9c7708f11ddc962e8227ca44bedb91359 sqlite3.c a5507c5647ffcc36b22f0e3ca521ae8d308e8afbed54c8f23fedea0ba93a38e3 sqlite3.h
2024-01-12 19:44:39 drhok
12c. tclsh multitest.tcl --msvc --scenario failures - verify failures detected
2024-01-12 19:44:12 drhok
32e. Mac ARM
2024-01-12 19:41:29 drhok
34d. Mac OS X (PPC)
579523c9fd89163b0b9094165d5662e9c7708f11ddc962e8227ca44bedb91359 sqlite3.c a5507c5647ffcc36b22f0e3ca521ae8d308e8afbed54c8f23fedea0ba93a38e3 sqlite3.h
2024-01-12 19:41:05 drhok
34e. Mac OS X (ARM)
579523c9fd89163b0b9094165d5662e9c7708f11ddc962e8227ca44bedb91359 sqlite3.c a5507c5647ffcc36b22f0e3ca521ae8d308e8afbed54c8f23fedea0ba93a38e3 sqlite3.h
2024-01-12 19:40:38 drhok
34b. Linux (ARM)
579523c9fd89163b0b9094165d5662e9c7708f11ddc962e8227ca44bedb91359 sqlite3.c a5507c5647ffcc36b22f0e3ca521ae8d308e8afbed54c8f23fedea0ba93a38e3 sqlite3.h
2024-01-12 19:39:59 drhok
12b. tclsh multitest.tcl --xdev
0 failures on 7 th3makes and 4988383 tests in (00:10:04) 5 cores on w23 (64-bit)
2024-01-12 19:39:01 drhok
34a. Linux (x64)
579523c9fd89163b0b9094165d5662e9c7708f11ddc962e8227ca44bedb91359 sqlite3.c a5507c5647ffcc36b22f0e3ca521ae8d308e8afbed54c8f23fedea0ba93a38e3 sqlite3.h
2024-01-12 19:31:42 drhok
18d. Mac: FUZZDB=$CORPUS make run-fuzzcheck
2024-01-12 19:21:53 drhok
5. OMIT, ENABLE, and DISABLE options:
2024-01-12 19:21:50 drhok
5c. tclsh tool/omittest-msvc.tcl ← on Windows
2024-01-12 19:12:42 drhok
18b. Check-in CORPUS as an unversioned file in the dbsqlfuzz repository
2024-01-12 19:12:39 drhok
18a. Develop a new CORPUS database by running dbsqlfuzz for 10 billion iterations
2024-01-12 19:11:53 drhok
9. Tests for platform MacOS ARM:
2024-01-12 19:11:50 drhok
9b. tclsh multitest.tcl --xdev
2024-01-12 18:08:48 drhok
12d. nmake /f Makefile.msc verify-source releasetest
3398 bld(11/11) fuzz(40/40) make(5/5) tcl(7196/7196)
2024-01-12 18:02:55 drhok
9a. ./configure && make verify-source releasetest
OK f47a5f4e0ce078e6cc1183e6c 1771 bld(9/9) fuzz(27/27) make(4/4) tcl(11225/11225)
2024-01-12 18:01:18 drhok
6d. ./configure && make verify-source releasetest
OK f47a5f4e0ce078e6cc1183e6c 2656 bld(46/46) fuzz(126/126) make(18/18) tcl(37843/37843)
2024-01-12 17:54:33 drhok
6a. tclsh multitest.tcl
0 failures on 74 th3makes and 256642159 tests in (01:04:11) 20 cores on r21 (32/64-bit) SQLite 3.45.0 2024-01-12 11:44:49 f47a5f4e0ce078e6cc1183e6cbb3c4013af379b496efae94863a42e5c39928ed
2024-01-12 17:36:03 drhok
5a. Recent compile-time options have been added to the omittest.tcl and omittest-msvc.tcl scripts and checked in.
2024-01-12 17:36:01 drhok
5b. tclsh ../tool/omittest.tcl -skip_run -target libsqlite3.a ← on Linux
2024-01-12 17:10:10 drhok
6c. tclsh multitest.tcl --scenario failures - all failures detected
2024-01-12 17:07:17 drhok
6b. tclsh multitest.tcl --scenario coverage
0 failures on 4 th3makes and 7623166 tests in (00:18:01) on r20 (64-bit) SQLite 3.45.0 2024-01-12 11:44:49 f47a5f4e0ce078e6cc1183e6cbb3c4013af379b496efae
2024-01-12 16:44:45 drhok
4. Compiler warning checks.
2024-01-12 16:44:43 drhok
4c. Clang-6.0.0: CFLAGS='-O0' ./configure --enable-debug --enable-all && scan-build make sqlite3
2024-01-12 15:53:36 drhok
4b. Mac OS X GCC -Wall -Wextra (the "tool/warnings.sh" script)
2024-01-12 15:50:45 drhok
4d. Clang-10.0.0: CFLAGS='-O0' ./configure --enable-debug --enable-all && scan-build make sqlite3
2024-01-12 15:50:41 drhok
4a. Linux GCC -Wall -Wextra (the "tool/warnings.sh" script)
2024-01-12 15:41:48 drhok
3d. No unresolved hyperlinks in the documentation build.
2024-01-12 15:41:45 drhok
3c. Release accouncement in "news.html".
2024-01-12 15:41:43 drhok
3b. Release announcement in "changes.in".
2024-01-12 15:41:40 drhok
3a. Latest release on the "index.html" page.