| 2023-11-01 11:18:18
| drh | ok
|
| 3. Documentation review: |
| 2023-11-01 11:18:16
| drh | ok
|
| 3c. Release accouncement in "news.html". |
| 2023-11-01 10:30:04
| drh | ok
|
| 3h. Check new/changed documentation for spelling and gramatical mistakes. |
| Relying on community feedback for this, of which there has been plenty. |
| 2023-11-01 10:29:32
| drh | ok
|
| 3g. Test metrics are up-to-date (testing.html). |
| 2023-11-01 10:29:30
| drh | ok
|
| 3f. Database footprint is up-to-date (features.html). |
| 2023-11-01 10:29:27
| drh | ok
|
| 3e. The compile-time options are all up-to-date (compile.html). |
| 2023-11-01 10:28:54
| drh | ok
|
| 3b. Release announcement in "changes.in". |
| 2023-11-01 10:28:51
| drh | ok
|
| 3a. Latest release on the "index.html" page. |
| 2023-11-01 03:50:10
| larrybr | ok
|
| 3d. No unresolved hyperlinks in the documentation build. |
| 2023-10-31 23:14:23
| drh | ok
|
| 1d. Review dev-ops procedures and make any needed updates and corrections. |
| 2023-10-31 23:14:20
| drh | ok
|
| 1c. Review this checklist for completeness and accuracy. |
| 2023-10-31 23:14:18
| drh | ok
|
| 1b. Review "multitest.tcl" and "alignment*.rc" scripts in TH3 for completeness. |
| 2023-10-31 23:14:16
| drh | ok
|
| 1a. Review the "test/testrunner.tcl" script for completeness and accuracy. |
| 2023-10-31 23:14:13
| drh | ok
|
| 1. Test procedure review. |
| 2023-10-31 23:14:03
| drh | ok
|
| 15. WASM |
| 2023-10-31 23:14:01
| drh | ok
|
| 15d. Click on the test links - confirm correct results. |
| 2023-10-31 23:13:59
| drh | ok
|
| 15c. althttpd --enable-sab --page index.html |
| 2023-10-31 23:11:58
| drh | ok
|
| 15b. (On Linux) ./configure --enable-all && cd ext/wasm && make |
| 2023-10-31 23:11:55
| 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. |
| 2023-10-31 23:07:59
| drh | ok
|
| 30. Compare performance to the previous release using kvtest. |
| 2023-10-31 23:07:57
| drh | ok
|
| 30b. Mac |
| 2023-10-31 23:06:46
| drh | ok
|
| 28. Performance tests using speedtest1 compared against the previous release and a release from about one year ago. |
| 2023-10-31 23:06:44
| drh | ok
|
| 28c. Mac |
| 2023-10-31 23:03:27
| drh | ok
|
| 30c. Windows |
| 2023-10-31 23:01:37
| drh | ok
|
| 28e. Windows with --testset rtree |
| 2023-10-31 23:01:33
| drh | ok
|
| 28d. Windows |
| 2023-10-31 22:55:51
| drh | ok
|
| 24. ZIPVFS tests: |
| 2023-10-31 22:55:37
| drh | ok
|
| 24h. At least one of the above on Windows. |
| 2023-10-31 22:55:33
| drh | ok
|
| 24e. th3make zipvfs.rc quick.rc |
| th3: da1335af559a8d07d8a603913007e0b070738792ca2d6ee45c45c50a86d0927e
th3: th3make msvc.rc zipvfs.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_ENABLE_ZIPVFS -DZIPVFS_OMIT_DEPRECATED -DSQLITE_DEBUG -DSQLITE_ENABLE_BYTECODE_VTAB -DSQLITE_ENABLE_DESERIALIZE -DSQLITE_ENABLE_STMTVTAB -DTH3_SELFCOVERAGE zipvfs/?*.cfg cfg/c?.cfg cfg/wal1.cfg cfg/f2fs.cfg coverage.testplan zipvfs/?*.test cov1/?*.test
th3: 0 errors in 3918113 tests. 1241.124 seconds on w23 64-bit little-endian
th3: SQLite 3.44.0 2023-10-30 23:20:45 a4c7954b9380dfd3599e521f7fd40b8b556a7d0268198b302146311d20c3b162 |
| 2023-10-31 22:54:11
| drh | ok
|
| 31. Check JSON performance |
| 2023-10-31 22:54:08
| drh | ok
|
| 31c. Verify that the JSON parser performance claimed in the json1.html file of the documentation is accurate |
| 2023-10-31 22:54:06
| drh | ok
|
| 31b. Verify JSON performance against the previous release |
| 2023-10-31 22:54:01
| drh | ok
|
| 31a. Run the procedures described in test/json/README.md |
| 2023-10-31 22:45:35
| drh | ok
|
| 30a. Linux |
| 2023-10-31 22:42:17
| drh | ok
|
| 29. Run make wordcount and do tests on current and prior versions: |
| 2023-10-31 22:42:15
| drh | ok
|
| 29b. rm -f wc.db && ./wordcount wc.db $BIGTEXT --all --cachesize 5 --nosync |
| 2023-10-31 22:38:06
| drh | ok
|
| 29a. rm -f wc.db && ./wordcount wc.db $BIGTEXT --all |
| 2023-10-31 22:32:37
| drh | ok
|
| 28b. Linux with --testset rtree |
| 2023-10-31 22:31:45
| drh | ok
|
| 28a. Linux |
| 2023-10-31 22:10:13
| drh | ok
|
| 24f. At least one of the above on Linux. |
| 2023-10-31 22:10:10
| drh | ok
|
| 24d. th3make zipvfs.rc quick1.rc -valgrind |
| th3: da1335af559a8d07d8a603913007e0b070738792ca2d6ee45c45c50a86d0927e
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 2036008 tests. 14634.631 seconds on r20 64-bit little-endian
th3: SQLite 3.44.0 2023-10-30 23:20:45 a4c7954b9380dfd3599e521f7fd40b8b556a7d0268198b302146311d20c3b162 |
| 2023-10-31 22:04:01
| drh | ok
|
| 12. Tests for platform Windows (64-bit): |
| 2023-10-31 22:03:58
| drh | ok
|
| 12d. Verify that EXEs and DLLs generated using MSVC contain the correct version number, product name, description, and copyright as resources. |
| 2023-10-31 21:58:18
| drh | ok
|
| 12c. nmake /f Makefile.msc verify-source releasetest |
| 2293 bld(11/11) fuzz(40/40) make(5/5) tcl(7123/7123) |
| 2023-10-31 20:32:23
| drh | ok
|
| 33. Verify that the performance and size measurement spreadsheet in the documentation (misc/speed-size-graph.ods) is up-to-date. |
| 2023-10-31 20:22:31
| drh | ok
|
| 20. Fossil updated to use the latest SQLite. |
| 2023-10-31 20:07:37
| drh | ok
|
| 12b. tclsh multitest.tcl --msvc --scenario failures - verify failures detected |
| 2023-10-31 20:05:13
| drh | ok
|
| 12a. tclsh multitest.tcl --xdev |
| 0 failures on 7 th3makes and 4905742 tests in (00:10:11) 5 cores on w23 (64-bit) |
| 2023-10-31 19:56:22
| drh | ---
|
| 24e. th3make zipvfs.rc quick.rc |
| 2023-10-31 19:56:09
| drh | ok
|
| 24c. th3make zipvfs.rc test.rc |
| th3: da1335af559a8d07d8a603913007e0b070738792ca2d6ee45c45c50a86d0927e
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 12563319 tests. 3624.988 seconds on minimac.local 64-bit little-endian
th3: SQLite 3.44.0 2023-10-30 23:20:45 a4c7954b9380dfd3599e521f7fd40b8b556a7d0268198b302146311d20c3b162 |
| 2023-10-31 19:55:59
| drh | fail
|
| 24c. th3make zipvfs.rc test.rc |
| th3: da1335af559a8d07d8a603913007e0b070738792ca2d6ee45c45c50a86d0927e
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 12563319 tests. 3624.988 seconds on minimac.local 64-bit little-endian
th3: SQLite 3.44.0 2023-10-30 23:20:45 a4c7954b9380dfd3599e521f7fd40b8b556a7d0268198b302146311d20c3b162 |
| 2023-10-31 19:55:19
| drh | ok
|
| 24g. At least one of the above on Mac OS X. |
| 2023-10-31 19:55:12
| drh | ok
|
| 24e. th3make zipvfs.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_ENABLE_ZIPVFS -DZIPVFS_OMIT_DEPRECATED -DSQLITE_DEBUG -DSQLITE_ENABLE_BYTECODE_VTAB -DSQLITE_ENABLE_DESERIALIZE -DSQLITE_ENABLE_STMTVTAB -DTH3_SELFCOVERAGE zipvfs/?*.cfg cfg/c?.cfg cfg/wal1.cfg cfg/f2fs.cfg coverage.testplan zipvfs/?*.test cov1/?*.test
th3: 42 errors in 3918130 tests. 1283.435 seconds on w23 64-bit little-endian
th3: SQLite 3.44.0 2023-10-30 23:20:45 a4c7954b9380dfd3599e521f7fd40b8b556a7d0268198b302146311d20c3b162 |
| 2023-10-31 19:53:16
| drh | ok
|
| 11. Tests for platform Windows (32-bit): |
| 2023-10-31 19:53:12
| drh | ok
|
| 11d. Verify that EXEs and DLLs generated using MSVC contain the correct version number, product name, description, and copyright as resources. |
| 2023-10-31 19:51:53
| drh | ok
|
| 11c. nmake /f Makefile.msc verify-source releasetest |
| 2413 bld(11/11) fuzz(40/40) make(5/5) tcl(7123/7123) |
| 2023-10-31 17:58:34
| drh | ok
|
| 6e. ./configure && make verify-source releasetest |
| 1167 bld(46/46) fuzz(126/126) make(18/18) tcl(37461/37461)
1167 bld(46/46) fuzz(126/126) make(18/18) tcl(37461/37461) |
| 2023-10-31 17:26:15
| drh | ok
|
| 37. Build and verify sqldiff |
| 2023-10-31 17:26:12
| drh | ok
|
| 37b. Mac |
| 2023-10-31 17:24:51
| drh | ok
|
| 36. Build and verify correct operation of sqlite3_analyzer on: |
| 2023-10-31 17:19:05
| drh | ok
|
| 24b. testfixture test/testrunner.tcl --zipvfs <ZIPVFS-source-directory> zipvfs |
| 324 bld(1/1) tcl(48/48)
160 bld(1/1) tcl(48/48) (Mac-ARM64) |
| 2023-10-31 17:07:19
| dan | ok
|
| 41. Website built procedures |
| 2023-10-31 17:07:16
| dan | ok
|
| 41c. Compile-time options for build products have been updated as necessary |
| 2023-10-31 17:07:13
| dan | ok
|
| 41d. All build products work on their target platforms |
| 2023-10-31 16:56:08
| dan | ok
|
| 41b. tools/mkmsvcmin.tcl has been run to update the MSVC makefiles in autoconf |
| 2023-10-31 16:55:15
| dan | ok
|
| 41a. Compile-time options in builds/products_build.sh in the supportdb repository has been updated to align with any changes to the default makefiles. |
| 2023-10-31 16:50:56
| dan | ok
|
| 36b. Mac OS X |
| 2023-10-31 16:46:36
| drh | ---
|
| 24g. At least one of the above on Mac OS X. |
| 2023-10-31 16:46:31
| drh | ---
|
| 24h. At least one of the above on Windows. |
| 2023-10-31 16:46:15
| drh | fail
|
| 24e. th3make zipvfs.rc quick.rc |
| th3: da1335af559a8d07d8a603913007e0b070738792ca2d6ee45c45c50a86d0927e
th3: th3make msvc.rc zipvfs.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_ENABLE_ZIPVFS -DZIPVFS_OMIT_DEPRECATED -DSQLITE_DEBUG -DSQLITE_ENABLE_BYTECODE_VTAB -DSQLITE_ENABLE_DESERIALIZE -DSQLITE_ENABLE_STMTVTAB -DTH3_SELFCOVERAGE zipvfs/?*.cfg cfg/c?.cfg cfg/wal1.cfg cfg/f2fs.cfg coverage.testplan zipvfs/?*.test cov1/?*.test
th3: 42 errors in 3918130 tests. 1283.435 seconds on w23 64-bit little-endian
th3: SQLite 3.44.0 2023-10-30 23:20:45 a4c7954b9380dfd3599e521f7fd40b8b556a7d0268198b302146311d20c3b162 |
| 2023-10-31 16:46:09
| drh | fail
|
| 24c. th3make zipvfs.rc test.rc |
| th3: da1335af559a8d07d8a603913007e0b070738792ca2d6ee45c45c50a86d0927e
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: 34 errors in 12563038 tests. 3591.822 seconds on minimac.local 64-bit little-endian
th3: SQLite 3.44.0 2023-10-30 23:20:45 a4c7954b9380dfd3599e521f7fd40b8b556a7d0268198b302146311d20c3b162 |
| 2023-10-31 16:42:51
| drh | ok
|
| 24g. At least one of the above on Mac OS X. |
| 2023-10-31 16:42:47
| drh | ok
|
| 24c. th3make zipvfs.rc test.rc |
| th3: da1335af559a8d07d8a603913007e0b070738792ca2d6ee45c45c50a86d0927e
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: 34 errors in 12563038 tests. 3591.822 seconds on minimac.local 64-bit little-endian
th3: SQLite 3.44.0 2023-10-30 23:20:45 a4c7954b9380dfd3599e521f7fd40b8b556a7d0268198b302146311d20c3b162 |
| 2023-10-31 16:41:46
| drh | ok
|
| 36a. Linux |
| 2023-10-31 16:41:43
| drh | ok
|
| 37a. Linux |
| 2023-10-31 16:35:35
| drh | ok
|
| 11b. tclsh multitest.tcl --msvc --scenario failures - verify failures detected |
| 2023-10-31 16:32:39
| drh | ok
|
| 37c. Windows |
| 2023-10-31 16:32:37
| drh | ok
|
| 36c. Windows |
| 2023-10-31 16:24:02
| dan | ok
|
| 27. TEA archive builds correctly and runs: |
| 2023-10-31 16:23:59
| dan | ok
|
| 26. Amalgamation autoconf tarball. |
| 2023-10-31 16:23:57
| dan | ok
|
| 27c. Mac OS X |
| 2023-10-31 16:23:14
| drh | ok
|
| 38. Build the "atrc" test program and run "./atrc $DB | ./sqlite3 $DB" against multiple databases, visually verify the result |
| 2023-10-31 16:22:15
| dan | ok
|
| 26c. Works on Mac OS X. |
| 2023-10-31 16:10:32
| dan | ok
|
| 27d. Windows MSVC |
| "nmake -f makefile.vc install INSTALLDIR=c:Tcl" installs sqlite 3.44 Tcl extension correctly. |
| 2023-10-31 15:59:06
| dan | ok
|
| 26d. Works on Windows MSVC |
| "nmake -f Makefile.msc" builds sqlite3.exe, sqlite3.lib and sqlite3.dll. |
| 2023-10-31 15:57:45
| drh | ok
|
| 24h. At least one of the above on Windows. |
| 2023-10-31 15:57:42
| drh | ok
|
| 24e. th3make zipvfs.rc quick.rc |
| th3: da1335af559a8d07d8a603913007e0b070738792ca2d6ee45c45c50a86d0927e
th3: th3make msvc.rc zipvfs.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_ENABLE_ZIPVFS -DZIPVFS_OMIT_DEPRECATED -DSQLITE_DEBUG -DSQLITE_ENABLE_BYTECODE_VTAB -DSQLITE_ENABLE_DESERIALIZE -DSQLITE_ENABLE_STMTVTAB -DTH3_SELFCOVERAGE zipvfs/?*.cfg cfg/c?.cfg cfg/wal1.cfg cfg/f2fs.cfg coverage.testplan zipvfs/?*.test cov1/?*.test
th3: 42 errors in 3918130 tests. 1283.435 seconds on w23 64-bit little-endian
th3: SQLite 3.44.0 2023-10-30 23:20:45 a4c7954b9380dfd3599e521f7fd40b8b556a7d0268198b302146311d20c3b162 |
| 2023-10-31 15:50:19
| dan | ok
|
| 27b. Linux |
| 2023-10-31 15:48:20
| dan | ok
|
| 26b. Works on Linux. |
| 2023-10-31 15:47:11
| dan | ok
|
| 27a. Verify that the SQLite version number is correct in autoconf/tea/configure.ac |
| AC_INIT([sqlite],[3.44.0]) |
| 2023-10-31 15:45:15
| dan | ok
|
| 26a. Builds. |
| 2023-10-31 15:24:58
| drh | ok
|
| 25. NDS-Devkit testing |
| 2023-10-31 15:24:56
| drh | ok
|
| 25a. Merge all trunk enhancements into the reuse-schema branch and use that branch to update the devkit. |
| 2023-10-31 15:24:10
| drh | ok
|
| 23. SEE tests using TH3: |
| 2023-10-31 15:24:07
| drh | ok
|
| 23j. At least one of the above using "test.rc". |
| 2023-10-31 15:24:04
| drh | ok
|
| 23i. Verify that builds work with -DSQLITE_ENABLE_UPDATE_DELETE_LIMIT |
| 2023-10-31 15:24:00
| drh | ok
|
| 23a. see.c |
| th3: da1335af559a8d07d8a603913007e0b070738792ca2d6ee45c45c50a86d0927e
th3: ./th3make test.rc see.rc -DSQLITE_ENABLE_UPDATE_DELETE_LIMIT
th3: mkth3.tcl -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_HAS_CODEC -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 12721233 tests. 4648.959 seconds on r20 64-bit little-endian
th3: SQLite 3.44.0 2023-10-30 20:51:43 deb2c5a0e939f2c2d5fca2cf4c0aadbe3833ab628bc49cf0a0c152807b7d66c3 |
| 2023-10-31 15:22:50
| drh | ok
|
| 25c. Verify the "NDS DevKit" version number shown at the end of the test |
| 2023-10-31 15:22:14
| drh | ok
|
| 25b. Test using: tclsh th3make debug.rc nds_devkit.rc |
| th3: da1335af559a8d07d8a603913007e0b070738792ca2d6ee45c45c50a86d0927e
th3: ./th3make debug.rc nds_devkit.rc
th3: mkth3.tcl -DSQLITE_DEBUG -DSQLITE_THREADSAFE=0 -DSQLITE_ENABLE_WHERETRACE -DSQLITE_ENABLE_BYTECODE_VTAB -DSQLITE_ENABLE_DBPAGE_VTAB -DSQLITE_ENABLE_DBSTAT_VTAB -DSQLITE_ENABLE_DESERIALIZE -DSQLITE_ENABLE_STMTVTAB -DNDS_ENABLE_EXTENSIONS -DNDS_ENABLE_COMPRESS -DSQLITE_ENABLE_SHARED_SCHEMA -DSQLITE_SECURE_DELETE nx_compress.c cfg/c?.cfg cfg/wal1.cfg coverage.testplan cov1/?*.test
th3: 0 errors in 2600417 tests. 674.135 seconds on bella 64-bit little-endian
th3: NDS DevKit 3.44.0 2023-10-31 15:06:44 4418b1f9d8941507
th3: SQLite 3.44.0 2023-10-31 11:21:21 c660793cfd605f11fb69aedf7fd9e8a61f21c26fccfe4780445d9fdcbef0b44a |
| 2023-10-31 15:18:44
| drh | ok
|
| 23n. At least one of the above on Windows. |
| 2023-10-31 15:18:39
| drh | ok
|
| 23h. see-aes256-cryptoapi.c |
| th3: da1335af559a8d07d8a603913007e0b070738792ca2d6ee45c45c50a86d0927e
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 2514337 tests. 666.107 seconds on w23 64-bit little-endian
th3: SQLite 3.44.0 2023-10-30 20:51:43 deb2c5a0e939f2c2d5fca2cf4c0aadbe3833ab628bc49cf0a0c152807b7d66c3 |
| 2023-10-31 15:02:59
| drh | ok
|
| 9. Tests for platform MacOS ARM: |
| 2023-10-31 15:02:56
| drh | ok
|
| 9b. tclsh multitest.tcl --xdev |
| 0 failures on 7 th3makes and 4860777 tests in (00:05:15) 2 cores on minimac.local (64-bit)
SQLite 3.44.0 2023-10-30 23:20:45 a4c7954b9380dfd3599e521f7fd40b8b556a7d0268198b302146311d20c3b162 |
| 2023-10-31 15:01:18
| drh | ok
|
| 23d. see-rc4.c |
| 2023-10-31 14:58:34
| drh | ok
|
| 11a. tclsh multitest.tcl --xdev |
| 0 failures on 7 th3makes and 4879453 tests in (00:17:25) 2 cores on w23 (32-bit)
SQLite 3.44.0 2023-10-30 23:20:45 a4c7954b9380dfd3599e521f7fd40b8b556a7d0268198b302146311d20c3b162 |
| 2023-10-31 14:57:03
| drh | ok
|
| 9a. ./configure && make verify-source releasetest |
| 1838 bld(9/9) fuzz(27/27) make(4/4) tcl(12386/12386) |
| 2023-10-31 14:56:39
| drh | ok
|
| 8. Tests for platform MacOS x64: |
| 2023-10-31 14:56:37
| drh | ok
|
| 8c. tclsh multitest.tcl --scenario failures - all failures detected |
| 2023-10-31 14:56:07
| drh | ok
|
| 8b. tclsh multitest.tcl --xdev |
| 0 failures on 7 th3makes and 4860796 tests in (00:13:12) 2 cores on SQLite-iMac-2018.local (64-bit)
SQLite 3.44.0 2023-10-30 23:20:45 a4c7954b9380dfd3599e521f7fd40b8b556a7d0268198b302146311d20c3b162 |
| 2023-10-31 14:48:03
| drh | ok
|
| 23l. At least one of the above on Linux. |
| 2023-10-31 14:47:58
| drh | ok
|
| 23g. see-aes256-openssl.c |
| 2023-10-31 14:29:10
| drh | ok
|
| 24b. testfixture test/testrunner.tcl --zipvfs <ZIPVFS-source-directory> zipvfs |
| 324 bld(1/1) tcl(48/48) |
| 2023-10-31 14:25:09
| drh | ok
|
| 6. Tests for platform Linux x86_64: |
| 2023-10-31 14:25:07
| drh | ok
|
| 6k. 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 |
| 2023-10-31 14:24:33
| drh | ok
|
| 6i. CC=clang CFLAGS='-fsanitize=thread' ./configure && make threadtest5 && ./threadtest5 |
| 2023-10-31 14:23:10
| drh | ok
|
| 6j. Run auxiliary test script in the /usr subdirectory of the TH3 repository |
| 2023-10-31 14:16:46
| drh | ok
|
| 6h. Test the reuse-schema branch with ./configure --enable-all && make "OPTS=-DSQLITE_ENABLE_SHARED_SCHEMA" sdevtest |
| 133 bld(6/6) fuzz(18/18) tcl(2318/2318) |
| 2023-10-31 14:06:15
| drh | ok
|
| 8a. ./configure && make verify-source releasetest |
| 5775 bld(9/9) fuzz(27/27) make(4/4) tcl(12386/12386) |
| 2023-10-31 14:05:01
| drh | ok
|
| 6g. ./configure --enable-debug --enable-all && make parse.c && CC=clang CFLAGS='-fsanitize=address,undefined' make -e test |
| SQLite 2023-10-30 23:20:45 a4c7954b9380dfd3599e521f7fd40b8b556a7d0268198b302146311d20c3b162
0 errors out of 336788 tests on r21 Linux 64-bit little-endian
All memory allocations freed - no leaks
Maximum memory usage: 9206008 bytes
Current memory usage: 0 bytes |
| 2023-10-31 12:41:31
| drh | ok
|
| 24a. Verify that the configure script version number agrees with the SQLite version number |
| 2023-10-31 12:38:56
| drh | ok
|
| 23c. see-aes256-ofb.c |
| 2023-10-31 12:34:06
| drh | ok
|
| 23b. see-aes128-ofb.c |
| 2023-10-31 12:24:30
| drh | ok
|
| 6f. sh tool/symbols.sh - no incorrect exports or dependencies |
| 2023-10-31 12:24:00
| drh | ok
|
| 6d. tclsh multitest.tcl --scenario failures - all failures detected |
| 2023-10-31 12:22:17
| drh | ok
|
| 6c. tclsh multitest.tcl --scenario obscure |
| 2023-10-31 12:18:07
| drh | ok
|
| 7. Tests for platform Linux ARM (BeagleBoard or RaspberryPI) |
| 2023-10-31 12:18:05
| drh | ok
|
| 7b. Recompile and test Fossil. |
| 2023-10-31 12:17:25
| drh | ok
|
| 7a. tclsh th3make min.rc -DTH3_LOWMEM --unobfuscated |
| 2023-10-31 12:17:08
| drh | ok
|
| 23e. see-aes128-ccm.c |
| 2023-10-31 12:07:36
| drh | ok
|
| 23m. At least one of the above on Mac OS X. |
| 2023-10-31 12:07:33
| drh | ok
|
| 23k. At least one of the above with option -DSQLITE_DIRECT_OVERFLOW_READ. |
| 2023-10-31 12:07:30
| drh | ok
|
| 23f. see-cccrypt.c |
| 2023-10-31 11:52:17
| drh | ok
|
| 22. CEROD tests in the "test/" subdirectory. |
| 2023-10-31 11:50:07
| drh | ok
|
| 10. Tests for platform MacOS (PPC): |
| 2023-10-31 11:50:04
| drh | ok
|
| 10c. Verify that Fossil repositories are cross-platform with x86/x64. |
| 2023-10-31 11:50:01
| drh | ok
|
| 10b. Recompile and test Fossil. |
| 2023-10-31 11:45:07
| drh | ok
|
| 6b. tclsh multitest.tcl --scenario coverage |
| Core and STAT4 coverage only. Coverage of RTREE and VFS has been lost. |
| 2023-10-31 11:21:51
| drh | ok
|
| 17. Trunk changes merged and verified on active branches. See https://sqlite.org/devops/doc/trunk/build/release-actions-drh.md for detailed instructions. |
| 2023-10-31 11:21:48
| drh | ok
|
| 17g. reuse-schema-see (in the see-base repository) |
| 2023-10-31 11:07:14
| 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.7.2 and 3.8.2 using backcompat.test:
SQLite 2023-10-30 23:20:45 a4c7954b9380dfd3599e521f7fd40b8b556a7d0268198b302146311d20c3b162
0 errors out of 265 tests on ws1 Linux 64-bit little-endian |
| 2023-10-31 11:06:13
| drh | ok
|
| 32. Use the ".selftest" command of the shell to verify that legacy database files are readable and cross-platform |
| 2023-10-31 11:06:10
| drh | ok
|
| 32g. Windows 64-bit |
| 2023-10-31 11:06:07
| drh | ok
|
| 32f. Windows 32-bit |
| 2023-10-31 11:06:05
| drh | ok
|
| 32c. Linux ARM |
| 2023-10-31 11:04:13
| drh | ok
|
| 32d. Mac x64 |
| 2023-10-31 11:03:00
| dan | ok
|
| 39. Run the rbu/run_rbu_tests.tcl script in the test-dbs project on Linux. |
| All tests report "round trip successful". |
| 2023-10-31 11:00:11
| drh | ok
|
| 34. Verify that the amalgamation builds are byte-for-byte identical on all workstation platforms. |
| 2023-10-31 11:00:07
| drh | ok
|
| 34f. Windows using NMAKE. |
| 9f1d25fc6f70da3853febe3e5175f6beaf417e47ccbde7fb789ee31ca09ff44a sqlite3.c
c2cd9f04f5a2e34461e0227e849d5d5498e3712527aae7d59c3a946c53f5c798 sqlite3.h
4c6f5454b8af556db2e266eec27ce640c10e4484eb87e8ceb81461120ad556c4 shell.c |
| 2023-10-31 10:59:06
| drh | ok
|
| 34e. Mac OS X (ARM) |
| 9f1d25fc6f70da3853febe3e5175f6beaf417e47ccbde7fb789ee31ca09ff44a sqlite3.c
c2cd9f04f5a2e34461e0227e849d5d5498e3712527aae7d59c3a946c53f5c798 sqlite3.h
4c6f5454b8af556db2e266eec27ce640c10e4484eb87e8ceb81461120ad556c4 shell.c |
| 2023-10-31 10:58:55
| drh | ok
|
| 34d. Mac OS X (PPC) |
| 9f1d25fc6f70da3853febe3e5175f6beaf417e47ccbde7fb789ee31ca09ff44a sqlite3.c
c2cd9f04f5a2e34461e0227e849d5d5498e3712527aae7d59c3a946c53f5c798 sqlite3.h
4c6f5454b8af556db2e266eec27ce640c10e4484eb87e8ceb81461120ad556c4 shell.c |
| 2023-10-31 10:58:45
| drh | ok
|
| 34c. Mac OS X |
| 9f1d25fc6f70da3853febe3e5175f6beaf417e47ccbde7fb789ee31ca09ff44a sqlite3.c
c2cd9f04f5a2e34461e0227e849d5d5498e3712527aae7d59c3a946c53f5c798 sqlite3.h
4c6f5454b8af556db2e266eec27ce640c10e4484eb87e8ceb81461120ad556c4 shell.c |
| 2023-10-31 10:58:24
| drh | ok
|
| 34a. Linux (x64) |
| 9f1d25fc6f70da3853febe3e5175f6beaf417e47ccbde7fb789ee31ca09ff44a sqlite3.c
c2cd9f04f5a2e34461e0227e849d5d5498e3712527aae7d59c3a946c53f5c798 sqlite3.h
4c6f5454b8af556db2e266eec27ce640c10e4484eb87e8ceb81461120ad556c4 shell.c |
| 2023-10-31 10:58:12
| drh | ok
|
| 34b. Linux (ARM) |
| 9f1d25fc6f70da3853febe3e5175f6beaf417e47ccbde7fb789ee31ca09ff44a sqlite3.c
c2cd9f04f5a2e34461e0227e849d5d5498e3712527aae7d59c3a946c53f5c798 sqlite3.h
4c6f5454b8af556db2e266eec27ce640c10e4484eb87e8ceb81461120ad556c4 shell.c |
| 2023-10-31 10:44:37
| drh | ok
|
| 6e. ./configure && make verify-source releasetest |
| 1167 bld(46/46) fuzz(126/126) make(18/18) tcl(37461/37461) |
| 2023-10-31 09:39:26
| drh | ok
|
| 6a. tclsh multitest.tcl |
| 0 failures on 73 th3makes and 251520183 tests in (01:06:31) 16 cores on r21 (32/64-bit)
SQLite 3.44.0 2023-10-30 23:20:45 a4c7954b9380dfd3599e521f7fd40b8b556a7d0268198b302146311d20c3b162 |
| 2023-10-30 23:24:25
| drh | ok
|
| 32e. Mac ARM |
| 2023-10-30 23:15:40
| drh | ok
|
| 17d. reuse-schema (from trunk) |
| 2023-10-30 22:57:36
| drh | ok
|
| 17c. bedrock (from wal2) |
| 2023-10-30 21:59:53
| drh | ok
|
| 17b. wal2 (from trunk) |
| 2023-10-30 21:59:49
| drh | ok
|
| 17a. begin-concurrent (from trunk) |
| fts3corrupt4 tests fail due to a difference in the PRNG. Not a real problem. |
| 2023-10-30 21:34:51
| dan | ok
|
| 14. Tests for platform OpenBSD (x86): |
| 2023-10-30 21:34:48
| dan | ok
|
| 14a. make test |
| SQLite 2023-10-30 20:35:33 c4f724de279dae1afd10d435ad61ed07c1e4658288457c50e4f9b2f4521bbe12
0 errors out of 282092 tests on foo.. OpenBSD 64-bit little-endian
All memory allocations freed - no leaks |
| 2023-10-30 21:34:26
| dan | ok
|
| 14b. th3make quick.rc |
| th3: th3make CC=clang BCC=clang quick.rc
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 2562478 tests. 694.557 seconds on foo.. 64-bit little-endian
th3: SQLite 3.44.0 2023-10-30 20:35:33 c4f724de279dae1afd10d435ad61ed07c1e4658288457c50e4f9b2f4521bbe12 |
| 2023-10-30 21:00:53
| drh | ok
|
| 17f. client-see (in the see-base repository) |
| 2023-10-30 20:52:15
| drh | ok
|
| 17e. see (in the see-base repository) |
| 2023-10-30 20:48:46
| 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. |
| 2023-10-30 20:48:38
| drh | ok
|
| 32b. Linux x64 |
| 2023-10-30 20:43:00
| dan | ok
|
| 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 2023-10-30 19:50:20 166c96d91dcc8c500a084d5703db103176ed5ec7d5f1334050cd66b3f1cd0e4f
0 errors out of 281384 tests on ws1 Linux 64-bit little-endian
All memory allocations freed - no leaks
atomic2.test did run. |
| 2023-10-30 20:30:14
| drh | ok
|
| 32a. iBook PPC |
| 2023-10-30 20:30:06
| drh | ok
|
| 10a. .selftest checks (see below) |
| 2023-10-30 20:01:39
| drh | ok
|
| 13. Tests for platform Windows7: |
| 2023-10-30 20:01:37
| drh | ok
|
| 13d. Run selftest.txt from the dbs repository |
| 2023-10-30 20:00:44
| drh | ok
|
| 13c. Perform a .dump on a database that contains schema elements with Unicode characters |
| 2023-10-30 20:00:41
| drh | ok
|
| 13b. Verify that the --utf8 option does not work. |
| 2023-10-30 20:00:37
| drh | ok
|
| 13a. Compile the CLI separately (on Win11) and move the 64-bit EXE to the Win7 platform. |
| 2023-10-30 19:56:24
| larrybr | pending
|
| 20. Fossil updated to use the latest SQLite. |
| 2023-10-30 19:55:35
| drh | ok
|
| 5. OMIT, ENABLE, and DISABLE options: |
| 2023-10-30 19:55:30
| drh | ok
|
| 4. Compiler warning checks. |
| 2023-10-30 19:55:28
| drh | ok
|
| 4c. Clang-6.0.0: CFLAGS='-O0' ./configure --enable-debug --enable-all && scan-build make sqlite3 |
| 2023-10-30 19:55:09
| drh | ok
|
| 18. Dbsqlfuzz tests |
| 2023-10-30 19:55:07
| drh | ok
|
| 18e. make fuzzcheck-ubsan && ./fuzzcheck-ubsan $CORPUS --spinner |
| 2023-10-30 19:54:56
| drh | ok
|
| 21. Wapp updated to use the latest SQLite |
| 2023-10-30 19:54:51
| drh | ok
|
| 21a. Used on active websites with no issues |
| 2023-10-30 19:53:51
| drh | ok
|
| 18f. Mac: fuzzcheck $CORPUS --spinner |
| 2023-10-30 19:53:47
| drh | ok
|
| 18d. make fuzzcheck-asan && ./fuzzcheck-asan $CORPUS --spinner |
| 2023-10-30 19:48:45
| drh | ok
|
| 18g. Win10/MSVC: fuzzcheck $CORPUS -spinner |
| 2023-10-30 19:48:04
| drh | ok
|
| 18c. make fuzzcheck && ./fuzzcheck $CORPUS --spinner |
| 2023-10-30 19:38:52
| drh | ok
|
| 19. Sqllogictest: |
| 2023-10-30 19:38:50
| drh | ok
|
| 19c. tclsh run-all.tcl |
| 2023-10-30 19:38:31
| drh | ok
|
| 5b. tclsh ../tool/omittest.tcl -skip_run -target libsqlite3.a ← on Linux |
| 2023-10-30 19:29:56
| drh | ok
|
| 5a. Recent compile-time options have been added to the omittest.tcl and omittest-msvc.tcl scripts and checked in. |
| 2023-10-30 19:29:53
| drh | ok
|
| 5c. tclsh tool/omittest-msvc.tcl ← on Windows |
| 2023-10-30 19:21:09
| drh | ok
|
| 19a. Checked in latest SQLite amalgamation. |
| 2023-10-30 19:20:16
| drh | ok
|
| 19b. No SQLite compiler warnings. |
| 2023-10-30 19:20:02
| drh | ok
|
| 18b. Check-in CORPUS as an unversioned file in the dbsqlfuzz repository |
| 2023-10-30 19:19:59
| drh | ok
|
| 18a. Develop a new CORPUS database by running dbsqlfuzz for 10 billion iterations |
| 2023-10-30 19:18:09
| drh | ok
|
| 20. Fossil updated to use the latest SQLite. |
| 2023-10-30 19:18:07
| drh | ok
|
| 20c. fossil all test-integrity -d |
| 2023-10-30 19:18:04
| drh | ok
|
| 20b. Used on active websites with no issues. |
| 2023-10-30 19:17:39
| drh | ok
|
| 20a. No SQLite compiler warnings. |
| 2023-10-30 19:14:25
| drh | ok
|
| 4d. Clang-10.0.0: CFLAGS='-O0' ./configure --enable-debug --enable-all && scan-build make sqlite3 |
| 2023-10-30 19:09:17
| drh | ok
|
| 2. Source code change review. fossil diff --from release --to trunk |
| 2023-10-30 19:09: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]*(/ |
| 2023-10-30 19:03:58
| drh | ok
|
| 2h. Check all calls to sqlite3OsRead() and sqlite3OsWrite() to ensure that offset computations are 64-bit clean. |
| 2023-10-30 18:58:40
| drh | ok
|
| 4a. Linux GCC -Wall -Wextra (the "tool/warnings.sh" script) |
| 2023-10-30 18:58:38
| drh | ok
|
| 4b. Mac OS X GCC -Wall -Wextra (the "tool/warnings.sh" script) |
| 2023-10-30 18:55:21
| drh | ok
|
| 2j. Verify that source code contains no tabs and that surplus whitespace has been removed. |
| 2023-10-30 18:54:47
| drh | ok
|
| 2k. Verify that the list of APIs exposed via the extension header is up-to-date (sqlite3ext.h). |
| 2023-10-30 18:54:44
| drh | ok
|
| 2l. Significant compile-time options are recognized by the sqlite3_compileoption_used() interface. |
| 2023-10-30 18:53:50
| drh | ok
|
| 2m. Compare sqlite3.c and sqlite3.h against the previous release. |
| 2023-10-30 18:30:37
| drh | ok
|
| 2g. Variables and functions have been renamed to reflect changes in their use. |
| 2023-10-30 18:30:33
| drh | ok
|
| 2f. Verify that the azProhibitedFunctions list in the safeModeAuth() function of the CLI is complete and up-to-date. |
| 2023-10-30 18:30:27
| drh | ok
|
| 2e. Comments have been updated to reflect code changes. |
| 2023-10-30 18:30:25
| drh | ok
|
| 2d. New code complies with design rules. |
| 2023-10-30 18:30:22
| drh | ok
|
| 2c. New code complies with style guidelines. |
| 2023-10-30 18:30:20
| drh | ok
|
| 2b. All significant changes are mentioned in the "changes" log of the documentation. |
| 2023-10-30 18:30:17
| drh | ok
|
| 2a. No stray changes. |