SQLite

Release Checklist for SQLite 3.35.0
Login
2021-03-12 13:47:01 drhok
3e. Requirements marks are up-to-date in both documentation and source code.
2021-03-12 10:36:56 danok
20. ZIPVFS tests:
2021-03-12 10:36:52 danok
20d. th3make zipvfs.rc quick.rc -valgrind
th3: 0 errors in 3355496 tests. 60597.556 seconds on darkstar 64-bit little-endian th3: SQLite 3.35.0 2021-03-11 15:57:25 07150cf15ad36c7fc681a911f66db23d610ddf110a7be7f1fcefbd8750cd135a ==17066== ERROR SUMMARY: 0 errors from 0 contexts (suppressed: 0 from 0)
2021-03-11 23:49:57 drhok
6a. tclsh multitest.tcl
0 failures on 44 th3makes and 243885364 tests in (02:54:58) 8 cores on abby SQLite 3.35.0 2021-03-09 21:20:12 9645fe1a050e8b61aea1fba2f142819c387ecb043741392c5719bf7ad303bf8b -- 0 failures on 44 th3makes and 243892253 tests in (02:56:09) 8 cores on abby SQLite 3.35.0 2021-03-10 20:04:21 424b39eaeb578f85e58214af4b467e6e363431308ab7a327774e62fa70d3c2db -- 0 failures on 44 th3makes and 243889045 tests in (02:55:31) 8 cores on abby SQLite 3.35.0 2021-03-11 15:57:25 07150cf15ad36c7fc681a911f66db23d610ddf110a7be7f1fcefbd8750cd135a
2021-03-11 21:45:16 danok
20g. At least one of the above on Mac OS X.
20c
2021-03-11 21:45:00 danok
20c. th3make zipvfs.rc memdebug.rc
th3: 0 errors in 10093333 tests. 11651.986 seconds on Dans-iMac.local 64-bit little-endian th3: SQLite 3.35.0 2021-03-11 15:57:25 07150cf15ad36c7fc681a911f66db23d610ddf110a7be7f1fcefbd8750cd135a
2021-03-11 21:43:26 drhok
3i. Check new/changed documentation for spelling and gramatical mistakes.
2021-03-11 21:42:03 drhok
3f. The compile-time options are all up-to-date (compile.html).
2021-03-11 21:41:59 drhok
3h. Test metrics are up-to-date (testing.html).
2021-03-11 21:41:56 drhok
3g. Database footprint is up-to-date (features.html).
2021-03-11 21:40:55 drhok
3e. Requirements marks are up-to-date in both documentation and source code.
There are stale requirements marks. I'll fix them later. They won't affect the release.
2021-03-11 21:40:33 drhok
3d. No unresolved hyperlinks in the documentation build.
2021-03-11 21:40:30 drhok
3b. Release announcement in "changes.in".
2021-03-11 21:38:21 drhok
29. Verify that the performance and size measurement spreadsheet in the documentation (misc/speed-size-graph.ods) is up-to-date.
2021-03-11 21:31:23 drhok
3a. Latest release on the "index.html" page.
2021-03-11 21:25:31 drhok
27. Compare performance to the previous release using kvtest.
2021-03-11 21:25:28 drhok
27b. Mac
2021-03-11 21:24:31 drhok
24. Performance tests using speedtest1 compared against the previous release and a release from about one year ago.
2021-03-11 21:20:31 drhok
23. TEA archive builds correctly and runs:
2021-03-11 21:20:28 drhok
23c. Mac OS X
2021-03-11 21:20:14 drhok
24b. Mac
2021-03-11 21:19:01 drhok
22. Amalgamation autoconf tarball.
2021-03-11 21:18:57 drhok
22c. Works on Mac OS X.
2021-03-11 21:18:26 drhok
8. Tests for platform Mac OS X:
2021-03-11 21:18:23 drhok
8d. tclsh test/wapptest.tcl -platform Failure-Detection -noui - all failures detected
8 errors from 197 tests in 7 configurations. SQLite version 3.35.0 2021-03-11 15:57:25 07150cf15ad36c7fc681a911f66db23d610ddf110a7be7f1fcefbd8750cd135a
2021-03-11 21:17:14 drhok
1. Test procedure review.
2021-03-11 21:17:12 drhok
1c. Review this checklist for completeness and accuracy.
2021-03-11 21:17:09 drhok
1b. Review "multitest.tcl" and "alignment*.rc" scripts in TH3 for completeness.
2021-03-11 21:17:07 drhok
1a. Review the "test/wapptest.tcl" script for completeness and accuracy.
2021-03-11 21:14:18 drhok
8c. tclsh multitest.tcl --scenario failures - all failures detected
2021-03-11 21:13:48 drhok
8b. tclsh multitest.tcl --quick
0 failures on 16 th3makes and 28515709 tests in (00:51:33) 2 cores on SQLite-iMac-2018 SQLite 3.35.0 2021-03-11 15:57:25 07150cf15ad36c7fc681a911f66db23d610ddf110a7be7f1fcefbd8750cd135a
2021-03-11 21:01:03 danok
13. Trunk changes merged and verified on active branches:
2021-03-11 21:01:00 danok
13f. reuse-schema (from trunk)
veryquick.test passes.
2021-03-11 20:43:09 drhok
21. NDS-Devkit testing
2021-03-11 20:43:03 drhok
21c. Verify the "NDS DevKit" version number shown at the end of the test
2021-03-11 20:42:54 drhok
21b. Test using: tclsh th3make test.rc nds_devkit.rc
th3: 23abbd744567a61c6e2258464cdb7935c9ed964d7c06d7be6ef53d4dd8a98a6a 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_JSON1 -DSQLITE_ENABLE_STMTVTAB -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: 24 errors in 9205019 tests. 2964.867 seconds on bella 64-bit little-endian th3: NDS DevKit 3.35.0 2021-03-11 19:34:42 47732c5134044dfa th3: SQLite 3.35.0 2021-03-11 10:55:08 ef8c6e06cb094c5a6f5862f0f3f2a67c3db40dc39e520cc421311bcb55e0f762
2021-03-11 20:31:05 danok
20h. At least one of the above on Windows.
20b
2021-03-11 20:30:56 danok
20b. th3make zipvfs.rc test.rc
th3: 0 errors in 10510666 tests. 6901.933 seconds on DESKTOP-C1KR53M 32-bit little-endian th3: SQLite 3.35.0 2021-03-11 15:57:25 07150cf15ad36c7fc681a911f66db23d610ddf110a7be7f1fcefbd8750cd135a
2021-03-11 20:19:02 danok
13e. begin-concurrent-pnu-wal2 (from wal2)
veryquick.test passes.
2021-03-11 19:42:27 danok
13d. wal2 (from trunk)
veryquick.test passes.
2021-03-11 19:42:14 danok
13c. begin-concurrent-report (from begin-concurrent-pnu)
veryquick.test passes
2021-03-11 19:40:17 drhok
19. SEE tests using TH3:
2021-03-11 19:40:11 drhok
19n. At least one of the above on Mac OS X.
2021-03-11 19:40:08 drhok
19f. see-cccrypt.c
th3: 37a59976e377e8cc19fd11b0ad9558c6f3c2178c25b38377aa4d0b44e0e00a45 th3: ./th3make quick.rc see.rc th3: mkth3.tcl -DSQLITE_DEBUG -DSQLITE_ENABLE_BYTECODE_VTAB -DSQLITE_ENABLE_DESERIALIZE -DSQLITE_ENABLE_JSON1 -DSQLITE_ENABLE_STMTVTAB -DSQLITE_HAS_CODEC cfg/c?.cfg cfg/wal1.cfg cfg/f2fs.cfg coverage.testplan cov1/?*.test th3: 0 errors in 2104621 tests. 386.506 seconds on SQLite-iMac-2018 64-bit little-endian th3: SQLite 3.35.0 2021-03-10 23:45:10 2a0cda1e263db1d5baa571f1e69437a0dc89822e22211e987640333ee99e4332
2021-03-11 19:38:17 drhpending
21b. Test using: tclsh th3make test.rc nds_devkit.rc
2021-03-11 19:36:36 drhok
21a. Merge all trunk enhancements into the reuse-schema branch and use that branch to update the devkit.
2021-03-11 19:30:40 drhok
19d. see-rc4.c
th3: ./th3make quick.rc see.rc th3: mkth3.tcl -DSQLITE_DEBUG -DSQLITE_ENABLE_BYTECODE_VTAB -DSQLITE_ENABLE_DESERIALIZE -DSQLITE_ENABLE_JSON1 -DSQLITE_ENABLE_STMTVTAB -DSQLITE_HAS_CODEC cfg/c?.cfg cfg/wal1.cfg cfg/f2fs.cfg coverage.testplan cov1/?*.test th3: 0 errors in 2121795 tests. 326.596 seconds on abby 64-bit little-endian th3: SQLite 3.35.0 2021-03-10 23:45:10 2a0cda1e263db1d5baa571f1e69437a0dc89822e22211e987640333ee99e4332
2021-03-11 19:26:18 danok
13c. begin-concurrent-report (from begin-concurrent-pnu)
veryquick.test passes.
2021-03-11 19:22:53 drhok
19c. see-aes256-ofb.c
th3: 37a59976e377e8cc19fd11b0ad9558c6f3c2178c25b38377aa4d0b44e0e00a45 th3: ./th3make quick.rc see.rc th3: mkth3.tcl -DSQLITE_DEBUG -DSQLITE_ENABLE_BYTECODE_VTAB -DSQLITE_ENABLE_DESERIALIZE -DSQLITE_ENABLE_JSON1 -DSQLITE_ENABLE_STMTVTAB -DSQLITE_HAS_CODEC cfg/c?.cfg cfg/wal1.cfg cfg/f2fs.cfg coverage.testplan cov1/?*.test th3: 0 errors in 2121753 tests. 282.231 seconds on abby 64-bit little-endian th3: SQLite 3.35.0 2021-03-10 23:45:10 2a0cda1e263db1d5baa571f1e69437a0dc89822e22211e987640333ee99e4332
2021-03-11 19:09:17 danok
13b. begin-concurrent-pnu (from trunk)
veryquick.test passes.
2021-03-11 19:07:27 drhok
19b. see-aes128-ofb.c
th3: 37a59976e377e8cc19fd11b0ad9558c6f3c2178c25b38377aa4d0b44e0e00a45 th3: ./th3make quick.rc see.rc th3: mkth3.tcl -DSQLITE_DEBUG -DSQLITE_ENABLE_BYTECODE_VTAB -DSQLITE_ENABLE_DESERIALIZE -DSQLITE_ENABLE_JSON1 -DSQLITE_ENABLE_STMTVTAB -DSQLITE_HAS_CODEC cfg/c?.cfg cfg/wal1.cfg cfg/f2fs.cfg coverage.testplan cov1/?*.test th3: 0 errors in 2121751 tests. 265.157 seconds on abby 64-bit little-endian th3: SQLite 3.35.0 2021-03-10 23:45:10 2a0cda1e263db1d5baa571f1e69437a0dc89822e22211e987640333ee99e4332
2021-03-11 19:02:11 drhok
18. CEROD tests in the "test/" subdirectory.
2021-03-11 18:55:38 drhok
27a. Linux
2021-03-11 18:53:08 drhok
6. Tests for platform Linux x86_64:
2021-03-11 18:53:05 drhok
6e. tclsh test/wapptest.tcl --platform Failure-Detection -noui - all failures detected
2021-03-11 18:51:45 danok
13a. begin-concurrent (from trunk)
veryquick.test passes.
2021-03-11 18:47:39 drhok
6b. tclsh test/wapptest.tcl -noui --debug
0 errors from 16848696 tests in 34 configurations. SQLite version 3.35.0 2021-03-11 15:57:25 07150cf15ad36c7fc681a911f66db23d610ddf110a7be7f1fcefbd8750cd135a
2021-03-11 18:31:06 danok
37. Website built procedures
2021-03-11 18:31:03 danok
37b. All build products work on their target platforms
2021-03-11 18:27:48 danok
37a. Compile-time options for build products have been updated as necessary
-municode added to windows shell build.
2021-03-11 18:27:13 drhok
27c. Windows
2021-03-11 18:24:25 drhok
25. Performance tests using speedtest1 --testset rtree
2021-03-11 18:24:22 drhok
25b. Windows
2021-03-11 18:23:16 drhok
24c. Windows
2021-03-11 18:17:37 drhok
22d. Works on Windows MinGW
2021-03-11 18:11:23 danok
31. 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 using backcompat.test against 3.7.3 and 3.8.2. SQLite 2021-03-11 15:57:25 07150cf15ad36c7fc681a911f66db23d610ddf110a7be7f1fcefbd8750cd135a 0 errors out of 265 tests on darkstar Linux 64-bit little-endian
2021-03-11 18:10:28 drhok
23d. Windows MSVC
2021-03-11 18:08:48 drhok
22e. Works on Windows MSVC
2021-03-11 18:07:58 drhpending
8b. tclsh multitest.tcl --quick
2021-03-11 18:06:50 drhok
8a. tclsh test/wapptest.tcl -noui --debug
0 errors from 6513662 tests in 6 configurations. SQLite version 3.35.0 2021-03-11 13:43:29 41df3bbefd63151f2ddb920066777eab8e07ecfc0edb0f71f9493debe0a4a2c4
2021-03-11 18:05:18 drhok
23b. Linux
2021-03-11 18:05:15 drhok
23a. Verify that the SQLite version number is correct in autoconf/tea/configure.ac
2021-03-11 18:02:47 drhok
22b. Works on Linux.
2021-03-11 18:02:40 drhok
22a. Builds.
2021-03-11 18:01:54 danok
11. Tests for platform OpenBSD (x86):
2021-03-11 18:01:52 danok
11b. th3make quick.rc
th3: 0 errors in 2155572 tests. 2456.034 seconds on obsd.home.com 32-bit little-endian th3: SQLite 3.35.0 2021-03-11 13:43:29 41df3bbefd63151f2ddb920066777eab8e07ecfc0edb0f71f9493debe0a4a2c4
2021-03-11 18:01:10 drhok
19o. At least one of the above on Windows.
2021-03-11 18:01:04 drhok
19l. At least one of the above with option -DSQLITE_DIRECT_OVERFLOW_READ.
2021-03-11 18:00:59 drhok
19i. Verify that builds work with -DSQLITE_ENABLE_UPDATE_DELETE_LIMIT
2021-03-11 18:00:53 drhok
19h. see-aes256-cryptoapi.c
th3: mkth3.tcl -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_JSON1 -DSQLITE_ENABLE_STMTVTAB -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 2153361 tests. 1065.443 seconds on SQLiteWin10 64-bit little-endian th3: SQLite 3.35.0 2021-03-10 23:45:10 2a0cda1e263db1d5baa571f1e69437a0dc89822e22211e987640333ee99e4332
2021-03-11 17:57:33 danok
20e. th3make zipvfs.rc quick.rc
th3: 0 errors in 3357239 tests. 1251.510 seconds on darkstar 64-bit little-endian th3: SQLite 3.35.0 2021-03-11 15:57:25 07150cf15ad36c7fc681a911f66db23d610ddf110a7be7f1fcefbd8750cd135a
2021-03-11 17:57:28 danpending
20e. th3make zipvfs.rc quick.rc
th3: 0 errors in 3357239 tests. 1251.510 seconds on darkstar 64-bit little-endian th3: SQLite 3.35.0 2021-03-11 15:57:25 07150cf15ad36c7fc681a911f66db23d610ddf110a7be7f1fcefbd8750cd135a
2021-03-11 17:54:16 drhpending
19h. see-aes256-cryptoapi.c
2021-03-11 17:15:16 danok
35. Run the rbu/run_rbu_tests.tcl script in the test-dbs project on Linux.
All tests report "round trip successful".
2021-03-11 16:56:48 danpending
20e. th3make zipvfs.rc quick.rc
linux
2021-03-11 16:56:42 danpending
20d. th3make zipvfs.rc quick.rc -valgrind
on linux
2021-03-11 16:56:34 danpending
20c. th3make zipvfs.rc memdebug.rc
on osx
2021-03-11 16:56:29 danprelim
20c. th3make zipvfs.rc memdebug.rc
on osx
2021-03-11 16:56:22 danpending
20b. th3make zipvfs.rc test.rc
on windows
2021-03-11 16:19:39 danok
16. Build using the configure/make in main source tree.
2021-03-11 16:19:36 danok
16b. Verify the correct version numbers have been installed.
3.35.0
2021-03-11 16:19:30 danok
16a. Make sure that autoconf has been run to update the configure script.
2021-03-11 15:26:20 drhok
28. Use the ".selftest" command of the shell to verify that legacy database files are readable and cross-platform
2021-03-11 15:26:17 drhok
28d. Windows
2021-03-11 15:23:56 drhok
30. Verify that the amalgamation builds are byte-for-byte identical on all workstation platforms.
2021-03-11 15:23:52 drhok
30d. Windows using native MinGW.
e6f4b25e27421edf56ff92c17839b7c1e1b1682b2d41019069c3d33405997ca0 sqlite3.c 215fb0bbc7e06a5204416810ed67aa19186faeeac7e48a9d6df32094a8598d62 sqlite3.h 3cbb6763c6e7248e0f1ce0a3609b3a8abeb614e517951c8421fce86c6699d202 manifest
2021-03-11 15:22:53 drhok
30e. Windows using NMAKE.
e6f4b25e27421edf56ff92c17839b7c1e1b1682b2d41019069c3d33405997ca0 sqlite3.c 215fb0bbc7e06a5204416810ed67aa19186faeeac7e48a9d6df32094a8598d62 sqlite3.h 3cbb6763c6e7248e0f1ce0a3609b3a8abeb614e517951c8421fce86c6699d202 manifest All of these are version f762d7df2a41a88560a4251d744e0887f42812f8
2021-03-11 15:21:03 danok
11a. make test
SQLite 2021-03-11 13:43:29 41df3bbefd63151f2ddb920066777eab8e07ecfc0edb0f71f9493debe0a4a2c4 0 errors out of 249650 tests on obsd.home.com OpenBSD 32-bit little-endian
2021-03-11 15:12:05 drhok
33. Build and verify sqldiff
2021-03-11 15:12:02 drhok
33c. Windows
2021-03-11 15:11:17 drhok
32. Build and verify correct operation of sqlite3_analyzer on:
2021-03-11 15:11:14 drhok
32c. Windows
2021-03-11 15:07:54 drhok
10. Tests for platform Windows:
2021-03-11 15:07:50 drhok
10f. sh tool/symbols-mingw.sh - no incorrect exports or dependencies
2021-03-11 15:06:47 drhok
10g. Verify that EXEs and DLLs generated using MSVC contain the correct version number, product name, description, and copyright as resources.
2021-03-11 15:03:05 drhok
10c. tclsh multitest.tcl --msvc --scenario failures - verify failures detected
2021-03-11 15:02:14 drhok
10b. tclsh multitest.tcl --msvc --quick on x86
0 failures on 13 th3makes and 26090381 tests in (02:16:39) 2 cores on SQLiteWin10 SQLite 3.35.0 2021-03-10 20:04:21 424b39eaeb578f85e58214af4b467e6e363431308ab7a327774e62fa70d3c2db
2021-03-11 15:02:07 drhpending
10b. tclsh multitest.tcl --msvc --quick on x86
0 failures on 13 th3makes and 26090381 tests in (02:16:39) 2 cores on SQLiteWin10 SQLite 3.35.0 2021-03-10 20:04:21 424b39eaeb578f85e58214af4b467e6e363431308ab7a327774e62fa70d3c2db
2021-03-11 13:45:50 drhpending
10b. tclsh multitest.tcl --msvc --quick on x86
2021-03-11 12:41:19 drhok
10a. tclsh multitest.tcl --msvc --quick on x64
0 failures on 16 th3makes and 28423916 tests in (03:40:15) on SQLiteWin10 SQLite 3.35.0 2021-03-10 20:04:21 424b39eaeb578f85e58214af4b467e6e363431308ab7a327774e62fa70d3c2db
2021-03-11 12:24:50 drhok
19k. At least one of the above using "memdebug.rc".
2021-03-11 12:24:41 drhok
19e. see-aes128-ccm.c
th3: e9e4a5b84d46a87554b6b6af560ececf338285ed09f8f558acc5ef039ab47388 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 10073238 tests. 8050.540 seconds on bella 64-bit little-endian th3: SQLite 3.35.0 2021-03-10 23:45:10 2a0cda1e263db1d5baa571f1e69437a0dc89822e22211e987640333ee99e4332
2021-03-11 11:29:24 danpending
11b. th3make quick.rc
2021-03-11 11:29:20 danpending
11a. make test
2021-03-11 11:27:03 danok
12. 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 2021-03-11 08:49:52 b7c92e1d08f213865f026d8dbdc4e805fb5c119b7f206506ed06e83a878de657 0 errors out of 248281 tests on darkstar Linux 64-bit little-endian
2021-03-11 11:13:48 danok
6h. Test the reuse-schema branch with ./configure --enable-all && make "OPTS=-DSQLITE_ENABLE_SHARED_SCHEMA" test.
SQLite 2021-03-11 10:55:08 ef8c6e06cb094c5a6f5862f0f3f2a67c3db40dc39e520cc421311bcb55e0f762 0 errors out of 295741 tests on darkstar Linux 64-bit little-endian
2021-03-11 01:22:18 drhok
19j. At least one of the above using "test.rc".
2021-03-11 01:22:15 drhok
19g. see-aes256-openssl.c
th3: 0 errors in 10518025 tests. 3422.980 seconds on bella 64-bit little-endian th3: SQLite 3.35.0 2021-03-10 23:45:10 2a0cda1e263db1d5baa571f1e69437a0dc89822e22211e987640333ee99e4332
2021-03-11 00:44:55 drhok
15. Sqllogictest:
2021-03-11 00:44:52 drhok
15c. tclsh run-all.tcl - on unix
0 errors out of 11879758 tests and 1244 invocations in 1331 seconds
2021-03-11 00:36:44 drhok
15a. Checked in latest SQLite amalgamation.
2021-03-11 00:20:09 drhok
34. Build the "atrc" test program and run "./atrc $DB | ./sqlite3 $DB" against multiple databases, visually verify the result
2021-03-11 00:15:00 drhok
24a. Linux
2021-03-11 00:14:20 drhok
25a. Linux
2021-03-11 00:11:13 drhok
26. Run make wordcount and do tests on current and prior versions:
2021-03-11 00:11:10 drhok
26b. rm -f wc.db && ./wordcount wc.db $BIGTEXT --all --cachesize 5 --nosync
2021-03-11 00:09:22 drhok
26a. rm -f wc.db && ./wordcount wc.db $BIGTEXT --all
2021-03-11 00:03:55 drhok
6a. tclsh multitest.tcl
0 failures on 44 th3makes and 243885364 tests in (02:54:58) 8 cores on abby SQLite 3.35.0 2021-03-09 21:20:12 9645fe1a050e8b61aea1fba2f142819c387ecb043741392c5719bf7ad303bf8b -- 0 failures on 44 th3makes and 243892253 tests in (02:56:09) 8 cores on abby SQLite 3.35.0 2021-03-10 20:04:21 424b39eaeb578f85e58214af4b467e6e363431308ab7a327774e62fa70d3c2db
2021-03-11 00:01:40 drhok
19m. At least one of the above on Linux.
2021-03-11 00:01:33 drhok
19a. see.c
th3: 0 errors in 2121753 tests. 323.272 seconds on bella 64-bit little-endian th3: SQLite 3.35.0 2021-03-10 23:45:10 2a0cda1e263db1d5baa571f1e69437a0dc89822e22211e987640333ee99e4332
2021-03-10 23:33:58 drhok
10d. tclsh test/wapptest.tcl --msvc -noui --debug
0 errors from 3234003 tests in 8 configurations. SQLite version 3.35.0 2021-03-10 10:43:17 f762d7df2a41a88560a4251d744e0887f42812f8160af4f0129d22a71c0fa48b -- 0 errors from 2436422 tests in 5 configurations. SQLite version 3.35.0 2021-03-10 20:04:21 424b39eaeb578f85e58214af4b467e6e363431308ab7a327774e62fa70d3c2db
2021-03-10 21:00:28 drhok
6g. CC=clang CFLAGS='-fsanitize=address,undefined' ./configure --enable-debug --enable-all && make test
2021-03-10 18:16:37 danok
20f. At least one of the above on Linux.
20a
2021-03-10 18:16:28 danok
20a. testfixture ../zipvfs/test/zipvfs.test (See test/README.md for details)
SQLite 2021-03-10 17:52:59 88132f698a7a9b7d41dd1dd393592cbda130d2bf1a9fd18c509503e1891b9655 0 errors out of 74141 tests on darkstar Linux 64-bit little-endian
2021-03-10 14:01:07 drhok
33a. Linux
2021-03-10 14:01:04 drhok
32a. Linux
2021-03-10 13:57:33 drhok
33b. Mac
2021-03-10 13:56:56 drhok
32b. Mac OS X
2021-03-10 13:56:12 drhok
36. 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.
2021-03-10 13:55:03 drhok
28c. Mac
2021-03-10 13:53:36 drhok
30b. Mac OS X
e6f4b25e27421edf56ff92c17839b7c1e1b1682b2d41019069c3d33405997ca0 sqlite3.c 215fb0bbc7e06a5204416810ed67aa19186faeeac7e48a9d6df32094a8598d62 sqlite3.h 3cbb6763c6e7248e0f1ce0a3609b3a8abeb614e517951c8421fce86c6699d202 manifest
2021-03-10 13:49:15 drhok
30c. Mac OS X (PPC)
e6f4b25e27421edf56ff92c17839b7c1e1b1682b2d41019069c3d33405997ca0 sqlite3.c 215fb0bbc7e06a5204416810ed67aa19186faeeac7e48a9d6df32094a8598d62 sqlite3.h 3cbb6763c6e7248e0f1ce0a3609b3a8abeb614e517951c8421fce86c6699d202 manifest
2021-03-10 13:49:01 drhok
30a. Linux
e6f4b25e27421edf56ff92c17839b7c1e1b1682b2d41019069c3d33405997ca0 sqlite3.c 215fb0bbc7e06a5204416810ed67aa19186faeeac7e48a9d6df32094a8598d62 sqlite3.h 3cbb6763c6e7248e0f1ce0a3609b3a8abeb614e517951c8421fce86c6699d202 manifest
2021-03-10 13:46:24 drhok
28b. Linux
2021-03-10 13:41:44 drhok
28a. iBook PPC
2021-03-10 13:41:33 drhok
9. Tests for platform Mac OS X 10.5 (PPC):
2021-03-10 13:41:31 drhok
9a. .selftest checks (see below)
2021-03-10 13:29:20 danok
10e. tclsh test/wapptest.tcl --msvc --platform Failure-Detection -noui - all failures detected
All configurations report errors: 7 errors from 99 tests in 3 configurations. SQLite version 3.35.0 2021-03-10 10:43:17 f762d7df2a41a88560a4251d744e0887f42812f8160af4f0129d22a71c0fa48b
2021-03-10 13:27:36 danok
10d. tclsh test/wapptest.tcl --msvc -noui --debug
0 errors from 3234003 tests in 8 configurations. SQLite version 3.35.0 2021-03-10 10:43:17 f762d7df2a41a88560a4251d744e0887f42812f8160af4f0129d22a71c0fa48b
2021-03-10 13:27:20 drhok
9c. Verify that Fossil repositories are cross-platform with x86/x64.
2021-03-10 13:27:15 drhok
9b. Recompile and test Fossil.
2021-03-10 13:13:44 drhok
14. Dbsqlfuzz tests
2021-03-10 13:13:41 drhok
14c. valgrind fuzzcheck $CORPUS --spinner
fuzzcheck: 0 errors out of 64586 tests in 6396.716 seconds SQLite 3.35.0 2021-03-09 23:38:27 a6681fbb2e0c8d5a7c968f6fd458f61658fad6ac4c7eb8663762b6ac386cdae5
2021-03-10 02:47:30 drhok
15d. tclsh run-all.tcl - on windows
0 errors out of 11879758 tests and 1244 invocations in 3474 seconds
2021-03-10 01:10:22 drhok
6d. tclsh multitest.tcl --scenario failures - all failures detected
2021-03-10 01:08:58 drhok
6c. tclsh multitest.tcl --scenario obscure
0 failures on 2 th3makes and 4327510 tests in (00:08:52) on abby SQLite 3.35.0 2021-03-09 21:20:12 9645fe1a050e8b61aea1fba2f142819c387ecb043741392c5719bf7ad303bf8b
2021-03-10 01:08:07 drhok
17. Fossil updated to use the latest SQLite.
2021-03-10 01:08:03 drhok
17c. fossil all test-integrity -d
2021-03-10 01:06:28 drhok
15b. No SQLite compiler warnings.
2021-03-10 01:02:53 drhok
14h. Win10/MSVC: fuzzcheck $CORPUS -spinner
fuzzcheck: 0 errors out of 64586 tests in 389.064 seconds SQLite 3.35.0 2021-03-09 23:38:27 a6681fbb2e0c8d5a7c968f6fd458f61658fad6ac4c7eb8663762b6ac386cdae5
2021-03-10 00:49:32 drhok
14f. CC=clang CFLAGS='-Os -g -fsanitize=memory' make -e clean fuzzcheck && ./fuzzcheck $CORPUS --spinner
fuzzcheck: 0 errors out of 64586 tests in 1108.914 seconds SQLite 3.35.0 2021-03-09 23:38:27 a6681fbb2e0c8d5a7c968f6fd458f61658fad6ac4c7eb8663762b6ac386cdae5
2021-03-10 00:39:51 drhok
6a. tclsh multitest.tcl
0 failures on 44 th3makes and 243885364 tests in (02:54:58) 8 cores on abby SQLite 3.35.0 2021-03-09 21:20:12 9645fe1a050e8b61aea1fba2f142819c387ecb043741392c5719bf7ad303bf8b
2021-03-10 00:28:49 drhok
14e. CC=clang CFLAGS='-Os -g -fsanitize=address' make -e clean fuzzcheck && ./fuzzcheck $CORPUS --spinner
fuzzcheck: 0 errors out of 64586 tests in 1112.346 seconds SQLite 3.35.0 2021-03-09 23:38:27 a6681fbb2e0c8d5a7c968f6fd458f61658fad6ac4c7eb8663762b6ac386cdae5
2021-03-10 00:10:47 drhok
7. Tests for platform Linux ARM (BeagleBoard or RaspberryPI)
2021-03-10 00:10:44 drhok
7a. tclsh th3make min.rc
th3: 839aedd8be6928aebfb5859ebd7ee9a6eae9989e110b1e19dc56c400f74d70b6 th3: ./th3make min.rc th3: mkth3.tcl cfg/c?.cfg cfg/wal1.cfg cfg/f2fs.cfg coverage.testplan cov1/?*.test th3: 0 errors in 1806339 tests. 4085.343 seconds on raspberrypi 32-bit little-endian th3: SQLite 3.35.0 2021-03-09 21:20:12 9645fe1a050e8b61aea1fba2f142819c387ecb043741392c5719bf7ad303bf8b
2021-03-10 00:07:58 drhok
14d. CC=clang CFLAGS='-Os -g -fsanitize=undefined' make -e clean fuzzcheck && ./fuzzcheck $CORPUS --spinner
fuzzcheck: 0 errors out of 64586 tests in 458.539 seconds SQLite 3.35.0 2021-03-09 23:38:27 a6681fbb2e0c8d5a7c968f6fd458f61658fad6ac4c7eb8663762b6ac386cdae5
2021-03-10 00:04:13 drhok
14g. Mac: fuzzcheck $CORPUS --spinner
2021-03-09 23:58:43 drhok
17b. Used on active websites with no issues.
2021-03-09 23:58:40 drhok
17a. No SQLite compiler warnings.
2021-03-09 22:05:42 drhok
7b. Recompile and test Fossil.
2021-03-09 22:04:09 drhok
5. OMIT, ENABLE, and DISABLE options:
2021-03-09 22:04:07 drhok
5a. tclsh ../tool/omittest.tcl -skip_run -target libsqlite3.a
2021-03-09 21:54:04 drhok
4. Compiler warning checks.
2021-03-09 21:54:02 drhok
4b. Mac OS X GCC -Wall -Wextra (the "tool/warnings.sh" script)
2021-03-09 21:39:49 drhok
6f. sh tool/symbols.sh - no incorrect exports or dependencies
2021-03-09 21:35:49 drhok
4a. Linux GCC -Wall -Wextra (the "tool/warnings.sh" script)
2021-03-09 21:19:11 drhok
2. Source code change review. fossil diff --from release --to trunk
2021-03-09 21:18:58 drhok
2l. Compare sqlite3.c and sqlite3.h against the previous release.
2021-03-09 20:47:38 drhok
2k. Significant compile-time options are recognized by the sqlite3_compileoption_used() interface.
2021-03-09 20:47:32 drhok
2j. Verify that the list of APIs exposed via the extension header is up-to-date (sqlite3ext.h).
2021-03-09 20:31:41 drhok
2i. Verify that source code contains no tabs and that surplus whitespace has been removed.
2021-03-09 20:31:05 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]*(/
2021-03-09 20:25:25 drhok
2g. Check all calls to sqlite3OsRead() and sqlite3OsWrite() to ensure that offset computations are 64-bit clean.
2021-03-09 20:24:56 drhok
2f. Variables and functions have been renamed to reflect changes in their use.
2021-03-09 20:24:52 drhok
2e. Comments have been updated to reflect code changes.
2021-03-09 20:24:49 drhok
2d. New code complies with design rules.
2021-03-09 20:24:46 drhok
2c. New code complies with style guidelines.
2021-03-09 20:24:44 drhok
2b. All significant changes are mentioned in the "changes" log of the documentation.
2021-03-09 20:24:41 drhok
2a. No stray changes.
2021-03-09 16:14:58 drhok
14b. Check-in CORPUS as an unversioned file in the dbsqlfuzz repository
2021-03-09 16:14:55 drhok
14a. Develop a new CORPUS database by running dbsqlfuzz for days and at least 100 million iterations
20210309.db contains 64586 cases resulting from a merge of over 1150 million test cases run over the previous five days.