SQLite

Release Checklist for SQLite 3.39.0
Login
2022-06-25 14:27:19 drhok
3. Documentation review:
2022-06-25 14:27:17 drhok
3c. Release accouncement in "news.html".
2022-06-25 14:21:33 drhok
38. Website built procedures
2022-06-25 14:21:30 drhok
38b. tools/mkmsvcmin.tcl has been run to update the MSVC makefiles in autoconf
2022-06-25 10:41:38 drhok
6b. tclsh multitest.tcl --scenario coverage
1 branch miss each on STAT4 (t02) and on vfs-cov.rc. Deemed pass. The same for SQLite 3.39.0 2022-06-25 02:39:29 cd6254fcd32798f7be4e6d827597ddaa2e46ac6e2f0149cd3a3be0416fa18835
2022-06-25 10:41:02 drhok
6e. tclsh test/wapptest.tcl -noui --debug
0 errors from 16985445 tests in 50 configurations. SQLite version 3.39.0 2022-06-24 12:56:48 e93fd170ce4ae91d572c46d03f68f55d00091d0188030517455017d90d212587 0 errors from 16985442 tests in 50 configurations. SQLite version 3.39.0 2022-06-25 02:39:29 cd6254fcd32798f7be4e6d827597ddaa2e46ac6e2f0149cd3a3be0416fa18835
2022-06-25 10:40:40 drhok
6a. tclsh multitest.tcl
0 failures on 50 th3makes and 251668233 tests in (01:14:29) 16 cores on r21 SQLite 3.39.0 2022-06-24 12:56:48 e93fd170ce4ae91d572c46d03f68f55d00091d0188030517455017d90d212587 0 failures on 50 th3makes and 251668088 tests in (01:16:56) 16 cores on r21 SQLite 3.39.0 2022-06-25 02:39:29 cd6254fcd32798f7be4e6d827597ddaa2e46ac6e2f0149cd3a3be0416fa18835 drh@r21:/ramdisk/th3$
2022-06-25 07:11:28 danok
21. ZIPVFS tests:
2022-06-25 07:11:09 danok
21d. th3make zipvfs.rc quick.rc -valgrind
th3: 0 errors in 3816168 tests. 37777.532 seconds on ws1 64-bit little-endian th3: SQLite 3.39.0 2022-06-24 12:56:48 e93fd170ce4ae91d572c46d03f68f55d00091d0188030517455017d90d212587
2022-06-24 23:50:12 drhok
30. Verify that the performance and size measurement spreadsheet in the documentation (misc/speed-size-graph.ods) is up-to-date.
2022-06-24 23:45:18 drhok
20. SEE tests using TH3:
2022-06-24 23:45:13 drhok
20k. At least one of the above using "memdebug.rc".
2022-06-24 23:45:05 drhok
20b. see-aes128-ofb.c
th3: 514178f6ac0d05e3ecad2510c78aafd895ddad78b909b05b27bd7792acd3a865 th3: th3make quick.rc msvc.rc see.rc th3: mkth3.tcl -DSQLITE_DEBUG -DSQLITE_ENABLE_BYTECODE_VTAB -DSQLITE_ENABLE_DESERIALIZE -DSQLITE_ENABLE_STMTVTAB -DTH3_SELFCOVERAGE -D_CRT_SECURE_NO_DEPRECATE -D_CRT_SECURE_NO_WARNINGS -D_CRT_NONSTDC_NO_DEPRECATE -D_CRT_NONSTDC_NO_WARNINGS -DSQLITE_HAS_CODEC cfg/c?.cfg cfg/wal1.cfg cfg/f2fs.cfg coverage.testplan cov1/?*.test th3: 0 errors in 2479390 tests. 954.930 seconds on SQLiteWin10 64-bit little-endian th3: SQLite 3.39.0 2022-06-24 16:50:40 f0c615c1e30e073b8fc7773a222c22d891b15ba530d52f44373900b01c31deb4 Full TH3 coverage verified th3: 514178f6ac0d05e3ecad2510c78aafd895ddad78b909b05b27bd7792acd3a865 th3: ./th3make memdebug.rc see.rc th3: mkth3.tcl -DSQLITE_DEBUG -DSQLITE_MEMDEBUG -DSQLITE_HAS_CODEC cfg/?*.cfg extra1/?*.cfg bugs/?*.test cov1/?*.test extra1/?*.test fts/?*.test req1/?*.test th3: 0 errors in 11403829 tests. 9217.033 seconds on r20 64-bit little-endian th3: SQLite 3.39.0 2022-06-24 16:50:40 f0c615c1e30e073b8fc7773a222c22d891b15ba530d52f44373900b01c31deb4
2022-06-24 23:44:26 drhok
24. TEA archive builds correctly and runs:
2022-06-24 23:44:23 drhok
24c. Mac OS X
2022-06-24 23:42:09 drhok
23. Amalgamation autoconf tarball.
2022-06-24 23:42:07 drhok
23d. Works on Windows MinGW
2022-06-24 23:40:53 drhok
23c. Works on Mac OS X.
2022-06-24 23:35:48 drhok
24d. Windows MSVC
2022-06-24 23:34:02 drhok
23e. Works on Windows MSVC
2022-06-24 23:31:05 drhok
24b. Linux
2022-06-24 23:28:43 drhok
23b. Works on Linux.
2022-06-24 23:28:39 drhok
23a. Builds.
2022-06-24 23:27:47 drhok
26. Performance tests using speedtest1 --testset rtree
2022-06-24 23:27:44 drhok
26b. Windows
2022-06-24 23:22:50 drhok
25. Performance tests using speedtest1 compared against the previous release and a release from about one year ago.
2022-06-24 23:22:47 drhok
25c. Windows
2022-06-24 23:21:13 drhok
25b. Mac
2022-06-24 23:20:32 drhok
28. Compare performance to the previous release using kvtest.
2022-06-24 23:20:29 drhok
28b. Mac
2022-06-24 22:02:03 drhok
28c. Windows
2022-06-24 21:57:32 drhok
20c. see-aes256-ofb.c
th3: 514178f6ac0d05e3ecad2510c78aafd895ddad78b909b05b27bd7792acd3a865 th3: th3make quick.rc msvc.rc see.rc th3: mkth3.tcl -DSQLITE_DEBUG -DSQLITE_ENABLE_BYTECODE_VTAB -DSQLITE_ENABLE_DESERIALIZE -DSQLITE_ENABLE_STMTVTAB -DTH3_SELFCOVERAGE -D_CRT_SECURE_NO_DEPRECATE -D_CRT_SECURE_NO_WARNINGS -D_CRT_NONSTDC_NO_DEPRECATE -D_CRT_NONSTDC_NO_WARNINGS -DSQLITE_HAS_CODEC cfg/c?.cfg cfg/wal1.cfg cfg/f2fs.cfg coverage.testplan cov1/?*.test th3: 0 errors in 2479417 tests. 972.410 seconds on SQLiteWin10 64-bit little-endian th3: SQLite 3.39.0 2022-06-24 16:50:40 f0c615c1e30e073b8fc7773a222c22d891b15ba530d52f44373900b01c31deb4
2022-06-24 21:56:54 drhok
24a. Verify that the SQLite version number is correct in autoconf/tea/configure.ac
2022-06-24 21:56:48 danok
38d. All build products work on their target platforms
All start and pass smoketests.
2022-06-24 21:40:00 drhok
20b. see-aes128-ofb.c
th3: 514178f6ac0d05e3ecad2510c78aafd895ddad78b909b05b27bd7792acd3a865 th3: th3make quick.rc msvc.rc see.rc th3: mkth3.tcl -DSQLITE_DEBUG -DSQLITE_ENABLE_BYTECODE_VTAB -DSQLITE_ENABLE_DESERIALIZE -DSQLITE_ENABLE_STMTVTAB -DTH3_SELFCOVERAGE -D_CRT_SECURE_NO_DEPRECATE -D_CRT_SECURE_NO_WARNINGS -D_CRT_NONSTDC_NO_DEPRECATE -D_CRT_NONSTDC_NO_WARNINGS -DSQLITE_HAS_CODEC cfg/c?.cfg cfg/wal1.cfg cfg/f2fs.cfg coverage.testplan cov1/?*.test th3: 0 errors in 2479390 tests. 954.930 seconds on SQLiteWin10 64-bit little-endian th3: SQLite 3.39.0 2022-06-24 16:50:40 f0c615c1e30e073b8fc7773a222c22d891b15ba530d52f44373900b01c31deb4
2022-06-24 21:36:01 drhok
27. Run make wordcount and do tests on current and prior versions:
2022-06-24 21:35:58 drhok
27b. rm -f wc.db && ./wordcount wc.db $BIGTEXT --all --cachesize 5 --nosync
2022-06-24 21:33:17 drhok
27a. rm -f wc.db && ./wordcount wc.db $BIGTEXT --all
2022-06-24 21:31:17 danok
21g. At least one of the above on Mac OS X.
21c
2022-06-24 21:30:52 danok
38c. Compile-time options for build products have been updated as necessary
2022-06-24 21:30:44 danok
38a. Compile-time options in builds/products_build.sh in the supportdb repository has been updated to align with any changes to the default makefiles.
Only changes to default makefiles involve fuzzcheck and wasm.
2022-06-24 21:29:06 drhok
26a. Linux
2022-06-24 21:28:54 danok
21c. th3make zipvfs.rc memdebug.rc
th3: 0 errors in 11371006 tests. 20309.507 seconds on Dans-iMac.local 64-bit little-endian th3: SQLite 3.39.0 2022-06-24 12:56:48 e93fd170ce4ae91d572c46d03f68f55d00091d0188030517455017d90d212587
2022-06-24 21:27:05 danok
32. Verify that databases (including FTS3 and RTREE databases), rollback journals, and WAL files created by the release candidate are readable and writeable by historical versions of SQLite (as long as no unsupported features are used) and vice versa.
Tested against 3.7.3 and 3.8.2 using backcompat.test. SQLite 2022-06-24 12:56:48 e93fd170ce4ae91d572c46d03f68f55d00091d0188030517455017d90d212587 0 errors out of 265 tests on ws1 Linux 64-bit little-endian
2022-06-24 21:25:56 drhok
25a. Linux
2022-06-24 21:25:33 danok
36. Run the rbu/run_rbu_tests.tcl script in the test-dbs project on Linux.
All tests report "round trip successful".
2022-06-24 21:25:12 drhok
28a. Linux
2022-06-24 21:22:36 drhok
20h. see-aes256-cryptoapi.c
Full TH3 coverage verified th3: 514178f6ac0d05e3ecad2510c78aafd895ddad78b909b05b27bd7792acd3a865 th3: th3make quick.rc msvc.rc see.rc th3: mkth3.tcl -DSQLITE_DEBUG -DSQLITE_ENABLE_BYTECODE_VTAB -DSQLITE_ENABLE_DESERIALIZE -DSQLITE_ENABLE_STMTVTAB -DTH3_SELFCOVERAGE -D_CRT_SECURE_NO_DEPRECATE -D_CRT_SECURE_NO_WARNINGS -D_CRT_NONSTDC_NO_DEPRECATE -D_CRT_NONSTDC_NO_WARNINGS -DSQLITE_HAS_CODEC cfg/c?.cfg cfg/wal1.cfg cfg/f2fs.cfg coverage.testplan cov1/?*.test th3: 0 errors in 2479393 tests. 897.515 seconds on SQLiteWin10 64-bit little-endian th3: SQLite 3.39.0 2022-06-24 16:50:40 f0c615c1e30e073b8fc7773a222c22d891b15ba530d52f44373900b01c31deb4
2022-06-24 20:56:54 drhok
20o. At least one of the above on Windows.
2022-06-24 20:56:45 drhok
20a. see.c
Full TH3 coverage verified th3: 03ddccb80667d4d05191dfb42f2f856cd2da582827b5e0872040cc259fcdf66b th3: th3make test.rc msvc.rc see.rc th3: mkth3.tcl -DSQLITE_DEBUG -DSQLITE_ENABLE_EXPENSIVE_ASSERT -DSQLITE_ENABLE_WHERETRACE -DSQLITE_ENABLE_BYTECODE_VTAB -DSQLITE_ENABLE_DBPAGE_VTAB -DSQLITE_ENABLE_DBSTAT_VTAB -DSQLITE_ENABLE_DESERIALIZE -DSQLITE_ENABLE_STMTVTAB -D_CRT_SECURE_NO_DEPRECATE -D_CRT_SECURE_NO_WARNINGS -D_CRT_NONSTDC_NO_DEPRECATE -D_CRT_NONSTDC_NO_WARNINGS -DSQLITE_HAS_CODEC cfg/?*.cfg extra1/?*.cfg bugs/?*.test cov1/?*.test extra1/?*.test fts/?*.test req1/?*.test demo/?*.test th3: 0 errors in 8993742 tests. 4995.316 seconds on SQLiteWin10 64-bit little-endian th3: SQLite 3.39.0 2022-06-24 16:50:40 f0c615c1e30e073b8fc7773a222c22d891b15ba530d52f44373900b01c31deb4
2022-06-24 20:44:09 drhok
20m. At least one of the above on Linux.
2022-06-24 20:44:06 drhok
20j. At least one of the above using "test.rc".
2022-06-24 20:44:01 drhok
20g. see-aes256-openssl.c
th3: 03ddccb80667d4d05191dfb42f2f856cd2da582827b5e0872040cc259fcdf66b th3: ./th3make test.rc see.rc -lcrypto 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_HAS_CODEC cfg/?*.cfg extra1/?*.cfg bugs/?*.test cov1/?*.test extra1/?*.test fts/?*.test req1/?*.test demo/?*.test th3: 0 errors in 11762899 tests. 2565.381 seconds on r21 64-bit little-endian th3: SQLite 3.39.0 2022-06-24 16:50:40 f0c615c1e30e073b8fc7773a222c22d891b15ba530d52f44373900b01c31deb4
2022-06-24 19:55:22 drhok
20l. At least one of the above with option -DSQLITE_DIRECT_OVERFLOW_READ.
2022-06-24 19:55:19 drhok
20i. Verify that builds work with -DSQLITE_ENABLE_UPDATE_DELETE_LIMIT
2022-06-24 19:55:15 drh---
20h. see-aes256-cryptoapi.c
2022-06-24 19:55:05 drhok
20h. see-aes256-cryptoapi.c
2022-06-24 19:55:02 drhok
20d. see-rc4.c
Full TH3 coverage verified th3: 03ddccb80667d4d05191dfb42f2f856cd2da582827b5e0872040cc259fcdf66b th3: ./th3make quick.rc see.rc -DSQLITE_ENABLE_UPDATE_DELETE_LIMIT -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_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 2461574 tests. 213.379 seconds on minimac 64-bit little-endian th3: SQLite 3.39.0 2022-06-24 16:50:40 f0c615c1e30e073b8fc7773a222c22d891b15ba530d52f44373900b01c31deb4
2022-06-24 19:34:03 drhok
20e. see-aes128-ccm.c
Full TH3 coverage verified th3: 03ddccb80667d4d05191dfb42f2f856cd2da582827b5e0872040cc259fcdf66b 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 2451670 tests. 274.598 seconds on minimac 64-bit little-endian th3: SQLite 3.39.0 2022-06-24 16:50:40 f0c615c1e30e073b8fc7773a222c22d891b15ba530d52f44373900b01c31deb4
2022-06-24 19:33:13 drhok
7. Tests for platform Linux ARM (BeagleBoard or RaspberryPI)
2022-06-24 19:33:10 drhok
7a. tclsh th3make min.rc -DTH3_LOWMEM --unobfuscated
Full TH3 coverage verified th3: 7be6a6f51b747781e8cc5380d0a0f3a2f56512a358a8acdf4f091ebd7da500c2 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 2145733 tests. 5403.917 seconds on raspberrypi 32-bit little-endian th3: SQLite 3.39.0 2022-06-24 12:56:48 e93fd170ce4ae91d572c46d03f68f55d00091d0188030517455017d90d212587
2022-06-24 18:51:57 drhok
20n. At least one of the above on Mac OS X.
2022-06-24 18:51:52 drhok
20f. see-cccrypt.c
th3: 0 errors in 2451591 tests. 201.491 seconds on minimac 64-bit little-endian th3: SQLite 3.39.0 2022-06-24 16:50:40 f0c615c1e30e073b8fc7773a222c22d891b15ba530d52f44373900b01c31deb4
2022-06-24 18:51:18 drhok
22. NDS-Devkit testing
2022-06-24 18:51:15 drhok
22c. Verify the "NDS DevKit" version number shown at the end of the test
2022-06-24 18:51:12 drhok
22b. Test using: tclsh th3make test.rc nds_devkit.rc
2022-06-24 18:12:01 drhok
22a. Merge all trunk enhancements into the reuse-schema branch and use that branch to update the devkit.
2022-06-24 18:11:02 drhok
19. CEROD tests in the "test/" subdirectory.
2022-06-24 18:04:54 drhok
35. Build the "atrc" test program and run "./atrc $DB | ./sqlite3 $DB" against multiple databases, visually verify the result
2022-06-24 18:03:32 drhok
33. Build and verify correct operation of sqlite3_analyzer on:
2022-06-24 18:03:30 drhok
34. Build and verify sqldiff
2022-06-24 18:03:28 drhok
34a. Linux
2022-06-24 18:03:25 drhok
33a. Linux
2022-06-24 18:03:13 drhok
29. Use the ".selftest" command of the shell to verify that legacy database files are readable and cross-platform
2022-06-24 18:03:10 drhok
29d. Windows
2022-06-24 18:01:18 drhok
29c. Mac
2022-06-24 17:58:10 drhok
34b. Mac
2022-06-24 17:58:07 drhok
33b. Mac OS X
2022-06-24 17:57:03 drhok
29b. Linux
2022-06-24 17:56:49 drhok
37. 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.
2022-06-24 17:54:41 drhok
34c. Windows
2022-06-24 17:54:36 drhok
33c. Windows
2022-06-24 17:35:31 drhok
29a. iBook PPC
2022-06-24 17:35:24 drhok
10. Tests for platform MacOS (PPC):
2022-06-24 17:35:22 drhok
10a. .selftest checks (see below)
2022-06-24 17:27:01 drhok
31. Verify that the amalgamation builds are byte-for-byte identical on all workstation platforms.
2022-06-24 17:26:57 drhok
31d. Windows using native MinGW.
9e74c300f6e363d22807c248ebd4e576bf4ca4b96d479e517f6f8653bdf2ac69 sqlite3.c ccf7428be64e7be45ed971e54edd1f9d03dd40bb3410f0fc47a5443f25f69074 sqlite3.h
2022-06-24 17:25:31 drhok
31c. Mac OS X (PPC)
9e74c300f6e363d22807c248ebd4e576bf4ca4b96d479e517f6f8653bdf2ac69 sqlite3.c ccf7428be64e7be45ed971e54edd1f9d03dd40bb3410f0fc47a5443f25f69074 sqlite3.h
2022-06-24 17:24:35 drhok
31e. Windows using NMAKE.
9e74c300f6e363d22807c248ebd4e576bf4ca4b96d479e517f6f8653bdf2ac69 sqlite3.c ccf7428be64e7be45ed971e54edd1f9d03dd40bb3410f0fc47a5443f25f69074 sqlite3.h
2022-06-24 17:23:04 drhok
31b. Mac OS X
9e74c300f6e363d22807c248ebd4e576bf4ca4b96d479e517f6f8653bdf2ac69 sqlite3.c ccf7428be64e7be45ed971e54edd1f9d03dd40bb3410f0fc47a5443f25f69074 sqlite3.h
2022-06-24 17:22:36 drhok
31a. Linux
9e74c300f6e363d22807c248ebd4e576bf4ca4b96d479e517f6f8653bdf2ac69 sqlite3.c ccf7428be64e7be45ed971e54edd1f9d03dd40bb3410f0fc47a5443f25f69074 sqlite3.h
2022-06-24 17:14:51 drhok
10c. Verify that Fossil repositories are cross-platform with x86/x64.
2022-06-24 17:14:48 drhok
10b. Recompile and test Fossil.
2022-06-24 17:03:15 drhok
14. Trunk changes merged and verified on active branches:
2022-06-24 17:03:13 drhok
14g. client-see (in the see-base repository)
2022-06-24 16:58:16 drhok
6. Tests for platform Linux x86_64:
2022-06-24 16:58:13 drhok
6i. Test the reuse-schema branch with ./configure --enable-all && make "OPTS=-DSQLITE_ENABLE_SHARED_SCHEMA" test.
2022-06-24 16:51:01 drhok
14f. see (in the see-base repository)
2022-06-24 16:33:55 danok
21h. At least one of the above on Windows.
21d
2022-06-24 16:33:47 danok
21e. th3make zipvfs.rc quick.rc
th3: 0 errors in 3833356 tests. 2084.600 seconds on DESKTOP-C1KR53M 32-bit little-endian th3: SQLite 3.39.0 2022-06-24 12:56:48 e93fd170ce4ae91d572c46d03f68f55d00091d0188030517455017d90d212587
2022-06-24 16:22:28 drhok
14e. reuse-schema (from trunk)
2022-06-24 16:07:12 danok
21f. At least one of the above on Linux.
21b ran on Linux.
2022-06-24 16:06:53 danpending
21d. th3make zipvfs.rc quick.rc -valgrind
on Linux
2022-06-24 16:06:27 danok
21b. th3make zipvfs.rc test.rc
th3: 0 errors in 14286386 tests. 5697.305 seconds on ws1 64-bit little-endian th3: SQLite 3.39.0 2022-06-24 12:56:48 e93fd170ce4ae91d572c46d03f68f55d00091d0188030517455017d90d212587
2022-06-24 15:49:36 danpending
21e. th3make zipvfs.rc quick.rc
on win32
2022-06-24 15:26:47 drhok
14d. begin-concurrent-pnu-wal2 (from wal2)
2022-06-24 15:26:45 drhok
14c. wal2 (from trunk)
2022-06-24 15:26:07 drhok
6j. CC=clang CFLAGS='-fsanitize=thread' ./configure && make threadtest5 && ./threadtest5
2022-06-24 15:11:11 drhok
6c. tclsh multitest.tcl --scenario obscure
2022-06-24 15:10:56 drhok
14b. begin-concurrent-report (from begin-concurrent-pnu)
2022-06-24 15:10:12 danpending
21c. th3make zipvfs.rc memdebug.rc
on osx
2022-06-24 14:58:44 drhok
14a. begin-concurrent (from trunk)
2022-06-24 14:58:22 drhok
6b. tclsh multitest.tcl --scenario coverage
1 branch miss each on STAT4 (t02) and on vfs-cov.rc. Deemed pass.
2022-06-24 14:53:24 drhok
6h. CC=clang CFLAGS='-fsanitize=address,undefined' ./configure --enable-debug --enable-all && make test
2022-06-24 14:47:32 drhok
6g. sh tool/symbols.sh - no incorrect exports or dependencies
2022-06-24 14:47:22 drhok
6f. tclsh test/wapptest.tcl --platform Failure-Detection -noui - all failures detected
2022-06-24 14:46:49 drhok
6d. tclsh multitest.tcl --scenario failures - all failures detected
2022-06-24 14:36:00 drhok
6a. tclsh multitest.tcl
0 failures on 50 th3makes and 251668233 tests in (01:14:29) 16 cores on r21 SQLite 3.39.0 2022-06-24 12:56:48 e93fd170ce4ae91d572c46d03f68f55d00091d0188030517455017d90d212587
2022-06-24 14:35:35 drhok
6e. tclsh test/wapptest.tcl -noui --debug
0 errors from 16985445 tests in 50 configurations. SQLite version 3.39.0 2022-06-24 12:56:48 e93fd170ce4ae91d572c46d03f68f55d00091d0188030517455017d90d212587
2022-06-24 14:30:18 danpending
21b. th3make zipvfs.rc test.rc
2022-06-24 13:37:30 danok
13. 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 2022-06-23 12:36:56 5fa00959ebc3a46fe400564d5a30e8c44857cd4f0473fb25e84154019eff3f39 0 errors out of 253484 tests on ws1 Linux 64-bit little-endian
2022-06-24 13:36:04 danok
12. Tests for platform OpenBSD (x86):
2022-06-24 13:36:01 danok
12b. th3make quick.rc
th3: 0 errors in 2512670 tests. 2888.809 seconds on obsd.home.com 32-bit little-endian th3: SQLite 3.39.0 2022-06-23 12:36:56 5fa00959ebc3a46fe400564d5a30e8c44857cd4f0473fb25e84154019eff3f39
2022-06-24 13:35:19 danok
13. 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"
th3: 0 errors in 2512670 tests. 2888.809 seconds on obsd.home.com 32-bit little-endian th3: SQLite 3.39.0 2022-06-23 12:36:56 5fa00959ebc3a46fe400564d5a30e8c44857cd4f0473fb25e84154019eff3f39
2022-06-24 12:13:41 drhok
15. Dbsqlfuzz tests
2022-06-24 12:13:38 drhok
15g. CFLAGS='-Os -g -DSQLITE_VDBE_COVERAGE' make -e clean fuzzcheck && ./fuzzcheck $CORPUS --spinner
2022-06-24 12:10:13 drhok
15i. Win10/MSVC: fuzzcheck $CORPUS -spinner
2022-06-24 12:10:10 drhok
15h. Mac: fuzzcheck $CORPUS --spinner
2022-06-24 12:10:06 drhok
15f. CC=clang CFLAGS='-Os -g -fsanitize=memory' make -e clean fuzzcheck && ./fuzzcheck $CORPUS --spinner
2022-06-24 12:10:03 drhok
15e. CC=clang CFLAGS='-Os -g -fsanitize=address' make -e clean fuzzcheck && ./fuzzcheck $CORPUS --spinner
2022-06-24 12:10:01 drhok
15d. CC=clang CFLAGS='-Os -g -fsanitize=undefined' make -e clean fuzzcheck && ./fuzzcheck $CORPUS --spinner
2022-06-24 12:09:59 drhok
15c. valgrind fuzzcheck $CORPUS --spinner
2022-06-24 12:03:49 drhok
8. Tests for platform MacOS x64:
2022-06-24 12:03:47 drhok
8c. tclsh multitest.tcl --scenario failures - all failures detected
2022-06-24 12:03:07 drhok
8b. tclsh multitest.tcl --quick
0 failures on 16 th3makes and 33213530 tests in (01:28:17) 2 cores on SQLite-iMac-2018 SQLite 3.39.0 2022-06-23 12:36:56 5fa00959ebc3a46fe400564d5a30e8c44857cd4f0473fb25e84154019eff3f39
2022-06-24 10:26:43 drhok
4. Compiler warning checks.
2022-06-24 10:26:40 drhok
4b. Mac OS X GCC -Wall -Wextra (the "tool/warnings.sh" script)
2022-06-24 10:26:29 drhok
4d. Clang-10.0.0: CFLAGS='-O0' ./configure --enable-debug --enable-all && scan-build make sqlite3
2022-06-24 10:26:26 drhok
4c. Clang-6.0.0: CFLAGS='-O0' ./configure --enable-debug --enable-all && scan-build make sqlite3
2022-06-24 10:24:58 drhok
8d. tclsh test/wapptest.tcl -platform Failure-Detection -noui - all failures detected
2022-06-24 10:14:45 drhok
5. OMIT, ENABLE, and DISABLE options:
2022-06-24 10:14:43 drhok
5a. tclsh ../tool/omittest.tcl -skip_run -target libsqlite3.a
2022-06-24 10:13:26 drhok
4a. Linux GCC -Wall -Wextra (the "tool/warnings.sh" script)
2022-06-24 10:12:20 drhok
8a. tclsh test/wapptest.tcl -noui --debug
0 errors from 6614178 tests in 12 configurations. SQLite version 3.39.0 2022-06-23 12:36:56 5fa00959ebc3a46fe400564d5a30e8c44857cd4f0473fb25e84154019eff3f39
2022-06-24 01:25:59 drhok
17. Build using the configure/make in main source tree.
2022-06-24 01:25:54 drhok
17b. Verify the correct version numbers have been installed.
2022-06-24 01:25:52 drhok
17a. Make sure that autoconf has been run to update the configure script.
2022-06-24 01:24:07 drhok
16. Sqllogictest:
2022-06-24 01:24:04 drhok
16d. tclsh run-all.tcl - on windows
2022-06-24 01:09:31 drhok
16c. tclsh run-all.tcl - on unix
2022-06-24 00:40:40 drhok
16b. No SQLite compiler warnings.
2022-06-24 00:40:36 drhok
16a. Checked in latest SQLite amalgamation.
2022-06-23 23:50:04 drhok
18. Fossil updated to use the latest SQLite.
2022-06-23 23:50:01 drhok
18c. fossil all test-integrity -d
2022-06-23 23:49:58 drhok
18b. Used on active websites with no issues.
2022-06-23 23:49:55 drhok
18a. No SQLite compiler warnings.
2022-06-23 23:49:33 drhok
11. Tests for platform Windows:
2022-06-23 23:49:30 drhok
11g. Verify that EXEs and DLLs generated using MSVC contain the correct version number, product name, description, and copyright as resources.
2022-06-23 23:45:51 drhok
11f. sh tool/symbols-mingw.sh - no incorrect exports or dependencies
2022-06-23 23:43:39 drhok
11c. tclsh multitest.tcl --msvc --scenario failures - verify failures detected
2022-06-23 23:42:02 drhok
11b. tclsh multitest.tcl --msvc --quick on x86
0 failures on 16 th3makes and 32824728 tests in (02:33:10) 2 cores on SQLiteWin10 SQLite 3.39.0 2022-06-22 18:51:47 83ff1a28e3e7a99fa90d5079897d76529c4256eed859bf7cb98b860fbedfdc5b
2022-06-23 20:03:36 danok
21a. testfixture ../zipvfs/test/zipvfs.test (See test/README.md for details)
SQLite 2022-06-23 12:36:56 5fa000 errors out of 74182 tests on ws1 Linux 64-bit little-endian 959ebc3a46fe400564d5a30e8c44857cd4f0473fb25e84154019eff3f39
2022-06-23 19:50:26 drhok
11a. tclsh multitest.tcl --msvc --quick on x64
0 failures on 16 th3makes and 33024812 tests in (03:11:51) on SQLiteWin10 SQLite 3.39.0 2022-06-22 18:51:47 83ff1a28e3e7a99fa90d5079897d76529c4256eed859bf7cb98b860fbedfdc5b
2022-06-23 18:10:26 danfail
12b. th3make quick.rc
th3: 2 errors in 2512663 tests. 3912.428 seconds on obsd.home.com 32-bit little-endian th3: SQLite 3.39.0 2022-06-23 12:36:56 5fa00959ebc3a46fe400564d5a30e8c44857cd4f0473fb25e84154019eff3f39 c3.memdb03.200... FAILED Expected: [17 5] Got: [0 17 5] cM.memdb03.200... FAILED Expected: [17 5] Got: [0 17 5]
2022-06-23 17:52:36 danok
12a. make test
SQLite 2022-06-23 12:36:56 5fa00959ebc3a46fe400564d5a30e8c44857cd4f0473fb25e84154019eff3f39 0 errors out of 214757 tests on obsd.home.com OpenBSD 32-bit little-endian
2022-06-23 17:00:20 drhok
7b. Recompile and test Fossil.
2022-06-23 16:08:42 drhok
11e. tclsh test/wapptest.tcl --msvc --platform Failure-Detection -noui - all failures detected
2022-06-23 15:58:34 danok
13. 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 2022-06-23 12:36:56 5fa00959ebc3a46fe400564d5a30e8c44857cd4f0473fb25e84154019eff3f39 0 errors out of 253484 tests on ws1 Linux 64-bit little-endian
2022-06-23 15:58:02 danok
13. 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"
2022-06-23 15:42:51 drhok
11d. tclsh test/wapptest.tcl --msvc -noui --debug
0 errors from 3380497 tests in 12 configurations. SQLite version 3.39.0 2022-06-22 18:51:47 83ff1a28e3e7a99fa90d5079897d76529c4256eed859bf7cb98b860fbedfdc5b
2022-06-23 14:19:56 drhok
9. Tests for platform MacOS ARM:
2022-06-23 14:19:52 drhok
9b. tclsh multitest.tcl --quick
0 failures on 16 th3makes and 33212211 tests in (00:20:56) 3 cores on minimac SQLite 3.39.0 2022-06-22 18:51:47 83ff1a28e3e7a99fa90d5079897d76529c4256eed859bf7cb98b860fbedfdc5b
2022-06-23 13:47:47 drhok
9a. tclsh test/wapptest.tcl -noui --debug
0 errors from 6094141 tests in 12 configurations. SQLite version 3.39.0 2022-06-22 18:51:47 83ff1a28e3e7a99fa90d5079897d76529c4256eed859bf7cb98b860fbedfdc5b
2022-06-23 12:08:40 drhpending
9a. tclsh test/wapptest.tcl -noui --debug
2022-06-23 12:04:41 drhpending
11d. tclsh test/wapptest.tcl --msvc -noui --debug
2022-06-22 21:14:41 drhok
3i. Check new/changed documentation for spelling and gramatical mistakes.
2022-06-22 18:43:35 drhok
15b. Check-in CORPUS as an unversioned file in the dbsqlfuzz repository
2022-06-22 18:43:32 drhok
15a. Develop a new CORPUS database by running dbsqlfuzz for 10 billion iterations
2022-06-22 18:43:05 drhok
3g. Database footprint is up-to-date (features.html).
2022-06-22 17:06:30 drhok
3h. Test metrics are up-to-date (testing.html).
2022-06-22 17:06:22 drhok
3f. The compile-time options are all up-to-date (compile.html).
2022-06-22 17:06:18 drhok
3e. Requirements marks are up-to-date in both documentation and source code. Do this early so that necessary code changes are well validated by subsequent checklist items.
2022-06-22 17:06:15 drhok
3d. No unresolved hyperlinks in the documentation build.
2022-06-22 17:06:12 drhok
3b. Release announcement in "changes.in".
2022-06-22 17:06:08 drhok
3a. Latest release on the "index.html" page.
2022-06-22 16:03:38 drhok
2. Source code change review. fossil diff --from release --to trunk
2022-06-22 16:03:35 drhok
2l. Compare sqlite3.c and sqlite3.h against the previous release.
2022-06-22 16:03:32 drhok
2k. Significant compile-time options are recognized by the sqlite3_compileoption_used() interface.
2022-06-22 16:03:29 drhok
2j. Verify that the list of APIs exposed via the extension header is up-to-date (sqlite3ext.h).
2022-06-22 16:02:57 drhok
2i. Verify that source code contains no tabs and that surplus whitespace has been removed.
2022-06-22 16:02:37 drhok
2h. 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]*(/
2022-06-22 15:54:07 drhok
2g. Check all calls to sqlite3OsRead() and sqlite3OsWrite() to ensure that offset computations are 64-bit clean.
2022-06-22 15:53:27 drhok
2f. Variables and functions have been renamed to reflect changes in their use.
2022-06-22 15:53:20 drhok
2e. Comments have been updated to reflect code changes.
2022-06-22 15:53:16 drhok
2d. New code complies with design rules.
2022-06-22 15:53:14 drhok
2c. New code complies with style guidelines.
2022-06-22 15:53:10 drhok
2b. All significant changes are mentioned in the "changes" log of the documentation.
2022-06-22 15:53:08 drhok
2a. No stray changes.
2022-06-21 23:40:56 drhok
1. Test procedure review.
2022-06-21 23:40:53 drhok
1c. Review this checklist for completeness and accuracy.
2022-06-21 23:39:57 drhok
1b. Review "multitest.tcl" and "alignment*.rc" scripts in TH3 for completeness.
2022-06-21 23:38:53 drhok
1a. Review the "test/wapptest.tcl" script for completeness and accuracy.