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.
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)
OpenBSD GCC using options -Wall
Windows (32-bit) MSVC using option /W4 (nmake /f makefile.msc USE_FULLWARN=1)
Windows (64-bit) MSVC using option /W4 (nmake /f makefile.msc USE_FULLWARN=1)
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 alternative and special-purpose Windows systems
th3make msvc.rc winrt.rc min.rc - Windows Runtime 8.0 (x86)
th3make msvc.rc winrt.rc min.rc - Windows Runtime 8.0 (ARM)
th3make msvc.rc winrt.rc min.rc - Windows Runtime 8.1
th3make msvc.rc wp80.rc min.rc - Windows Phone 8.0
th3make msvc.rc wp81.rc min.rc - Windows Phone 8.1
th3make msvc.rc wince.rc min.rc - Windows Embedded Compact
2013 - When tests are going to be run on the [Hyper-V based] emulator,
no-mmap.rc must be used as well.
Tests for platform OpenBSD (x86):
make test
th3make quick.rc
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 in the ZIPVFS source tree 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 dbselftest 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
OpenBSD
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
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.
System.Data.SQLite builds and checks out using the SQLite core.