SQLite

Release Checklist for SQLite 3.46.0
Login
2024-07-20 17:51:37 drhok
15. WASM
2024-07-05 00:03:43 drhok
3. Documentation review:
2024-07-05 00:03:41 drhok
3h. Check new/changed documentation for spelling and gramatical mistakes.
2024-05-22 18:34:55 drhok
3c. Release accouncement in "news.html".
2024-05-22 17:33:43 drhok
1. Test procedure review.
2024-05-22 17:33:41 drhok
1d. Review dev-ops procedures and make any needed updates and corrections.
2024-05-22 17:33:38 drhok
1c. Review this checklist for completeness and accuracy.
2024-05-22 17:33:36 drhok
1b. Review "multitest.tcl" and "alignment*.rc" scripts in TH3 for completeness.
2024-05-22 17:33:34 drhok
1a. Review the "test/testrunner.tcl" script for completeness and accuracy.
2024-05-22 17:33:29 drhok
2. Source code change review. fossil diff --from release --to trunk
2024-05-22 17:33:26 drhok
2m. Compare sqlite3.c and sqlite3.h against the previous release.
2024-05-22 17:33:23 drhok
2l. Significant compile-time options are recognized by the sqlite3_compileoption_used() interface.
2024-05-22 17:33:19 drhok
2k. Verify that the list of APIs exposed via the extension header is up-to-date (sqlite3ext.h).
2024-05-22 17:33:12 drhok
2j. Verify that source code contains no tabs and that surplus whitespace has been removed.
2024-05-22 17:32:43 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-05-22 17:31:25 drhok
2h. Check all calls to sqlite3OsRead() and sqlite3OsWrite() to ensure that offset computations are 64-bit clean.
2024-05-22 17:30:35 drhok
2g. Variables and functions have been renamed to reflect changes in their use.
2024-05-22 17:30:31 drhok
2f. Verify that the azProhibitedFunctions list in the safeModeAuth() function of the CLI is complete and up-to-date.
2024-05-22 17:29:47 drhok
2e. Comments have been updated to reflect code changes.
2024-05-22 17:29:44 drhok
2d. New code complies with design rules.
2024-05-22 17:28:25 drhok
2c. New code complies with style guidelines.
2024-05-22 17:28:23 drhok
2b. All significant changes are mentioned in the "changes" log of the documentation.
2024-05-22 17:28:20 drhok
2a. No stray changes.
2024-05-22 13:55:18 drhok
3g. Test metrics are up-to-date (testing.html).
2024-05-22 13:55:14 drhok
3f. Database footprint is up-to-date (features.html).
2024-05-22 13:55:09 drhok
3e. The compile-time options are all up-to-date (compile.html).
2024-05-22 13:55:03 drhok
3d. No unresolved hyperlinks in the documentation build.
2024-05-22 13:54:48 drhok
3b. Release announcement in "changes.in".
2024-05-22 13:54:45 drhok
3a. Latest release on the "index.html" page.
2024-05-22 12:19:36 stephanok
15d. Click on the test links - confirm correct results.
2024-05-22 12:19:34 stephanok
15c. althttpd --enable-sab --page index.html
2024-05-22 12:19:32 stephanok
15b. (On Linux) ./configure --enable-all && cd ext/wasm && make
2024-05-22 11:40:02 drhok
30. Compare performance to the previous release using kvtest.
2024-05-22 11:39:59 drhok
28. Performance tests using speedtest1 compared against the previous release and a release from about one year ago.
2024-05-22 11:39:56 drhok
30c. Windows
2024-05-22 11:39:54 drhok
28e. Windows with --testset rtree
2024-05-22 11:39:52 drhok
28d. Windows
2024-05-22 11:21:46 drhok
30b. Mac
2024-05-22 11:20:49 drhok
28c. Mac
2024-05-22 11:18:00 drhok
30a. Linux
2024-05-22 11:16:17 drhok
28b. Linux with --testset rtree
2024-05-22 11:13:46 drhok
28a. Linux
2024-05-22 11:12:50 danok
27. TEA archive builds correctly and runs:
2024-05-22 11:12:48 danok
27d. Windows MSVC
2024-05-22 11:10:21 drhok
31. Check JSON performance
2024-05-22 11:04:25 danok
27c. Mac OS X
2024-05-22 11:03:58 drhok
31b. Verify JSON performance against the previous release
2024-05-22 11:03:55 drhok
31a. Run the procedures described in test/json/README.md
2024-05-22 11:00:42 danok
27b. Linux
2024-05-22 11:00:39 danok
27a. Verify that the SQLite version number is correct in autoconf/tea/configure.ac
2024-05-22 10:37:27 drhok
13. Tests for platform Windows7:
2024-05-22 10:37:25 drhok
13b. Verify that the --utf8 option does not work.
2024-05-22 10:36:50 drhok
13d. Run selftest.txt from the dbs repository
2024-05-22 10:36:20 drhok
13c. Perform a .dump on a database that contains schema elements with Unicode characters
2024-05-22 10:34:47 drhok
13a. Compile the CLI separately (on Win11) and move the 64-bit EXE to the Win7 platform.
2024-05-22 10:26:24 drhok
25. NDS-Devkit testing
2024-05-22 10:26:21 drhok
25c. Verify the "NDS DevKit" version number shown at the end of the test
2024-05-22 10:26:15 drhok
25b. Test using: tclsh th3make debug.rc nds_devkit.rc
2024-05-22 00:14:12 drhok
25a. Merge all trunk enhancements into the reuse-schema branch and use that branch to update the devkit.
2024-05-21 23:36:38 drhok
29. Run make wordcount and do tests on current and prior versions:
2024-05-21 23:36:35 drhok
29b. rm -f wc.db && ./wordcount wc.db $BIGTEXT --all --cachesize 5 --nosync
2024-05-21 23:33:19 drhok
29a. rm -f wc.db && ./wordcount wc.db $BIGTEXT --all
2024-05-21 23:28:23 drhok
8. Tests for platform MacOS x64:
2024-05-21 23:28:20 drhok
8a. ./configure && make verify-source releasetest
5958 bld(9/9) fuzz(27/27) make(4/4) tcl(11443/11443)
2024-05-21 23:27:47 drhok
38. Build the "atrc" test program and run "./atrc $DB | ./sqlite3 $DB" against multiple databases, visually verify the result
2024-05-21 23:16:52 drhok
6. Tests for platform Linux x86_64:
2024-05-21 23:16:48 drhok
6k. From a read-only source tree: $SRC/configure && make mdevtest
72 bld(12/12) fuzz(27/27) tcl(3582/3582)
2024-05-21 23:13:33 drhok
6g. Test the reuse-schema branch with ./configure --enable-all && make "OPTS=-DSQLITE_ENABLE_SHARED_SCHEMA" sdevtest
120 bld(8/8) fuzz(18/18) tcl(2388/2388)
2024-05-21 23:08:42 drhok
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
2024-05-21 23:07:27 drhok
6i. Run auxiliary test script in the /usr subdirectory of the TH3 repository
2024-05-21 23:04:09 drhok
19. Sqllogictest:
2024-05-21 23:04:07 drhok
19c. tclsh run-all.tcl
0 errors out of 11879758 tests and 1244 invocations in 999 seconds
2024-05-21 23:03:15 drhok
6h. CC=clang CFLAGS='-fsanitize=thread' ./configure && make threadtest5 && ./threadtest5
2024-05-21 23:02:25 drhok
6f. ./configure --enable-debug --enable-all && make parse.c && CC=clang CFLAGS='-fsanitize=address,undefined' make -e test
SQLite 2024-05-21 17:37:50 3210e1ca4d0efedf9710c97abd050ba10d3af98cb1f029c26daa84daf42fbc7e 0 errors out of 389910 tests on r23 Linux 64-bit little-endian All memory allocations freed - no leaks
2024-05-21 22:03:44 drhok
19b. No SQLite compiler warnings.
2024-05-21 22:03:41 drhok
19a. Checked in latest SQLite amalgamation.
2024-05-21 21:58:36 drhok
6c. tclsh multitest.tcl --scenario failures - all failures detected
2024-05-21 21:51:58 drhok
6b. tclsh multitest.tcl --scenario coverage
0 failures on 4 th3makes and 7624016 tests in (00:10:58) on r23 (64-bit) SQLite 3.46.0 2024-05-21 17:37:50 3210e1ca4d0efedf9710c97abd050ba10d3af98cb1f029c26daa84daf42fbc7e
2024-05-21 21:36:23 drhok
6a. tclsh multitest.tcl
0 failures on 75 th3makes and 259388330 tests in (00:43:38) 24 cores on r23 (32/64-bit) SQLite 3.46.0 2024-05-21 11:11:29 de8182cf1773ac0d04268d896a613841cf6bf61f9f030342170657d5e06f2acb 0 failures on 75 th3makes and 259387239 tests in (00:44:16) 24 cores on r23 (32/64-bit) SQLite 3.46.0 2024-05-21 17:37:50 3210e1ca4d0efedf9710c97abd050ba10d3af98cb1f029c26daa84daf42fbc7e
2024-05-21 20:48:46 danok
41. Website built procedures
2024-05-21 20:48:43 danok
41c. All build products work on their target platforms
2024-05-21 20:48:02 drhok
5. OMIT, ENABLE, and DISABLE options:
2024-05-21 20:48:00 drhok
5c. tclsh tool/omittest-msvc.tcl ← on Windows
2024-05-21 20:36:46 danok
41b. Compile-time options for build products have been updated as necessary
2024-05-21 20:36:42 danok
41a. tools/mkmsvcmin.tcl has been run to update the MSVC makefiles in autoconf
2024-05-21 20:30:14 drhok
5b. tclsh ../tool/omittest.tcl -skip_run -target libsqlite3.a ← on Linux
2024-05-21 20:30:11 drhok
5a. Recent compile-time options have been added to the omittest.tcl and omittest-msvc.tcl scripts and checked in.
2024-05-21 20:09:38 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-05-21 20:09:37 danok
26. Amalgamation autoconf tarball.
2024-05-21 20:09:34 danok
26d. Works on Windows MSVC
2024-05-21 20:08:08 drhok
33. Verify that the performance and size measurement spreadsheet in the documentation (misc/speed-size-graph.ods) is up-to-date.
2024-05-21 20:06:12 danok
26c. Works on Mac OS X.
2024-05-21 19:58:25 danok
26b. Works on Linux.
2024-05-21 19:57:52 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-05-21 19:55:08 drhok
22. CEROD tests in the "test/" subdirectory.
2024-05-21 19:17:41 danok
26a. Builds.
2024-05-21 19:13:40 drhok
23. SEE tests using TH3. Source directories "th3" and "see" are siblings:
2024-05-21 19:13:38 drhok
23e. tclsh multitest.tcl --dev --srcdir ../see --see aes128-ccm
Extra arguments: see.rc File tested: ../see/sqlite3-see-aes128-ccm.c 0 failures on 6 th3makes and 3208085 tests in (00:03:10) 6 cores on r20 (64-bit)
2024-05-21 18:53:52 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 against 3.41.0, 3.15.0 and 3.8.1 using backcompat.test SQLite 2024-05-21 17:37:50 3210e1ca4d0efedf9710c97abd050ba10d3af98cb1f029c26daa84daf42fbc7e
2024-05-21 18:09:47 drhok
18. Dbsqlfuzz tests
2024-05-21 18:09:45 drhok
18d. Mac: FUZZDB=$CORPUS make run-fuzzcheck
20240514.db: 67254/67254 fuzzcheck: 392469 query invariants checked fuzzcheck: 0 errors out of 67254 tests in 173.425 seconds SQLite 3.46.0 2024-05-21 17:37:50 3210e1ca4d0efedf9710c97abd050ba10d3af98cb1f029c26daa84daf42fbc7e (64-bit)
2024-05-21 18:08:12 drhok
23g. tclsh multitest.tcl --dev --srcdir ../see --see aes256-openssl
Extra arguments: see.rc -lcrypto File tested: ../see/sqlite3-see-aes256-openssl.c 0 failures on 6 th3makes and 3207656 tests in (00:02:43) 6 cores on r20 (64-bit)
2024-05-21 18:03:46 drhok
23d. tclsh multitest.tcl --dev --srcdir ../see --see rc4
Extra arguments: see.rc File tested: ../see/sqlite3-see-rc4.c 0 failures on 6 th3makes and 3208050 tests in (00:03:24) 6 cores on r20 (64-bit)
2024-05-21 18:02:49 drhok
23h. tclsh multitest.tcl --dev --srcdir ../see --see aes256-cryptoapi.c (Windows)
Extra arguments: msvc.rc see.rc File tested: ../see/sqlite3-see-aes256-cryptoapi.c 0 failures on 6 th3makes and 3147048 tests in (00:07:45) 6 cores on w23 (64-bit)
2024-05-21 17:59:46 drhok
23i. On one of the above, add ++UPDATE_DELETE_LIMIT
2024-05-21 17:59:42 drhok
23c. tclsh multitest.tcl --dev --srcdir ../see --see aes256-ofb
Extra arguments: see.rc -DSQLITE_ENABLE_UPDATE_DELETE_LIMIT File tested: ../see/sqlite3-see-aes128-ofb.c 0 failures on 6 th3makes and 3215554 tests in (00:02:51) 6 cores on r20 (64-bit)
2024-05-21 17:56:03 drhok
23j. At least one of the above on Linux.
2024-05-21 17:55:32 drhok
23a. tclsh multitest.tcl --dev --srcdir ../see --see
Extra arguments: see.rc File tested: ../see/sqlite3-see.c 0 failures on 6 th3makes and 3184773 tests in (00:03:39) 3 cores on minimac.local (64-bit)
2024-05-21 17:55:18 drhok
23b. tclsh multitest.tcl --dev --srcdir ../see --see aes128-ofb
Extra arguments: see.rc File tested: ../see/sqlite3-see-aes128-ofb.c 0 failures on 6 th3makes and 3207613 tests in (00:02:51) 6 cores on r20 (64-bit)
2024-05-21 17:37:53 drhok
23f. tclsh multitest.tcl --dev --srcdir ../see --see cccrypt (Mac)
Extra arguments: see.rc File tested: ../see/sqlite3-see-cccrypt.c 0 failures on 6 th3makes and 3184729 tests in (00:02:59) 3 cores on minimac.local (64-bit)
2024-05-21 17:01:39 danok
24. ZIPVFS tests:
2024-05-21 17:01:36 danok
24d. Mac: tclsh multitest.tcl --scenario zipvfs
0 failures on 8 th3makes and 3724433 tests in (00:07:14) 8 cores on Dans-iMac.local (64-bit) SQLite 3.46.0 2024-05-21 14:54:46 54a49f1847f95c377f0f611eb10f635b879bba8c2eb25e65e2f66a56f4f9a505
2024-05-21 16:58:09 drhok
18c. Linux: FUZZDB=$CORPUS make run-fuzzcheck
20240514.db: 67254/67254 fuzzcheck: 392513 query invariants checked fuzzcheck: 0 errors out of 67254 tests in 182.015 seconds SQLite 3.46.0 2024-05-21 14:54:46 54a49f1847f95c377f0f611eb10f635b879bba8c2eb25e65e2f66a56f4f9a505 (64-bit)
2024-05-21 16:48:57 danok
24e. Windows: tclsh multitest.tcl --scenario zipvfs
0 failures on 8 th3makes and 3743871 tests in (07:07:53) 8 cores on DESKTOP-C1KR53M (64-bit) SQLite 3.46.0 2024-05-21 14:54:46 54a49f1847f95c377f0f611eb10f635b879bba8c2eb25e65e2f66a56f4f9a505
2024-05-21 16:47:17 danok
24c. Linux: tclsh multitest.tcl --scenario zipvfs --extra --valgrind --omit 'quick[23]'
0 failures on 6 th3makes and 1820891 tests in (00:31:54) 8 cores on ws1 (64-bit) SQLite 3.46.0 2024-05-21 14:54:46 54a49f1847f95c377f0f611eb10f635b879bba8c2eb25e65e2f66a56f4f9a505
2024-05-21 16:46:07 drhok
18e. Win10/MSVC: fuzzcheck $CORPUS -spinner
20240514.db: 67254/67254 fuzzcheck: 392557 query invariants checked fuzzcheck: 0 errors out of 67254 tests in 165.110 seconds SQLite 3.46.0 2024-05-21 14:54:46 54a49f1847f95c377f0f611eb10f635b879bba8c2eb25e65e2f66a56f4f9a505 (64-bit)
2024-05-21 16:41:06 drhok
18b. Check-in CORPUS as an unversioned file in the dbsqlfuzz repository
2024-05-21 16:40:07 drhok
18a. Develop a new CORPUS database by running dbsqlfuzz for 10 billion iterations
2024-05-21 16:39:45 drhok
37. Build and verify sqldiff
2024-05-21 16:39:43 drhok
37a. Linux
2024-05-21 16:39:40 drhok
37b. Mac
2024-05-21 16:39:32 drhok
36. Build and verify correct operation of sqlite3_analyzer on:
2024-05-21 16:39:30 drhok
36a. Linux
2024-05-21 16:38:56 drhok
36b. Mac OS X
2024-05-21 16:37:13 drhok
32. Use the ".selftest" command of the shell to verify that legacy database files are readable and cross-platform
2024-05-21 16:37:10 drhok
32e. Mac ARM
2024-05-21 16:37:08 drhok
32d. Mac x64
2024-05-21 16:36:53 drhok
32b. Linux x64
2024-05-21 16:34:02 drhok
32g. Windows 64-bit
2024-05-21 16:31:12 drhok
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-05-21 16:30:11 drhok
32f. Windows 32-bit
2024-05-21 16:29:05 drhok
37c. Windows
2024-05-21 16:29:03 drhok
36c. Windows
2024-05-21 16:26:50 drhok
34. Verify that the amalgamation builds are byte-for-byte identical on all workstation platforms.
2024-05-21 16:26:48 drhok
34f. Windows using NMAKE.
eb127b45d6693e9dfd34f28e118610cec80963242c9520e9c6c48952b135d4c6 sqlite3.c 826f75c9ffd6a23bbcacfb851c4a602b4c408b2e9b4361e13f8529f45f926b59 sqlite3.h
2024-05-21 16:25:50 drhok
11. Tests for platform Windows (32-bit):
2024-05-21 16:25:48 drhok
11c. tclsh multitest.tcl --msvc --scenario failures - verify failures detected
2024-05-21 16:25:18 drhok
11b. tclsh multitest.tcl --xdev
0 failures on 7 th3makes and 4967499 tests in (00:16:40) 2 cores on w23 (32-bit) SQLite 3.46.0 2024-05-21 13:34:26 aab59f9f7c1c4cfac4d29d7c7a381583295312baf3b9a75e30a617b1541e12e1
2024-05-21 16:24:31 drhok
34d. Mac OS X (PPC)
eb127b45d6693e9dfd34f28e118610cec80963242c9520e9c6c48952b135d4c6 sqlite3.c 826f75c9ffd6a23bbcacfb851c4a602b4c408b2e9b4361e13f8529f45f926b59 sqlite3.h
2024-05-21 16:24:05 drhok
34c. Mac OS X
eb127b45d6693e9dfd34f28e118610cec80963242c9520e9c6c48952b135d4c6 sqlite3.c 826f75c9ffd6a23bbcacfb851c4a602b4c408b2e9b4361e13f8529f45f926b59 sqlite3.h
2024-05-21 16:23:55 drhok
34b. Linux (ARM)
eb127b45d6693e9dfd34f28e118610cec80963242c9520e9c6c48952b135d4c6 sqlite3.c 826f75c9ffd6a23bbcacfb851c4a602b4c408b2e9b4361e13f8529f45f926b59 sqlite3.h
2024-05-21 16:23:36 drhok
34a. Linux (x64)
eb127b45d6693e9dfd34f28e118610cec80963242c9520e9c6c48952b135d4c6 sqlite3.c 826f75c9ffd6a23bbcacfb851c4a602b4c408b2e9b4361e13f8529f45f926b59 sqlite3.h
2024-05-21 16:23:12 drhok
34e. Mac OS X (ARM)
eb127b45d6693e9dfd34f28e118610cec80963242c9520e9c6c48952b135d4c6 sqlite3.c 826f75c9ffd6a23bbcacfb851c4a602b4c408b2e9b4361e13f8529f45f926b59 sqlite3.h
2024-05-21 15:38:05 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-05-21 15:37:57 drhok
17g. reuse-schema-see (in the see-base repository)
2024-05-21 15:35:45 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-05-21 15:35:40 drhok
11e. Verify that EXEs and DLLs generated using MSVC contain the correct version number, product name, description, and copyright as resources.
2024-05-21 15:32:34 drhok
11d. nmake /f Makefile.msc verify-source releasetest
2528 bld(11/11) fuzz(40/40) make(5/5) tcl(7337/7337)
2024-05-21 15:24:43 drhok
17d. reuse-schema (from trunk)
2024-05-21 15:24:41 drhok
17c. bedrock (from wal2)
2024-05-21 15:24:39 drhok
17b. wal2 (from trunk)
2024-05-21 15:23:45 danok
24b. testfixture test/testrunner.tcl --zipvfs <ZIPVFS-source-directory> zipvfs
120 bld(1/1) tcl(48/48)
2024-05-21 15:23:01 danok
24a. Verify that the configure script version number agrees with the SQLite version number
2024-05-21 15:19:23 drhok
17a. begin-concurrent (from trunk)
2024-05-21 15:15:33 drhok
17f. client-see (in the see-base repository)
2024-05-21 15:14:18 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-05-21 14:54:46 54a49f1847f95c377f0f611eb10f635b879bba8c2eb25e65e2f66a56f4f9a505 0 errors out of 328293 tests on ws1 Linux 64-bit little-endian
2024-05-21 15:13:28 drhok
17e. see (in the see-base repository)
2024-05-21 15:13:17 danok
14. Tests for platform OpenBSD (x86):
2024-05-21 15:12:31 danok
14b. th3make quick.rc
Full TH3 coverage verified th3: dac89bf060bc8f169bbf972a9d3aa35b727e0176c6cb41e854799b5901078770 th3: mkth3.tcl -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 2612676 tests. 609.935 seconds on foo.. 64-bit little-endian th3: SQLite 3.46.0 2024-05-21 13:34:26 aab59f9f7c1c4cfac4d29d7c7a381583295312baf3b9a75e30a617b1541e12e1
2024-05-21 15:11:32 drhok
20. Fossil updated to use the latest SQLite.
2024-05-21 15:11:30 drhok
20i. Do the above on Windows
2024-05-21 15:11:27 drhok
20h. Do the above on RaspberryPi
2024-05-21 15:02:33 danok
14a. make test
SQLite 2024-05-21 13:34:26 aab59f9f7c1c4cfac4d29d7c7a381583295312baf3b9a75e30a617b1541e12e1 0 errors out of 328071 tests on foo.. OpenBSD 64-bit little-endian
2024-05-21 14:44:17 drhok
12. Tests for platform Windows (64-bit):
2024-05-21 14:44:13 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-05-21 14:43:43 drhok
12f. After updating Fossil to use the latest SQLite, verify that it compiles without warnings and that it works
2024-05-21 14:41:39 drhok
12c. tclsh multitest.tcl --msvc --scenario failures - verify failures detected
2024-05-21 14:41:33 drhok
12b. tclsh multitest.tcl --xdev
0 failures on 7 th3makes and 4994755 tests in (00:15:02) 2 cores on w23 (64-bit) SQLite 3.46.0 2024-05-21 13:34:26 aab59f9f7c1c4cfac4d29d7c7a381583295312baf3b9a75e30a617b1541e12e1
2024-05-21 14:40:26 drhok
12b. tclsh multitest.tcl --xdev
0 failures on 7 th3makes and 4994755 tests in (00:15:02) 2 cores on w23 (64-bit) SQLite 3.46.0 2024-05-21 13:34:26 aab59f9f7c1c4cfac4d29d7c7a381583295312baf3b9a75e30a617b1541e12e1
2024-05-21 14:25:58 drhok
7. Tests for platform Linux ARM (BeagleBoard or RaspberryPI)
2024-05-21 14:25:55 drhok
7b. Recompile and test Fossil.
2024-05-21 14:19:49 drhok
7a. tclsh th3make min.rc -DTH3_LOWMEM --unobfuscated
th3: dac89bf060bc8f169bbf972a9d3aa35b727e0176c6cb41e854799b5901078770 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 2278863 tests. 1346.684 seconds on pi4 32-bit little-endian th3: SQLite 3.46.0 2024-05-21 13:34:26 aab59f9f7c1c4cfac4d29d7c7a381583295312baf3b9a75e30a617b1541e12e1
2024-05-21 14:08:05 drh---
11e. Verify that EXEs and DLLs generated using MSVC contain the correct version number, product name, description, and copyright as resources.
2024-05-21 14:07:58 drh---
11d. nmake /f Makefile.msc verify-source releasetest
2024-05-21 14:07:48 drhok
12e. Verify that EXEs and DLLs generated using MSVC contain the correct version number, product name, description, and copyright as resources.
2024-05-21 14:07:45 drhok
12d. nmake /f Makefile.msc verify-source releasetest
2454 bld(11/11) fuzz(40/40) make(5/5) tcl(7337/7337)
2024-05-21 14:06:20 drhok
11e. Verify that EXEs and DLLs generated using MSVC contain the correct version number, product name, description, and copyright as resources.
2024-05-21 14:05:11 drhok
8c. tclsh multitest.tcl --scenario failures - all failures detected
2024-05-21 14:04:28 drhok
8b. tclsh multitest.tcl --xdev
0 failures on 7 th3makes and 5017154 tests in (00:24:34) on SQLite-iMac-2018.local (64-bit) SQLite 3.46.0 2024-05-21 11:11:29 de8182cf1773ac0d04268d896a613841cf6bf61f9f030342170657d5e06f2acb
2024-05-21 14:03:31 drhok
11d. nmake /f Makefile.msc verify-source releasetest
2454 bld(11/11) fuzz(40/40) make(5/5) tcl(7337/7337)
2024-05-21 14:02:28 drhok
20g. Do the above on Mac
2024-05-21 14:02:15 drhok
20f. Do the above on Linux
2024-05-21 14:02:12 drhok
20c. fossil all test-integrity -d
2024-05-21 14:02:09 drhok
20d. fossil all sync --all
2024-05-21 13:59:22 drhok
20b. Used on active websites with no issues.
2024-05-21 13:59:19 drhok
20a. No SQLite compiler warnings.
2024-05-21 13:59:08 drhok
20e. fossil all repack
2024-05-21 13:56:46 drhok
21. Wapp updated to use the latest SQLite
2024-05-21 13:56:43 drhok
21a. Used on active websites with no issues
2024-05-21 13:51:27 drhok
34d. Mac OS X (PPC)
ebac8b7dea6f2d208f5fa821e785da186d2e601fe73bcff54a847851b01afc79 sqlite3.c d11b816f9534161862e3add948619bd4886bbaa9e4ae81df2c5c32672c470ce5 sqlite3.h
2024-05-21 13:51:07 drhok
34e. Mac OS X (ARM)
ebac8b7dea6f2d208f5fa821e785da186d2e601fe73bcff54a847851b01afc79 sqlite3.c d11b816f9534161862e3add948619bd4886bbaa9e4ae81df2c5c32672c470ce5 sqlite3.h
2024-05-21 13:50:54 drhok
34b. Linux (ARM)
ebac8b7dea6f2d208f5fa821e785da186d2e601fe73bcff54a847851b01afc79 sqlite3.c d11b816f9534161862e3add948619bd4886bbaa9e4ae81df2c5c32672c470ce5 sqlite3.h
2024-05-21 13:50:43 drhok
34a. Linux (x64)
ebac8b7dea6f2d208f5fa821e785da186d2e601fe73bcff54a847851b01afc79 sqlite3.c d11b816f9534161862e3add948619bd4886bbaa9e4ae81df2c5c32672c470ce5 sqlite3.h
2024-05-21 13:48:41 drhok
32a. iBook PPC
2024-05-21 13:48:32 drhok
10. Tests for platform MacOS (PPC):
2024-05-21 13:48:30 drhok
10c. Verify that Fossil repositories are cross-platform with x86/x64.
2024-05-21 13:48:26 drhok
10b. Recompile and test Fossil.
2024-05-21 13:39:26 drhok
10a. .selftest checks (see below)
2024-05-21 13:38:38 drhok
6e. sh tool/symbols.sh - no incorrect exports or dependencies
2024-05-21 13:37:59 drhok
4. Compiler warning checks.
2024-05-21 13:37:55 drhok
4a. Linux GCC -Wall -Wextra (the "tool/warnings.sh" script)
2024-05-21 13:37:53 drhok
4b. Mac OS X GCC -Wall -Wextra (the "tool/warnings.sh" script)
2024-05-21 13:35:48 drhok
32c. Linux ARM
2024-05-21 13:27:12 drhok
4c. Clang-6.0.0: CFLAGS='-O0' ./configure --enable-debug --enable-all && scan-build make sqlite3
2024-05-21 13:21:58 drhok
9. Tests for platform MacOS ARM:
2024-05-21 13:21:56 drhok
9b. tclsh multitest.tcl --xdev
0 failures on 7 th3makes and 5017198 tests in (00:04:58) 3 cores on minimac.local (64-bit) SQLite 3.46.0 2024-05-21 11:11:29 de8182cf1773ac0d04268d896a613841cf6bf61f9f030342170657d5e06f2acb
2024-05-21 13:14:45 drhok
9a. ./configure && make verify-source releasetest
1872 bld(9/9) fuzz(27/27) make(4/4) tcl(11443/11443)
2024-05-21 13:13:43 drhok
6d. ./configure && make verify-source releasetest
1392 bld(49/49) fuzz(135/135) make(19/19) tcl(39772/39772)
2024-05-21 13:13:07 drhok
6a. tclsh multitest.tcl
0 failures on 75 th3makes and 259388330 tests in (00:43:38) 24 cores on r23 (32/64-bit) SQLite 3.46.0 2024-05-21 11:11:29 de8182cf1773ac0d04268d896a613841cf6bf61f9f030342170657d5e06f2acb
2024-05-21 13:12:41 drhok
4d. Clang-10.0.0: CFLAGS='-O0' ./configure --enable-debug --enable-all && scan-build make sqlite3