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.
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)
Windows (32-bit) MSVC using option /W4 (nmake /f makefile.msc)
Windows (64-bit) MSVC using option /W4 (nmake /f makefile.msc)
tclsh releasetest.tcl --platform Failure-Detection - all failures detected
nmake /f makefile.msc MEMDEBUG=1 DEBUG=3 test
nmake /f makefile.msc WIN32HEAP=1 DEBUG=4 test
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"
Sqllogictest:
Checked in latest SQLite amalgamation.
No SQLite compiler warnings.
tclsh run-all.tcl - on unix
tclsh run-all.tcl - on windows
Build using the configure/make in main source tree.
Make sure that autoconf has been run to update the configure script.
Verify the correct version numbers have been installed.
Fossil updated to use the latest SQLite.
No SQLite compiler warnings.
Used on active websites with no issues.
fossil all dbstat --db-check
Rebuild and use Firefox with the latest SQLite
Routine use with no problems
./mach mochitest dom/indexedDB
./mach xpcshell-test dom/indexedDB
./mach web-platform-tests IndexedDB
CEROD tests in the "test/" subdirectory.
SEE tests using TH3:
see.c
see-aes128-ofb.c
see-aes256-ofb.c
see-rc4.c
see-aes128-ccm.c
see-cccrypt.c
At least one of the above using "test.rc".
At least one of the above using "memdebug.rc".
At least one of the above on Linux.
At least one of the above on Mac OS X.
At least one of the above on Windows.
SEE using configure; make test
Linux
Mac
ZIPVFS tests:
testfixture ../zipvfs/test/zipvfs.test(See test/README.txt for details)
th3make zipvfs.rc test.rc
th3make zipvfs.rc memdebug.rc
th3make zipvfs.rc quick.rc -valgrind
th3make zipvfs.rc quick.rc
At least one of the above on Linux.
At least one of the above on Mac OS X.
At least one of the above on Windows.
th3make zipvfs-cov.rc - verify full coverage
NDS-Devkit testing
Verify that devkit sources are up-to-date with SQLite and ZIPVFS by running update-src.sh and mkdevkit.tcl in the sbin subdirectory of the devkit source tree. Record nds_sqlite3.[ch] hashes in the comment.
Test using: tclsh th3make test.rc nds_devkit.rc
Verify the "NDS DevKit" version number shown at the end of the test
Amalgamation autoconf tarball.
Builds.
Works on Linux.
Works on Mac OS X.
Works on Windows MinGW
Works on Windows MSVC
TEA archive builds correctly and runs:
Linux
Mac OS X
Performance tests using speedtest1 compared against the previous release and a release from about one year ago.
Android
Linux
Mac
Windows
Performance tests using speedtest1 --testset rtree
Linux
Windows
Run make wordcount; bash run-wordcount.bash $OPTIONS with options:
Compare performance to the previous release using kvtest.
Android
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
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 (MinGW)
Windows (MSVC)
A database containing WITHOUT ROWID tables.
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
Linux
MacOS
Windows (MSVC)
Recompile and use this checklist program using the latest SQLite
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 for build products have been updated as necessary