All significant changes are mentioned in the "changes" log of the documentation.
New code complies with style guidelines.
New code complies with design rules.
Comments have been updated to reflect code changes.
Variables and functions have been renamed to reflect changes in their use.
Check all calls to sqlite3OsRead() and sqlite3OsWrite() to ensure that offset computations are 64-bit clean.
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]*(/
Verify that source code contains no tabs and that surplus whitespace has been removed.
Verify that the list of APIs exposed via the extension header is up-to-date (sqlite3ext.h).
Significant compile-time options are recognized by the sqlite3_compileoption_used() interface.
Compare sqlite3.c and sqlite3.h against the previous release.
Documentation review:
Latest release on the "index.html" page.
Release announcement in "changes.in".
Release accouncement in "news.html".
No unresolved hyperlinks in the documentation build.
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.
The compile-time options are all up-to-date (compile.html).
Database footprint is up-to-date (features.html).
Test metrics are up-to-date (testing.html).
Check new/changed documentation for spelling and gramatical mistakes.
Compiler warning checks.
Linux GCC -Wall -Wextra (the "tool/warnings.sh" script)
Mac OS X GCC -Wall -Wextra (the "tool/warnings.sh" script)
Clang-6.0.0: CFLAGS='-O0' ./configure --enable-debug --enable-all && scan-build make sqlite3
Clang-10.0.0: CFLAGS='-O0' ./configure --enable-debug --enable-all && scan-build make sqlite3
tclsh test/wapptest.tcl --msvc --platform Failure-Detection -noui - all failures detected
sh tool/symbols-mingw.sh - no incorrect exports or dependencies
Verify that EXEs and DLLs generated using MSVC contain the correct version number, product name, description, and copyright as resources.
Tests for platform OpenBSD (x86):
make test
th3make quick.rc
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"
Trunk changes merged and verified on active branches:
Compare performance to the previous release using kvtest.
Linux
Mac
Windows
Use the ".selftest" command of the shell to verify that legacy database files are readable and cross-platform
iBook PPC
Linux
Mac
Windows
Verify that the performance and size measurement spreadsheet in the documentation (misc/speed-size-graph.ods) is up-to-date.
Verify that the amalgamation builds are byte-for-byte identical on all workstation platforms.
Linux
Mac OS X
Mac OS X (PPC)
Windows using native MinGW.
Windows using NMAKE.
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.
Build and verify correct operation of sqlite3_analyzer on:
Linux
Mac OS X
Windows
Build and verify sqldiff
Linux
Mac
Windows
Build the "atrc" test program and run "./atrc $DB | ./sqlite3 $DB" against multiple databases, visually verify the result
Run the rbu/run_rbu_tests.tcl script in the test-dbs project on Linux.
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.
Website built procedures
Compile-time options in builds/products_build.sh in the supportdb repository has been updated to align with any changes to the default makefiles.
tools/mkmsvcmin.tcl has been run to update the MSVC makefiles in autoconf
Compile-time options for build products have been updated as necessary