SQLite

Release Checklist for SQLite 3.42.0
Login
2023-05-16 12:34:35 drhok
39. Website built procedures
2023-05-16 12:34:33 drhok
39b. tools/mkmsvcmin.tcl has been run to update the MSVC makefiles in autoconf
2023-05-16 11:15:56 danok
39d. All build products work on their target platforms
They do.
2023-05-16 11:07:52 danok
12. Tests for platform OpenBSD (x86):
2023-05-16 11:07:49 danok
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 danok
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 danok
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 danok
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 danok
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 danok
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 drhok
3. Documentation review:
2023-05-16 10:48:24 drhok
3c. Release accouncement in "news.html".
2023-05-16 10:38:41 drhok
6. Tests for platform Linux x86_64:
2023-05-15 20:33:29 drhok
11. Tests for platform Windows:
2023-05-15 20:33:26 drhok
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 drhpending
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 drhok
11e. sh tool/symbols-mingw.sh - no incorrect exports or dependencies
2023-05-15 17:38:54 drhok
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 drhok
37. Run the rbu/run_rbu_tests.tcl script in the test-dbs project on Linux.
2023-05-15 17:21:29 drhok
16. Dbsqlfuzz tests
2023-05-15 17:21:26 drhok
16i. Win10/MSVC: fuzzcheck $CORPUS -spinner
2023-05-15 15:43:32 drhok
13. WASM
2023-05-15 15:43:30 drhok
13d. Click on the test links - confirm correct results.
2023-05-15 15:43:27 drhok
13c. althttpd --enable-sab --page index.html
2023-05-15 15:40:26 drhok
13b. (On Linux) ./configure --enable-all && cd ext/wasm && make
2023-05-15 15:38:13 drhok
1. Test procedure review.
2023-05-15 15:38:10 drhok
1d. Review dev-ops procedures and make any needed updates and corrections.
2023-05-15 15:38:08 drhok
1b. Review "multitest.tcl" and "alignment*.rc" scripts in TH3 for completeness.
2023-05-15 15:38:06 drhok
1a. Review the "test/testrunner.tcl" script for completeness and accuracy.
2023-05-15 15:34:13 drhok
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 drhpending
11d. nmake /f Makefile.msc releasetest
2023-05-15 12:26:56 drhok
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 drhpending
11b. tclsh multitest.tcl --msvc --only min on x86
2023-05-15 10:50:50 drhok
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 drhok
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 drhok
22. ZIPVFS tests:
2023-05-14 20:49:08 drhok
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 drhfail
22d. th3make zipvfs.rc quick1.rc -valgrind
valgrind runs out of memory.
2023-05-14 10:27:28 drhok
16c. valgrind fuzzcheck $CORPUS --spinner
2023-05-13 22:07:19 drhfail
16i. Win10/MSVC: fuzzcheck $CORPUS -spinner
Crashes on: fuzzcheck 20230508.db --sqlid 38158
2023-05-13 22:04:21 drhok
16g. CFLAGS='-Os -g -DSQLITE_VDBE_COVERAGE' make -e clean fuzzcheck && ./fuzzcheck $CORPUS --spinner
2023-05-13 21:52:24 drhok
16f. CC=clang CFLAGS='-Os -g -fsanitize=memory' make -e clean fuzzcheck && ./fuzzcheck $CORPUS --spinner
2023-05-13 20:32:01 drhpending
16c. valgrind fuzzcheck $CORPUS --spinner
2023-05-13 20:31:15 drhpending
22d. th3make zipvfs.rc quick1.rc -valgrind
2023-05-13 20:31:03 drhok
22h. At least one of the above on Windows.
2023-05-13 20:30:59 drhok
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 drhok
16e. CC=clang CFLAGS='-Os -g -fsanitize=address' make -e clean fuzzcheck && ./fuzzcheck $CORPUS --spinner
2023-05-13 20:18:57 drhok
16h. Mac: fuzzcheck $CORPUS --spinner
2023-05-13 20:18:21 drhok
16d. CC=clang CFLAGS='-Os -g -fsanitize=undefined' make -e clean fuzzcheck && ./fuzzcheck $CORPUS --spinner
2023-05-13 19:40:32 drhok
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 drhok
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 drhok
20. CEROD tests in the "test/" subdirectory.
2023-05-13 18:41:22 drhok
22f. At least one of the above on Linux.
2023-05-13 18:29:01 drhok
22b. testfixture test/testrunner.tcl --zipvfs <ZIPVFS-source-directory> zipvfs
2023-05-13 18:26:47 drhok
22a. Verify that the configure script version number agrees with the SQLite version number
2023-05-13 18:23:54 drhok
22g. At least one of the above on Mac OS X.
2023-05-13 18:23:51 drhok
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 drhok
13a. Build and install Fiddle according to website maintenance instructions. Run simple tests.
2023-05-13 17:59:46 drhok
15. Trunk changes merged and verified on active branches:
2023-05-13 17:59:44 drhok
15g. reuse-schema-see (in the see-base repository)
2023-05-13 17:59:41 drhok
15f. client-see (in the see-base repository)
2023-05-13 17:59:31 drhok
8. Tests for platform MacOS x64:
2023-05-13 17:59:28 drhok
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 drhok
23. NDS-Devkit testing
2023-05-13 17:29:41 drhok
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 drhok
23c. Verify the "NDS DevKit" version number shown at the end of the test
2023-05-13 17:28:39 drhok
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 drhok
23a. Merge all trunk enhancements into the reuse-schema branch and use that branch to update the devkit.
2023-05-13 16:28:45 drhok
6j. Run auxiliary test script in the /usr subdirectory of the TH3 repository
2023-05-13 16:15:27 drhok
8c. tclsh multitest.tcl --scenario failures - all failures detected
2023-05-13 16:14:53 drhok
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 drhok
6i. CC=clang CFLAGS='-fsanitize=thread' ./configure && make threadtest5 && ./threadtest5
2023-05-13 16:13:28 drhok
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 drhok
16b. Check-in CORPUS as an unversioned file in the dbsqlfuzz repository
2023-05-13 16:09:30 drhok
16a. Develop a new CORPUS database by running dbsqlfuzz for 10 billion iterations
2023-05-13 16:09:17 drhok
15a. begin-concurrent (from trunk)
2023-05-13 16:09:14 drhok
15d. reuse-schema (from trunk)
2023-05-13 16:08:52 drhok
7. Tests for platform Linux ARM (BeagleBoard or RaspberryPI)
2023-05-13 16:08:50 drhok
7b. Recompile and test Fossil.
2023-05-13 16:06:42 drhfail
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 drhok
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 drhok
9. Tests for platform MacOS ARM:
2023-05-13 15:36:48 drhok
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 drhok
6f. sh tool/symbols.sh - no incorrect exports or dependencies
2023-05-13 15:14:26 drhok
6d. tclsh multitest.tcl --scenario failures - all failures detected
2023-05-13 15:12:35 drhok
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 drhok
15c. bedrock (from wal2)
2023-05-13 15:09:15 drhok
15e. see (in the see-base repository)
2023-05-13 15:08:50 drhok
15b. wal2 (from trunk)
2023-05-13 14:54:10 drhok
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 drhok
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 drhok
11c. tclsh multitest.tcl --msvc --scenario failures - verify failures detected
2023-05-13 14:49:40 drhok
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 drhok
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 drhok
4. Compiler warning checks.
2023-05-13 13:43:45 drhok
4a. Linux GCC -Wall -Wextra (the "tool/warnings.sh" script)
2023-05-13 13:42:45 drhok
4b. Mac OS X GCC -Wall -Wextra (the "tool/warnings.sh" script)
2023-05-13 13:41:17 drhok
21. SEE tests using TH3:
2023-05-13 13:41:08 drhok
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 drhok
21j. At least one of the above using "test.rc".
2023-05-13 13:40:41 drhok
21i. Verify that builds work with -DSQLITE_ENABLE_UPDATE_DELETE_LIMIT
2023-05-13 13:40:30 drhok
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 drhok
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 drhok
19a. Used on active websites with no issues
2023-05-13 11:07:16 drhok
19. Wapp updated to use the latest SQLite
2023-05-13 11:06:26 drhok
21l. At least one of the above on Linux.
2023-05-13 11:06:19 drhok
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 drhok
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 drhok
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 drhok
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 drhok
21n. At least one of the above on Windows.
2023-05-13 10:48:33 drhok
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 drhok
21m. At least one of the above on Mac OS X.
2023-05-13 10:38:31 drhok
21k. At least one of the above with option -DSQLITE_DIRECT_OVERFLOW_READ.
2023-05-13 10:38:18 drhok
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 drhok
17. Sqllogictest:
2023-05-12 20:28:01 drhok
17d. tclsh run-all.tcl - on windows
2023-05-12 20:23:03 drhok
17c. tclsh run-all.tcl - on unix
2023-05-12 19:53:05 drhok
17b. No SQLite compiler warnings.
2023-05-12 19:53:02 drhok
17a. Checked in latest SQLite amalgamation.
2023-05-12 19:45:10 drhok
27. Run make wordcount and do tests on current and prior versions:
2023-05-12 19:45:08 drhok
27a. rm -f wc.db && ./wordcount wc.db $BIGTEXT --all
2023-05-12 19:45:05 drhok
27b. rm -f wc.db && ./wordcount wc.db $BIGTEXT --all --cachesize 5 --nosync
2023-05-12 19:34:59 drhok
26. Performance tests using speedtest1 compared against the previous release and a release from about one year ago.
2023-05-12 19:34:57 drhok
28. Compare performance to the previous release using kvtest.
2023-05-12 19:34:54 drhok
28a. Linux
2023-05-12 19:34:13 drhok
26b. Linux with --testset rtree
2023-05-12 19:32:57 drhok
26a. Linux
2023-05-12 19:21:32 drhok
25. TEA archive builds correctly and runs:
2023-05-12 19:21:30 drhok
25c. Mac OS X
2023-05-12 19:18:54 drhok
24. Amalgamation autoconf tarball.
2023-05-12 19:18:51 drhok
24c. Works on Mac OS X.
2023-05-12 19:18:27 drhok
24d. Works on Windows MinGW
2023-05-12 19:17:34 drhok
25b. Linux
2023-05-12 19:16:13 drhok
25a. Verify that the SQLite version number is correct in autoconf/tea/configure.ac
2023-05-12 19:15:43 drhok
24b. Works on Linux.
2023-05-12 19:15:41 drhok
24a. Builds.
2023-05-12 19:09:49 drhok
25d. Windows MSVC
2023-05-12 19:07:50 drhok
24e. Works on Windows MSVC
2023-05-12 19:02:09 drhok
28b. Mac
2023-05-12 19:01:20 drhok
26c. Mac
2023-05-12 18:43:50 drhok
28c. Windows
2023-05-12 18:41:16 drhok
26e. Windows with --testset rtree
2023-05-12 18:39:32 drhok
26d. Windows
2023-05-12 17:58:35 drhok
35. Build and verify sqldiff
2023-05-12 17:58:32 drhok
35b. Mac
2023-05-12 17:53:54 drhok
34. Build and verify correct operation of sqlite3_analyzer on:
2023-05-12 17:53:52 drhok
34c. Windows
2023-05-12 17:53:49 drhok
35c. Windows
2023-05-12 17:52:11 drhok
34b. Mac OS X
2023-05-12 17:51:48 drhok
35a. Linux
2023-05-12 17:51:45 drhok
34a. Linux
2023-05-12 17:51:24 drhok
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 drhok
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 drhok
3h. Check new/changed documentation for spelling and gramatical mistakes.
2023-05-12 17:26:59 drhok
4d. Clang-10.0.0: CFLAGS='-O0' ./configure --enable-debug --enable-all && scan-build make sqlite3
2023-05-12 17:26:56 drhok
4c. Clang-6.0.0: CFLAGS='-O0' ./configure --enable-debug --enable-all && scan-build make sqlite3
2023-05-12 17:19:09 drhok
3g. Test metrics are up-to-date (testing.html).
2023-05-12 17:19:06 drhok
3f. Database footprint is up-to-date (features.html).
2023-05-12 17:18:44 drhok
3e. The compile-time options are all up-to-date (compile.html).
2023-05-12 17:18:41 drhok
3d. No unresolved hyperlinks in the documentation build.
2023-05-12 17:18:37 drhok
3b. Release announcement in "changes.in".
2023-05-12 17:18:25 drhok
3a. Latest release on the "index.html" page.
2023-05-12 17:06:47 drhok
5. OMIT, ENABLE, and DISABLE options:
2023-05-12 17:06:45 drhok
5c. tclsh tool/omittest-msvc.tcl ← on Windows
2023-05-12 17:06:42 drhok
5b. tclsh ../tool/omittest.tcl -skip_run -target libsqlite3.a ← on Linux
2023-05-12 14:46:56 drhok
18. Fossil updated to use the latest SQLite.
2023-05-12 14:46:54 drhok
18c. fossil all test-integrity -d
2023-05-12 14:46:51 drhok
18b. Used on active websites with no issues.
2023-05-12 14:46:49 drhok
18a. No SQLite compiler warnings.
2023-05-12 14:17:08 drhok
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 drhok
30c. Linux ARM
2023-05-12 13:34:33 drhok
30f. Windows 32-bit
2023-05-12 13:28:03 drhok
30g. Windows 64-bit
2023-05-12 13:25:35 drhok
30d. Mac x64
2023-05-12 13:23:41 drhok
30e. Mac ARM
2023-05-12 13:23:31 drhok
30b. Linux x64
2023-05-12 13:21:28 drhok
32. Verify that the amalgamation builds are byte-for-byte identical on all workstation platforms.
2023-05-12 13:21:25 drhok
32b. Linux (ARM)
a55e7950e36a03642060fdf5a6e02c9b795c5fc117f7af4daedec76ac52cde98 sqlite3.c 1d2dc09f52e86803719e52b5ab0308fa446a8f3cee6d55dd55741930eeed9661 sqlite3.h
2023-05-12 13:07:23 drhok
32a. Linux (x64)
a55e7950e36a03642060fdf5a6e02c9b795c5fc117f7af4daedec76ac52cde98 sqlite3.c 1d2dc09f52e86803719e52b5ab0308fa446a8f3cee6d55dd55741930eeed9661 sqlite3.h
2023-05-12 13:06:55 drhok
32c. Mac OS X
a55e7950e36a03642060fdf5a6e02c9b795c5fc117f7af4daedec76ac52cde98 sqlite3.c 1d2dc09f52e86803719e52b5ab0308fa446a8f3cee6d55dd55741930eeed9661 sqlite3.h
2023-05-12 13:06:03 drhok
32d. Mac OS X (PPC)
a55e7950e36a03642060fdf5a6e02c9b795c5fc117f7af4daedec76ac52cde98 sqlite3.c 1d2dc09f52e86803719e52b5ab0308fa446a8f3cee6d55dd55741930eeed9661 sqlite3.h
2023-05-12 13:05:45 drhok
32e. Mac OS X (ARM)
a55e7950e36a03642060fdf5a6e02c9b795c5fc117f7af4daedec76ac52cde98 sqlite3.c 1d2dc09f52e86803719e52b5ab0308fa446a8f3cee6d55dd55741930eeed9661 sqlite3.h
2023-05-12 13:05:24 drhok
32f. Windows using native MinGW.
a55e7950e36a03642060fdf5a6e02c9b795c5fc117f7af4daedec76ac52cde98 sqlite3.c 1d2dc09f52e86803719e52b5ab0308fa446a8f3cee6d55dd55741930eeed9661 sqlite3.h
2023-05-12 13:05:00 drhok
32g. Windows using NMAKE.
a55e7950e36a03642060fdf5a6e02c9b795c5fc117f7af4daedec76ac52cde98 sqlite3.c 1d2dc09f52e86803719e52b5ab0308fa446a8f3cee6d55dd55741930eeed9661 sqlite3.h
2023-05-12 12:41:58 drhok
30a. iBook PPC
2023-05-12 12:41:52 drhok
10. Tests for platform MacOS (PPC):
2023-05-12 12:41:49 drhok
10a. .selftest checks (see below)
2023-05-12 12:36:40 drhok
10c. Verify that Fossil repositories are cross-platform with x86/x64.
2023-05-12 12:35:02 drhok
10b. Recompile and test Fossil.
2023-05-10 16:42:42 drhok
29. Check JSON parse performance using test/json/json-speed-check.sh
2023-05-10 15:41:24 drhok
2. Source code change review. fossil diff --from release --to trunk
2023-05-10 15:41:22 drhok
2l. Significant compile-time options are recognized by the sqlite3_compileoption_used() interface.
2023-05-10 15:41:18 drhok
2k. Verify that the list of APIs exposed via the extension header is up-to-date (sqlite3ext.h).
2023-05-09 16:18:27 drhok
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 drhok
2h. Check all calls to sqlite3OsRead() and sqlite3OsWrite() to ensure that offset computations are 64-bit clean.
2023-05-09 15:43:53 drhok
1c. Review this checklist for completeness and accuracy.
2023-05-09 15:43:08 drhok
2j. Verify that source code contains no tabs and that surplus whitespace has been removed.
2023-05-09 15:41:22 drhok
2g. Variables and functions have been renamed to reflect changes in their use.
2023-05-09 15:41:19 drhok
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 drhok
2e. Comments have been updated to reflect code changes.
2023-05-09 15:27:20 drhok
2d. New code complies with design rules.
2023-05-09 15:27:17 drhok
2c. New code complies with style guidelines.
2023-05-09 15:27:15 drhok
2b. All significant changes are mentioned in the "changes" log of the documentation.
2023-05-09 15:27:12 drhok
2a. No stray changes.
2023-05-09 15:26:54 drhok
2m. Compare sqlite3.c and sqlite3.h against the previous release.
2023-05-05 14:16:45 drhok
5a. Recent compile-time options have been added to the omittest.tcl and omittest-msvc.tcl scripts and checked in.