| 2025-01-13 20:12:40
| drh | ok
|
| 6a. In sibling th3 checkout: make releasetest |
| 0 failures on 75 jobs, 261697985 tests in 01:09:56, 16 cores, r21 (32/64-bit)
SQLite 3.48.0 2025-01-05 19:58:30
bcdaef434142973a0805117495e561b2dcd1ec1465cacc9b944a3707291afc0d
0 failures on 75 jobs, 261707687 tests in 01:10:30, 16 cores, r21 (32/64-bit)
SQLite 3.48.0 2025-01-13 11:28:34 ed83b79100b4345235aec990303c4526874f0c2f870116
0 failures on 75 jobs, 261700623 tests in 49:29, 16 cores, r23 (32/64-bit)
SQLite 3.48.0 2025-01-13 13:32:56 315079b150b47e013e2cde4985bc39d24e0f6f6c6e60f9383fb8ea4ea897c67a |
| 2025-01-13 17:35:13
| dan | ok
|
| 13. Tests for platform OpenBSD (x86): |
| 2025-01-13 17:35:12
| dan | ok
|
| 13b. In sibling TH3 directory: make devtest |
| 0 failures on 6 jobs, 3266236 tests in 19:04, foo.. (64-bit) |
| 2025-01-13 14:50:13
| dan | ok
|
| 42b. All build products work on their target platforms |
| 2025-01-13 14:50:11
| dan | ok
|
| 42a. Compile-time options for build products have been updated as necessary |
| 2025-01-13 14:50:07
| dan | ok
|
| 42. Website built procedures |
| 2025-01-13 13:57:42
| dan | ok
|
| 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.8.1, 3.15.0 and 3.41.0 using backcompat.test.
SQLite 2025-01-13 13:32:56 315079b150b47e013e2cde4985bc39d24e0f6f6c6e60f9383fb8ea4ea897c67a
0 errors out of 403 tests on ws1 Linux 64-bit |
| 2025-01-13 13:42:53
| drh | ok
|
| 3. Documentation review: |
| 2025-01-13 13:42:50
| drh | ok
|
| 3h. Check new/changed documentation for spelling and gramatical mistakes. |
| 2025-01-13 13:42:28
| dan | ok
|
| 13a. ./configure && make devtest |
| 0 errors out of 880354 tests in 26:47 on foo.. OpenBSD 64-bit
SQLite 2025-01-13 11:28:34 ed83b79100b4345235aec990303c4526874f0c2f8701160c4639 |
| 2025-01-13 13:39:52
| drh | ok
|
| 3g. Test metrics are up-to-date (testing.html). |
| 2025-01-13 13:39:49
| drh | ok
|
| 3f. Database footprint is up-to-date (features.html). |
| 2025-01-13 13:39:46
| drh | ok
|
| 3e. The compile-time options are all up-to-date (compile.html). |
| 2025-01-13 13:39:43
| drh | ok
|
| 3d. No unresolved hyperlinks in the documentation build. |
| 2025-01-13 13:39:38
| drh | ok
|
| 3c. Release accouncement in "news.html". |
| 2025-01-13 13:39:15
| drh | ok
|
| 3b. Release announcement in "changes.in". |
| 2025-01-13 13:39:13
| drh | ok
|
| 3a. Latest release on the "index.html" page. |
| 2025-01-13 13:38:59
| drh | ok
|
| 2. Source code change review. fossil diff --from release --to trunk |
| 2025-01-13 13:38:57
| drh | ok
|
| 2m. Compare sqlite3.c and sqlite3.h against the previous release. |
| 2025-01-13 13:33:11
| drh | ok
|
| 2l. Significant compile-time options are recognized by the sqlite3_compileoption_used() interface. |
| 2025-01-13 13:33:09
| drh | ok
|
| 2k. Verify that the list of APIs exposed via the extension header is up-to-date (sqlite3ext.h). |
| 2025-01-13 13:33:04
| drh | ok
|
| 2j. Verify that source code contains no tabs and that surplus whitespace has been removed. |
| 2025-01-13 13:25:40
| 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]*(/ |
| 2025-01-13 13:25:38
| drh | ok
|
| 2h. Check all calls to sqlite3OsRead() and sqlite3OsWrite() to ensure that offset computations are 64-bit clean. |
| 2025-01-13 13:25:32
| drh | ok
|
| 2g. Variables and functions have been renamed to reflect changes in their use. |
| 2025-01-13 13:25:29
| drh | ok
|
| 2f. Verify that the azProhibitedFunctions list in the safeModeAuth() function of the CLI is complete and up-to-date. |
| 2025-01-13 13:25:17
| drh | ok
|
| 2e. Comments have been updated to reflect code changes. |
| 2025-01-13 13:25:14
| drh | ok
|
| 2d. New code complies with design rules. |
| 2025-01-13 13:25:12
| drh | ok
|
| 2c. New code complies with style guidelines. |
| 2025-01-13 13:25:09
| drh | ok
|
| 2b. All significant changes are mentioned in the "changes" log of the documentation. |
| 2025-01-13 13:25:07
| drh | ok
|
| 2a. No stray changes. |
| 2025-01-13 12:44:08
| drh | ok
|
| 6a. In sibling th3 checkout: make releasetest |
| 0 failures on 75 jobs, 261697985 tests in 01:09:56, 16 cores, r21 (32/64-bit)
SQLite 3.48.0 2025-01-05 19:58:30
bcdaef434142973a0805117495e561b2dcd1ec1465cacc9b944a3707291afc0d
0 failures on 75 jobs, 261707687 tests in 01:10:30, 16 cores, r21 (32/64-bit)
SQLite 3.48.0 2025-01-13 11:28:34 ed83b79100b4345235aec990303c4526874f0c2f870116 |
| 2025-01-13 12:42:29
| drh | ok
|
| 6d. ./configure && make verify-source releasetest |
| 0 errors out of 14914346 tests in 01:12:57 on r20 Linux 64-bit
SQLite 2025-01-13 11:28:34 ed83b79100b4345235aec990303c4526874f0c2f8701160c4639 |
| 2025-01-13 11:30:47
| drh | pending
|
| 6d. ./configure && make verify-source releasetest |
| Retesting after changes. |
| 2025-01-13 11:07:58
| dan | ok
|
| 17. 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-01-11 16:28:41 3e2875dac27de1525d9c78f38ac5f1fc12fec7e1b43dbdf47798b128fae49084
0 errors out of 329765 tests on ws1 Linux 64-bit |
| 2025-01-13 10:16:43
| drh | fail
|
| 6d. ./configure && make verify-source releasetest |
| Lots of undefined-behavior reported by the Sanitize configuration
when run using GCC 13.3.0 on the new Ubuntu 24.04.1 install. None
of it appears to be important. None of it is in the core. But it
still needs to be fixed. |
| 2025-01-13 10:15:41
| drh | ok
|
| 6a. In sibling th3 checkout: make releasetest |
| 0 failures on 75 jobs, 261697985 tests in 01:09:56, 16 cores, r21 (32/64-bit)
SQLite 3.48.0 2025-01-05 19:58:30 bcdaef434142973a0805117495e561b2dcd1ec1465cacc9b944a3707291afc0dL |
| 2025-01-13 10:14:43
| drh | fail
|
| 6a. In sibling th3 checkout: make releasetest |
| Lots of undefined-behavior reported by the Sanitize configuration
when run using GCC 13.3.0 on the new Ubuntu 24.04.1 install. None
of it appears to be important. None of it is in the core. But it
still needs to be fixed. |
| 2025-01-11 21:39:02
| drh | ok
|
| 19c. Linux: FUZZDB=$CORPUS make run-fuzzcheck |
| SQLite 3.48.0 2025-01-11 16:28:41 3e2875dac27de1525d9c78f38ac5f1fc12fec7e1b43dbd
On r20 with 20250103.db |
| 2025-01-11 18:01:48
| drh | ok
|
| 6f. ./configure --enable-debug --enable-all && make parse.c && CC=clang CFLAGS='-fsanitize=address,undefined' make -e test |
| ! tableapi-2.3.3 expected: [1 {near "invalid": syntax error}]
! tableapi-2.3.3 got: [invalid command name "SQLITE_ERROR" 1 {near "invalid": syntax error}]
After fixing the sqlite3_get_table_printf test command in testfixture results in:
SQLite 2025-01-06 18:32:53 a0df29c7a3eb4f558aba00598d827643830591def3101a4d5464543527b8d13c
0 errors out of 393531 tests on r20 Linux 64-bit
----
SQLite 2025-01-11 16:28:41 3e2875dac27de1525d9c78f38ac5f1fc12fec7e1b43dbdf47798b128fae49084
0 errors out of 393531 tests on r20 Linux 64-bit |
| 2025-01-08 16:25:12
| drh | ok
|
| 4d. Clang-10.0.0: CFLAGS='-O0' ./configure --enable-debug --enable-all && scan-build make sqlite3 |
| Repeated for check-in c0b691095ae72fc07530777ef6d23688fb4196ce |
| 2025-01-08 16:21:03
| drh | ok
|
| 26. NDS-Devkit testing |
| 2025-01-08 16:20:59
| drh | ok
|
| 26c. Verify the "NDS DevKit" version number shown at the end of the test |
| 2025-01-08 16:20:55
| drh | ok
|
| 26b. 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. |
| th3: 0 errors in 2677078 tests. 402.814 seconds on bella 64-bit little-endian
th3: 0 errors in 2677078 tests. 436.285 seconds on bella 64-bit little-endian
th3: NDS DevKit 3.48.0 2025-01-08 14:42:16 b3e6a45c3f950010
th3: SQLite 3.48.0 2025-01-03 19:18:07 0609633ce242472d781d7f1c70f9a64df6795ca6e5b97042db8d938285cdf69b |
| 2025-01-08 15:57:23
| drh | ok
|
| 26b. 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. |
| th3: 0 errors in 2677078 tests. 402.814 seconds on bella 64-bit little-endian |
| 2025-01-08 15:57:03
| drh | ok
|
| 26a. Merge all trunk enhancements into the reuse-schema branch and use that branch to update the devkit. |
| 2025-01-08 14:39:00
| drh | ok
|
| 23. CEROD tests in the "test/" subdirectory. |
| 2025-01-08 14:10:43
| drh | ok
|
| 33. Verify that the performance and size measurement spreadsheet in the documentation (misc/speed-size-graph.ods) is up-to-date. |
| 2025-01-07 22:37:49
| drh | ok
|
| 24. SEE tests using TH3. From the TH3 source directory with the sibling ../see for the SEE sources. |
| 2025-01-07 22:37:47
| drh | ok
|
| 24c. Windows: nmake clean see-test |
| 2025-01-07 22:37:44
| drh | ok
|
| 24b. Mac: make clean see-test |
| 2025-01-07 21:34:41
| drh | ok
|
| 24a. Linux: make clean see-test |
| 2025-01-07 13:14:45
| drh | ok
|
| 40. Run the rbu/run_rbu_tests.tcl script in the test-dbs project on Linux. |
| This is what I did, starting in an SQLite checkout:
(1) fossil clean -f
(2) ./configure --with-tclsh=$HOME/tcl/tcl9/bin/tclsh9.0 --enable-all
(3) make clean sqlite3 sqldiff rbu tclextension-install OPTIONS=-DSQLITE_ENABLE_RBU
(4) $HOME/tcl/tcl9/bin/tclsh9.0 ../dbs/rbu/run_rbu_tests.tcl |
| 2025-01-07 12:51:20
| drh | ok
|
| 39. Build the "atrc" test program and run "./atrc $DB | ./sqlite3 $DB" against multiple databases, visually verify the result |
| 2025-01-07 12:45:42
| drh | ok
|
| 31. Check JSON performance |
| 2025-01-07 12:45:40
| drh | ok
|
| 31b. Verify JSON performance against the previous release |
| 2025-01-07 12:45:37
| drh | ok
|
| 31a. Run the procedures described in test/json/README.md |
| 2025-01-07 12:41:33
| drh | ok
|
| 29. Run make wordcount and do tests on current and prior versions: |
| 2025-01-07 12:41:31
| drh | ok
|
| 29b. rm -f wc.db && ./wordcount wc.db $BIGTEXT --all --cachesize 5 --nosync |
| 2025-01-07 12:39:49
| drh | ok
|
| 29a. rm -f wc.db && ./wordcount wc.db $BIGTEXT --all |
| 2025-01-07 12:32:45
| drh | ok
|
| 30. Compare performance to the previous release using kvtest. |
| 2025-01-07 12:32:42
| drh | ok
|
| 30b. Mac |
| 2025-01-07 12:32:38
| drh | ok
|
| 28. Performance tests using speedtest1 compared against the previous release and a release from about one year ago. |
| 2025-01-07 12:31:59
| drh | ok
|
| 28c. Mac |
| 2025-01-07 12:30:04
| drh | ok
|
| 30a. Linux |
| 2025-01-07 12:29:00
| drh | ok
|
| 28b. Linux with --testset rtree |
| 2025-01-07 12:28:08
| drh | ok
|
| 28a. Linux |
| 2025-01-07 00:45:15
| drh | ok
|
| 6. Tests for platform Linux x86_64: |
| 2025-01-07 00:45:11
| drh | ok
|
| 6k. From a read-only source tree: $SRC/configure && make devtest |
| 06:11 bld(8/8) fuzz(18/18) tcl(2408/2408) ETC 00:00
0 errors out of 881552 tests in 06:11 on bella Linux 64-bit
SQLite 2025-01-06 21:36:16 cb54f0063edd284996b225183b8e35d71ffcd3c0fb4f56a0e316 |
| 2025-01-06 21:14:24
| drh | ok
|
| 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 |
| 2025-01-06 21:13:39
| drh | ok
|
| 6i. Run auxiliary test script in the /usr subdirectory of the TH3 repository |
| Had to make adjustments to usr/misc001.sh. |
| 2025-01-06 20:21:11
| drh | ok
|
| 6h. CC=clang CFLAGS='-fsanitize=thread' ./configure && make threadtest5 && ./threadtest5 |
| 2025-01-06 20:17:39
| drh | ok
|
| 6g. Test the reuse-schema branch with ./configure --enable-all && make "OPTS=-DSQLITE_ENABLE_SHARED_SCHEMA" sdevtest |
| 0 errors out of 882005 tests in 02:58 on r21 Linux 64-bit
SQLite 2025-01-06 20:12:59 3703a844374743d7daab34c5db271aaaa7776f60729e67214e4e |
| 2025-01-06 19:53:03
| drh | ok
|
| 6f. ./configure --enable-debug --enable-all && make parse.c && CC=clang CFLAGS='-fsanitize=address,undefined' make -e test |
| ! tableapi-2.3.3 expected: [1 {near "invalid": syntax error}]
! tableapi-2.3.3 got: [invalid command name "SQLITE_ERROR" 1 {near "invalid": syntax error}]
After fixing the sqlite3_get_table_printf test command in testfixture results in:
SQLite 2025-01-06 18:32:53 a0df29c7a3eb4f558aba00598d827643830591def3101a4d5464543527b8d13c
0 errors out of 393531 tests on r20 Linux 64-bit |
| 2025-01-06 11:56:27
| stephan | ok
|
| 14. WASM |
| 2025-01-06 11:56:16
| stephan | ok
|
| 14d. Click on the test links - confirm correct results. |
| 2025-01-06 11:55:58
| stephan | ok
|
| 14c. Run "althttpd --enable-sab --popop" then visit the HOST:PORT/index.html in a web-browser. |
| Tested with FF v132 and Chrome v131. |
| 2025-01-06 11:55:32
| stephan | ok
|
| 14b. (On Linux) ./configure --enable-all && cd ext/wasm && make |
| 2025-01-06 11:55:27
| stephan | ok
|
| 14a. Build and install Fiddle according to website maintenance instructions at https://sqlite.org/devops/doc/trunk/build/website-build.md. Run simple tests. |
| Tested with FF v132 and Chrome v131. |
| 2025-01-06 10:39:39
| drh | ok
|
| 6c. In sibling th3 checkout: tclsh multitest.tcl --scenario failures - all failures detected |
| 2025-01-06 10:38:50
| drh | ok
|
| 6b. In sibling th3 checkout: tclsh multitest.tcl --scenario coverage |
| 0 failures on 4 jobs, 7687499 tests in 17:12, 16 cores, r21 (64-bit) |
| 2025-01-06 09:37:32
| drh | fail
|
| 6f. ./configure --enable-debug --enable-all && make parse.c && CC=clang CFLAGS='-fsanitize=address,undefined' make -e test |
| ! tableapi-2.3.3 expected: [1 {near "invalid": syntax error}]
! tableapi-2.3.3 got: [invalid command name "SQLITE_ERROR" 1 {near "invalid": syntax error}]
I do not know if the above is real or not. I cannot recreate the problem
separately. I'll rerun the entire test... |
| 2025-01-06 09:32:44
| drh | ok
|
| 6a. In sibling th3 checkout: make releasetest |
| 0 failures on 75 jobs, 261697985 tests in 01:09:56, 16 cores, r21 (32/64-bit)
SQLite 3.48.0 2025-01-05 19:58:30 bcdaef434142973a0805117495e561b2dcd1ec1465cacc9b944a3707291afc0d |
| 2025-01-06 00:45:37
| drh | pending
|
| 6f. ./configure --enable-debug --enable-all && make parse.c && CC=clang CFLAGS='-fsanitize=address,undefined' make -e test |
| 2025-01-06 00:45:29
| drh | pending
|
| 6a. In sibling th3 checkout: make releasetest |
| 2025-01-06 00:44:02
| drh | ok
|
| 6e. sh tool/symbols.sh - no incorrect exports or dependencies |
| 2025-01-06 00:43:34
| drh | ok
|
| 6d. ./configure && make verify-source releasetest |
| 0 errors out of 14914368 tests in 26:25 on r21 Linux 64-bit
SQLite 2025-01-05 19:58:30 bcdaef434142973a0805117495e561b2dcd1ec1465cacc9b944a |
| 2025-01-05 21:40:03
| drh | ok
|
16. 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-01-04 16:08:13
| drh | ok
|
| 15. Building The TCL Extension. Detailed procedures document at
https://sqlite.org/src/doc/trunk/doc/tcl-extension-testing.md |
| 2025-01-04 16:08:10
| drh | ok
|
| 15b. Tested on Mac |
| 2025-01-04 15:59:38
| drh | ok
|
| 15c. Tested on Windows |
| 2025-01-04 15:59:36
| drh | ok
|
| 15a. Tested on Linux |
| 2025-01-04 12:00:03
| drh | ok
|
| 12. Tests for platform Windows (64-bit): |
| 2025-01-04 12:00:01
| 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-01-04 11:59:37
| drh | ok
|
| 12c. In sibling TH3 checkout: tclsh multitest.tcl --msvc --scenario failures - verify failures detected |
| 2025-01-04 11:58:16
| drh | ok
|
| 27. Amalgamation autoconf tarball. |
| 2025-01-04 11:58:07
| drh | ok
|
| 27d. Works on Windows MSVC |
| 2025-01-04 11:57:48
| drh | ok
|
| 12b. In sibling TH3 checkout: nmake releasetest |
| Extra arguments: msvc.rc
Source tree tested: ../sqlite
0 failures on 69 jobs, 207045893 tests in 04:34:32, 8 cores, w23 (64-bit)
SQLite 3.48.0 2025-01-03 11:51:50 9ee57a30a49d9813bf2669a5d8346f7e018e3fbf1792739951311a8d3a249d45 |
| 2025-01-04 11:54:45
| drh | ok
|
| 27c. Works on Mac OS X. |
| 2025-01-04 11:49:00
| drh | ok
|
| 27b. Works on Linux. |
| 2025-01-04 11:48:56
| drh | ok
|
| 27a. Builds (using "make amalgamation-tarball" and/or "make snapshot-tarball"). |
| 2025-01-04 00:13:25
| drh | ok
|
| 12f. After updating Fossil to use the latest SQLite, verify that it compiles without warnings and that it works |
| 2025-01-04 00:13:22
| drh | ok
|
| 12e. Verify that EXEs and DLLs generated using MSVC contain the correct version number, product name, description, and copyright as resources. |
| 2025-01-04 00:11:56
| drh | ok
|
| 12d. nmake /f Makefile.msc verify-source releasetest |
| 0 errors out of 4093569 tests in 45:52 on w23 Windows NT 64-bit
SQLite 2025-01-03 11:51:50 9ee57a30a49d9813bf2669a5d8346f7e018e3fbf179273995131 |
| 2025-01-03 22:55:50
| drh | ok
|
| 9. Tests for platform MacOS ARM: |
| 2025-01-03 22:55:46
| drh | ok
|
| 9b. In sibling TH3 checkout: make releasetest |
| 0 failures on 71 jobs, 250903111 tests in 04:04:41, 4 cores, minimac (64-bit)
SQLite 3.48.0 2025-01-03 11:51:50 9ee57a30a49d9813bf2669a5d8346f7e018e3fbf1792739951311a8d3a249d45 |
| 2025-01-03 21:25:06
| drh | ok
|
| 41. 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-01-03 21:21:18
| drh | ok
|
| 38. Build and verify sqlite3_rsync |
| 2025-01-03 21:21:16
| drh | ok
|
| 38b. Mac |
| 2025-01-03 21:21:13
| drh | ok
|
| 37. Build and verify sqldiff |
| 2025-01-03 21:21:11
| drh | ok
|
| 37b. Mac |
| 2025-01-03 21:21:08
| drh | ok
|
| 36. Build and verify correct operation of sqlite3_analyzer on: |
| 2025-01-03 21:21:06
| drh | ok
|
| 36b. Mac OS X |
| 2025-01-03 21:19:52
| drh | ok
|
| 38a. Linux |
| 2025-01-03 21:19:48
| drh | ok
|
| 37a. Linux |
| 2025-01-03 21:19:45
| drh | ok
|
| 36a. Linux |
| 2025-01-03 21:14:59
| drh | ok
|
| 37c. Windows |
| 2025-01-03 21:14:35
| drh | ok
|
| 7. Tests for platform Linux ARM (RaspberryPI) |
| 2025-01-03 19:18:33
| drh | ok
|
| 18. Trunk changes merged and verified on active branches.
See https://sqlite.org/devops/doc/trunk/build/release-actions-drh.md
for detailed instructions. |
| 2025-01-03 19:18:30
| drh | ok
|
| 18g. reuse-schema-see (in the see-base repository) |
| 2025-01-03 19:14: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-01-03 19:14:56
| drh | ok
|
| 32c. Linux ARM |
| 2025-01-03 19:14:54
| drh | ok
|
| 32e. Mac ARM |
| 2025-01-03 19:11:22
| drh | ok
|
| 32d. Mac x64 |
| 2025-01-03 19:11:16
| drh | ok
|
| 32b. Linux x64 |
| 2025-01-03 19:07:08
| drh | ok
|
| 10. Tests for platform MacOS (PPC): |
| 2025-01-03 19:07:06
| 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-01-03 17:37:21
| drh | ok
|
| 34. Verify that the amalgamation builds are byte-for-byte identical on all workstation platforms. |
| 2025-01-03 17:37:16
| drh | ok
|
| 34c. Mac OS X |
| 001acf111014d65e3b62b4ef504897af079e841037568e6523182fbba7a5f85a sqlite3.c
d2a70ceb1aee07f7d2992e877b76bb12725fc5c25e64defea9f26c0fac108ffc sqlite3.h |
| 2025-01-03 17:37:05
| drh | ok
|
| 34b. Linux (ARM) |
| 001acf111014d65e3b62b4ef504897af079e841037568e6523182fbba7a5f85a sqlite3.c
d2a70ceb1aee07f7d2992e877b76bb12725fc5c25e64defea9f26c0fac108ffc sqlite3.h |
| 2025-01-03 17:36:50
| drh | ok
|
| 34f. Windows using NMAKE. |
| 001acf111014d65e3b62b4ef504897af079e841037568e6523182fbba7a5f85a sqlite3.c
a8b167ac374d604da570207c0f634a312b85dd5335dcef6950ff49ed1fbab106 sqlite3.h |
| 2025-01-03 17:35:44
| drh | ok
|
| 34e. Mac OS X (ARM) |
| 001acf111014d65e3b62b4ef504897af079e841037568e6523182fbba7a5f85a sqlite3.c
d2a70ceb1aee07f7d2992e877b76bb12725fc5c25e64defea9f26c0fac108ffc sqlite3.h |
| 2025-01-03 17:34:35
| drh | ok
|
| 34d. Mac OS X (PPC) |
| 001acf111014d65e3b62b4ef504897af079e841037568e6523182fbba7a5f85a sqlite3.c
d2a70ceb1aee07f7d2992e877b76bb12725fc5c25e64defea9f26c0fac108ffc sqlite3.h |
| 2025-01-03 17:34:20
| drh | ok
|
| 34a. Linux (x64) |
| 001acf111014d65e3b62b4ef504897af079e841037568e6523182fbba7a5f85a sqlite3.c
d2a70ceb1aee07f7d2992e877b76bb12725fc5c25e64defea9f26c0fac108ffc sqlite3.h |
| 2025-01-03 17:33:14
| drh | ok
|
| 32a. iBook PPC |
| 2025-01-03 17:33:08
| drh | ok
|
| 10a. .selftest checks (see below) |
| 2025-01-03 17:32:37
| drh | ok
|
| 11. Tests for platform Windows (32-bit): |
| 2025-01-03 17:32:34
| drh | ok
|
| 11c. In sibling TH3 checkout: tclsh multitest.tcl --msvc --scenario failures - verify failures detected |
| 2025-01-03 17:32:03
| drh | ok
|
| 11b. In sibling TH3 checkout: nmake devtest |
| 0 failures on 6 jobs, 3204558 tests in 07:30, 8 cores, w23 (32-bit) |
| 2025-01-03 17:02:16
| 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-01-03 17:01:52
| drh | ok
|
| 11e. Verify that EXEs and DLLs generated using MSVC contain the correct version number, product name, description, and copyright as resources. |
| 2025-01-03 16:57:45
| drh | retest
|
| 9b. In sibling TH3 checkout: make releasetest |
| Testing stopped after seeing:
t19: test1.rc asan.rc.......................................... FAIL (00:00:10)
Missing output file t19/th3-out.txt
t20: test2.rc asan.rc.......................................... FAIL (00:00:10)
Missing output file t20/th3-out.txt
t21: test3.rc asan.rc.......................................... FAIL (00:00:10)
Missing output file t21/th3-out.txt
Analysis: Errors resulted from me running "brew pour llvm" which installed
clang-19, which apparently does not allow "#include <stdio.h>" - perhaps some
kind of brew error. Running "brew uninstall llvm" seems to clear the problem.
Need to rerun the entire test now. |
| 2025-01-03 16:57:02
| drh | retest
|
| 9b. In sibling TH3 checkout: make releasetest |
| Testing stopped after seeing:
t19: test1.rc asan.rc.......................................... FAIL (00:00:10)
Missing output file t19/th3-out.txt
t20: test2.rc asan.rc.......................................... FAIL (00:00:10)
Missing output file t20/th3-out.txt
t21: test3.rc asan.rc.......................................... FAIL (00:00:10)
Missing output file t21/th3-out.txt
Analysis: Errors resulted from me running "brew pour llvm" which installed
clang-19, which apparently does not allow "#include " - perhaps some
kind of brew error. Running "brew uninstall llvm" seems to clear the problem.
Need to rerun the entire test now. |
| 2025-01-03 16:42:05
| drh | ok
|
| 7b. In sibling TH3 checkout: make devtest |
| 0 failures on 6 jobs, 3270241 tests in 38:59, 2 cores, pi4 (32-bit) |
| 2025-01-03 16:41:42
| drh | ok
|
| 11d. nmake /f Makefile.msc verify-source releasetest |
| 0 errors out of 4091104 tests in 46:49 on w23 Windows NT 32-bit
SQLite 2025-01-03 11:51:50 9ee57a30a49d9813bf2669a5d8346f7e018e3fbf179273995131 |
| 2025-01-03 16:10:43
| drh | fail
|
| 9b. In sibling TH3 checkout: make releasetest |
| Testing stopped after seeing:
t19: test1.rc asan.rc.......................................... FAIL (00:00:10)
Missing output file t19/th3-out.txt
t20: test2.rc asan.rc.......................................... FAIL (00:00:10)
Missing output file t20/th3-out.txt
t21: test3.rc asan.rc.......................................... FAIL (00:00:10)
Missing output file t21/th3-out.txt |
| 2025-01-03 16:01:43
| drh | ok
|
| 18f. client-see (in the see-base repository) |
| 2025-01-03 15:58:59
| drh | ok
|
| 10c. Recompile and test Fossil. |
| 2025-01-03 15:50:44
| drh | ok
|
| 20. Sqllogictest: |
| 2025-01-03 15:50:41
| drh | ok
|
| 20c. tclsh run-all.tcl |
| 2025-01-03 15:49:25
| drh | ok
|
| 18e. see (in the see-base repository) |
| 2025-01-03 15:49:18
| drh | ok
|
| 19. Dbsqlfuzz tests |
| 2025-01-03 15:49:15
| drh | ok
|
| 19d. Mac: FUZZDB=$CORPUS make run-fuzzcheck |
| 2025-01-03 15:46:17
| drh | pending
|
| 11d. nmake /f Makefile.msc verify-source releasetest |
| 2025-01-03 15:46:11
| drh | ok
|
| 11d. nmake /f Makefile.msc verify-source releasetest |
| 2025-01-03 15:27:31
| drh | pending
|
| 7b. In sibling TH3 checkout: make devtest |
| 2025-01-03 15:26:54
| drh | ok
|
| 7a. ./configure && make verify-source devtest |
| 0 errors out of 881772 tests in 41:06 on pi4 Linux 32-bit
SQLite 2025-01-03 11:51:50 9ee57a30a49d9813bf2669a5d8346f7e018e3fbf179273995131 |
| 2025-01-03 15:26:21
| drh | ok
|
| 5. OMIT, ENABLE, and DISABLE options: |
| 2025-01-03 15:26:18
| drh | ok
|
| 5c. tclsh tool/omittest-msvc.tcl ← on Windows |
| 2025-01-03 15:26:14
| drh | pending
|
| 5c. tclsh tool/omittest-msvc.tcl ← on Windows |
| 2025-01-03 15:21:55
| drh | ok
|
| 18d. reuse-schema (from trunk) |
| 2025-01-03 15:20:07
| drh | ok
|
| 18c. bedrock (from wal2) |
| 2025-01-03 15:19:58
| drh | pending
|
| 19d. Mac: FUZZDB=$CORPUS make run-fuzzcheck |
| 2025-01-03 15:18:44
| drh | pending
|
| 20c. tclsh run-all.tcl |
| 2025-01-03 15:15:00
| drh | pending
|
| 5c. tclsh tool/omittest-msvc.tcl ← on Windows |
| 2025-01-03 15:13:44
| drh | ok
|
| 8. Tests for platform MacOS x64: |
| 2025-01-03 15:13:39
| drh | ok
|
| 8c. In sibling TH3 checkout: tclsh multitest.tcl --scenario failures - all failures detected |
| 2025-01-03 15:12:14
| drh | ok
|
| 18b. wal2 (from trunk) |
| 2025-01-03 15:10:32
| drh | ok
|
| 8b. In sibling TH3 checkout: make devtest |
| 2025-01-03 15:09:50
| drh | ok
|
| 20b. No SQLite compiler warnings. |
| 2025-01-03 15:09:47
| drh | ok
|
| 20a. Checked in latest SQLite amalgamation. |
| 2025-01-03 15:07:54
| drh | ok
|
| 18a. begin-concurrent (from trunk) |
| 2025-01-03 15:01:45
| drh | ok
|
| 19e. Windows: fuzzcheck $CORPUS -spinner |
| 2025-01-03 15:00:53
| drh | pending
|
| 9b. In sibling TH3 checkout: make releasetest |
| 2025-01-03 15:00:17
| drh | pending
|
| 7a. ./configure && make verify-source devtest |
| 2025-01-03 14:59:47
| drh | ok
|
| 7a. ./configure && make verify-source devtest |
| 0 errors out of 6130085 tests in 31:14 on minimac Darwin 64-bit
SQLite 2025-01-03 11:51:50 9ee57a30a49d9813bf2669a5d8346f7e018e3fbf179273995131 |
| 2025-01-03 14:59:10
| drh | ok
|
| 8a. ./configure && make verify-source releasetest |
| 0 errors out of 880510 tests in 12:24 on SQLite-iMac-2018 Darwin 64-bit
SQLite 2025-01-03 11:51:50 9ee57a30a49d9813bf2669a5d8346f7e018e3fbf179273995131 |
| 2025-01-03 14:56:52
| drh | ok
|
| 32f. Windows 32-bit |
| 2025-01-03 14:53:50
| drh | ok
|
| 4. Compiler warning checks. |
| 2025-01-03 14:53:47
| drh | ok
|
| 4c. Clang-6.0.0: CFLAGS='-O0' ./configure --enable-debug --enable-all && scan-build make sqlite3 |
| 2025-01-03 14:53:40
| drh | ok
|
| 4d. Clang-10.0.0: CFLAGS='-O0' ./configure --enable-debug --enable-all && scan-build make sqlite3 |
| 2025-01-03 14:53:09
| drh | ok
|
| 9a. ./configure && make verify-source releasetest. Optionally add --enable-test-status to configure |
| 0 errors out of 6130085 tests in 31:14 on minimac Darwin 64-bit
SQLite 2025-01-03 11:51:50 9ee57a30a49d9813bf2669a5d8346f7e018e3fbf179273995131 |
| 2025-01-03 14:52:41
| drh | ok
|
| 19c. Linux: FUZZDB=$CORPUS make run-fuzzcheck |
| 2025-01-03 14:51:46
| drh | ok
|
| 32g. Windows 64-bit |
| 2025-01-03 14:50:12
| drh | ok
|
| 38c. Windows |
| 2025-01-03 14:46:54
| drh | ok
|
| 37c. Windows |
| 2025-01-03 14:46:27
| drh | ok
|
| 36c. Windows |
| 2025-01-03 14:45:14
| drh | pending
|
| 19c. Linux: FUZZDB=$CORPUS make run-fuzzcheck |
| 2025-01-03 14:44:40
| drh | pending
|
| 4d. Clang-10.0.0: CFLAGS='-O0' ./configure --enable-debug --enable-all && scan-build make sqlite3 |
| 2025-01-03 14:44:35
| drh | pending
|
| 4c. Clang-6.0.0: CFLAGS='-O0' ./configure --enable-debug --enable-all && scan-build make sqlite3 |
| 2025-01-03 14:44:28
| drh | pending
|
| 9a. ./configure && make verify-source releasetest. Optionally add --enable-test-status to configure |
| 2025-01-03 14:44:14
| drh | pending
|
| 7a. ./configure && make verify-source devtest |
| 2025-01-03 14:44:07
| drh | pending
|
| 8a. ./configure && make verify-source releasetest |
| 2025-01-03 14:42:53
| drh | ok
|
| 4b. Mac OS X GCC -Wall -Wextra (the "tool/warnings.sh" script) |
| 2025-01-03 14:41:18
| drh | ok
|
| 4a. Linux GCC -Wall -Wextra (the "tool/warnings.sh" script) |
| 2025-01-03 14:39:23
| drh | ok
|
| 5b. tclsh tool/omittest.tcl ← on Linux |
| 2025-01-03 14:39:21
| drh | ok
|
| 5a. Recent compile-time options have been added to the omittest.tcl and omittest-msvc.tcl scripts and checked in. |
| 2025-01-03 14:37:20
| drh | ok
|
| 30c. Windows |
| 2025-01-03 14:35:13
| drh | ok
|
| 22. Wapp updated to use the latest SQLite |
| 2025-01-03 14:35:11
| drh | ok
|
| 22c. https://sqlite.org/src/ext/officeipaddr |
| 2025-01-03 14:35:09
| drh | ok
|
| 22b. https://sqlite.org/src/ext/logview |
| 2025-01-03 14:35:07
| drh | ok
|
| 22a. Used for this checklist - verify on the CGI-environment page |
| 2025-01-03 14:33:53
| drh | ok
|
| 25. ZIPVFS tests. (See also https://sqlite.org/devops/doc/trunk/build/zipvfs.md) |
| 2025-01-03 14:33:50
| drh | ok
|
| 25c. Linux: tclsh multitest.tcl --scenario zipvfs --extra --valgrind --omit 'quick[23]' |
| Extra arguments: --valgrind
Files tested: ../zipvfs/sqlite.c ../zipvfs/zipvfs.c
0 failures on 6 jobs, 1842163 tests in 30:03, 16 cores, r21 (64-bit) |
| 2025-01-03 14:33:13
| drh | ok
|
| 19b. Check-in CORPUS as an unversioned file in the dbsqlfuzz repository |
| 2025-01-03 14:32:13
| drh | ok
|
| 19a. Develop a new CORPUS database by running dbsqlfuzz for 10 billion iterations |
| 20250103.db |
| 2025-01-03 14:30:58
| drh | ok
|
| 28e. Windows with --testset rtree |
| 2025-01-03 14:30:10
| drh | ok
|
| 28d. Windows |
| 2025-01-03 14:23:02
| drh | ok
|
| 25e. Windows: tclsh multitest.tcl --scenario zipvfs |
| 0 failures on 8 jobs, 3781255 tests in 07:42, 8 cores, w23 (64-bit) |
| 2025-01-03 14:10:46
| drh | ok
|
| 25d. Mac: tclsh multitest.tcl --scenario zipvfs |
| 0 failures on 8 jobs, 3761451 tests in 02:54, 4 cores, minimac (64-bit) |
| 2025-01-03 13:59:55
| drh | ok
|
| 25b. testfixture test/testrunner.tcl --zipvfs <ZIPVFS-source-directory> zipvfs |
| 2025-01-03 13:59:51
| drh | ok
|
| 25a. Verify that the configure script version number agrees with the SQLite version number |
| 2025-01-03 12:11:37
| drh | ok
|
| 21. Fossil updated to use the latest SQLite. |
| 2025-01-03 12:11:35
| drh | ok
|
| 21i. Do the above on Windows |
| 2025-01-03 12:11:33
| drh | ok
|
| 21h. Do the above on RaspberryPi |
| 2025-01-03 12:11:31
| drh | ok
|
| 21g. Do the above on Mac |
| 2025-01-03 12:11:28
| drh | ok
|
| 21f. Do the above on Linux |
| 2025-01-03 12:11:26
| drh | ok
|
| 21e. fossil all repack |
| 2025-01-03 12:11:24
| drh | ok
|
| 21d. fossil all sync --all |
| 2025-01-03 12:11:22
| drh | ok
|
| 21c. fossil all test-integrity -d |
| 2025-01-03 12:11:15
| drh | ok
|
| 21b. Used on active websites with no issues. |
| 2025-01-03 12:11:13
| drh | ok
|
| 21a. No SQLite compiler warnings. |
| 2025-01-03 12:10:31
| drh | ok
|
| 1. Test procedure review. |
| 2025-01-03 12:10:29
| drh | ok
|
| 1d. Review dev-ops procedures and make any needed updates and corrections. |
| 2025-01-03 12:10:26
| drh | ok
|
| 1c. Review this checklist for completeness and accuracy. |
| 2025-01-03 12:10:19
| drh | ok
|
| 1b. Review "multitest.tcl" and "alignment*.rc" scripts in TH3 for completeness. |
| 2025-01-03 12:06:33
| drh | ok
|
| 1a. Review "test/testrunner.tcl" and "test/testrunner_data.tcl" for completeness and accuracy. |