| 2023-08-23 21:38:33
| drh | ok
|
| 3. Documentation review: |
| 2023-08-23 21:38:31
| drh | ok
|
| 3c. Release accouncement in "news.html". |
| 2023-08-23 14:09:21
| drh | ok
|
| 1d. Review dev-ops procedures and make any needed updates and corrections. |
| 2023-08-23 14:09:19
| drh | ok
|
| 1c. Review this checklist for completeness and accuracy. |
| 2023-08-23 14:09:16
| drh | ok
|
| 1b. Review "multitest.tcl" and "alignment*.rc" scripts in TH3 for completeness. |
| 2023-08-23 14:09:14
| drh | ok
|
| 1a. Review the "test/testrunner.tcl" script for completeness and accuracy. |
| 2023-08-23 14:09:12
| drh | ok
|
| 1. Test procedure review. |
| 2023-08-23 14:09:08
| drh | ok
|
| 3h. Check new/changed documentation for spelling and gramatical mistakes. |
| 2023-08-23 14:09:05
| drh | ok
|
| 3g. Test metrics are up-to-date (testing.html). |
| 2023-08-23 14:09:02
| drh | ok
|
| 3f. Database footprint is up-to-date (features.html). |
| 2023-08-23 14:08:59
| drh | ok
|
| 3e. The compile-time options are all up-to-date (compile.html). |
| 2023-08-23 14:08:56
| drh | ok
|
| 3d. No unresolved hyperlinks in the documentation build. |
| 2023-08-23 14:08:52
| drh | ok
|
| 3b. Release announcement in "changes.in". |
| 2023-08-23 14:08:50
| drh | ok
|
| 3a. Latest release on the "index.html" page. |
| 2023-08-23 14:07:53
| drh | ok
|
| 2m. Compare sqlite3.c and sqlite3.h against the previous release. |
| 2023-08-23 13:55:52
| drh | ok
|
| 2. Source code change review. fossil diff --from release --to trunk |
| 2023-08-23 13:55:50
| drh | ok
|
| 2f. Verify that the azProhibitedFunctions list in the safeModeAuth() function of the CLI is complete and up-to-date. |
| 2023-08-23 13:51:30
| drh | ok
|
| 2l. Significant compile-time options are recognized by the sqlite3_compileoption_used() interface. |
| 2023-08-23 13:51:26
| drh | ok
|
| 2k. Verify that the list of APIs exposed via the extension header is up-to-date (sqlite3ext.h). |
| 2023-08-23 13:51:22
| drh | ok
|
| 2j. Verify that source code contains no tabs and that surplus whitespace has been removed. |
| 2023-08-23 13:51:18
| 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-08-23 13:27:17
| drh | ok
|
| 2h. Check all calls to sqlite3OsRead() and sqlite3OsWrite() to ensure that offset computations are 64-bit clean. |
| 2023-08-23 13:25:28
| drh | ok
|
| 2g. Variables and functions have been renamed to reflect changes in their use. |
| 2023-08-23 13:23:42
| drh | ok
|
| 2e. Comments have been updated to reflect code changes. |
| 2023-08-23 13:23:38
| drh | ok
|
| 2d. New code complies with design rules. |
| 2023-08-23 13:23:35
| drh | ok
|
| 2c. New code complies with style guidelines. |
| 2023-08-23 13:23:32
| drh | ok
|
| 2b. All significant changes are mentioned in the "changes" log of the documentation. |
| 2023-08-23 13:23:27
| drh | ok
|
| 2a. No stray changes. |
| 2023-08-23 11:56:24
| drh | ok
|
| 6a. tclsh multitest.tcl |
| 0 failures on 73 th3makes and 249636209 tests in (01:19:33) 12 cores on r21 (32/64-bit)
SQLite 3.43.0 2023-08-22 13:41:18 055ae724ff34bd41a1d97180b90fce081861856ac67572a633d31f518c20aa1e
0 failures on 73 th3makes and 249634896 tests in (01:18:46) 12 cores on r21 (32/64-bit)
SQLite 3.43.0 2023-08-23 10:20:39 bb9dcdaf3244c4fc6872850a82b80c469203911e2f6e3a3211e508be39b59fa3 |
| 2023-08-22 20:08:59
| drh | ok
|
| 24. NDS-Devkit testing |
| 2023-08-22 20:08:57
| drh | ok
|
| 24c. Verify the "NDS DevKit" version number shown at the end of the test |
| 2023-08-22 20:08:54
| drh | ok
|
| 24b. Test using: tclsh th3make test.rc nds_devkit.rc |
| th3: 94b3e723377c277de2c7e1bef0f32f12be40fa061dc4be78b64d1c636fc1e316
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 11084832 tests. 6194.738 seconds on bella 64-bit little-endian
th3: NDS DevKit 3.43.0 2023-08-22 17:43:18 87b54f4f39bb3ef2
th3: SQLite 3.43.0 2023-08-22 16:00:00 963f5c6907185c28198494afd391d4d99554b2a57921f0b63551e4372db9f4ea |
| 2023-08-22 17:45:20
| drh | ok
|
| 24a. Merge all trunk enhancements into the reuse-schema branch and use that branch to update the devkit. |
| 2023-08-22 17:39:05
| drh | ok
|
| 6. Tests for platform Linux x86_64: |
| 2023-08-22 17:39:01
| drh | ok
|
| 6b. tclsh multitest.tcl --scenario coverage |
| Core coverage only. |
| 2023-08-22 17:38:52
| drh | ok
|
| 6g. ./configure --enable-debug --enable-all && make parse.c && CC=clang CFLAGS='-fsanitize=address,undefined' make -e test |
| SQLite 2023-08-22 16:44:33 724bc15701f3f647c741b614d4ac4fd98e1cdfe49a85f48c64fb1df5b83811b0
0 errors out of 308454 tests on r20 Linux 64-bit little-endian
All memory allocations freed - no leaks |
| 2023-08-22 17:05:39
| drh | ok
|
| 6d. tclsh multitest.tcl --scenario failures - all failures detected |
| 2023-08-22 17:00:08
| drh | ok
|
| 6c. tclsh multitest.tcl --scenario obscure |
| 2023-08-22 16:28:23
| drh | ok
|
| 6a. tclsh multitest.tcl |
| 0 failures on 73 th3makes and 249636209 tests in (01:19:33) 12 cores on r21 (32/64-bit)
SQLite 3.43.0 2023-08-22 13:41:18 055ae724ff34bd41a1d97180b90fce081861856ac67572a633d31f518c20aa1e |
| 2023-08-22 15:57:42
| drh | ok
|
| 6i. Test the reuse-schema branch with ./configure --enable-all && make "OPTS=-DSQLITE_ENABLE_SHARED_SCHEMA" sdevtest |
| 452s: build (2/2) f=0 r=0 script (2298/2298) f=0 r=0 make (2/2) f=0 r=0 |
| 2023-08-22 15:26:58
| drh | fail
|
| 6g. ./configure --enable-debug --enable-all && make parse.c && CC=clang CFLAGS='-fsanitize=address,undefined' make -e test |
| !Failures on these tests: sqldiff-2.0 sqldiff-2.1 |
| 2023-08-22 14:53:15
| drh | ok
|
| 32. Verify that the performance and size measurement spreadsheet in the documentation (misc/speed-size-graph.ods) is up-to-date. |
| 2023-08-22 14:43:22
| drh | ok
|
| 6l. 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-08-22 14:42:19
| drh | ok
|
| 6k. Run auxiliary test script in the /usr subdirectory of the TH3 repository |
| 2023-08-22 14:40:06
| drh | ok
|
| 6j. CC=clang CFLAGS='-fsanitize=thread' ./configure && make threadtest5 && ./threadtest5 |
| 2023-08-22 14:39:28
| drh | ok
|
| 6f. sh tool/symbols.sh - no incorrect exports or dependencies |
| 2023-08-22 14:31:44
| drh | ok
|
| 22. SEE tests using TH3: |
| 2023-08-22 14:31:41
| drh | ok
|
| 22c. see-aes256-ofb.c |
| th3: 94b3e723377c277de2c7e1bef0f32f12be40fa061dc4be78b64d1c636fc1e316
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 2459363 tests. 238.543 seconds on minimac 64-bit little-endian
th3: SQLite 3.43.0 2023-08-21 17:22:32 ed3782f2df67bf841be6acc3b1ae345002f8f30891f8caf8e4767c5a9cfcbc92 |
| 2023-08-22 14:31:18
| drh | ok
|
| 22e. see-aes128-ccm.c |
| th3: 7daec470ddcbeffc0fcb8235e04ff2730513d5a1f3f76d55b4fe3392b9678370
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 2486610 tests. 681.238 seconds on w23 64-bit little-endian
th3: SQLite 3.43.0 2023-08-21 17:22:32 ed3782f2df67bf841be6acc3b1ae345002f8f30891f8caf8e4767c5a9cfcbc92 |
| 2023-08-22 14:28:11
| dan | ok
|
| 6h. Test the reuse-schema branch with ./configure --enable-all && make "OPTS=-DSQLITE_ENABLE_SHARED_SCHEMA" test. (This test should be omitted in the next release. The following test is sufficient.) |
| SQLite 2023-08-21 17:53:26 e94f09f18856881bb6bf135405036b3965abb336a3d4c66615cb698bcd516910
0 errors out of 307989 tests on ws1 Linux 64-bit little-endian |
| 2023-08-22 14:25:40
| drh | ok
|
| 22b. see-aes128-ofb.c |
| th3: 94b3e723377c277de2c7e1bef0f32f12be40fa061dc4be78b64d1c636fc1e316
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 2478650 tests. 340.165 seconds on r20 64-bit little-endian
th3: SQLite 3.43.0 2023-08-21 17:22:32 ed3782f2df67bf841be6acc3b1ae345002f8f30891f8caf8e4767c5a9cfcbc92 |
| 2023-08-22 14:24:34
| drh | ok
|
| 22j. At least one of the above using "test.rc". |
| 2023-08-22 14:24:31
| drh | ok
|
| 22m. At least one of the above on Mac OS X. |
| 2023-08-22 14:24:28
| drh | ok
|
| 22f. see-cccrypt.c |
| th3: 94b3e723377c277de2c7e1bef0f32f12be40fa061dc4be78b64d1c636fc1e316
th3: ./th3make see.rc test.rc
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 cfg/?*.cfg extra1/?*.cfg bugs/?*.test cov1/?*.test extra1/?*.test fts/?*.test req1/?*.test demo/?*.test
th3: 0 errors in 9817939 tests. 2547.485 seconds on minimac 64-bit little-endian
th3: SQLite 3.43.0 2023-08-21 17:22:32 ed3782f2df67bf841be6acc3b1ae345002f8f30891f8caf8e4767c5a9cfcbc92 |
| 2023-08-22 14:15:10
| drh | ok
|
| 22n. At least one of the above on Windows. |
| 2023-08-22 14:15:05
| drh | ok
|
| 22a. see.c |
| th3: 94b3e723377c277de2c7e1bef0f32f12be40fa061dc4be78b64d1c636fc1e316
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 2478694 tests. 360.090 seconds on r20 64-bit little-endian
th3: SQLite 3.43.0 2023-08-21 17:22:32 ed3782f2df67bf841be6acc3b1ae345002f8f30891f8caf8e4767c5a9cfcbc92 |
| 2023-08-22 14:14:10
| dan | ok
|
| 26. TEA archive builds correctly and runs: |
| 2023-08-22 14:14:08
| dan | ok
|
| 26d. Windows MSVC |
| [nmake /f makefile.vc INSTALLDIR=c:UsersDanDesktop cl868_64 install] built and installed the extension. |
| 2023-08-22 14:10:43
| drh | ok
|
| 22h. see-aes256-cryptoapi.c |
| th3: 7daec470ddcbeffc0fcb8235e04ff2730513d5a1f3f76d55b4fe3392b9678370
th3: th3make see.rc msvc.rc quick.rc
th3: mkth3.tcl -DSQLITE_HAS_CODEC -D_CRT_SECURE_NO_DEPRECATE -D_CRT_SECURE_NO_WARNINGS -D_CRT_NONSTDC_NO_DEPRECATE -D_CRT_NONSTDC_NO_WARNINGS -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 2486530 tests. 614.640 seconds on w23 64-bit little-endian
th3: SQLite 3.43.0 2023-08-21 17:22:32 ed3782f2df67bf841be6acc3b1ae345002f8f30891f8caf8e4767c5a9cfcbc92 |
| 2023-08-22 14:07:12
| drh | ok
|
| 22k. At least one of the above with option -DSQLITE_DIRECT_OVERFLOW_READ. |
| 2023-08-22 14:07:09
| drh | ok
|
| 22i. Verify that builds work with -DSQLITE_ENABLE_UPDATE_DELETE_LIMIT |
| 2023-08-22 14:07:05
| drh | ok
|
| 22d. see-rc4.c |
| th3: 94b3e723377c277de2c7e1bef0f32f12be40fa061dc4be78b64d1c636fc1e316
th3: ./th3make see.rc quick.rc -DSQLITE_ENABLE_UPDATE_DELETE_LIMIT -DSQLITE_DIRECT_OVERFLOW_READ
th3: mkth3.tcl -DSQLITE_HAS_CODEC -DSQLITE_DEBUG -DSQLITE_ENABLE_BYTECODE_VTAB -DSQLITE_ENABLE_DESERIALIZE -DSQLITE_ENABLE_STMTVTAB -DTH3_SELFCOVERAGE -DSQLITE_ENABLE_UPDATE_DELETE_LIMIT -DSQLITE_DIRECT_OVERFLOW_READ cfg/c?.cfg cfg/wal1.cfg cfg/f2fs.cfg coverage.testplan cov1/?*.test
th3: 0 errors in 2489593 tests. 402.039 seconds on r20 64-bit little-endian
th3: SQLite 3.43.0 2023-08-21 17:22:32 ed3782f2df67bf841be6acc3b1ae345002f8f30891f8caf8e4767c5a9cfcbc92 |
| 2023-08-22 14:07:01
| dan | ok
|
| 25. Amalgamation autoconf tarball. |
| 2023-08-22 14:06:58
| dan | ok
|
| 25d. Works on Windows MSVC |
| 2023-08-22 14:01:12
| drh | ok
|
| 21. CEROD tests in the "test/" subdirectory. |
| 2023-08-22 14:00:55
| dan | ok
|
| 26c. Mac OS X |
| 2023-08-22 13:59:19
| dan | ok
|
| 25c. Works on Mac OS X. |
| 2023-08-22 13:56:38
| drh | ok
|
| 22l. At least one of the above on Linux. |
| 2023-08-22 13:56:34
| drh | ok
|
| 22g. see-aes256-openssl.c |
| th3: 94b3e723377c277de2c7e1bef0f32f12be40fa061dc4be78b64d1c636fc1e316
th3: ./th3make see.rc quick.rc -lcrypto
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 2478672 tests. 309.696 seconds on r20 64-bit little-endian
th3: SQLite 3.43.0 2023-08-21 17:22:32 ed3782f2df67bf841be6acc3b1ae345002f8f30891f8caf8e4767c5a9cfcbc92 |
| 2023-08-22 13:48:29
| dan | ok
|
| 26b. Linux |
| 2023-08-22 13:47:08
| dan | ok
|
| 26a. Verify that the SQLite version number is correct in autoconf/tea/configure.ac |
| 3.43.0 |
| 2023-08-22 13:39:48
| dan | ok
|
| 25b. Works on Linux. |
| 2023-08-22 13:39:47
| dan | ok
|
| 25a. Builds. |
| 2023-08-22 13:38:38
| drh | ok
|
| 37. Build the "atrc" test program and run "./atrc $DB | ./sqlite3 $DB" against multiple databases, visually verify the result |
| 2023-08-22 13:31:03
| drh | ok
|
| 28. Run make wordcount and do tests on current and prior versions: |
| 2023-08-22 13:31:00
| drh | ok
|
| 28b. rm -f wc.db && ./wordcount wc.db $BIGTEXT --all --cachesize 5 --nosync |
| 2023-08-22 13:29:04
| drh | ok
|
| 28a. rm -f wc.db && ./wordcount wc.db $BIGTEXT --all |
| 2023-08-22 13:26:50
| drh | ok
|
| 29. Compare performance to the previous release using kvtest. |
| 2023-08-22 13:26:48
| drh | ok
|
| 29c. Windows |
| 2023-08-22 13:24:12
| drh | ok
|
| 29b. Mac |
| 2023-08-22 13:22:12
| drh | ok
|
| 29a. Linux |
| 2023-08-22 13:14:35
| drh | ok
|
| 27. Performance tests using speedtest1 compared against the previous release and a release from about one year ago. |
| 2023-08-22 13:14:33
| drh | ok
|
| 27e. Windows with --testset rtree |
| 2023-08-22 13:13:28
| drh | ok
|
| 27d. Windows |
| 2023-08-22 13:00:32
| drh | ok
|
| 30. Check JSON performance |
| 2023-08-22 13:00:30
| drh | ok
|
| 30c. Verify that the JSON parser performance claimed in the json1.html file of the documentation is accurate |
| 2023-08-22 13:00:26
| drh | ok
|
| 30b. Verify JSON performance against the previous release |
| 2023-08-22 13:00:20
| drh | ok
|
| 30a. Run the procedures described in test/json/README.md |
| More than 2x faster |
| 2023-08-22 12:58:27
| drh | ok
|
| 27c. Mac |
| 2023-08-22 12:58:13
| drh | ok
|
| 27b. Linux with --testset rtree |
| Slightly slower. Mostly this is due to slower binary-to-decimal conversion
of floating point values. The new routines are more accurate, and they are
still 4x faster than the standard C-library. Consider this an opportunity
for improvement in the next release. Did not show up during development
because ordinary speedtest1 does not do all that much floating-point
conversion. |
| 2023-08-22 11:41:52
| dan | ok
|
| 40. Website built procedures |
| 2023-08-22 11:41:47
| dan | ok
|
| 40d. All build products work on their target platforms |
| 2023-08-22 11:28:32
| dan | ok
|
| 40c. Compile-time options for build products have been updated as necessary |
| 2023-08-22 11:28:22
| dan | ok
|
| 40a. Compile-time options in builds/products_build.sh in the supportdb repository has been updated to align with any changes to the default makefiles. |
| The only such change to default makefiles this release cycle was to
add SQLITE_USE_SEH to Makefile.msc. Not using this for the website
builds as we use mingw, which does not support SEH properly. |
| 2023-08-22 11:28:09
| dan | ok
|
| 40a. Compile-time options in builds/products_build.sh in the supportdb repository has been updated to align with any changes to the default makefiles. |
| The only such change to default makefiles this release cycle was to add SQLITE_USE_SEH to Makefile.msc. Not using this for the website builds as we use mingw, which does not support SEH properly. |
| 2023-08-22 11:20:43
| dan | ok
|
| 40b. tools/mkmsvcmin.tcl has been run to update the MSVC makefiles in autoconf |
| 2023-08-22 11:19:08
| dan | ok
|
| 40a. Compile-time options in builds/products_build.sh in the supportdb repository has been updated to align with any changes to the default makefiles. |
| No such changes to default makefiles this release cycle. |
| 2023-08-22 11:16:39
| dan | ok
|
| 38. Run the rbu/run_rbu_tests.tcl script in the test-dbs project on Linux. |
| All tests report "round trip test successful.". |
| 2023-08-22 11:01:08
| dan | ok
|
| 34. Verify that databases (including FTS3 and RTREE databases), rollback journals, and WAL files created by the release candidate are readable and writeable by historical versions of SQLite (as long as no unsupported features are used) and vice versa. |
| Tested against 3.41.0, 3.15.0 and 3.8.1 using backcompat.test.
SQLite 2023-08-21 16:14:58 f5c50349b1e4da233b554f371be49297b8b40ca5fe0188899ed906f682bf70d6
0 errors out of 403 tests on ws1 Linux 64-bit little-endian |
| 2023-08-22 10:21:28
| drh | ok
|
| 23. ZIPVFS tests: |
| 2023-08-22 10:21:22
| drh | ok
|
| 23d. th3make zipvfs.rc quick1.rc -valgrind |
| th3: 94b3e723377c277de2c7e1bef0f32f12be40fa061dc4be78b64d1c636fc1e316
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 2015090 tests. 14851.994 seconds on r20 64-bit little-endian
th3: SQLite 3.43.0 2023-08-21 16:14:58 f5c50349b1e4da233b554f371be49297b8b40ca5fe0188899ed906f682bf70d6 |
| 2023-08-21 23:46:14
| drh | ok
|
| 27a. Linux |
| 2023-08-21 20:31:04
| drh | ok
|
| 39. 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-08-21 20:29:19
| drh | ok
|
| 35. Build and verify correct operation of sqlite3_analyzer on: |
| 2023-08-21 20:29:17
| drh | ok
|
| 35b. Mac OS X |
| 2023-08-21 20:29:14
| drh | ok
|
| 36. Build and verify sqldiff |
| 2023-08-21 20:29:12
| drh | ok
|
| 36b. Mac |
| 2023-08-21 20:28:43
| drh | ok
|
| 35a. Linux |
| 2023-08-21 20:28:40
| drh | ok
|
| 36a. Linux |
| 2023-08-21 20:26:58
| drh | ok
|
| 33. Verify that the amalgamation builds are byte-for-byte identical on all workstation platforms. |
| 2023-08-21 20:26:56
| drh | ok
|
| 33d. Mac OS X (PPC) |
| 1fd5d41604dbe61b3477698c0ec1850c6de0381557ced1a72fcc49d98febbc25 sqlite3.c
9b5b6a412dbee8d03dff546c52ffa7b29c2ec2c7fa79defed9037ec6e0c807f4 sqlite3.h |
| 2023-08-21 20:26:33
| drh | ok
|
| 33f. Windows using NMAKE. |
| 1fd5d41604dbe61b3477698c0ec1850c6de0381557ced1a72fcc49d98febbc25 sqlite3.c
9b5b6a412dbee8d03dff546c52ffa7b29c2ec2c7fa79defed9037ec6e0c807f4 sqlite3.h |
| 2023-08-21 20:25:32
| drh | ok
|
| 33a. Linux (x64) |
| 1fd5d41604dbe61b3477698c0ec1850c6de0381557ced1a72fcc49d98febbc25 sqlite3.c
9b5b6a412dbee8d03dff546c52ffa7b29c2ec2c7fa79defed9037ec6e0c807f4 sqlite3.h |
| 2023-08-21 20:24:59
| drh | ok
|
| 33b. Linux (ARM) |
| 1fd5d41604dbe61b3477698c0ec1850c6de0381557ced1a72fcc49d98febbc25 sqlite3.c
9b5b6a412dbee8d03dff546c52ffa7b29c2ec2c7fa79defed9037ec6e0c807f4 sqlite3.h |
| 2023-08-21 20:24:54
| drh | ok
|
| 33c. Mac OS X |
| 1fd5d41604dbe61b3477698c0ec1850c6de0381557ced1a72fcc49d98febbc25 sqlite3.c
9b5b6a412dbee8d03dff546c52ffa7b29c2ec2c7fa79defed9037ec6e0c807f4 sqlite3.h |
| 2023-08-21 20:24:45
| drh | ok
|
| 33e. Mac OS X (ARM) |
| 1fd5d41604dbe61b3477698c0ec1850c6de0381557ced1a72fcc49d98febbc25 sqlite3.c
9b5b6a412dbee8d03dff546c52ffa7b29c2ec2c7fa79defed9037ec6e0c807f4 sqlite3.h |
| 2023-08-21 20:22:44
| drh | ok
|
| 31. Use the ".selftest" command of the shell to verify that legacy database files are readable and cross-platform |
| 2023-08-21 20:22:41
| drh | ok
|
| 31f. Windows 32-bit |
| 2023-08-21 20:22:13
| drh | ok
|
| 31d. Mac x64 |
| 2023-08-21 20:22:11
| drh | ok
|
| 31g. Windows 64-bit |
| 2023-08-21 20:19:52
| drh | ok
|
| 31e. Mac ARM |
| 2023-08-21 20:18:52
| drh | ok
|
| 31b. Linux x64 |
| 2023-08-21 20:18:48
| drh | ok
|
| 31c. Linux ARM |
| 2023-08-21 19:54:47
| dan | review
|
| 23d. th3make zipvfs.rc quick1.rc -valgrind |
| th3: 128 errors in 2015084 tests. 11609.909 seconds on ws1 64-bit little-endian
th3: SQLite 3.43.0 2023-08-21 16:14:58 f5c50349b1e4da233b554f371be49297b8b40ca5fe0188899ed906f682bf70d6
All errors are in expr31.test. All are due to very small rounding errors in real values. |
| 2023-08-21 19:52:14
| dan | ok
|
| 23h. At least one of the above on Windows. |
| 23c |
| 2023-08-21 19:52:04
| dan | ok
|
| 23c. th3make zipvfs.rc test.rc |
| slice5: 0 errors in 1169532 tests. 1012.976 seconds on DESKTOP-C1KR53M 64-bit little-endian
slice3: 0 errors in 1407666 tests. 1273.468 seconds on DESKTOP-C1KR53M 64-bit little-endian
slice4: 0 errors in 1637905 tests. 1328.943 seconds on DESKTOP-C1KR53M 64-bit little-endian
slice2: 0 errors in 1362349 tests. 1460.861 seconds on DESKTOP-C1KR53M 64-bit little-endian
slice6: 0 errors in 1595785 tests. 1500.432 seconds on DESKTOP-C1KR53M 64-bit little-endian
slice7: 0 errors in 1497718 tests. 1558.957 seconds on DESKTOP-C1KR53M 64-bit little-endian
slice1: 0 errors in 2044017 tests. 1723.670 seconds on DESKTOP-C1KR53M 64-bit little-endian
slice0: 0 errors in 2052174 tests. 2187.832 seconds on DESKTOP-C1KR53M 64-bit little-endian
totals: 0 errors out of 12767146 total tests in 2215 sec |
| 2023-08-21 19:33:37
| dan | ok
|
| 23g. At least one of the above on Mac OS X. |
| 23e |
| 2023-08-21 19:33:30
| dan | ok
|
| 23e. th3make zipvfs.rc quick.rc |
| th3: 0 errors in 3827718 tests. 1068.455 seconds on Dans-iMac.local 64-bit little-endian
th3: SQLite 3.43.0 2023-08-21 16:14:58 f5c50349b1e4da233b554f371be49297b8b40ca5fe0188899ed906f682bf70d6 |
| 2023-08-21 19:14:38
| drh | ok
|
| 35c. Windows |
| 2023-08-21 19:11:48
| drh | ok
|
| 36c. Windows |
| 2023-08-21 19:07:18
| drh | ok
|
| 16. Trunk changes merged and verified on active branches. See https://sqlite.org/devops/doc/trunk/build/release-actions-drh.md for detailed instructions. |
| 2023-08-21 19:07:15
| drh | ok
|
| 16g. reuse-schema-see (in the see-base repository) |
| 2023-08-21 19:07:11
| drh | ok
|
| 16c. bedrock (from wal2) |
| 2023-08-21 18:26:40
| drh | ok
|
| 16b. wal2 (from trunk) |
| 2023-08-21 18:26:38
| drh | ok
|
| 16a. begin-concurrent (from trunk) |
| 2023-08-21 17:58:37
| drh | ok
|
| 12. Tests for platform Windows (64-bit): |
| 2023-08-21 17:58:34
| drh | ok
|
| 12b. tclsh multitest.tcl --msvc --scenario failures - verify failures detected |
| 2023-08-21 17:58:09
| drh | ok
|
| 12a. tclsh multitest.tcl --msvc --quick |
| 0 failures on 17 th3makes and 33701430 tests in (00:40:40) 8 cores on w23 (64-bit)
SQLite 3.43.0 2023-08-21 16:14:58 f5c50349b1e4da233b554f371be49297b8b40ca5fe0188899ed906f682bf70d6 |
| 2023-08-21 17:53:41
| drh | ok
|
| 16d. reuse-schema (from trunk) |
| 2023-08-21 17:38:00
| drh | ok
|
| 16f. client-see (in the see-base repository) |
| 2023-08-21 17:37:41
| drh | ok
|
| 18. Sqllogictest: |
| 2023-08-21 17:37:37
| drh | ok
|
| 18a. Checked in latest SQLite amalgamation. |
| 2023-08-21 17:37:35
| drh | ok
|
| 18b. No SQLite compiler warnings. |
| 2023-08-21 17:37:32
| drh | ok
|
| 18c. tclsh run-all.tcl |
| 2023-08-21 17:28:54
| drh | ok
|
| 16e. see (in the see-base repository) |
| 2023-08-21 17:03:33
| drh | ok
|
| 17. Dbsqlfuzz tests |
| 2023-08-21 17:03:30
| drh | ok
|
| 17i. Win10/MSVC: fuzzcheck $CORPUS -spinner |
| 2023-08-21 16:59:35
| drh | ok
|
| 17h. Mac: fuzzcheck $CORPUS --spinner |
| 2023-08-21 16:59:16
| drh | ok
|
| 12d. Verify that EXEs and DLLs generated using MSVC contain the correct version number, product name, description, and copyright as resources. |
| 2023-08-21 16:58:04
| drh | ok
|
| 12c. nmake /f Makefile.msc verify-source releasetest |
| 2748s: build (6/6) f=0 r=0 script (7060/7060) f=0 r=0 make (10/10) f=0 r=0 |
| 2023-08-21 16:54:46
| drh | ok
|
| 17g. CFLAGS='-Os -g -DSQLITE_VDBE_COVERAGE' make -e clean fuzzcheck && ./fuzzcheck $CORPUS --spinner |
| 2023-08-21 16:52:09
| drh | ok
|
| 31a. iBook PPC |
| 2023-08-21 16:52:01
| drh | ok
|
| 10. Tests for platform MacOS (PPC): |
| 2023-08-21 16:51:58
| drh | ok
|
| 10a. .selftest checks (see below) |
| 2023-08-21 16:49:44
| drh | ok
|
| 17e. CC=clang CFLAGS='-Os -g -fsanitize=address' make -e clean fuzzcheck && ./fuzzcheck $CORPUS --spinner |
| 2023-08-21 16:49:41
| drh | ok
|
| 17f. CC=clang CFLAGS='-Os -g -fsanitize=memory' make -e clean fuzzcheck && ./fuzzcheck $CORPUS --spinner |
| 2023-08-21 16:49:27
| drh | ok
|
| 17d. CC=clang CFLAGS='-Os -g -fsanitize=undefined' make -e clean fuzzcheck && ./fuzzcheck $CORPUS --spinner |
| 2023-08-21 16:31:29
| dan | ok
|
| 23f. At least one of the above on Linux. |
| 23b |
| 2023-08-21 16:31:22
| dan | ok
|
| 23b. testfixture test/testrunner.tcl --zipvfs <ZIPVFS-source-directory> zipvfs |
| 147s: build (1/1) f=0 r=0 script (48/48) f=0 r=0 |
| 2023-08-21 16:30:11
| drh | ok
|
| 10c. Verify that Fossil repositories are cross-platform with x86/x64. |
| 2023-08-21 16:30:08
| drh | ok
|
| 10b. Recompile and test Fossil. |
| 2023-08-21 16:28:35
| drh | ok
|
| 7. Tests for platform Linux ARM (BeagleBoard or RaspberryPI) |
| 2023-08-21 16:28:32
| drh | ok
|
| 7a. tclsh th3make min.rc -DTH3_LOWMEM --unobfuscated |
| th3: 0 errors in 2205898 tests. 1384.839 seconds on pi4 32-bit little-endian
th3: SQLite 3.43.0 2023-08-21 14:40:19 a6fb9de8f87261194e6034376f62b1cac30b764f106dd3adcf728e020f8a4fd5 |
| 2023-08-21 16:25:13
| dan | ok
|
| 23a. Verify that the configure script version number agrees with the SQLite version number |
| It does. 3.43.0. |
| 2023-08-21 15:55:34
| drh | ok
|
| 5. OMIT, ENABLE, and DISABLE options: |
| 2023-08-21 15:55:32
| drh | ok
|
| 5c. tclsh tool/omittest-msvc.tcl ← on Windows |
| 2023-08-21 15:30:17
| dan | ok
|
| 13. Tests for platform OpenBSD (x86): |
| 2023-08-21 15:30:14
| dan | ok
|
| 13b. th3make quick.rc |
| th3: 0 errors in 2533105 tests. 584.001 seconds on foo.. 64-bit little-endian
th3: SQLite 3.43.0 2023-08-21 14:40:19 a6fb9de8f87261194e6034376f62b1cac30b764f106dd3adcf728e020f8a4fd5 |
| 2023-08-21 14:56:38
| dan | ok
|
| 13a. make test |
| SQLite 2023-08-21 14:40:19 a6fb9de8f87261194e6034376f62b1cac30b764f106dd3adcf728e020f8a4fd5
0 errors out of 256944 tests on foo.. OpenBSD 64-bit little-endian |
| 2023-08-21 14:50:42
| drh | fail
|
| 5c. tclsh tool/omittest-msvc.tcl ← on Windows |
| During SQLITE_OMIT_WAL:
sqlite3.c(63960): warning C4013: 'sqlite3WalSystemErrno' undefined; assuming extern returning int
sqlite3.c(63960): error C2039: 'pWal': is not a member of 'Pager' |
| 2023-08-21 14:45:04
| drh | ok
|
| 7b. Recompile and test Fossil. |
| 2023-08-21 14:35:17
| drh | ok
|
| 11. Tests for platform Windows (32-bit): |
| 2023-08-21 14:35:14
| drh | ok
|
| 11d. Verify that EXEs and DLLs generated using MSVC contain the correct version number, product name, description, and copyright as resources. |
| 2023-08-21 14:31:35
| drh | ok
|
| 8. Tests for platform MacOS x64: |
| 2023-08-21 14:31:32
| drh | ok
|
| 8a. ./configure && make verify-source releasetest |
| 6221s: build (3/3) f=0 r=0 script (12271/12271) f=0 r=0 make (7/7) f=0 r=0 |
| 2023-08-21 14:27:42
| drh | ok
|
| 11b. tclsh multitest.tcl --msvc --scenario failures - verify failures detected |
| 2023-08-21 14:27:06
| drh | ok
|
| 11a. tclsh multitest.tcl --msvc --quick |
| 0 failures on 16 th3makes and 32859670 tests in (00:44:40) 8 cores on w23 (32-bit)
SQLite 3.43.0 2023-08-19 08:12:10 c319033276c3565d0f1f2cae1c91791940d322fe79696bc26d74fddeb2664373 |
| 2023-08-21 12:26:18
| drh | pending
|
| 8a. ./configure && make verify-source releasetest |
| 2023-08-21 12:13:15
| drh | ok
|
| 8c. tclsh multitest.tcl --scenario failures - all failures detected |
| 2023-08-21 12:12:42
| drh | ok
|
| 8b. tclsh multitest.tcl --quick |
| 0 failures on 16 th3makes and 33212028 tests in (02:26:55) on SQLite-iMac-2018 (64-bit)
SQLite 3.43.0 2023-08-18 15:39:38 c48f1be8cc505a7e2902c79e26c1d9a121ff5c55785ac812d2e09232b2414695 |
| 2023-08-21 12:05:08
| drh | ok
|
| 9. Tests for platform MacOS ARM: |
| 2023-08-21 12:05:04
| drh | ok
|
| 9b. tclsh multitest.tcl --quick |
| 0 failures on 16 th3makes and 33211717 tests in (00:13:39) 8 cores on minimac (64-bit)
SQLite 3.43.0 2023-08-19 08:12:10 c319033276c3565d0f1f2cae1c91791940d322fe79696bc26d74fddeb2664373 |
| 2023-08-21 12:03:42
| drh | ok
|
| 5b. tclsh ../tool/omittest.tcl -skip_run -target libsqlite3.a ← on Linux |
| 2023-08-21 12:03:38
| drh | ok
|
| 5a. Recent compile-time options have been added to the omittest.tcl and omittest-msvc.tcl scripts and checked in. |
| 2023-08-21 12:03:03
| drh | fail
|
| 11a. tclsh multitest.tcl --msvc --quick |
| AddressSanitizer out of memory in t60.c1.fuzz01 |
| 2023-08-21 11:57:46
| drh | ok
|
| 6e. ./configure && make verify-source releasetest |
| 2941s: build (18/18) f=0 r=0 script (37121/37121) f=0 r=0 make (32/32) f=0 r=0 |
| 2023-08-21 11:53:01
| drh | pending
|
| 11a. tclsh multitest.tcl --msvc --quick |
| 2023-08-21 11:52:54
| drh | prelim
|
| 11a. tclsh multitest.tcl --msvc --quick |
| 2023-08-21 11:51:48
| drh | ok
|
| 11c. nmake /f Makefile.msc verify-source releasetest |
| 2474s: build (6/6) f=0 r=0 script (7060/7060) f=0 r=0 make (10/10) f=0 r=0 |
| 2023-08-21 11:41:14
| drh | ok
|
| 9a. ./configure && make verify-source releasetest |
| 1881s: build (3/3) f=0 r=0 script (12271/12271) f=0 r=0 make (7/7) f=0 r=0 |
| 2023-08-21 11:29:08
| drh | ok
|
| 17c. valgrind fuzzcheck $CORPUS --spinner |
| 2023-08-21 11:02:17
| drh | ok
|
| 4. Compiler warning checks. |
| 2023-08-21 11:02:15
| drh | ok
|
| 4c. Clang-6.0.0: CFLAGS='-O0' ./configure --enable-debug --enable-all && scan-build make sqlite3 |
| 2023-08-21 11:01:30
| drh | pending
|
| 6e. ./configure && make verify-source releasetest |
| 2023-08-21 11:01:04
| drh | pending
|
| 9a. ./configure && make verify-source releasetest |
| 2023-08-21 11:00:44
| drh | pending
|
| 11c. nmake /f Makefile.msc verify-source releasetest |
| 2023-08-21 10:59:39
| dan | ok
|
| 15. 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-08-19 08:12:10 c319033276c3565d0f1f2cae1c91791940d322fe79696bc26d74fddeb2664373
0 errors out of 256228 tests on ws1 Linux 64-bit little-endian |
| 2023-08-21 10:39:52
| drh | ok
|
| 20. Wapp updated to use the latest SQLite |
| 2023-08-21 10:39:50
| drh | ok
|
| 20a. Used on active websites with no issues |
| 2023-08-21 10:39:43
| drh | ok
|
| 19. Fossil updated to use the latest SQLite. |
| 2023-08-21 10:39:41
| drh | ok
|
| 19c. fossil all test-integrity -d |
| 2023-08-21 10:39:38
| drh | ok
|
| 19b. Used on active websites with no issues. |
| 2023-08-21 10:39:35
| drh | ok
|
| 19a. No SQLite compiler warnings. |
| 2023-08-21 10:38:46
| drh | ok
|
| 14. WASM |
| 2023-08-21 10:38:21
| drh | 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. |
| 2023-08-21 10:36:00
| drh | pending
|
| 17c. valgrind fuzzcheck $CORPUS --spinner |
| 2023-08-21 10:34:44
| drh | ok
|
| 4d. Clang-10.0.0: CFLAGS='-O0' ./configure --enable-debug --enable-all && scan-build make sqlite3 |
| 2023-08-21 10:33:23
| drh | ok
|
| 17b. Check-in CORPUS as an unversioned file in the dbsqlfuzz repository |
| 2023-08-21 10:33:19
| drh | ok
|
| 17a. Develop a new CORPUS database by running dbsqlfuzz for 10 billion iterations |
| 2023-08-21 10:30:14
| drh | ok
|
| 4a. Linux GCC -Wall -Wextra (the "tool/warnings.sh" script) |
| 2023-08-21 10:30:02
| drh | ok
|
| 4b. Mac OS X GCC -Wall -Wextra (the "tool/warnings.sh" script) |
| 2023-08-15 21:15:46
| stephan | retest
|
| 14. WASM |
| (inadvertently marked as completed) |
| 2023-08-15 21:15:11
| stephan | pending
|
| 14a. Build and install Fiddle according to website maintenance instructions at https://sqlite.org/devops/doc/trunk/build/website-build.md. Run simple tests. |
| (inadvertently clicked this one) |
| 2023-08-15 21:05:55
| stephan | ok
|
| 14. WASM |
| 2023-08-15 21:05:44
| stephan | ok
|
| 14d. Click on the test links - confirm correct results. |
| 2023-08-15 21:05:42
| stephan | ok
|
| 14c. althttpd --enable-sab --page index.html |
| 2023-08-15 21:05:39
| stephan | ok
|
| 14b. (On Linux) ./configure --enable-all && cd ext/wasm && make |
| 2023-08-15 21:05:35
| 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. |