| 2023-02-21 14:04:31
| drh | ok
|
| 3. Documentation review: |
| 2023-02-21 14:04:29
| drh | ok
|
| 3c. Release accouncement in "news.html". |
| 2023-02-21 14:04:26
| drh | ok
|
| 3i. Check new/changed documentation for spelling and gramatical mistakes. |
| 2023-02-21 13:53:11
| dan | ok
|
| 39. Website built procedures |
| 2023-02-21 13:44:25
| drh | ok
|
| 13. WASM |
| 2023-02-21 13:44:23
| drh | ok
|
| 13d. Click on the test links - confirm correct results. |
| 2023-02-21 13:44:20
| drh | ok
|
| 13c. althttpd --enable-sab --page index.html |
| 2023-02-21 13:44:18
| drh | ok
|
| 13b. (On Linux) ./configure --enable-all && cd ext/wasm && make |
| 2023-02-21 13:44:15
| drh | ok
|
| 13a. Build and install Fiddle according to website maintenance instructions. Run simple tests. |
| 2023-02-21 13:41:09
| drh | ok
|
| 39. Website built procedures |
| 2023-02-21 13:41:07
| dan | ok
|
| 39a. Compile-time options in builds/products_build.sh in the supportdb repository has been updated to align with any changes to the default makefiles. |
| Added -DSQLITE_DQS=0 to shell tool builds. |
| 2023-02-21 13:41:06
| drh | ok
|
| 39d. All build products work on their target platforms |
| 2023-02-21 13:41:01
| drh | ok
|
| 39c. Compile-time options for build products have been updated as necessary |
| 2023-02-21 13:40:53
| drh | ok
|
| 39a. Compile-time options in builds/products_build.sh in the supportdb repository has been updated to align with any changes to the default makefiles. |
| Added -DSQLITE_DQS to shell tool builds. |
| 2023-02-21 13:40:34
| dan | ok
|
| 39a. Compile-time options in builds/products_build.sh in the supportdb repository has been updated to align with any changes to the default makefiles. |
| Added -DSQLITE_DQS to shell tool builds. |
| 2023-02-21 13:32:47
| drh | ok
|
| 3h. Test metrics are up-to-date (testing.html). |
| 2023-02-21 13:32:44
| drh | ok
|
| 3g. Database footprint is up-to-date (features.html). |
| 2023-02-21 13:32:40
| drh | ok
|
| 3f. The compile-time options are all up-to-date (compile.html). |
| 2023-02-21 13:32:38
| drh | ok
|
| 3d. No unresolved hyperlinks in the documentation build. |
| 2023-02-21 13:32:35
| drh | ok
|
| 3b. Release announcement in "changes.in". |
| 2023-02-21 13:32:31
| drh | ok
|
| 3a. Latest release on the "index.html" page. |
| 2023-02-21 13:28:58
| drh | ok
|
| 39b. tools/mkmsvcmin.tcl has been run to update the MSVC makefiles in autoconf |
| 2023-02-21 13:27:23
| drh | ok
|
| 22. ZIPVFS tests: |
| 2023-02-21 13:27:20
| drh | ok
|
| 22a. Verify that the configure script version number agrees with the SQLite version number |
| 2023-02-21 13:20:27
| drh | ok
|
| 31. Verify that the performance and size measurement spreadsheet in the documentation (misc/speed-size-graph.ods) is up-to-date. |
| 2023-02-21 12:49:02
| drh | ok
|
| 22d. th3make zipvfs.rc quick1.rc -valgrind |
| 2023-02-21 12:48:56
| drh | ---
|
| 22d. th3make zipvfs.rc quick1.rc -valgrind |
| 2023-02-21 12:47:21
| drh | ok
|
| 2. Source code change review. fossil diff --from release --to trunk |
| 2023-02-21 12:47:18
| drh | ok
|
| 2a. No stray changes. |
| 2023-02-21 12:47:16
| drh | ok
|
| 2b. All significant changes are mentioned in the "changes" log of the documentation. |
| 2023-02-21 12:47:13
| drh | ok
|
| 2c. New code complies with style guidelines. |
| 2023-02-21 12:47:11
| drh | ok
|
| 2d. New code complies with design rules. |
| 2023-02-21 12:47:09
| drh | ok
|
| 2e. Comments have been updated to reflect code changes. |
| 2023-02-21 12:47:06
| drh | ok
|
| 2g. Variables and functions have been renamed to reflect changes in their use. |
| 2023-02-21 12:47:02
| drh | ok
|
| 2h. Check all calls to sqlite3OsRead() and sqlite3OsWrite() to ensure that offset computations are 64-bit clean. |
| 2023-02-21 12:46:59
| 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-02-21 12:46:56
| drh | ok
|
| 2j. Verify that source code contains no tabs and that surplus whitespace has been removed. |
| 2023-02-21 12:46:36
| drh | ok
|
| 2k. Verify that the list of APIs exposed via the extension header is up-to-date (sqlite3ext.h). |
| 2023-02-21 12:46:32
| drh | ok
|
| 2l. Significant compile-time options are recognized by the sqlite3_compileoption_used() interface. |
| 2023-02-21 12:46:29
| drh | ok
|
| 2m. Compare sqlite3.c and sqlite3.h against the previous release. |
| 2023-02-21 11:56:53
| drh | ok
|
| 1. Test procedure review. |
| 2023-02-21 11:56:50
| drh | ok
|
| 1a. Review the "test/testrunner.tcl" script for completeness and accuracy. |
| 2023-02-21 11:56:48
| drh | ok
|
| 1b. Review "multitest.tcl" and "alignment*.rc" scripts in TH3 for completeness. |
| 2023-02-21 00:13:19
| drh | ok
|
| 29. Compare performance to the previous release using kvtest. |
| 2023-02-21 00:13:17
| drh | ok
|
| 29b. Mac |
| 2023-02-21 00:12:19
| drh | ok
|
| 26. Performance tests using speedtest1 compared against the previous release and a release from about one year ago. |
| 2023-02-21 00:12:16
| drh | ok
|
| 26b. Mac |
| 2023-02-21 00:08:56
| drh | ok
|
| 27. Performance tests using speedtest1 --testset rtree |
| 2023-02-21 00:08:54
| drh | ok
|
| 27b. Windows |
| 2023-02-21 00:07:44
| drh | ok
|
| 26c. Windows |
| 2023-02-21 00:06:11
| drh | ok
|
| 29c. Windows |
| 2023-02-21 00:01:10
| drh | ok
|
| 29a. Linux |
| 2023-02-20 23:57:28
| drh | ok
|
| 28. Run make wordcount and do tests on current and prior versions: |
| 2023-02-20 23:57:26
| drh | ok
|
| 28b. rm -f wc.db && ./wordcount wc.db $BIGTEXT --all --cachesize 5 --nosync |
| 2023-02-20 23:55:28
| drh | ok
|
| 28a. rm -f wc.db && ./wordcount wc.db $BIGTEXT --all |
| 2023-02-20 23:26:52
| drh | ok
|
| 27a. Linux |
| 2023-02-20 23:25:48
| drh | ok
|
| 26a. Linux |
| 2023-02-20 21:19:14
| dan | ok
|
| 37. Run the rbu/run_rbu_tests.tcl script in the test-dbs project on Linux. |
| All round trips successful. |
| 2023-02-20 21:07:13
| dan | ok
|
| 33. 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-02-20 19:43:01 b450a920c0c59affd105616e999205cb9d2b25a79f8a7f7f05610ddaac0f770f
0 errors out of 265 tests on ws1 Linux 64-bit little-endian |
| 2023-02-20 20:56:56
| dan | ok
|
| 22c. th3make zipvfs.rc test.rc |
| th3: 0 errors in 12368095 tests. 11149.730 seconds on Dans-iMac.local 64-bit little-endian
th3: SQLite 3.41.0 2023-02-19 19:16:51 b2534d8de5051a3516f4b9ee5a4b99e1dcf455e9af88c60815d2c2a479fc8566 |
| 2023-02-20 20:29:17
| drh | ok
|
| 35. Build and verify sqldiff |
| 2023-02-20 20:29:14
| drh | ok
|
| 35c. Windows |
| 2023-02-20 20:29:08
| drh | ok
|
| 34. Build and verify correct operation of sqlite3_analyzer on: |
| 2023-02-20 20:29:05
| drh | ok
|
| 34c. Windows |
| 2023-02-20 20:26:45
| drh | ok
|
| 32. Verify that the amalgamation builds are byte-for-byte identical on all workstation platforms. |
| 2023-02-20 20:26:41
| drh | ok
|
| 32f. Windows using native MinGW. |
| e572b59b10e1bd2d8fd22def532aa6a704b3f2ea7b7b514f80a1b92e98d90083 sqlite3.c
9ffb9dbd1ff5c4234377eb328e1e1ac28c4ef54e7ae14bf5be4f0391e341d495 sqlite3.h |
| 2023-02-20 20:24:14
| drh | ok
|
| 30. Use the ".selftest" command of the shell to verify that legacy database files are readable and cross-platform |
| 2023-02-20 20:24:11
| drh | ok
|
| 30f. Windows 32-bit |
| 2023-02-20 20:21:39
| drh | ok
|
| 30c. Linux ARM |
| 2023-02-20 20:19:10
| drh | ok
|
| 25. TEA archive builds correctly and runs: |
| 2023-02-20 20:19:08
| drh | ok
|
| 25d. Windows MSVC |
| 2023-02-20 20:14:44
| drh | ok
|
| 24. Amalgamation autoconf tarball. |
| 2023-02-20 20:14:39
| drh | ok
|
| 24d. Works on Windows MinGW |
| 2023-02-20 20:07:32
| drh | ok
|
| 24e. Works on Windows MSVC |
| 2023-02-20 20:04:49
| drh | ok
|
| 22h. At least one of the above on Windows. |
| th3: 63a6a73d3ee146e6aa9dad068f26e2b4167b7ccfda778dd0478193b2768a846b
th3: th3make zipvfs.rc quick.rc
th3: mkth3.tcl -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 3779352 tests. 1657.329 seconds on SQLiteWin10 32-bit little-endian
th3: SQLite 3.41.0 2023-02-19 19:16:51 b2534d8de5051a3516f4b9ee5a4b99e1dcf455e9af88c60815d2c2a479fc8566 |
| 2023-02-20 20:03:13
| drh | ok
|
| 25c. Mac OS X |
| 2023-02-20 19:51:45
| drh | ok
|
| 24c. Works on Mac OS X. |
| 2023-02-20 19:49:10
| drh | ok
|
| 25b. Linux |
| 2023-02-20 19:49:08
| drh | ok
|
| 25a. Verify that the SQLite version number is correct in autoconf/tea/configure.ac |
| 2023-02-20 19:41:08
| drh | ok
|
| 24b. Works on Linux. |
| 2023-02-20 19:38:47
| drh | ok
|
| 24a. Builds. |
| 2023-02-20 19:36:50
| drh | ok
|
| 22f. At least one of the above on Linux. |
| 2023-02-20 19:36:42
| drh | ok
|
| 23. NDS-Devkit testing |
| 2023-02-20 19:36:39
| drh | ok
|
| 23c. Verify the "NDS DevKit" version number shown at the end of the test |
| 2023-02-20 19:36:36
| drh | ok
|
| 23b. Test using: tclsh th3make test.rc nds_devkit.rc |
| th3: 5b84a403511208bb746ffa0af5588ccff7b20e880608b082f4c4211be9776d6d
th3: th3make test.rc nds_devkit.rc
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 -DNDS_ENABLE_EXTENSIONS -DNDS_ENABLE_COMPRESS -DSQLITE_ENABLE_SHARED_SCHEMA -DSQLITE_SECURE_DELETE nx_compress.c cfg/?*.cfg extra1/?*.cfg bugs/?*.test cov1/?*.test extra1/?*.test fts/?*.test req1/?*.test demo/?*.test
th3: 0 errors in 10977937 tests. 2428.490 seconds on r21 64-bit little-endian
th3: NDS DevKit 3.41.0 2023-02-20 18:46:37 b490483dc17d4796
th3: SQLite 3.41.0 2023-02-19 19:06:17 6bb8d9763deb5bd231ef23cefde1f3bda37e4f8258ca9947ad3e5e8b51e0ad7c
FILES GENERATED: |
| 2023-02-20 19:32:44
| drh | ok
|
| 21. SEE tests using TH3: |
| 2023-02-20 19:32:40
| drh | ok
|
| 21o. At least one of the above on Windows. |
| 2023-02-20 19:32:36
| drh | ok
|
| 21h. see-aes256-cryptoapi.c |
| th3: 63a6a73d3ee146e6aa9dad068f26e2b4167b7ccfda778dd0478193b2768a846b
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 2434085 tests. 853.665 seconds on SQLiteWin10 64-bit little-endian
th3: SQLite 3.41.0 2023-02-20 17:00:34 ddff0edc77937e472846c4f78002e96012f84aed1357ed7b684664d78900b1fd |
| 2023-02-20 19:01:19
| drh | ok
|
| 11. Tests for platform Windows: |
| 2023-02-20 19:01:16
| drh | ok
|
| 11f. Verify that EXEs and DLLs generated using MSVC contain the correct version number, product name, description, and copyright as resources. |
| 2023-02-20 18:59:08
| drh | ok
|
| 11e. sh tool/symbols-mingw.sh - no incorrect exports or dependencies |
| 2023-02-20 18:57:13
| drh | ok
|
| 11c. tclsh multitest.tcl --msvc --scenario failures - verify failures detected |
| 2023-02-20 18:56:22
| drh | ok
|
| 11b. tclsh multitest.tcl --msvc --quick on x86 |
| 0 failures on 16 th3makes and 32176197 tests in (02:18:56) 2 cores on SQLiteWin10
SQLite 3.41.0 2023-02-19 19:16:51 b2534d8de5051a3516f4b9ee5a4b99e1dcf455e9af88c60815d2c2a479fc8566 |
| 2023-02-20 18:48:45
| drh | ok
|
| 23a. Merge all trunk enhancements into the reuse-schema branch and use that branch to update the devkit. |
| 2023-02-20 18:38:56
| drh | ok
|
| 18. Build using the configure/make in main source tree. |
| 2023-02-20 18:38:53
| drh | ok
|
| 18a. Make sure that autoconf has been run to update the configure script. |
| 2023-02-20 18:38:51
| drh | ok
|
| 18b. Verify the correct version numbers have been installed. |
| 2023-02-20 18:38:28
| drh | ok
|
| 36. Build the "atrc" test program and run "./atrc $DB | ./sqlite3 $DB" against multiple databases, visually verify the result |
| 2023-02-20 18:20:00
| drh | ok
|
| 38. 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-02-20 18:19:25
| drh | ok
|
| 32b. Linux (ARM) |
| e572b59b10e1bd2d8fd22def532aa6a704b3f2ea7b7b514f80a1b92e98d90083 sqlite3.c
9ffb9dbd1ff5c4234377eb328e1e1ac28c4ef54e7ae14bf5be4f0391e341d495 sqlite3.h |
| 2023-02-20 18:10:19
| drh | ok
|
| 35a. Linux |
| 2023-02-20 18:09:34
| drh | ok
|
| 34a. Linux |
| 2023-02-20 18:06:46
| drh | ok
|
| 32e. Mac OS X (ARM) |
| e572b59b10e1bd2d8fd22def532aa6a704b3f2ea7b7b514f80a1b92e98d90083 sqlite3.c
9ffb9dbd1ff5c4234377eb328e1e1ac28c4ef54e7ae14bf5be4f0391e341d495 sqlite3.h |
| 2023-02-20 18:05:48
| drh | ok
|
| 8. Tests for platform MacOS x64: |
| 2023-02-20 18:05:44
| drh | ok
|
| 7. Tests for platform Linux ARM (BeagleBoard or RaspberryPI) |
| 2023-02-20 18:05:40
| drh | ok
|
| 7b. Recompile and test Fossil. |
| 2023-02-20 18:04:31
| drh | ok
|
| 30e. Mac ARM |
| 2023-02-20 18:00:54
| drh | ok
|
| 22g. At least one of the above on Mac OS X. |
| 2023-02-20 18:00:51
| drh | ok
|
| 22e. th3make zipvfs.rc quick.rc |
| th3: 5b84a403511208bb746ffa0af5588ccff7b20e880608b082f4c4211be9776d6d
th3: ./th3make zipvfs.rc quick.rc
th3: mkth3.tcl -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 3753383 tests. 396.129 seconds on minimac 64-bit little-endian
th3: SQLite 3.41.0 2023-02-19 19:16:51 b2534d8de5051a3516f4b9ee5a4b99e1dcf455e9af88c60815d2c2a479fc8566
FILES GENERATED: |
| 2023-02-20 18:00:16
| drh | ok
|
| 21c. see-aes256-ofb.c |
| th3: 5b84a403511208bb746ffa0af5588ccff7b20e880608b082f4c4211be9776d6d
th3: ./th3make quick.rc see.rc
th3: mkth3.tcl -DSQLITE_DEBUG -DSQLITE_ENABLE_BYTECODE_VTAB -DSQLITE_ENABLE_DESERIALIZE -DSQLITE_ENABLE_STMTVTAB -DTH3_SELFCOVERAGE -DSQLITE_HAS_CODEC cfg/c?.cfg cfg/wal1.cfg cfg/f2fs.cfg coverage.testplan cov1/?*.test
th3: 0 errors in 2426359 tests. 259.344 seconds on r21 64-bit little-endian
th3: SQLite 3.41.0 2023-02-18 23:23:13 62e657a033dc9348c51a866058691460c0152485c0c102b027d4eadf14e414fb |
| 2023-02-20 17:54:23
| drh | ok
|
| 21b. see-aes128-ofb.c |
| h3: 5b84a403511208bb746ffa0af5588ccff7b20e880608b082f4c4211be9776d6d
th3: ./th3make test.rc see.rc
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 cfg/?*.cfg extra1/?*.cfg bugs/?*.test cov1/?*.test extra1/?*.test fts/?*.test req1/?*.test demo/?*.test
th3: 0 errors in 12498401 tests. 3288.100 seconds on r21 64-bit little-endian
th3: SQLite 3.41.0 2023-02-18 23:23:13 62e657a033dc9348c51a866058691460c0152485c0c102b027d4eadf14e414fb |
| 2023-02-20 17:53:31
| drh | ok
|
| 21f. see-cccrypt.c |
| th3: 5b84a403511208bb746ffa0af5588ccff7b20e880608b082f4c4211be9776d6d
th3: ./th3make see.rc quick.rc
th3: mkth3.tcl -DSQLITE_HAS_CODEC -DSQLITE_DEBUG -DSQLITE_ENABLE_BYTECODE_VTAB -DSQLITE_ENABLE_DESERIALIZE -DSQLITE_ENABLE_STMTVTAB -DTH3_SELFCOVERAGE cfg/c?.cfg cfg/wal1.cfg cfg/f2fs.cfg coverage.testplan cov1/?*.test
th3: 0 errors in 2407405 tests. 576.231 seconds on SQLite-iMac-2018 64-bit little-endian
th3: SQLite 3.41.0 2023-02-20 17:00:34 ddff0edc77937e472846c4f78002e96012f84aed1357ed7b684664d78900b1fd |
| 2023-02-20 17:52:05
| drh | ok
|
| 20. CEROD tests in the "test/" subdirectory. |
| 2023-02-20 17:51:55
| drh | ok
|
| 21n. At least one of the above on Mac OS X. |
| 2023-02-20 17:51:52
| drh | ok
|
| 21j. At least one of the above using "test.rc". |
| 2023-02-20 17:51:49
| drh | ok
|
| 21l. At least one of the above with option -DSQLITE_DIRECT_OVERFLOW_READ. |
| 2023-02-20 17:51:46
| drh | ok
|
| 21i. Verify that builds work with -DSQLITE_ENABLE_UPDATE_DELETE_LIMIT |
| 2023-02-20 17:51:41
| drh | ok
|
| 21a. see.c |
| th3: 5b84a403511208bb746ffa0af5588ccff7b20e880608b082f4c4211be9776d6d
th3: ./th3make see.rc test.rc -DSQLITE_DIRECT_OVERFLOW_READ -DSQLITE_ENABLE_UPDATE_DELETE_LIMIT
th3: mkth3.tcl -DSQLITE_HAS_CODEC -DSQLITE_DEBUG -DSQLITE_ENABLE_EXPENSIVE_ASSERT -DSQLITE_ENABLE_WHERETRACE -DSQLITE_ENABLE_BYTECODE_VTAB -DSQLITE_ENABLE_DBPAGE_VTAB -DSQLITE_ENABLE_DBSTAT_VTAB -DSQLITE_ENABLE_DESERIALIZE -DSQLITE_ENABLE_STMTVTAB -DSQLITE_ENABLE_RTREE -DSQLITE_DIRECT_OVERFLOW_READ -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 9526414 tests. 3280.969 seconds on minimac 64-bit little-endian
th3: SQLite 3.41.0 2023-02-18 23:23:13 62e657a033dc9348c51a866058691460c0152485c0c102b027d4eadf14e414fb |
| 2023-02-20 17:50:27
| drh | ok
|
| 7a. tclsh th3make min.rc -DTH3_LOWMEM --unobfuscated |
| th3: 5a31d846be30009e638c0a834c81fe39ae062eb3d38e61932fb7f2b2cbff2170
th3: ./th3make --unobfuscated min.rc
th3: mkth3.tcl cfg/c?.cfg cfg/wal1.cfg cfg/f2fs.cfg coverage.testplan cov1/?*.test
th3: 0 errors in 2159258 tests. 9484.404 seconds on raspberrypi 32-bit little-endian
th3: SQLite 3.41.0 2023-02-19 19:16:51 b2534d8de5051a3516f4b9ee5a4b99e1dcf455e9af88c60815d2c2a479fc8566 |
| 2023-02-20 17:41:27
| dan | ---
|
| 22d. th3make zipvfs.rc quick1.rc -valgrind |
| 2023-02-20 16:58:14
| drh | ok
|
| 21d. see-rc4.c |
| th3: 63a6a73d3ee146e6aa9dad068f26e2b4167b7ccfda778dd0478193b2768a846b
th3: ./th3make quick.rc see.rc
th3: mkth3.tcl -DSQLITE_DEBUG -DSQLITE_ENABLE_BYTECODE_VTAB -DSQLITE_ENABLE_DESERIALIZE -DSQLITE_ENABLE_STMTVTAB -DTH3_SELFCOVERAGE -DSQLITE_HAS_CODEC cfg/c?.cfg cfg/wal1.cfg cfg/f2fs.cfg coverage.testplan cov1/?*.test
th3: 0 errors in 2426475 tests. 294.277 seconds on r21 64-bit little-endian
th3: SQLite 3.41.0 2023-02-18 23:23:13 62e657a033dc9348c51a866058691460c0152485c0c102b027d4eadf14e414fb |
| 2023-02-20 16:44:07
| drh | ok
|
| 21g. see-aes256-openssl.c |
| th3: 63a6a73d3ee146e6aa9dad068f26e2b4167b7ccfda778dd0478193b2768a846b
th3: ./th3make quick.rc see.rc -lcrypto
th3: mkth3.tcl -DSQLITE_DEBUG -DSQLITE_ENABLE_BYTECODE_VTAB -DSQLITE_ENABLE_DESERIALIZE -DSQLITE_ENABLE_STMTVTAB -DTH3_SELFCOVERAGE -DSQLITE_HAS_CODEC cfg/c?.cfg cfg/wal1.cfg cfg/f2fs.cfg coverage.testplan cov1/?*.test
th3: 0 errors in 2426471 tests. 223.497 seconds on r21 64-bit little-endian
th3: SQLite 3.41.0 2023-02-18 23:23:13 62e657a033dc9348c51a866058691460c0152485c0c102b027d4eadf14e414fb |
| 2023-02-20 16:40:22
| drh | ok
|
| 19. Fossil updated to use the latest SQLite. |
| 2023-02-20 16:40:20
| drh | ok
|
| 19c. fossil all test-integrity -d |
| 2023-02-20 16:40:18
| drh | ok
|
| 19b. Used on active websites with no issues. |
| 2023-02-20 16:40:15
| drh | ok
|
| 19a. No SQLite compiler warnings. |
| 2023-02-20 16:38:03
| drh | ok
|
| 21m. At least one of the above on Linux. |
| 2023-02-20 16:38:00
| drh | ok
|
| 21k. At least one of the above using "memdebug.rc". |
| 2023-02-20 16:37:55
| drh | ok
|
| 21e. see-aes128-ccm.c |
| th3: 5a31d846be30009e638c0a834c81fe39ae062eb3d38e61932fb7f2b2cbff2170
th3: ./th3make see.rc memdebug.rc
th3: mkth3.tcl -DSQLITE_HAS_CODEC -DSQLITE_DEBUG -DSQLITE_MEMDEBUG cfg/?*.cfg extra1/?*.cfg bugs/?*.test cov1/?*.test extra1/?*.test fts/?*.test req1/?*.test
th3: 0 errors in 10998202 tests. 6335.110 seconds on r21 64-bit little-endian
th3: SQLite 3.41.0 2023-02-18 23:23:13 62e657a033dc9348c51a866058691460c0152485c0c102b027d4eadf14e414fb |
| 2023-02-20 16:35:36
| drh | ok
|
| 35b. Mac |
| 2023-02-20 16:34:57
| drh | ok
|
| 30g. Windows 64-bit |
| 2023-02-20 16:24:47
| drh | ok
|
| 34b. Mac OS X |
| 2023-02-20 16:23:27
| drh | ok
|
| 11a. tclsh multitest.tcl --msvc --quick on x64 |
| 0 failures on 16 th3makes and 32375765 tests in (02:59:07) on SQLiteWin10
SQLite 3.41.0 2023-02-19 19:16:51 b2534d8de5051a3516f4b9ee5a4b99e1dcf455e9af88c60815d2c2a479fc8566 |
| 2023-02-20 16:22:49
| drh | ok
|
| 32g. Windows using NMAKE. |
| e572b59b10e1bd2d8fd22def532aa6a704b3f2ea7b7b514f80a1b92e98d90083 sqlite3.c
9ffb9dbd1ff5c4234377eb328e1e1ac28c4ef54e7ae14bf5be4f0391e341d495 sqlite3.h |
| 2023-02-20 16:21:26
| drh | ok
|
| 30d. Mac x64 |
| 2023-02-20 16:21:00
| drh | ok
|
| 32c. Mac OS X |
| e572b59b10e1bd2d8fd22def532aa6a704b3f2ea7b7b514f80a1b92e98d90083 sqlite3.c
9ffb9dbd1ff5c4234377eb328e1e1ac28c4ef54e7ae14bf5be4f0391e341d495 sqlite3.h |
| 2023-02-20 15:52:51
| dan | ok
|
| 11d. nmake /f Makefile.msc releasetest |
| 2036s: build (5/5) f=0 r=0 script (5972/5972) f=1 r=0 make (9/9) f=0 r=0 |
| 2023-02-20 15:46:23
| drh | ok
|
| 10. Tests for platform MacOS (PPC): |
| 2023-02-20 15:46:20
| drh | ok
|
| 10c. Verify that Fossil repositories are cross-platform with x86/x64. |
| 2023-02-20 15:46:17
| drh | ok
|
| 10b. Recompile and test Fossil. |
| 2023-02-20 15:46:08
| drh | ok
|
| 8c. tclsh multitest.tcl --scenario failures - all failures detected |
| 2023-02-20 15:43:08
| drh | ok
|
| 8b. tclsh multitest.tcl --quick |
| 0 failures on 16 th3makes and 32524654 tests in (02:15:40) on SQLite-iMac-2018
SQLite 3.41.0 2023-02-19 19:16:51 b2534d8de5051a3516f4b9ee5a4b99e1dcf455e9af88c60815d2c2a479fc8566 |
| 2023-02-20 15:34:51
| dan | ok
|
| 12. Tests for platform OpenBSD (x86): |
| 2023-02-20 15:34:46
| dan | ok
|
| 12b. th3make quick.rc |
| th3: 0 errors in 2463961 tests. 744.903 seconds on openbsd.my.domain 32-bit little-endian
th3: SQLite 3.41.0 2023-02-19 19:16:51 b2534d8de5051a3516f4b9ee5a4b99e1dcf455e9af88c60815d2c2a479fc8566 |
| 2023-02-20 15:02:49
| dan | pending
|
| 22d. th3make zipvfs.rc quick1.rc -valgrind |
| 2023-02-20 15:00:04
| drh | ok
|
| 10a. .selftest checks (see below) |
| 2023-02-20 14:45:34
| drh | ok
|
| 30a. iBook PPC |
| 2023-02-20 14:44:42
| drh | ok
|
| 30b. Linux x64 |
| 2023-02-20 14:42:20
| drh | ok
|
| 32d. Mac OS X (PPC) |
| e572b59b10e1bd2d8fd22def532aa6a704b3f2ea7b7b514f80a1b92e98d90083 sqlite3.c
9ffb9dbd1ff5c4234377eb328e1e1ac28c4ef54e7ae14bf5be4f0391e341d495 sqlite3.h |
| 2023-02-20 14:42:07
| drh | ok
|
| 32a. Linux (x64) |
| e572b59b10e1bd2d8fd22def532aa6a704b3f2ea7b7b514f80a1b92e98d90083 sqlite3.c
9ffb9dbd1ff5c4234377eb328e1e1ac28c4ef54e7ae14bf5be4f0391e341d495 sqlite3.h |
| 2023-02-20 14:40:55
| drh | ok
|
| 6. Tests for platform Linux x86_64: |
| 2023-02-20 14:40:51
| drh | ok
|
| 6g. ./configure --enable-debug --enable-all && make parse.c && CC=clang CFLAGS='-fsanitize=address,undefined' make -e test |
| SQLite 2023-02-19 19:16:51 b2534d8de5051a3516f4b9ee5a4b99e1dcf455e9af88c60815d2c2a479fc8566
0 errors out of 299692 tests on r20 Linux 64-bit little-endian
All memory allocations freed - no leaks
Maximum memory usage: 9205568 bytes
Current memory usage: 0 bytes |
| 2023-02-20 14:34:24
| drh | ok
|
| 6j. Run auxiliary test script in the /usr subdirectory of the TH3 repository |
| 2023-02-20 14:30:44
| drh | ok
|
| 6h. Test the reuse-schema branch with ./configure --enable-all && make "OPTS=-DSQLITE_ENABLE_SHARED_SCHEMA" test. |
| SQLite 2023-02-18 21:59:17 38fc1d3dfc791485acbaf61e7e187ae2a85cb054e33addb4a26566ecfb82814d
0 errors out of 299227 tests on r21 Linux 64-bit little-endian
All memory allocations freed - no leaks
Maximum memory usage: 9205168 bytes
Current memory usage: 0 bytes |
| 2023-02-20 14:27:14
| drh | ok
|
| 9. Tests for platform MacOS ARM: |
| 2023-02-20 14:27:10
| drh | ok
|
| 9b. tclsh multitest.tcl --quick |
| 0 failures on 16 th3makes and 32524168 tests in (00:50:33) on minimac
SQLite 3.41.0 2023-02-19 19:16:51 b2534d8de5051a3516f4b9ee5a4b99e1dcf455e9af88c60815d2c2a479fc8566 |
| 2023-02-20 14:27:05
| drh | ok
|
| 9b. tclsh multitest.tcl --quick |
| 2023-02-20 14:24:07
| drh | ok
|
| 6i. CC=clang CFLAGS='-fsanitize=thread' ./configure && make threadtest5 && ./threadtest5 |
| 2023-02-20 14:22:30
| dan | ok
|
| 22b. testfixture ../zipvfs/test/zipvfs.test (See test/README.md for details) |
| 336s: build (1/1) f=0 r=0 script (48/48) f=0 r=0 |
| 2023-02-20 14:21:24
| dan | ok
|
| 22b. testfixture ../zipvfs/test/zipvfs.test (See test/README.md for details) |
| 0 failures: (1/1) f=0 r=0 script (48/48) f=0 r=0 |
| 2023-02-20 14:07:31
| drh | ok
|
| 6f. sh tool/symbols.sh - no incorrect exports or dependencies |
| 2023-02-20 14:04:48
| drh | ok
|
| 6c. tclsh multitest.tcl --scenario obscure |
| 2023-02-20 14:02:47
| drh | ok
|
| 6d. tclsh multitest.tcl --scenario failures - all failures detected |
| 2023-02-20 13:54:57
| drh | ok
|
| 6b. tclsh multitest.tcl --scenario coverage |
| 0 failures on 4 th3makes and 7246997 tests in (00:14:32) on r21
SQLite 3.41.0 2023-02-19 19:16:51 b2534d8de5051a3516f4b9ee5a4b99e1dcf455e9af88c60815d2c2a479fc8566 |
| 2023-02-20 13:54:36
| drh | ok
|
| 6a. tclsh multitest.tcl |
| 0 failures on 73 th3makes and 246784339 tests in (02:25:43) 8 cores on r20
SQLite 3.41.0 2023-02-19 19:16:51 b2534d8de5051a3516f4b9ee5a4b99e1dcf455e9af88c60815d2c2a479fc8566 |
| 2023-02-20 13:33:48
| dan | ok
|
| 6e. ./configure && make releasetest |
| 1803s: build (18/18) f=0 r=0 script (37433/37433) f=0 r=0 make (32/32) f=0 r=0 |
| 2023-02-20 13:32:54
| dan | ok
|
| 12a. make test |
| SQLite 2023-02-19 19:16:51 b2534d8de5051a3516f4b9ee5a4b99e1dcf455e9af88c60815d2c2a479fc8566
0 errors out of 214929 tests on openbsd.my.domain OpenBSD 32-bit little-endian |
| 2023-02-20 13:20:08
| drh | ok
|
| 8a. ./configure && make releasetest |
| 3869s: build (3/3) f=0 r=0 script (12352/12352) f=0 r=0 make (7/7) f=0 r=0 |
| 2023-02-20 13:19:52
| drh | ok
|
| 9a. ./configure && make releasetest |
| 1566s: build (3/3) f=0 r=0 script (12352/12352) f=0 r=0 make (7/7) f=0 r=0 |
| 2023-02-20 11:58:55
| dan | ok
|
| 14. 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" |
| SQLite 2023-02-19 19:16:51 b2534d8de5051a3516f4b9ee5a4b99e1dcf455e9af88c60815d2c2a479fc8566
0 errors out of 254342 tests on ws1 Linux 64-bit little-endian |
| 2023-02-19 21:04:32
| drh | ok
|
| 17. Sqllogictest: |
| 2023-02-19 21:04:30
| drh | ok
|
| 17d. tclsh run-all.tcl - on windows |
| 2023-02-19 21:04:27
| drh | ok
|
| 17c. tclsh run-all.tcl - on unix |
| 2023-02-19 21:04:25
| drh | ok
|
| 17b. No SQLite compiler warnings. |
| 2023-02-19 20:28:35
| drh | ok
|
| 17a. Checked in latest SQLite amalgamation. |
| 2023-02-19 20:25:29
| drh | ok
|
| 5. OMIT, ENABLE, and DISABLE options: |
| 2023-02-19 20:25:27
| drh | ok
|
| 5b. tclsh tool/omittest-msvc.tcl ← on Windows |
| 2023-02-19 20:22:12
| drh | ok
|
| 5a. tclsh ../tool/omittest.tcl -skip_run -target libsqlite3.a ← on Linux |
| 2023-02-19 19:31:08
| drh | ok
|
| 4. Compiler warning checks. |
| 2023-02-19 19:31:05
| drh | ok
|
| 4d. Clang-10.0.0: CFLAGS='-O0' ./configure --enable-debug --enable-all && scan-build make sqlite3 |
| 2023-02-19 19:31:03
| drh | ok
|
| 4c. Clang-6.0.0: CFLAGS='-O0' ./configure --enable-debug --enable-all && scan-build make sqlite3 |
| 2023-02-19 19:18:28
| drh | ok
|
| 4b. Mac OS X GCC -Wall -Wextra (the "tool/warnings.sh" script) |
| 2023-02-19 19:17:02
| drh | ok
|
| 4a. Linux GCC -Wall -Wextra (the "tool/warnings.sh" script) |
| 2023-02-19 19:06:52
| drh | ok
|
| 15. Trunk changes merged and verified on active branches: |
| 2023-02-19 19:06:49
| drh | ok
|
| 15g. reuse-schema-see (in the see-base repository) |
| 2023-02-19 19:06:47
| drh | ok
|
| 15f. client-see (in the see-base repository) |
| 2023-02-19 19:06:44
| drh | ok
|
| 15e. see (in the see-base repository) |
| 2023-02-18 21:59:37
| drh | ok
|
| 15d. reuse-schema (from trunk) |
| 2023-02-18 21:59:33
| drh | ok
|
| 15c. bedrock (from wal2) |
| 2023-02-18 21:59:31
| drh | ok
|
| 15b. wal2 (from trunk) |
| 2023-02-18 21:59:28
| drh | ok
|
| 15a. begin-concurrent (from trunk) |
| 2023-02-18 21:23:10
| drh | ok
|
| 16. Dbsqlfuzz tests |
| 2023-02-18 21:23:05
| drh | ok
|
| 16i. Win10/MSVC: fuzzcheck $CORPUS -spinner |
| 20230214.db: 60233/60233
fuzzcheck: 0 errors out of 60233 tests in 185.737 seconds
SQLite 3.41.0 2023-02-18 20:31:26 655991f5d9afdd3281049eb430921046e0ba90eef215020c2fb149adc0d3c4c5 |
| 2023-02-18 21:18:47
| drh | ok
|
| 16h. Mac: fuzzcheck $CORPUS --spinner |
| 20230214.db: 60233/60233
fuzzcheck: 0 errors out of 60233 tests in 70.483 seconds
SQLite 3.41.0 2023-02-18 20:31:26 655991f5d9afdd3281049eb430921046e0ba90eef215020c2fb149adc0d3c4c5 |
| 2023-02-18 21:16:49
| drh | ok
|
| 16g. CFLAGS='-Os -g -DSQLITE_VDBE_COVERAGE' make -e clean fuzzcheck && ./fuzzcheck $CORPUS --spinner |
| 20230214.db: 60233/60233
fuzzcheck: 0 errors out of 60233 tests in 195.630 seconds
SQLite 3.41.0 2023-02-18 20:31:26 655991f5d9afdd3281049eb430921046e0ba90eef215020c2fb149adc0d3c4c5 |
| 2023-02-18 21:08:22
| drh | ok
|
| 16c. valgrind fuzzcheck $CORPUS --spinner |
| 20230214.db: 60233/60233
fuzzcheck: 0 errors out of 60233 tests in 4901.970 seconds
SQLite 3.41.0 2023-02-18 15:50:23 315574d5cbe5c805ff2163052d986b054985984fb45bfb064d1a7b39a22b90eb |
| 2023-02-18 20:31:51
| drh | ok
|
| 3e. Requirements marks are up-to-date in both documentation and source code. Do this early so that necessary code changes are well validated by subsequent checklist items. |
| 2023-02-18 19:46:15
| drh | ok
|
| 2f. Verify that the azProhibitedFunctions list in the safeModeAuth() function of the CLI is complete and up-to-date. |
| 2023-02-18 19:28:19
| drh | ok
|
| 16f. CC=clang CFLAGS='-Os -g -fsanitize=memory' make -e clean fuzzcheck && ./fuzzcheck $CORPUS --spinner |
| 20230214.db: 60233/60233
fuzzcheck: 0 errors out of 60233 tests in 1202.307 seconds
SQLite 3.41.0 2023-02-18 15:50:23 315574d5cbe5c805ff2163052d986b054985984fb45bfb064d1a7b39a22b90eb |
| 2023-02-18 19:18:00
| drh | ok
|
| 1c. Review this checklist for completeness and accuracy. |
| 2023-02-18 16:07:15
| drh | ok
|
| 16e. CC=clang CFLAGS='-Os -g -fsanitize=address' make -e clean fuzzcheck && ./fuzzcheck $CORPUS --spinner |
| 20230214.db: 60233/60233
fuzzcheck: 0 errors out of 60233 tests in 607.738 seconds
SQLite 3.41.0 2023-02-18 15:50:23 315574d5cbe5c805ff2163052d986b054985984fb45bfb064d1a7b39a22b90eb |
| 2023-02-18 15:53:46
| drh | ok
|
| 16d. CC=clang CFLAGS='-Os -g -fsanitize=undefined' make -e clean fuzzcheck && ./fuzzcheck $CORPUS --spinner |
| 20230214.db: 60233/60233
fuzzcheck: 0 errors out of 60233 tests in 695.933 seconds
SQLite 3.41.0 2023-02-17 22:48:46 e0a0bf56f11f32f58705098e76c276deaf90cfa87e110032bdaad10ce967alt1 |
| 2023-02-18 15:30:01
| drh | ok
|
| 16b. Check-in CORPUS as an unversioned file in the dbsqlfuzz repository |
| 2023-02-18 15:29:56
| drh | ok
|
| 16a. Develop a new CORPUS database by running dbsqlfuzz for 10 billion iterations |
| CORPUS is 20230214.db |