| 2025-05-28 18:07:39
| drh | ok
|
| 31. Compare performance to the previous release using kvtest. |
| 2025-05-28 18:07:36
| drh | ok
|
| 31c. Windows |
| 2025-05-28 18:04:51
| drh | ok
|
| 31b. Mac |
| 2025-05-28 18:01:43
| drh | ok
|
| 12d. nmake /f Makefile.msc verify-source releasetest |
| splitting work across 8 cores
built testset in 10001ms..
57:44 bld(19/19) fuzz(130/130) make(5/5) tcl(8665/8665) ETC 00:00
Test database is C:/Users/drh/sqlite/sqlite/testrunner.db
Test log is C:/Users/drh/sqlite/sqlite/testrunner.log
Extra fuzzcheck data taken from ../fuzz/20250516.db
0 errors out of 4489155 tests in 57:44 on w23 Windows NT 64-bit
SQLite 2025-05-19 14:50:36 ba8184d132a935aa1980fbfb61ff308b93d433d559db4968f901
0 errors out of 4489115 tests in 50:34 on w23 Windows NT 64-bit
SQLite 2025-05-28 16:56:23 f037ca064daeb81cb386da2a372d8e2d2dce55a3a13bc7bea496 |
| 2025-05-28 17:54:42
| drh | ok
|
| 6i. In sibling th3 checkout: make releasetest |
| 0 failures on 75 jobs, 262517691 tests in 01:15:00, 16 cores, r21 (32/64-bit)
SQLite 3.50.0 2025-05-19 14:50:36 ba8184d132a935aa1980fbfb61ff308b93d433d559db4968f9014f7653ac9c6e
0 failures on 75 jobs, 262518106 tests in 01:14:28, 16 cores, r21 (32/64-bit)
SQLite 3.50.0 2025-05-23 14:52:23 7e9845433ff26bdc5fe8654281d584394b77e3b206d09669b4468e0271c6eb3
0 failures on 75 jobs, 262516138 tests in 01:13:54, 16 cores, r21 (32/64-bit)
SQLite 3.50.0 2025-05-24 01:34:41 c266e38c5b61f47b920027aad418b641ab32cb8a3360dbcfd9f9f29b14fd5375
0 failures on 75 jobs, 262520189 tests in 01:13:47, 16 cores, r21 (32/64-bit)
SQLite 3.50.0 2025-05-24 20:20:20 28215d131cd970a2756338579fb6b6091ab155be8f419505cae8ac918956165c
0 failures on 75 jobs, 262519287 tests in 48:56, 16 cores, r23 (32/64-bit)
SQLite 3.50.0 2025-05-28 16:56:23 f037ca064daeb81cb386da2a372d8e2d2dce55a3a13bc7bea4968ca51bf2843a |
| 2025-05-28 17:44:49
| drh | ok
|
| 9a. ./configure && make verify-source releasetest. Optionally add --enable-test-status to configure |
| splitting work across 4 cores
built testset in 353ms..
35:03 bld(16/16) fuzz(59/59) make(4/4) tcl(11625/11625) ETC 00:00
Test database is /Users/drh/sqlite/sqlite/testrunner.db
Test log is /Users/drh/sqlite/sqlite/testrunner.log
0 errors out of 6322972 tests in 35:03 on minimac Darwin 64-bit
SQLite 2025-05-19 14:50:36 ba8184d132a935aa1980fbfb61ff308b93d433d559db4968f901
0 errors out of 6323306 tests in 42:38 on minimac Darwin 64-bit
SQLite 2025-05-28 16:56:23 f037ca064daeb81cb386da2a372d8e2d2dce55a3a13bc7bea496 |
| 2025-05-28 12:36:35
| drh | ok
|
| 3. Documentation review: |
| 2025-05-28 12:36:33
| drh | ok
|
| 3h. Check new/changed documentation for spelling and gramatical mistakes. |
| 2025-05-28 12:15:28
| drh | ok
|
| 3c. Release accouncement in "news.html". |
| 2025-05-28 12:09:26
| drh | ok
|
| 3g. Test metrics are up-to-date (testing.html). |
| 2025-05-28 12:09:23
| drh | ok
|
| 3f. Database footprint is up-to-date (features.html). |
| 2025-05-28 12:09:21
| drh | ok
|
| 3e. The compile-time options are all up-to-date (compile.html). |
| 2025-05-28 11:44:28
| drh | ok
|
| 3d. No unresolved hyperlinks in the documentation build. |
| 2025-05-28 11:44:23
| drh | ok
|
| 3b. Release announcement in "changes.in". |
| 2025-05-28 11:44:20
| drh | ok
|
| 3a. Latest release on the "index.html" page. |
| 2025-05-27 11:26:44
| drh | ok
|
| 1. Test procedure review. |
| 2025-05-27 11:20:23
| drh | ok
|
| 1d. Review dev-ops procedures and make any needed updates and corrections. |
| 2025-05-27 11:20:21
| drh | ok
|
| 1c. Review this checklist for completeness and accuracy. |
| 2025-05-27 11:16:11
| drh | ok
|
| 38. Build the "atrc" test program and run "./atrc $DB | ./sqlite3 $DB" against multiple databases, visually verify the result |
| 2025-05-27 11:12:54
| drh | ok
|
| 37. Build and verify sqlite3_rsync |
| 2025-05-27 11:12:52
| drh | ok
|
| 37c. Windows |
| 2025-05-27 10:49:10
| drh | ok
|
| 37b. Mac |
| 2025-05-27 10:49:08
| drh | ok
|
| 37a. Linux |
| 2025-05-26 23:20:31
| drh | ok
|
| 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. |
| 2025-05-26 23:08:47
| drh | ok
|
| 31a. Linux |
| 2025-05-26 22:54:32
| drh | ok
|
| 30. Run make wordcount and do tests on current and prior versions: |
| 2025-05-26 22:54:29
| drh | ok
|
| 30b. rm -f wc.db && ./wordcount wc.db $BIGTEXT --all --cachesize 5 --nosync |
| 2025-05-26 21:59:28
| drh | ok
|
| 30a. rm -f wc.db && ./wordcount wc.db $BIGTEXT --all |
| 2025-05-26 19:42:58
| dan | ok
|
| 35. Build and verify correct operation of sqlite3_analyzer on: |
| 2025-05-26 19:42:56
| dan | ok
|
| 36. Build and verify sqldiff |
| 2025-05-26 19:42:54
| dan | ok
|
| 36c. Windows |
| 2025-05-26 19:42:52
| dan | ok
|
| 35c. Windows |
| 2025-05-26 19:20:38
| dan | ok
|
| 36b. Mac |
| 2025-05-26 19:20:35
| dan | ok
|
| 35b. Mac |
| 2025-05-26 18:52:41
| dan | ok
|
| 36a. Linux |
| 2025-05-26 18:52:39
| dan | ok
|
| 35a. Linux |
| 2025-05-26 18:51:46
| dan | ok
|
| 41b. All build products work on their target platforms |
| 2025-05-26 18:51:43
| dan | ok
|
| 41a. Compile-time options for build products have been updated as necessary |
| 2025-05-26 18:51:39
| dan | ok
|
| 41. Website built procedures |
| 2025-05-26 18:49:59
| drh | ok
|
| 15. WASM |
| 2025-05-26 18:49:56
| drh | ok
|
| 15d. Click on the test links - confirm correct results. |
| 2025-05-26 18:49:54
| drh | ok
|
| 15c. Run "althttpd --enable-sab --popup --max-age 1" then visit the HOST:PORT/index.html in a web-browser. |
| 2025-05-26 18:49:51
| drh | ok
|
| 15b. (On Linux) ./configure --enable-all && cd ext/wasm && make |
| 2025-05-26 18:33:54
| drh | ok
|
| 15a. Build and install Fiddle according to website maintenance instructions at https://sqlite.org/devops/doc/trunk/build/website-build.md. Run simple tests. |
| 2025-05-26 18:32:31
| drh | ok
|
| 11. Tests for platform Windows (32-bit): |
| 2025-05-26 18:32:28
| drh | ok
|
| 11e. Verify that EXEs and DLLs generated using MSVC contain the correct version number, product name, description, and copyright as resources. |
| 2025-05-26 18:30:09
| drh | ok
|
17. Verify the "install" make target using DESTDIR:
- Create a new temporary directory. Call it $tempdir.
- fossil clean -x && ./configure && make install DESTDIR=$tempdir
- Verify correct installation using tree $tempdir
|
| 2025-05-26 18:28:08
| drh | ok
|
| 16. Building The TCL Extension. Detailed procedures document at
https://sqlite.org/src/doc/trunk/doc/tcl-extension-testing.md |
| 2025-05-26 18:28:06
| drh | ok
|
| 16a. Tested on Linux |
| 2025-05-26 18:23:07
| drh | ok
|
| 16b. Tested on Mac |
| 2025-05-26 18:19:59
| drh | ok
|
| 16c. Tested on Windows |
| 2025-05-26 18:16:58
| drh | ok
|
32. Verify database file format compatibility:
- Build the CLI ("sqlite3" or "sqlite3.exe")
- Have ready a check-out of the https://sqlite.org/test-dbs Fossil repository
containing the test databases in sibling directory "../dbs".
- Start the CLI.
- .cd ../dbs
- .read selftest.txt
Verify that all tests pass. |
| 2025-05-26 18:16:35
| drh | ok
|
| 32f. Windows 32-bit |
| 2025-05-26 18:12:31
| drh | ok
|
| 32g. Windows 64-bit |
| 2025-05-26 18:11:23
| dan | ok
|
| 39. Run the rbu/run_rbu_tests.tcl script in the test-dbs project on Linux. |
| All tests report "round trip test successful." |
| 2025-05-26 18:10:49
| drh | ok
|
| 32b. Linux x64 |
| 2025-05-26 18:10:36
| drh | ok
|
| 32e. Mac ARM |
| 2025-05-26 18:10:32
| drh | ok
|
| 32d. Mac x64 |
| 2025-05-26 18:10:13
| drh | ok
|
| 32c. Linux ARM |
| 2025-05-26 17:43:03
| drh | ok
|
| 29. Performance tests using speedtest1 --testcase mix1 speedtest.db
compared against prior releases.
See the header comment on test/speedtest1.c
for guidance on how to compile the latest speedtest1.c against historical amalgamations. |
| 2025-05-26 17:42:59
| drh | ok
|
| 29c. Windows |
| 2025-05-26 17:35:40
| drh | ok
|
| 29b. Mac |
| 2025-05-26 17:30:32
| drh | ok
|
| 29a. Linux |
| 2025-05-26 17:22:14
| drh | ok
|
| 28. Amalgamation autoconf tarball. |
| 2025-05-26 17:22:11
| drh | ok
|
| 28d. Works on Windows MSVC |
| 2025-05-26 17:10:47
| drh | ok
|
| 28c. Works on Mac OS X. |
| 2025-05-26 16:57:34
| dan | ok
|
| 34. 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.15.0, 3.41.0 and 3.8.1 using backcompat.test. |
| 2025-05-26 16:18:27
| dan | ok
|
| 13. Tests for platform OpenBSD (x86): |
| 2025-05-26 16:18:24
| dan | ok
|
| 13a. ./configure && make devtest |
| 0 errors out of 927562 tests in 22:50 on foo.my.domain OpenBSD 64-bit
SQLite 2025-05-26 07:15:20 de0dfac1e5ca9d2661674c20664095386f60c77378311507fcba |
| 2025-05-26 16:09:24
| dan | ok
|
| 18. 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 2025-05-22 18:04:48 3dbde727146d28c316df47c7b5116be7f2476a0a0c893207c2a4ca3ab285alt1
0 errors out of 330047 tests on ws1 Linux 64-bit
atomic2.test did run. |
| 2025-05-26 15:52:50
| drh | ok
|
| 28b. Works on Linux. |
| 2025-05-26 15:52:47
| drh | ok
|
| 28a. Builds (using "make amalgamation-tarball" and/or "make snapshot-tarball"). |
| 2025-05-26 15:33:52
| dan | ok
|
| 13b. In sibling TH3 directory: make devtest |
| 0 failures on 6 jobs, 3288124 tests in 16:50, foo.my.domain (64-bit) |
| 2025-05-26 15:28:44
| drh | ok
|
| 27. NDS-Devkit testing - see https://sqlite.org/devops/doc/trunk/build/release-actions-drh.md#sec9.0 for additional guidance. |
| 2025-05-26 15:28:42
| drh | ok
|
| 27c. Verify the "NDS DevKit" version number shown at the end of the test |
| 2025-05-26 15:28:39
| drh | ok
|
| 27b. Test using: tclsh th3make debug.rc nds_devkit.rc -v ← Note that the -v
option is needed in order to see the NDS DevKit version number in the output. |
| 2025-05-26 15:28:36
| drh | ok
|
| 27a. Merge all trunk enhancements into the reuse-schema branch and use that branch to update the devkit. |
| 2025-05-26 14:51:50
| dan | review
|
| 13a. ./configure && make devtest |
| Reports: FAILED: Build All-Debug (fuzzcheck-ubsan). Status of ubsan on OpenBSD is "does not work reliably", and so it is not installed by default. |
| 2025-05-26 14:37:23
| drh | ok
|
| 26. ZIPVFS tests. (See also https://sqlite.org/devops/doc/trunk/build/zipvfs.md) |
| 2025-05-26 14:37:19
| drh | ok
|
| 26c. Linux: tclsh multitest.tcl --scenario zipvfs --extra --valgrind --omit 'quick[23]' |
| 0 failures on 6 jobs, 1852793 tests in 39:17, 8 cores, r20 (64-bit) |
| 2025-05-26 14:17:03
| drh | ok
|
| 26e. Windows: tclsh multitest.tcl --scenario zipvfs |
| 0 failures on 7 jobs, 2905948 tests in 07:35, 8 cores, w23 (64-bit) |
| 2025-05-26 14:09:59
| drh | ok
|
| 26d. Mac: tclsh multitest.tcl --scenario zipvfs |
| 0 failures on 8 jobs, 3755069 tests in 02:56, 4 cores, minimac (64-bit) |
| 2025-05-26 13:56:39
| drh | ok
|
| 26b. testfixture test/testrunner.tcl --zipvfs <ZIPVFS-source-directory> zipvfs |
| 0 errors out of 70501 tests in 02:13 on r20 Linux 64-bit
SQLite 2025-05-26 07:15:20 de0dfac1e5ca9d2661674c20664095386f60c77378311507fcba |
| 2025-05-26 13:55:58
| drh | ok
|
| 26a. Verify that the configure script version number agrees with the SQLite version number |
| 2025-05-26 13:35:21
| drh | ok
|
| 25. SEE tests using TH3. From the TH3 source directory with the sibling ../see for the SEE sources. |
| 2025-05-26 13:35:18
| drh | ok
|
| 25c. Windows: nmake clean see-test |
| 0 failures on 12 jobs, 10101248 tests in 17:53, 8 cores, w23 (64-bit) |
| 2025-05-26 13:34:37
| drh | ok
|
| 24. CEROD tests in the "test/" subdirectory. |
| 2025-05-26 12:03:17
| drh | ok
|
| 25b. Mac: make clean see-test |
| 0 failures on 12 jobs, 10110923 tests in 06:13, 4 cores, minimac (64-bit) |
| 2025-05-26 12:02:24
| drh | ok
|
| 6i. In sibling th3 checkout: make releasetest |
| 0 failures on 75 jobs, 262517691 tests in 01:15:00, 16 cores, r21 (32/64-bit)
SQLite 3.50.0 2025-05-19 14:50:36 ba8184d132a935aa1980fbfb61ff308b93d433d559db4968f9014f7653ac9c6e
0 failures on 75 jobs, 262518106 tests in 01:14:28, 16 cores, r21 (32/64-bit)
SQLite 3.50.0 2025-05-23 14:52:23 7e9845433ff26bdc5fe8654281d584394b77e3b206d09669b4468e0271c6eb3
0 failures on 75 jobs, 262516138 tests in 01:13:54, 16 cores, r21 (32/64-bit)
SQLite 3.50.0 2025-05-24 01:34:41 c266e38c5b61f47b920027aad418b641ab32cb8a3360dbcfd9f9f29b14fd5375
0 failures on 75 jobs, 262520189 tests in 01:13:47, 16 cores, r21 (32/64-bit)
SQLite 3.50.0 2025-05-24 20:20:20 28215d131cd970a2756338579fb6b6091ab155be8f419505cae8ac918956165c |
| 2025-05-26 11:56:31
| drh | ok
|
| 25a. Linux: make clean see-test |
| 0 failures on 12 jobs, 10397939 tests in 06:48, 8 cores, r20 (64-bit) |
| 2025-05-26 11:14:07
| drh | ok
|
| 22. Fossil updated to use the latest SQLite. |
| 2025-05-26 11:14:04
| drh | ok
|
| 22g. Do the above on Mac |
| 2025-05-26 11:10:24
| drh | ok
|
| 22i. Do the above on Windows |
| 2025-05-26 11:10:22
| drh | ok
|
| 22h. Do the above on RaspberryPi |
| 2025-05-26 11:10:19
| drh | ok
|
| 22f. Do the above on Linux |
| 2025-05-26 11:10:17
| drh | ok
|
| 22e. fossil all repack |
| 2025-05-26 11:10:15
| drh | ok
|
| 22d. fossil all sync --all |
| 2025-05-26 11:10:13
| drh | ok
|
| 22c. fossil all test-integrity -d |
| 2025-05-26 11:10:11
| drh | ok
|
| 22b. Used on active websites with no issues. |
| 2025-05-26 11:10:05
| drh | ok
|
| 23. Wapp updated to use the latest SQLite |
| 2025-05-26 11:10:03
| drh | ok
|
| 23c. https://sqlite.org/src/ext/officeipaddr |
| 2025-05-26 11:10:01
| drh | ok
|
| 23b. https://sqlite.org/src/ext/logview |
| 2025-05-26 11:06:59
| drh | ok
|
| 23a. Used for this checklist - verify on the CGI-environment page |
| 2025-05-26 10:57:02
| drh | ok
|
| 22a. No SQLite compiler warnings. |
| 2025-05-24 18:23:08
| drh | ok
|
| 6. Tests for platform Linux x86_64: |
| 2025-05-24 18:23:04
| drh | ok
|
| 6j. In sibling th3 checkout: tclsh multitest.tcl --scenario coverage |
| 0 failures on 4 jobs, 7741949 tests in 17:58, 16 cores, r21 (64-bit) |
| 2025-05-24 16:39:44
| drh | ok
|
| 6k. In sibling th3 checkout: tclsh multitest.tcl --scenario failures - all failures detected |
| 2025-05-24 16:38:19
| drh | ok
|
| 6i. In sibling th3 checkout: make releasetest |
| 0 failures on 75 jobs, 262517691 tests in 01:15:00, 16 cores, r21 (32/64-bit)
SQLite 3.50.0 2025-05-19 14:50:36 ba8184d132a935aa1980fbfb61ff308b93d433d559db4968f9014f7653ac9c6e
0 failures on 75 jobs, 262518106 tests in 01:14:28, 16 cores, r21 (32/64-bit)
SQLite 3.50.0 2025-05-23 14:52:23 7e9845433ff26bdc5fe8654281d584394b77e3b206d09669b4468e0271c6eb3
0 failures on 75 jobs, 262516138 tests in 01:13:54, 16 cores, r21 (32/64-bit)
SQLite 3.50.0 2025-05-24 01:34:41 c266e38c5b61f47b920027aad418b641ab32cb8a3360dbcfd9f9f29b14fd5375 |
| 2025-05-24 15:28:14
| drh | ok
|
| 11d. nmake /f Makefile.msc verify-source releasetest |
| splitting work across 8 cores
built testset in 884ms..
51:31 bld(19/19) fuzz(40/40) make(5/5) tcl(8665/8665) ETC 00:00
Test database is C:/Users/drh/sqlite/sqlite/testrunner.db
Test log is C:/Users/drh/sqlite/sqlite/testrunner.log
0 errors out of 4486534 tests in 51:31 on w23 Windows NT 32-bit
SQLite 2025-05-24 01:34:41 c266e38c5b61f47b920027aad418b641ab32cb8a3360dbcfd9f9 |
| 2025-05-24 11:03:51
| drh | ok
|
| 20. Dbsqlfuzz tests |
| 2025-05-24 11:03:40
| drh | ok
|
| 20f. Windows: tclsh test/testrunner.tcl release fuzzcheck --fuzzdb $CORPUS |
| splitting work across 8 cores
built testset in 143ms..
10:46 bld(5/5) fuzz(130/130) ETC 00:00
0 errors out of 232050 tests in 10:46 |
| 2025-05-24 11:00:05
| drh | ok
|
| 20d. Linux: test/testrunner.tcl release fuzzcheck --fuzzdb $CORPUS |
| Pi5: splitting work across 2 cores
built testset in 203ms..
03:36:32 bld(22/22) fuzz(798/798) ETC 00:00
0 errors out of 974863 tests in 03:36:32
r21: splitting work across 16 cores
built testset in 220ms..
12:09 bld(22/22) fuzz(798/798) ETC 00:00
Extra fuzzcheck data taken from ../fuzz/20250516.db
0 errors out of 974863 tests in 12:09 |
| 2025-05-24 10:49:22
| drh | ok
|
| 20d. Linux: test/testrunner.tcl release fuzzcheck --fuzzdb $CORPUS |
| Pi5: splitting work across 2 cores
built testset in 203ms..
03:36:32 bld(22/22) fuzz(798/798) ETC 00:00
0 errors out of 974863 tests in 03:36:32 |
| 2025-05-24 10:43:09
| drh | ok
|
| 20d. Linux: test/testrunner.tcl release fuzzcheck --fuzzdb $CORPUS |
| Pi5: 0 errors out of 974863 tests in 03:36:32 |
| 2025-05-24 10:41:04
| drh | ok
|
| 20c. Check-in CORPUS as an unversioned file in the dbsqlfuzz repository |
| 2025-05-24 10:40:59
| drh | ok
|
| 20b. Develop a new CORPUS database by running dbsqlfuzz for 10 billion iterations |
| 2025-05-24 10:40:55
| drh | ok
|
| 20a. Verify that the mutator has been updated to include any new SQL function names,
PRAGMA names, SQL keywords, and/or other new syntax added since the previous release |
| 2025-05-24 10:37:49
| drh | ok
|
| 6a. ./configure && make verify-source releasetest |
| splitting work across 16 cores
built testset in 925ms..
fossil 00:26 bld(1/71) r16 fuzz(0/813) make(0/19) tcl(2/39213) ETC 06:49:46 40:36 bld(71/71) fuzz(813/813) make(19/19) tcl(39213/39213) ETC 00:00
Test database is /home/drh/sqlite/sqlite/testrunner.db
Test log is /home/drh/sqlite/sqlite/testrunner.log
Extra fuzzcheck data taken from ../fuzz/20250516.db
0 errors out of 15203232 tests in 40:36 on r21 Linux 64-bit
SQLite 2025-05-24 01:34:41 c266e38c5b61f47b920027aad418b641ab32cb8a3360dbcfd9f9 |
| 2025-05-23 20:18:34
| drh | ok
|
| 6i. In sibling th3 checkout: make releasetest |
| 0 failures on 75 jobs, 262517691 tests in 01:15:00, 16 cores, r21 (32/64-bit)
SQLite 3.50.0 2025-05-19 14:50:36 ba8184d132a935aa1980fbfb61ff308b93d433d559db4968f9014f7653ac9c6e
0 failures on 75 jobs, 262518106 tests in 01:14:28, 16 cores, r21 (32/64-bit)
SQLite 3.50.0 2025-05-23 14:52:23 7e9845433ff26bdc5fe8654281d584394b77e3b206d09669b4468e0271c6eb37 |
| 2025-05-23 17:12:00
| drh | ok
|
| 20e. Mac: test/testrunner.tcl release fuzzcheck --fuzzdb $CORPUS |
| Extra fuzzcheck data taken from ../fuzz/20250516.db
0 errors out of 324954 tests in 10:50 |
| 2025-05-22 17:45:21
| drh | ok
|
| 6i. In sibling th3 checkout: make releasetest |
| 0 failures on 75 jobs, 262517691 tests in 01:15:00, 16 cores, r21 (32/64-bit)
SQLite 3.50.0 2025-05-19 14:50:36 ba8184d132a935aa1980fbfb61ff308b93d433d559db4968f9014f7653ac9c6e |
| 2025-05-22 15:00:41
| drh | ok
|
| 8. Tests for platform MacOS x64: |
| 2025-05-22 15:00:39
| drh | ok
|
| 8c. In sibling TH3 checkout: tclsh multitest.tcl --scenario failures - all failures detected |
| 2025-05-22 15:00:07
| drh | ok
|
| 8b. In sibling TH3 checkout: make devtest |
| 0 failures on 6 jobs, 3251375 tests in 09:13, 2 cores, SQLite-iMac-2018 (64-bit) |
| 2025-05-22 14:46:17
| drh | ok
|
| 8a. ./configure && make verify-source releasetest |
| splitting work across 2 cores
built testset in 750ms..
01:49:21 bld(16/16) fuzz(59/59) make(4/4) tcl(11625/11625) ETC 00:00
Test database is /Users/drh/sqlite/sqlite/testrunner.db
Test log is /Users/drh/sqlite/sqlite/testrunner.log
0 errors out of 6322831 tests in 01:49:21 on SQLite-iMac-2018 Darwin 64-bit
SQLite 2025-05-19 14:50:36 ba8184d132a935aa1980fbfb61ff308b93d433d559db4968f901 |
| 2025-05-22 14:31:08
| drh | ok
|
| 6h. From a read-only source tree: $SRC/configure && make devtest |
| 0 errors out of 975168 tests in 02:56 on r21 Linux 64-bit
SQLite 2025-05-19 14:50:36 ba8184d132a935aa1980fbfb61ff308b93d433d559db4968f901 |
| 2025-05-22 14:15:46
| drh | ok
|
| 6g. 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 -lm && ./a.out '' .recover |
| 2025-05-22 14:13:03
| drh | ok
|
| 6f. Run auxiliary test script in the /usr subdirectory of the TH3 repository |
| 2025-05-22 14:10:34
| drh | ok
|
| 6e. CC=clang CFLAGS='-fsanitize=thread' ./configure && make threadtest5 && ./threadtest5 |
| 2025-05-22 13:58:06
| drh | ok
|
| 6d. Test the reuse-schema branch with ./configure --enable-all && make "OPTS=-DSQLITE_ENABLE_SHARED_SCHEMA" sdevtest |
| 0 errors out of 975561 tests in 03:18 on r21 Linux 64-bit
SQLite 2025-05-19 17:06:55 fc5edd557e4398c87f920d85492eb8a22c27976b1a0a97039bb1 |
| 2025-05-22 13:53:44
| drh | ok
|
| 6c. ./configure --enable-debug --enable-all && make parse.c && CC=clang CFLAGS='-fsanitize=address,undefined' make -e test |
| SQLite 2025-05-19 14:50:36 ba8184d132a935aa1980fbfb61ff308b93d433d559db4968f9014f7653ac9c6e
0 errors out of 393925 tests on r21 Linux 64-bit
All memory allocations freed - no leaks |
| 2025-05-22 13:32:32
| drh | ok
|
| 19. Trunk changes merged and verified on active branches.
See https://sqlite.org/devops/doc/trunk/build/release-actions-drh.md
for detailed instructions. |
| 2025-05-22 13:32:30
| drh | ok
|
| 19g. reuse-schema-see (in the see-base repository) |
| 2025-05-22 13:32:28
| drh | ok
|
| 19f. client-see (in the see-base repository) |
| 2025-05-22 13:32:21
| drh | ok
|
| 19e. see (in the see-base repository) |
| 2025-05-22 13:32:19
| drh | ok
|
| 19d. reuse-schema (from trunk) |
| 2025-05-22 13:32:17
| drh | ok
|
| 19c. bedrock (from wal2) |
| 2025-05-22 13:32:14
| drh | ok
|
| 19b. wal2 (from trunk) |
| 2025-05-22 13:32:12
| drh | ok
|
| 19a. begin-concurrent (from trunk) |
| 2025-05-22 13:28:34
| drh | ok
|
| 11c. In sibling TH3 checkout: tclsh multitest.tcl --msvc --scenario failures - verify failures detected |
| 2025-05-22 13:27:46
| drh | ok
|
| 11b. In sibling TH3 checkout: nmake devtest |
| Source tree tested: ../sqlite
0 failures on 6 jobs, 3224887 tests in 08:02, 8 cores, w23 (32-bit) |
| 2025-05-22 13:18:49
| drh | ok
|
| 14. Run "./sqlite3 <test/vt100-a.sql" and verify correct column alignment: |
| 2025-05-22 13:18:46
| drh | ok
|
| 14a. Linux |
| 2025-05-22 13:17:42
| drh | ok
|
| 5. OMIT, ENABLE, and DISABLE options: |
| 2025-05-22 13:17:40
| drh | ok
|
| 5b. tclsh tool/omittest.tcl ← on Linux |
| 2025-05-22 13:07:26
| drh | ok
|
| 7. Tests for platform Linux ARM (RaspberryPI) |
| 2025-05-22 13:07:23
| drh | ok
|
| 7b. In sibling TH3 checkout: make devtest |
| 0 failures on 6 jobs, 3303164 tests in 10:54, 2 cores, pi5 (64-bit) |
| 2025-05-22 13:06:16
| drh | ok
|
| 6b. sh tool/symbols.sh - no incorrect exports or dependencies |
| 2025-05-22 13:05:48
| drh | ok
|
| 6a. ./configure && make verify-source releasetest |
| splitting work across 16 cores
built testset in 871ms..
31:26 bld(71/71) fuzz(183/183) make(19/19) tcl(39213/39213) ETC 00:00
Test database is /home/drh/sqlite/sqlite/testrunner.db
Test log is /home/drh/sqlite/sqlite/testrunner.log
0 errors out of 15204973 tests in 31:26 on r21 Linux 64-bit
SQLite 2025-05-19 14:50:36 ba8184d132a935aa1980fbfb61ff308b93d433d559db4968f901 |
| 2025-05-22 13:04:52
| drh | ok
|
| 10. Tests for platform MacOS (PPC): |
| 2025-05-22 13:04:49
| drh | ok
|
| 10c. Recompile and test Fossil. |
| 2025-05-22 12:57:59
| drh | ok
|
| 14b. Mac |
| 2025-05-22 12:54:46
| drh | ok
|
| 7a. ./configure && make verify-source devtest |
| splitting work across 2 cores
built testset in 275ms..
22:42 bld(10/10) fuzz(34/34) tcl(2416/2416) ETC 00:00
Test database is /home/drh/sqlite/sqlite/testrunner.db
Test log is /home/drh/sqlite/sqlite/testrunner.log
0 errors out of 975162 tests in 22:42 on pi5 Linux 64-bit
SQLite 2025-05-19 14:50:36 ba8184d132a935aa1980fbfb61ff308b93d433d559db4968f901 |
| 2025-05-22 12:54:02
| drh | ok
|
| 9. Tests for platform MacOS ARM: |
| 2025-05-22 12:53:59
| drh | ok
|
| 9b. In sibling TH3 checkout: make releasetest |
| 0 failures on 70 jobs, 248678774 tests in 04:07:27, 4 cores, minimac (64-bit)
SQLite 3.50.0 2025-05-19 14:50:36 ba8184d132a935aa1980fbfb61ff308b93d433d559db4968f9014f7653ac9c6e |
| 2025-05-22 12:51:05
| drh | ok
|
| 10b. Build sqlite3_rsync. Use it to sync a Fossil repo from a little-endian machine then verify that the synced repo is correct. This demonstrates that databases are x-platform between big- and little-ending systems. |
| 2025-05-22 12:48:43
| drh | ok
|
| 32a. iBook PPC |
| 2025-05-22 12:48:29
| drh | ok
|
| 10a. .selftest checks (see below) |
| 2025-05-22 12:47:35
| drh | ok
|
11a. Review the "32-bit Builds" section of doc/compile-for-windows.md for accuracy and completeness. Ensure that your build environment is set up correctly. You probably want:- set TCLDIR=c:\tcl32
- set PATH=c:\tcl32\bin;%PATH%
|
| 2025-05-22 12:46:33
| drh | ok
|
| 14c. Windows |
| 2025-05-22 12:45:57
| drh | ok
|
| 12. Tests for platform Windows (64-bit): |
| 2025-05-22 12:45:54
| drh | ok
|
| 12c. In sibling TH3 checkout: tclsh multitest.tcl --msvc --scenario failures - verify failures detected |
| 2025-05-22 12:45:07
| drh | ok
|
| 12e. Verify that EXEs and DLLs generated using MSVC contain the correct version number, product name, description, and copyright as resources. |
| 2025-05-22 12:43:47
| drh | ok
|
| 12f. After updating Fossil to use the latest SQLite, verify that it compiles without warnings and that it works |
| 2025-05-22 12:43:15
| drh | ok
|
| 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. |
| 2025-05-22 12:42:58
| drh | ok
|
| 5c. tclsh tool/omittest-msvc.tcl ← on Windows |
| 2025-05-22 12:26:26
| drh | ok
|
| 5a. Recent compile-time options have been added to the omittest.tcl and omittest-msvc.tcl scripts and checked in. |
| 2025-05-20 14:46:45
| drh | ok
|
| 12b. In sibling TH3 checkout: nmake releasetest |
| 0 failures on 69 jobs, 207683964 tests in 04:39:48, 8 cores, w23 (64-bit)
SQLite 3.50.0 2025-05-19 14:50:36 ba8184d132a935aa1980fbfb61ff308b93d433d559db4968f9014f7653ac9c6e |
| 2025-05-20 09:45:44
| drh | ok
|
| 12d. nmake /f Makefile.msc verify-source releasetest |
| splitting work across 8 cores
built testset in 10001ms..
57:44 bld(19/19) fuzz(130/130) make(5/5) tcl(8665/8665) ETC 00:00
Test database is C:/Users/drh/sqlite/sqlite/testrunner.db
Test log is C:/Users/drh/sqlite/sqlite/testrunner.log
Extra fuzzcheck data taken from ../fuzz/20250516.db
0 errors out of 4489155 tests in 57:44 on w23 Windows NT 64-bit
SQLite 2025-05-19 14:50:36 ba8184d132a935aa1980fbfb61ff308b93d433d559db4968f901 |
| 2025-05-19 23:58:14
| drh | ok
|
| 21. Sqllogictest: |
| 2025-05-19 23:58:10
| drh | ok
|
| 21a. Checked in latest SQLite amalgamation. |
| 2025-05-19 23:58:07
| drh | ok
|
| 21b. No SQLite compiler warnings. |
| 2025-05-19 23:58:04
| drh | ok
|
| 21c. tclsh run-all.tcl |
| 0 errors out of 11879758 tests and 1244 invocations in 651 seconds |
| 2025-05-19 18:40:34
| drh | ok
|
| 33. Verify that the amalgamation builds are byte-for-byte identical on all workstation platforms. |
| 2025-05-19 18:40:31
| drh | ok
|
| 33c. Mac (x64) |
| ddbf4ad41e12a9f4dd46c345de0e39af4d7ff4a50351fad88b47f92b75337f6e sqlite3.c
a5108ba40342ec1461fa4edccbae4457d1c534a92a38d72cb5c00ec208e4f9b3 sqlite3.h |
| 2025-05-19 18:39:35
| drh | ok
|
| 33e. Mac (ARM) |
| ddbf4ad41e12a9f4dd46c345de0e39af4d7ff4a50351fad88b47f92b75337f6e sqlite3.c
a5108ba40342ec1461fa4edccbae4457d1c534a92a38d72cb5c00ec208e4f9b3 sqlite3.h |
| 2025-05-19 18:39:22
| drh | ok
|
| 33d. Mac (PPC) |
| ddbf4ad41e12a9f4dd46c345de0e39af4d7ff4a50351fad88b47f92b75337f6e sqlite3.c
a5108ba40342ec1461fa4edccbae4457d1c534a92a38d72cb5c00ec208e4f9b3 sqlite3.h |
| 2025-05-19 16:15:47
| drh | ok
|
| 33b. Linux (ARM) |
| ddbf4ad41e12a9f4dd46c345de0e39af4d7ff4a50351fad88b47f92b75337f6e sqlite3.c
a5108ba40342ec1461fa4edccbae4457d1c534a92a38d72cb5c00ec208e4f9b3 sqlite3.h |
| 2025-05-19 16:13:10
| drh | ok
|
| 33a. Linux (x64) |
| ddbf4ad41e12a9f4dd46c345de0e39af4d7ff4a50351fad88b47f92b75337f6e sqlite3.c
a5108ba40342ec1461fa4edccbae4457d1c534a92a38d72cb5c00ec208e4f9b3 sqlite3.h |
| 2025-05-19 16:11:59
| drh | ok
|
| 33f. Windows using NMAKE. |
| ddbf4ad41e12a9f4dd46c345de0e39af4d7ff4a50351fad88b47f92b75337f6e sqlite3.c
a5108ba40342ec1461fa4edccbae4457d1c534a92a38d72cb5c00ec208e4f9b3 sqlite3.h |
| 2025-05-19 16:04:18
| drh | ok
|
| 9a. ./configure && make verify-source releasetest. Optionally add --enable-test-status to configure |
| splitting work across 4 cores
built testset in 353ms..
35:03 bld(16/16) fuzz(59/59) make(4/4) tcl(11625/11625) ETC 00:00
Test database is /Users/drh/sqlite/sqlite/testrunner.db
Test log is /Users/drh/sqlite/sqlite/testrunner.log
0 errors out of 6322972 tests in 35:03 on minimac Darwin 64-bit
SQLite 2025-05-19 14:50:36 ba8184d132a935aa1980fbfb61ff308b93d433d559db4968f901 |
| 2025-05-19 16:03:57
| drh | ---
|
| 8a. ./configure && make verify-source releasetest |
| 2025-05-19 16:02:27
| drh | ok
|
| 8a. ./configure && make verify-source releasetest |
| splitting work across 4 cores
built testset in 353ms..
35:03 bld(16/16) fuzz(59/59) make(4/4) tcl(11625/11625) ETC 00:00
Test database is /Users/drh/sqlite/sqlite/testrunner.db
Test log is /Users/drh/sqlite/sqlite/testrunner.log
0 errors out of 6322972 tests in 35:03 on minimac Darwin 64-bit
SQLite 2025-05-19 14:50:36 ba8184d132a935aa1980fbfb61ff308b93d433d559db4968f901 |
| 2025-05-19 15:13:04
| drh | ok
|
| 4. Compiler warning checks. |
| 2025-05-19 15:13:02
| drh | ok
|
| 4c. CFLAGS='-O0' ./configure --enable-debug --enable-all && scan-build make sqlite3 |
| 2025-05-19 14:37:16
| drh | ok
|
| 2. Source code change review. fossil diff --from release --to trunk |
| 2025-05-19 14:37:13
| drh | ok
|
| 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]*(/. Even if the argument to sqlite3_malloc64() is
a 64-bit integer, double check to ensure that integer is not initialized using any 32-bit multiplications. |
| 2025-05-19 14:37:11
| drh | ok
|
| 2h. Check all calls to sqlite3OsRead() and sqlite3OsWrite() to ensure that offset computations are 64-bit clean. |
| 2025-05-19 14:09:57
| drh | ok
|
| 2f. Verify that the azProhibitedFunctions list in the safeModeAuth() function of the CLI is complete and up-to-date. |
| 2025-05-19 14:04:55
| drh | ok
|
| 2k. Verify that the list of APIs exposed via the extension header is up-to-date (sqlite3ext.h). |
| 2025-05-19 13:43:46
| drh | ok
|
| 2l. Significant compile-time options are recognized by the sqlite3_compileoption_used() interface. |
| 2025-05-19 13:43:43
| drh | ok
|
| 2m. Compare sqlite3.c and sqlite3.h against the previous release. |
| 2025-05-19 12:46:13
| drh | ok
|
| 2j. Verify that source code contains no tabs characters. |
| 2025-05-19 12:30:27
| drh | ok
|
| 2g. Variables and functions have been renamed to reflect changes in their use. |
| 2025-05-19 12:30:23
| drh | ok
|
| 2e. Comments have been updated to reflect code changes. |
| 2025-05-19 12:30:19
| drh | ok
|
| 2d. New code complies with design rules. |
| 2025-05-19 12:30:17
| drh | ok
|
| 2c. New code complies with style guidelines. |
| 2025-05-19 12:30:15
| drh | ok
|
| 2b. All significant changes are mentioned in the "changes" log of the documentation. |
| 2025-05-19 12:30:12
| drh | ok
|
| 2a. No stray changes. |
| 2025-05-19 11:11:48
| drh | ok
|
| 4b. Mac OS X GCC -Wall -Wextra (the "tool/warnings.sh" script) |
| 2025-05-19 11:11:44
| drh | ok
|
| 4a. Linux GCC -Wall -Wextra (the "tool/warnings.sh" script) |
| 2025-05-19 10:19:13
| drh | ok
|
| 1b. Review "multitest.tcl" and "alignment*.rc" scripts in TH3 for completeness. |
| 2025-05-19 10:15:30
| drh | ok
|
| 1a. Review "test/testrunner.tcl" and "test/testrunner_data.tcl" for completeness and accuracy. |