2023-05-16 12:34:35
| drh | ok
|
39. Website built procedures |
2023-05-16 12:34:33
| drh | ok
|
39b. tools/mkmsvcmin.tcl has been run to update the MSVC makefiles in autoconf |
2023-05-16 11:15:56
| dan | ok
|
39d. All build products work on their target platforms |
They do. |
2023-05-16 11:07:52
| dan | ok
|
12. Tests for platform OpenBSD (x86): |
2023-05-16 11:07:49
| dan | ok
|
12b. th3make quick.rc |
th3: 49aa6899a188f63a1bd9880b7bae7ad6a736c40cf2ef11f5ff8d9b072f698ead
th3: ./th3make 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 2494601 tests. 721.777 seconds on openbsd.my.domain 32-bit little-endian
th3: SQLite 3.42.0 2023-05-15 19:17:31 1d3e008905461ebbd3ea0a862672f740fa72914d4d59fcf800e1ce56f1edfc9d |
2023-05-16 11:07:09
| dan | ok
|
39c. Compile-time options for build products have been updated as necessary |
Shell tool builds updated to include -DSQLITE_ENABLE_STMT_SCANSTATUS |
2023-05-16 11:05:38
| 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. |
No changes in default makefiles. |
2023-05-16 11:00:34
| 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-05-15 19:17:31 1d3e008905461ebbd3ea0a862672f740fa72914d4d59fcf800e1ce56f1edfc9d
0 errors out of 254688 tests on ws1 Linux 64-bit little-endian |
2023-05-16 11:00:11
| 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.8.2 and 3.7.2 using backcompat.test. SQLite 2023-05-15 19:17:31 1d3e008905461ebbd3ea0a862672f740fa72914d4d59fcf800e1ce56f1edfc9d 0 errors out of 265 tests on ws1 Linux 64-bit little-endian |
2023-05-16 10:49:51
| dan | ok
|
12a. make test |
SQLite 2023-05-15 19:17:31 1d3e008905461ebbd3ea0a862672f740fa72914d4d59fcf800e1ce56f1edfc9d
0 errors out of 215279 tests on openbsd.my.domain OpenBSD 32-bit little-endian |
2023-05-16 10:48:26
| drh | ok
|
3. Documentation review: |
2023-05-16 10:48:24
| drh | ok
|
3c. Release accouncement in "news.html". |
2023-05-16 10:38:41
| drh | ok
|
6. Tests for platform Linux x86_64: |
2023-05-15 20:33:29
| drh | ok
|
11. Tests for platform Windows: |
2023-05-15 20:33:26
| drh | ok
|
11d. nmake /f Makefile.msc releasetest |
8773s: build (5/5) f=0 r=0 script (6045/6045) f=0 r=0 make (9/9) f=0 r=0 |
2023-05-15 20:33:07
| drh | pending
|
11d. nmake /f Makefile.msc releasetest |
8773s: build (5/5) f=0 r=0 script (6045/6045) f=0 r=0 make (9/9) f=0 r=0 |
2023-05-15 17:42:47
| drh | ok
|
11e. sh tool/symbols-mingw.sh - no incorrect exports or dependencies |
2023-05-15 17:38:54
| drh | ok
|
11f. Verify that EXEs and DLLs generated using MSVC contain the correct version number, product name, description, and copyright as resources. |
2023-05-15 17:36:12
| drh | ok
|
37. Run the rbu/run_rbu_tests.tcl script in the test-dbs project on Linux. |
2023-05-15 17:21:29
| drh | ok
|
16. Dbsqlfuzz tests |
2023-05-15 17:21:26
| drh | ok
|
16i. Win10/MSVC: fuzzcheck $CORPUS -spinner |
2023-05-15 15:43:32
| drh | ok
|
13. WASM |
2023-05-15 15:43:30
| drh | ok
|
13d. Click on the test links - confirm correct results. |
2023-05-15 15:43:27
| drh | ok
|
13c. althttpd --enable-sab --page index.html |
2023-05-15 15:40:26
| drh | ok
|
13b. (On Linux) ./configure --enable-all && cd ext/wasm && make |
2023-05-15 15:38:13
| drh | ok
|
1. Test procedure review. |
2023-05-15 15:38:10
| drh | ok
|
1d. Review dev-ops procedures and make any needed updates and corrections. |
2023-05-15 15:38:08
| drh | ok
|
1b. Review "multitest.tcl" and "alignment*.rc" scripts in TH3 for completeness. |
2023-05-15 15:38:06
| drh | ok
|
1a. Review the "test/testrunner.tcl" script for completeness and accuracy. |
2023-05-15 15:34:13
| drh | ok
|
31. Verify that the performance and size measurement spreadsheet in the documentation (misc/speed-size-graph.ods) is up-to-date. |
2023-05-15 12:27:40
| drh | pending
|
11d. nmake /f Makefile.msc releasetest |
2023-05-15 12:26:56
| drh | ok
|
11b. tclsh multitest.tcl --msvc --only min on x86 |
0 failures on 1 th3makes and 2336442 tests in (00:16:50) on SQLiteWin10
SQLite 3.42.0 2023-05-15 10:55:04 5a479a2c7637a018d1828d9d37973bf3d36a2fc4cd5b752bca61a41cd0920d39 |
2023-05-15 11:15:12
| drh | pending
|
11b. tclsh multitest.tcl --msvc --only min on x86 |
2023-05-15 10:50:50
| drh | ok
|
6g. ./configure --enable-debug --enable-all && make parse.c && CC=clang CFLAGS='-fsanitize=address,undefined' make -e test |
SQLite 2023-05-15 03:48:48 4c5cd3e6968c44749b7663beee790969b41d247b9201b771ef90cbb03d09108f
0 errors out of 305140 tests on r20 Linux 64-bit little-endian
All memory allocations freed - no leaks
Maximum memory usage: 9205904 bytes |
2023-05-15 09:45:36
| drh | ok
|
6a. tclsh multitest.tcl |
0 failures on 73 th3makes and 248521157 tests in (02:29:06) 8 cores on r20
SQLite 3.42.0 2023-05-13 05:13:29 67001887044da71ab50c07d8345bd950a0a1f9688cf9cd6966312ea163cf6e17
After the RIGHT JOIN automatic index fix:
0 failures on 73 th3makes and 248522651 tests in (02:29:08) 8 cores on r20
SQLite 3.42.0 2023-05-15 02:06:35 4902015dcf3869f08d9986e422faa231d9218a5e0fc59ba8df0f407e4eb3d605 |
2023-05-14 20:49:12
| drh | ok
|
22. ZIPVFS tests: |
2023-05-14 20:49:08
| drh | ok
|
22d. th3make zipvfs.rc quick1.rc -valgrind |
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 zipvfs/?*.cfg {cfg/c[1234].cfg} coverage.testplan zipvfs/?*.test cov1/?*.test
th3: 0 errors in 2000914 tests. 10919.784 seconds on r21 64-bit little-endian
th3: SQLite 3.42.0 2023-05-13 15:34:15 603d9ad5012ca8996783996d7b8cd6a1aabf12b21604a2ccc137f4c2d99427b9
Previous failed run was due to PEBKAC. |
2023-05-14 10:37:36
| drh | fail
|
22d. th3make zipvfs.rc quick1.rc -valgrind |
valgrind runs out of memory. |
2023-05-14 10:27:28
| drh | ok
|
16c. valgrind fuzzcheck $CORPUS --spinner |
2023-05-13 22:07:19
| drh | fail
|
16i. Win10/MSVC: fuzzcheck $CORPUS -spinner |
Crashes on: fuzzcheck 20230508.db --sqlid 38158 |
2023-05-13 22:04:21
| drh | ok
|
16g. CFLAGS='-Os -g -DSQLITE_VDBE_COVERAGE' make -e clean fuzzcheck && ./fuzzcheck $CORPUS --spinner |
2023-05-13 21:52:24
| drh | ok
|
16f. CC=clang CFLAGS='-Os -g -fsanitize=memory' make -e clean fuzzcheck && ./fuzzcheck $CORPUS --spinner |
2023-05-13 20:32:01
| drh | pending
|
16c. valgrind fuzzcheck $CORPUS --spinner |
2023-05-13 20:31:15
| drh | pending
|
22d. th3make zipvfs.rc quick1.rc -valgrind |
2023-05-13 20:31:03
| drh | ok
|
22h. At least one of the above on Windows. |
2023-05-13 20:30:59
| drh | ok
|
22e. th3make zipvfs.rc quick.rc |
th3: 19a6d590b2f0824252c6ff7a42780174f996c5630776b670c046b50fbec0f720
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 3797184 tests. 425.994 seconds on minimac 64-bit little-endian
th3: SQLite 3.42.0 2023-05-13 15:34:15 603d9ad5012ca8996783996d7b8cd6a1aabf12b21604a2ccc137f4c2d99427b9
th3: 19a6d590b2f0824252c6ff7a42780174f996c5630776b670c046b50fbec0f720
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 3843745 tests. 2016.683 seconds on SQLiteWin10 64-bit little-endian
th3: SQLite 3.42.0 2023-05-13 15:34:15 603d9ad5012ca8996783996d7b8cd6a1aabf12b21604a2ccc137f4c2d99427b9 |
2023-05-13 20:29:45
| drh | ok
|
16e. CC=clang CFLAGS='-Os -g -fsanitize=address' make -e clean fuzzcheck && ./fuzzcheck $CORPUS --spinner |
2023-05-13 20:18:57
| drh | ok
|
16h. Mac: fuzzcheck $CORPUS --spinner |
2023-05-13 20:18:21
| drh | ok
|
16d. CC=clang CFLAGS='-Os -g -fsanitize=undefined' make -e clean fuzzcheck && ./fuzzcheck $CORPUS --spinner |
2023-05-13 19:40:32
| 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-05-13 19:36:29
| drh | ok
|
22c. th3make zipvfs.rc test.rc |
th3: 19a6d590b2f0824252c6ff7a42780174f996c5630776b670c046b50fbec0f720
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 15239928 tests. 3625.463 seconds on r21 64-bit little-endian
th3: SQLite 3.42.0 2023-05-13 15:34:15 603d9ad5012ca8996783996d7b8cd6a1aabf12b21604a2ccc137f4c2d99427b9 |
2023-05-13 18:54:24
| drh | ok
|
20. CEROD tests in the "test/" subdirectory. |
2023-05-13 18:41:22
| drh | ok
|
22f. At least one of the above on Linux. |
2023-05-13 18:29:01
| drh | ok
|
22b. testfixture test/testrunner.tcl --zipvfs <ZIPVFS-source-directory> zipvfs |
2023-05-13 18:26:47
| drh | ok
|
22a. Verify that the configure script version number agrees with the SQLite version number |
2023-05-13 18:23:54
| drh | ok
|
22g. At least one of the above on Mac OS X. |
2023-05-13 18:23:51
| drh | ok
|
22e. th3make zipvfs.rc quick.rc |
th3: 19a6d590b2f0824252c6ff7a42780174f996c5630776b670c046b50fbec0f720
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 3797184 tests. 425.994 seconds on minimac 64-bit little-endian
th3: SQLite 3.42.0 2023-05-13 15:34:15 603d9ad5012ca8996783996d7b8cd6a1aabf12b21604a2ccc137f4c2d99427b9 |
2023-05-13 18:10:08
| drh | ok
|
13a. Build and install Fiddle according to website maintenance instructions. Run simple tests. |
2023-05-13 17:59:46
| drh | ok
|
15. Trunk changes merged and verified on active branches: |
2023-05-13 17:59:44
| drh | ok
|
15g. reuse-schema-see (in the see-base repository) |
2023-05-13 17:59:41
| drh | ok
|
15f. client-see (in the see-base repository) |
2023-05-13 17:59:31
| drh | ok
|
8. Tests for platform MacOS x64: |
2023-05-13 17:59:28
| drh | ok
|
8a. ./configure && make releasetest |
5746s: build (3/3) f=0 r=0 script (12510/12510) f=0 r=0 make (7/7) f=0 r=0 |
2023-05-13 17:29:44
| drh | ok
|
23. NDS-Devkit testing |
2023-05-13 17:29:41
| drh | ok
|
23b. Test using: tclsh th3make test.rc nds_devkit.rc |
th3: 19a6d590b2f0824252c6ff7a42780174f996c5630776b670c046b50fbec0f720
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 2544268 tests. 512.321 seconds on bella 64-bit little-endian
th3: NDS DevKit 3.42.0 2023-05-13 17:13:29 b7192c8b8c5dfea5
th3: SQLite 3.42.0 2023-02-21 21:42:14 21e77216ea152e5243d5daf1e25d5e4a210825d19ad2c1d1927ee232d0c4alt1 |
2023-05-13 17:29:29
| drh | ok
|
23c. Verify the "NDS DevKit" version number shown at the end of the test |
2023-05-13 17:28:39
| drh | ok
|
6e. ./configure && make releasetest |
1302s: build (18/18) f=0 r=0 script (37873/37873) f=0 r=0 make (32/32) f=0 r=0 |
2023-05-13 17:20:42
| drh | ok
|
23a. Merge all trunk enhancements into the reuse-schema branch and use that branch to update the devkit. |
2023-05-13 16:28:45
| drh | ok
|
6j. Run auxiliary test script in the /usr subdirectory of the TH3 repository |
2023-05-13 16:15:27
| drh | ok
|
8c. tclsh multitest.tcl --scenario failures - all failures detected |
2023-05-13 16:14:53
| drh | ok
|
8b. tclsh multitest.tcl --quick |
0 failures on 16 th3makes and 32929593 tests in (00:53:55) 3 cores on SQLite-iMac-2018
SQLite 3.42.0 2023-05-13 05:13:29 67001887044da71ab50c07d8345bd950a0a1f9688cf9cd6966312ea163cf6e17 |
2023-05-13 16:14:35
| drh | ok
|
6i. CC=clang CFLAGS='-fsanitize=thread' ./configure && make threadtest5 && ./threadtest5 |
2023-05-13 16:13:28
| drh | ok
|
6h. Test the reuse-schema branch with ./configure --enable-all && make "OPTS=-DSQLITE_ENABLE_SHARED_SCHEMA" test. |
SQLite 2023-05-13 15:55:42 d6971af74b4dcc4d2a4ed5e4d9aa81c2e43e0ca25bd2fbdaf16553fa0ea69d6d
0 errors out of 304674 tests on r21 Linux 64-bit little-endian |
2023-05-13 16:11:33
| drh | ok
|
16b. Check-in CORPUS as an unversioned file in the dbsqlfuzz repository |
2023-05-13 16:09:30
| drh | ok
|
16a. Develop a new CORPUS database by running dbsqlfuzz for 10 billion iterations |
2023-05-13 16:09:17
| drh | ok
|
15a. begin-concurrent (from trunk) |
2023-05-13 16:09:14
| drh | ok
|
15d. reuse-schema (from trunk) |
2023-05-13 16:08:52
| drh | ok
|
7. Tests for platform Linux ARM (BeagleBoard or RaspberryPI) |
2023-05-13 16:08:50
| drh | ok
|
7b. Recompile and test Fossil. |
2023-05-13 16:06:42
| drh | fail
|
6g. ./configure --enable-debug --enable-all && make parse.c && CC=clang CFLAGS='-fsanitize=address,undefined' make -e test |
UBSAN fault in ext/misc/serices.c while running test/shell2.test. |
2023-05-13 15:37:08
| drh | ok
|
7a. tclsh th3make min.rc -DTH3_LOWMEM --unobfuscated |
th3: 7c59ae7747c3ef49d6a332277a2a6c0a4c6777a9bfff950a2042d856f2d302f7
th3: th3make min.rc -DTH3_LOWMEM --unobfuscated
th3: mkth3.tcl -DTH3_LOWMEM cfg/c?.cfg cfg/wal1.cfg cfg/f2fs.cfg coverage.testplan cov1/?*.test
th3: 0 errors in 2185220 tests. 5176.860 seconds on raspberrypi 32-bit little-endian
th3: SQLite 3.42.0 2023-05-12 19:06:00 f06c16a8b0e7a15ce4f7d99af3376a1bf1bfbfc0fdc048b079418ae74c619d6b |
2023-05-13 15:36:51
| drh | ok
|
9. Tests for platform MacOS ARM: |
2023-05-13 15:36:48
| drh | ok
|
9a. ./configure && make releasetest |
1795s: build (3/3) f=0 r=0 script (12510/12510) f=0 r=0 make (7/7) f=0 r=0 |
2023-05-13 15:15:05
| drh | ok
|
6f. sh tool/symbols.sh - no incorrect exports or dependencies |
2023-05-13 15:14:26
| drh | ok
|
6d. tclsh multitest.tcl --scenario failures - all failures detected |
2023-05-13 15:12:35
| drh | ok
|
6c. tclsh multitest.tcl --scenario obscure |
0 failures on 2 th3makes and 5011086 tests in (00:11:11) on r20
SQLite 3.42.0 2023-05-13 05:13:29 67001887044da71ab50c07d8345bd950a0a1f9688cf9cd6966312ea163cf6e17 |
2023-05-13 15:10:52
| drh | ok
|
15c. bedrock (from wal2) |
2023-05-13 15:09:15
| drh | ok
|
15e. see (in the see-base repository) |
2023-05-13 15:08:50
| drh | ok
|
15b. wal2 (from trunk) |
2023-05-13 14:54:10
| drh | ok
|
9b. tclsh multitest.tcl --quick |
0 failures on 16 th3makes and 32928741 tests in (00:13:31) 8 cores on minimac
SQLite 3.42.0 2023-05-13 05:13:29 67001887044da71ab50c07d8345bd950a0a1f9688cf9cd6966312ea163cf6e17 |
2023-05-13 14:53:20
| drh | ok
|
6b. tclsh multitest.tcl --scenario coverage |
Coverage lacking on vfs-cov.rc due to the change to use pread()/pwrite() on
Linux. Otherwise all is well. Deemed pass. |
2023-05-13 14:50:45
| drh | ok
|
11c. tclsh multitest.tcl --msvc --scenario failures - verify failures detected |
2023-05-13 14:49:40
| drh | ok
|
11a. tclsh multitest.tcl --msvc --quick on x64 |
0 failures on 16 th3makes and 32779127 tests in (03:07:13) on SQLiteWin10
SQLite 3.42.0 2023-05-13 05:13:29 67001887044da71ab50c07d8345bd950a0a1f9688cf9cd6966312ea163cf6e17 |
2023-05-13 13:44:52
| drh | ok
|
6a. tclsh multitest.tcl |
0 failures on 73 th3makes and 248521157 tests in (02:29:06) 8 cores on r20
SQLite 3.42.0 2023-05-13 05:13:29 67001887044da71ab50c07d8345bd950a0a1f9688cf9cd6966312ea163cf6e17 |
2023-05-13 13:43:48
| drh | ok
|
4. Compiler warning checks. |
2023-05-13 13:43:45
| drh | ok
|
4a. Linux GCC -Wall -Wextra (the "tool/warnings.sh" script) |
2023-05-13 13:42:45
| drh | ok
|
4b. Mac OS X GCC -Wall -Wextra (the "tool/warnings.sh" script) |
2023-05-13 13:41:17
| drh | ok
|
21. SEE tests using TH3: |
2023-05-13 13:41:08
| drh | ok
|
21d. see-rc4.c |
th3: 7c59ae7747c3ef49d6a332277a2a6c0a4c6777a9bfff950a2042d856f2d302f7
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 9565550 tests. 3174.199 seconds on minimac 64-bit little-endian
th3: SQLite 3.42.0 2023-05-12 22:31:56 7eacd277829f9fa6b5d1f9066a261f7b5845e406e534654e2dc647d25f4e97ee |
2023-05-13 13:40:44
| drh | ok
|
21j. At least one of the above using "test.rc". |
2023-05-13 13:40:41
| drh | ok
|
21i. Verify that builds work with -DSQLITE_ENABLE_UPDATE_DELETE_LIMIT |
2023-05-13 13:40:30
| drh | ok
|
21b. see-aes128-ofb.c |
th3: 7c59ae7747c3ef49d6a332277a2a6c0a4c6777a9bfff950a2042d856f2d302f7
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 2437492 tests. 222.388 seconds on minimac 64-bit little-endian
th3: SQLite 3.42.0 2023-05-12 22:31:56 7eacd277829f9fa6b5d1f9066a261f7b5845e406e534654e2dc647d25f4e97ee h3: 7c59ae7747c3ef49d6a332277a2a6c0a4c6777a9bfff950a2042d856f2d302f7
th3: ./th3make see.rc test.rc ~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_UPDATE_DELETE_LIMIT cfg/?*.cfg extra1/?*.cfg bugs/?*.test cov1/?*.test extra1/?*.test fts/?*.test req1/?*.test demo/?*.test
th3: 0 errors in 12566531 tests. 11329.266 seconds on bella 64-bit little-endian
th3: SQLite 3.42.0 2023-05-12 22:31:56 7eacd277829f9fa6b5d1f9066a261f7b5845e406e534654e2dc647d25f4e97ee |
2023-05-13 11:11:52
| drh | ok
|
21c. see-aes256-ofb.c |
th3: 7c59ae7747c3ef49d6a332277a2a6c0a4c6777a9bfff950a2042d856f2d302f7
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 2437460 tests. 238.134 seconds on minimac 64-bit little-endian
th3: SQLite 3.42.0 2023-05-12 22:31:56 7eacd277829f9fa6b5d1f9066a261f7b5845e406e534654e2dc647d25f4e97ee |
2023-05-13 11:07:19
| drh | ok
|
19a. Used on active websites with no issues |
2023-05-13 11:07:16
| drh | ok
|
19. Wapp updated to use the latest SQLite |
2023-05-13 11:06:26
| drh | ok
|
21l. At least one of the above on Linux. |
2023-05-13 11:06:19
| drh | ok
|
21g. see-aes256-openssl.c |
th3: 7c59ae7747c3ef49d6a332277a2a6c0a4c6777a9bfff950a2042d856f2d302f7
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 2456556 tests. 302.945 seconds on r20 64-bit little-endian
th3: SQLite 3.42.0 2023-05-12 22:31:56 7eacd277829f9fa6b5d1f9066a261f7b5845e406e534654e2dc647d25f4e97ee |
2023-05-13 11:05:52
| drh | ok
|
21h. see-aes256-cryptoapi.c |
th3: 7c59ae7747c3ef49d6a332277a2a6c0a4c6777a9bfff950a2042d856f2d302f7
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 2464243 tests. 900.868 seconds on SQLiteWin10 64-bit little-endian
th3: SQLite 3.42.0 2023-05-12 22:31:56 7eacd277829f9fa6b5d1f9066a261f7b5845e406e534654e2dc647d25f4e97ee |
2023-05-13 11:05:11
| drh | ok
|
21b. see-aes128-ofb.c |
th3: 7c59ae7747c3ef49d6a332277a2a6c0a4c6777a9bfff950a2042d856f2d302f7
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 2437492 tests. 222.388 seconds on minimac 64-bit little-endian
th3: SQLite 3.42.0 2023-05-12 22:31:56 7eacd277829f9fa6b5d1f9066a261f7b5845e406e534654e2dc647d25f4e97ee |
2023-05-13 10:55:07
| drh | ok
|
21e. see-aes128-ccm.c |
th3: 7c59ae7747c3ef49d6a332277a2a6c0a4c6777a9bfff950a2042d856f2d302f7
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 2437550 tests. 264.297 seconds on minimac 64-bit little-endian
th3: SQLite 3.42.0 2023-05-12 22:31:56 7eacd277829f9fa6b5d1f9066a261f7b5845e406e534654e2dc647d25f4e97ee |
2023-05-13 10:48:43
| drh | ok
|
21n. At least one of the above on Windows. |
2023-05-13 10:48:33
| drh | ok
|
21a. see.c |
th3: 7c59ae7747c3ef49d6a332277a2a6c0a4c6777a9bfff950a2042d856f2d302f7
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 2464255 tests. 954.817 seconds on SQLiteWin10 64-bit little-endian
th3: SQLite 3.42.0 2023-05-12 22:31:56 7eacd277829f9fa6b5d1f9066a261f7b5845e406e534654e2dc647d25f4e97ee |
2023-05-13 10:38:36
| drh | ok
|
21m. At least one of the above on Mac OS X. |
2023-05-13 10:38:31
| drh | ok
|
21k. At least one of the above with option -DSQLITE_DIRECT_OVERFLOW_READ. |
2023-05-13 10:38:18
| drh | ok
|
21f. see-cccrypt.c |
th3: 7c59ae7747c3ef49d6a332277a2a6c0a4c6777a9bfff950a2042d856f2d302f7
th3: ./th3make quick.rc see.rc -DSQLITE_DIRECT_OVERFLOW_READ
th3: mkth3.tcl -DSQLITE_DEBUG -DSQLITE_ENABLE_BYTECODE_VTAB -DSQLITE_ENABLE_DESERIALIZE -DSQLITE_ENABLE_STMTVTAB -DTH3_SELFCOVERAGE -DSQLITE_HAS_CODEC -DSQLITE_DIRECT_OVERFLOW_READ cfg/c?.cfg cfg/wal1.cfg cfg/f2fs.cfg coverage.testplan cov1/?*.test
th3: 0 errors in 2440450 tests. 190.998 seconds on minimac 64-bit little-endian
th3: SQLite 3.42.0 2023-05-12 22:31:56 7eacd277829f9fa6b5d1f9066a261f7b5845e406e534654e2dc647d25f4e97ee |
2023-05-12 20:28:04
| drh | ok
|
17. Sqllogictest: |
2023-05-12 20:28:01
| drh | ok
|
17d. tclsh run-all.tcl - on windows |
2023-05-12 20:23:03
| drh | ok
|
17c. tclsh run-all.tcl - on unix |
2023-05-12 19:53:05
| drh | ok
|
17b. No SQLite compiler warnings. |
2023-05-12 19:53:02
| drh | ok
|
17a. Checked in latest SQLite amalgamation. |
2023-05-12 19:45:10
| drh | ok
|
27. Run make wordcount and do tests on current and prior versions: |
2023-05-12 19:45:08
| drh | ok
|
27a. rm -f wc.db && ./wordcount wc.db $BIGTEXT --all |
2023-05-12 19:45:05
| drh | ok
|
27b. rm -f wc.db && ./wordcount wc.db $BIGTEXT --all --cachesize 5 --nosync |
2023-05-12 19:34:59
| drh | ok
|
26. Performance tests using speedtest1 compared against the previous release and a release from about one year ago. |
2023-05-12 19:34:57
| drh | ok
|
28. Compare performance to the previous release using kvtest. |
2023-05-12 19:34:54
| drh | ok
|
28a. Linux |
2023-05-12 19:34:13
| drh | ok
|
26b. Linux with --testset rtree |
2023-05-12 19:32:57
| drh | ok
|
26a. Linux |
2023-05-12 19:21:32
| drh | ok
|
25. TEA archive builds correctly and runs: |
2023-05-12 19:21:30
| drh | ok
|
25c. Mac OS X |
2023-05-12 19:18:54
| drh | ok
|
24. Amalgamation autoconf tarball. |
2023-05-12 19:18:51
| drh | ok
|
24c. Works on Mac OS X. |
2023-05-12 19:18:27
| drh | ok
|
24d. Works on Windows MinGW |
2023-05-12 19:17:34
| drh | ok
|
25b. Linux |
2023-05-12 19:16:13
| drh | ok
|
25a. Verify that the SQLite version number is correct in autoconf/tea/configure.ac |
2023-05-12 19:15:43
| drh | ok
|
24b. Works on Linux. |
2023-05-12 19:15:41
| drh | ok
|
24a. Builds. |
2023-05-12 19:09:49
| drh | ok
|
25d. Windows MSVC |
2023-05-12 19:07:50
| drh | ok
|
24e. Works on Windows MSVC |
2023-05-12 19:02:09
| drh | ok
|
28b. Mac |
2023-05-12 19:01:20
| drh | ok
|
26c. Mac |
2023-05-12 18:43:50
| drh | ok
|
28c. Windows |
2023-05-12 18:41:16
| drh | ok
|
26e. Windows with --testset rtree |
2023-05-12 18:39:32
| drh | ok
|
26d. Windows |
2023-05-12 17:58:35
| drh | ok
|
35. Build and verify sqldiff |
2023-05-12 17:58:32
| drh | ok
|
35b. Mac |
2023-05-12 17:53:54
| drh | ok
|
34. Build and verify correct operation of sqlite3_analyzer on: |
2023-05-12 17:53:52
| drh | ok
|
34c. Windows |
2023-05-12 17:53:49
| drh | ok
|
35c. Windows |
2023-05-12 17:52:11
| drh | ok
|
34b. Mac OS X |
2023-05-12 17:51:48
| drh | ok
|
35a. Linux |
2023-05-12 17:51:45
| drh | ok
|
34a. Linux |
2023-05-12 17:51:24
| drh | ok
|
36. Build the "atrc" test program and run "./atrc $DB | ./sqlite3 $DB" against multiple databases, visually verify the result |
2023-05-12 17:45:22
| 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-05-12 17:37:04
| drh | ok
|
3h. Check new/changed documentation for spelling and gramatical mistakes. |
2023-05-12 17:26:59
| drh | ok
|
4d. Clang-10.0.0: CFLAGS='-O0' ./configure --enable-debug --enable-all && scan-build make sqlite3 |
2023-05-12 17:26:56
| drh | ok
|
4c. Clang-6.0.0: CFLAGS='-O0' ./configure --enable-debug --enable-all && scan-build make sqlite3 |
2023-05-12 17:19:09
| drh | ok
|
3g. Test metrics are up-to-date (testing.html). |
2023-05-12 17:19:06
| drh | ok
|
3f. Database footprint is up-to-date (features.html). |
2023-05-12 17:18:44
| drh | ok
|
3e. The compile-time options are all up-to-date (compile.html). |
2023-05-12 17:18:41
| drh | ok
|
3d. No unresolved hyperlinks in the documentation build. |
2023-05-12 17:18:37
| drh | ok
|
3b. Release announcement in "changes.in". |
2023-05-12 17:18:25
| drh | ok
|
3a. Latest release on the "index.html" page. |
2023-05-12 17:06:47
| drh | ok
|
5. OMIT, ENABLE, and DISABLE options: |
2023-05-12 17:06:45
| drh | ok
|
5c. tclsh tool/omittest-msvc.tcl ← on Windows |
2023-05-12 17:06:42
| drh | ok
|
5b. tclsh ../tool/omittest.tcl -skip_run -target libsqlite3.a ← on Linux |
2023-05-12 14:46:56
| drh | ok
|
18. Fossil updated to use the latest SQLite. |
2023-05-12 14:46:54
| drh | ok
|
18c. fossil all test-integrity -d |
2023-05-12 14:46:51
| drh | ok
|
18b. Used on active websites with no issues. |
2023-05-12 14:46:49
| drh | ok
|
18a. No SQLite compiler warnings. |
2023-05-12 14:17:08
| drh | ok
|
30. Use the ".selftest" command of the shell to verify that legacy database files are readable and cross-platform |
2023-05-12 14:17:06
| drh | ok
|
30c. Linux ARM |
2023-05-12 13:34:33
| drh | ok
|
30f. Windows 32-bit |
2023-05-12 13:28:03
| drh | ok
|
30g. Windows 64-bit |
2023-05-12 13:25:35
| drh | ok
|
30d. Mac x64 |
2023-05-12 13:23:41
| drh | ok
|
30e. Mac ARM |
2023-05-12 13:23:31
| drh | ok
|
30b. Linux x64 |
2023-05-12 13:21:28
| drh | ok
|
32. Verify that the amalgamation builds are byte-for-byte identical on all workstation platforms. |
2023-05-12 13:21:25
| drh | ok
|
32b. Linux (ARM) |
a55e7950e36a03642060fdf5a6e02c9b795c5fc117f7af4daedec76ac52cde98 sqlite3.c
1d2dc09f52e86803719e52b5ab0308fa446a8f3cee6d55dd55741930eeed9661 sqlite3.h |
2023-05-12 13:07:23
| drh | ok
|
32a. Linux (x64) |
a55e7950e36a03642060fdf5a6e02c9b795c5fc117f7af4daedec76ac52cde98 sqlite3.c
1d2dc09f52e86803719e52b5ab0308fa446a8f3cee6d55dd55741930eeed9661 sqlite3.h |
2023-05-12 13:06:55
| drh | ok
|
32c. Mac OS X |
a55e7950e36a03642060fdf5a6e02c9b795c5fc117f7af4daedec76ac52cde98 sqlite3.c
1d2dc09f52e86803719e52b5ab0308fa446a8f3cee6d55dd55741930eeed9661 sqlite3.h |
2023-05-12 13:06:03
| drh | ok
|
32d. Mac OS X (PPC) |
a55e7950e36a03642060fdf5a6e02c9b795c5fc117f7af4daedec76ac52cde98 sqlite3.c
1d2dc09f52e86803719e52b5ab0308fa446a8f3cee6d55dd55741930eeed9661 sqlite3.h |
2023-05-12 13:05:45
| drh | ok
|
32e. Mac OS X (ARM) |
a55e7950e36a03642060fdf5a6e02c9b795c5fc117f7af4daedec76ac52cde98 sqlite3.c
1d2dc09f52e86803719e52b5ab0308fa446a8f3cee6d55dd55741930eeed9661 sqlite3.h |
2023-05-12 13:05:24
| drh | ok
|
32f. Windows using native MinGW. |
a55e7950e36a03642060fdf5a6e02c9b795c5fc117f7af4daedec76ac52cde98 sqlite3.c
1d2dc09f52e86803719e52b5ab0308fa446a8f3cee6d55dd55741930eeed9661 sqlite3.h |
2023-05-12 13:05:00
| drh | ok
|
32g. Windows using NMAKE. |
a55e7950e36a03642060fdf5a6e02c9b795c5fc117f7af4daedec76ac52cde98 sqlite3.c
1d2dc09f52e86803719e52b5ab0308fa446a8f3cee6d55dd55741930eeed9661 sqlite3.h |
2023-05-12 12:41:58
| drh | ok
|
30a. iBook PPC |
2023-05-12 12:41:52
| drh | ok
|
10. Tests for platform MacOS (PPC): |
2023-05-12 12:41:49
| drh | ok
|
10a. .selftest checks (see below) |
2023-05-12 12:36:40
| drh | ok
|
10c. Verify that Fossil repositories are cross-platform with x86/x64. |
2023-05-12 12:35:02
| drh | ok
|
10b. Recompile and test Fossil. |
2023-05-10 16:42:42
| drh | ok
|
29. Check JSON parse performance using test/json/json-speed-check.sh |
2023-05-10 15:41:24
| drh | ok
|
2. Source code change review. fossil diff --from release --to trunk |
2023-05-10 15:41:22
| drh | ok
|
2l. Significant compile-time options are recognized by the sqlite3_compileoption_used() interface. |
2023-05-10 15:41:18
| drh | ok
|
2k. Verify that the list of APIs exposed via the extension header is up-to-date (sqlite3ext.h). |
2023-05-09 16:18:27
| 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-05-09 16:16:12
| drh | ok
|
2h. Check all calls to sqlite3OsRead() and sqlite3OsWrite() to ensure that offset computations are 64-bit clean. |
2023-05-09 15:43:53
| drh | ok
|
1c. Review this checklist for completeness and accuracy. |
2023-05-09 15:43:08
| drh | ok
|
2j. Verify that source code contains no tabs and that surplus whitespace has been removed. |
2023-05-09 15:41:22
| drh | ok
|
2g. Variables and functions have been renamed to reflect changes in their use. |
2023-05-09 15:41:19
| drh | ok
|
2f. Verify that the azProhibitedFunctions list in the safeModeAuth() function of the CLI is complete and up-to-date. |
2023-05-09 15:27:23
| drh | ok
|
2e. Comments have been updated to reflect code changes. |
2023-05-09 15:27:20
| drh | ok
|
2d. New code complies with design rules. |
2023-05-09 15:27:17
| drh | ok
|
2c. New code complies with style guidelines. |
2023-05-09 15:27:15
| drh | ok
|
2b. All significant changes are mentioned in the "changes" log of the documentation. |
2023-05-09 15:27:12
| drh | ok
|
2a. No stray changes. |
2023-05-09 15:26:54
| drh | ok
|
2m. Compare sqlite3.c and sqlite3.h against the previous release. |
2023-05-05 14:16:45
| drh | ok
|
5a. Recent compile-time options have been added to the omittest.tcl and omittest-msvc.tcl scripts and checked in. |