SQLite 3.8.3.1 Status Board

History    Checklist    Baseline

 
1.   Compiler warning checks. (Warnings in the Porter stemmer code are allowed.) --- ---
 
a.   Linux GCC -Wall -Wextra (the tool/warnings.sh script) drh ok  *
b.   Mac GCC -Wall -Wextra (the tool/warnings.sh script) --- ---
c.   OpenBSD GCC using options -Wall --- ---
d.   Windows MSVC Win32 /W3 --- ---
e.   Windows MSVC Win64 /W3 drh ok  *
f.   sh tool/warnings-clang.sh --- ---
 
2.   Documentation checks: --- ---
 
a.   Latest release on the index.html page --- ---
b.   Release announcement in changes.in --- ---
c.   Release accouncement in news.html --- ---
d.   No unresolved hyperlinks in the documentation build --- ---
e.   Requirements marks are up-to-date in both documentation and source code --- ---
f.   The compile-time options are all up-to-date (compile.html) --- ---
g.   Database footprint is up-to-date (features.html) --- ---
h.   Test metrics are up-to-date (testing.html) --- ---
i.   Check new/changed documentation for spelling and gramatical mistakes --- ---
 
3.   Source code change review. "fossil diff --from release --to trunk" --- ---
 
a.   No stray changes --- ---
b.   All significant changes are mentioned in the "changes" log of the documentation --- ---
c.   New code complies with style guidelines --- ---
d.   New code complies with design rules --- ---
e.   Comments have been updated to reflect code changes --- ---
f.   Variables and functions have been renamed to reflect changes in their use --- ---
g.   Check all multiplications, and especially those involving the offset parameters to sqlite3OsRead() and sqlite3OsWrite() or having operands pageSize or szPage to make sure that 32x32-bit multiplicates that intend to yield a 64-bit result do not instead truncate to 32-bits. --- ---
h.   Verify that source code contains no tabs and that surplus whitespace has been removed. --- ---
i.   Verify that the list of APIs exposed via the extension header is up-to-date (sqlite3ext.h) --- ---
 
4.   OMIT, ENABLE, and DISABLE options: --- ---
 
a.   tclsh ../tool/omittest.tcl -skip_run --- ---
 
5.   Tests for platform Linux x86: --- ---
 
a.   tclsh releasetest.tcl --- ---
b.   tclsh th3make cov.rc (verify 100% branch test coverage) --- ---
c.   tclsh fulltest.tcl fast.rc test.rc --- ---
d.   tclsh th3make fast-ex.rc --- ---
 
6.   Tests for platform Linux x86_64: --- ---
 
a.   tclsh th3make cov.rc (verify 100% branch test coverage) --- ---
b.   tclsh th3make cov.rc -DHAVE_MALLOC_H -DHAVE_MALLOC_USABLE_SIZE (verify 100% branch test coverage) --- ---
c.   tclsh th3make cov.rc -DSQLITE_ENABLE_STAT4 (verify 100% branch test coverage) drh ok  *
d.   tclsh releasetest.tcl drh ok  *
e.   tclsh fulltest.tcl fast.rc test.rc drh ok  *
f.   tclsh th3make memdebug.rc --- ---
g.   tclsh th3make test-ex.rc --- ---
h.   tclsh th3make test.rc CC=clang --- ---
i.   tclsh th3make fast.rc CC=clang --- ---
j.   ./mptester x.db mptest/crash01.test --- ---
k.   ./mptester x.db mptest/multiwrite01.test --- ---
 
7.   Tests for platform Linux ARM (BeagleBoard) --- ---
 
a.   tclsh th3make min.rc --- ---
 
8.   Tests for platform Mac OS-X x86: --- ---
 
a.   tclsh releasetest.tcl --- ---
b.   tclsh fulltest.tcl fast.rc test.rc --- ---
c.   tclsh th3make fast.rc CC=clang --- ---
d.   ./mptester x.db mptest/crash01.test drh ok  *
e.   ./mptester x.db mptest/multiwrite01.test drh ok  *
 
9.   Tests for platform MacOS 10.2 PPC: --- ---
 
a.   tclsh th3make -Os min.rc --- ---
b.   Recompile and test Fossil --- ---
c.   Verify that Fossil repositories are cross-platform with x86/x64. --- ---
 
10.   Tests for platform Win32/64: --- ---
 
a.   make fulltestonly drh ok  *
b.   th3make test.rc
0 errors out of 5687848 tests in 27 configurations
mistachkin ok  *
c.   th3make fast.rc --- ---
d.   At least one of the above using MinGW --- ---
e.   At least one of the above using MSVC-32 --- ---
f.   At least one of the above using MSVC-64 --- ---
g.   At least one of the above on WinRT (x86) --- ---
h.   At least one of the above on WinRT (ARM) --- ---
i.   At least one of the above on Windows Phone --- ---
j.   At least one of the above on Windows Embedded Compact 2013 --- ---
k.   Verify that EXEs and DLLs generated using MSVC contain the correct version number, product name, description, and copyright as resources. --- ---
l.   th3make msvc.rc test.rc /RTC1 --- ---
m.   mptester x.db mptest/crash01.test mistachkin ok  *
n.   mptester x.db mptest/multiwrite01.test mistachkin ok  *
 
11.   Tests for platform Android: --- ---
 
a.   th3make -Os min.rc --- ---
 
12.   Tests for platform OpenBSD x86: --- ---
 
a.   make test --- ---
b.   th3make -Os min.rc --- ---
 
13.   Tests for platform Solaris Sparc: --- ---
 
a.   make test --- ---
b.   th3make test.rc --- ---
c.   th3make fast.rc --- ---
d.   Recompile and test Fossil --- ---
e.   Verify that Fossil repositories are cross-platform with x86/x64 --- ---
 
14.   Other test performed on any available platform: --- ---
 
a.   th3make alignment2.rc test.rc --- ---
b.   th3make test.rc -DHAVE_LOCALTIME_R --- ---
c.   th3make test.rc -DSQLITE_THREADSAFE=0 --- ---
d.   th3make test.rc -ftrapv --- ---
e.   OPTS=-DSQLITE_SMALL_STACK make sqlite3.c; th3make test.rc -DSQLITE_SMALL_STACK --- ---
f.   th3make test.rc CC=clang -fsanitize=undefined --- ---
g.   th3make test.rc -DSQLITE_MAX_ATTACHED=62 --- ---
h.   th3make min.rc -Os -DTH3_LOWMEM -DTH3_OMIT_MISUSE; valgrind ./th3 --- ---
i.   th3make min.rc -Os -DTH3_LOWMEM -DTH3_OMIT_MISUSE -DSQLITE_ENABLE_STAT4; valgrind ./th3 drh ok  *
j.   valgrind testfixture permutations.test valgrind --- ---
k.   th3make cov.rc -DSQLITE_TRACE_SIZE_LIMIT=15 (verify coverage) --- ---
l.   th3make min.rc -DSQLITE_TRACE_SIZE_LIMIT=15 -O6 --- ---
 
15.   Sqllogictest: --- ---
 
a.   Checked in latest SQLite amalgamation --- ---
b.   No compiler warnings drh ok  *
c.   run-all.sh with no errors drh ok  *
d.   run-all.bat with no errors mistachkin ok  *
 
16.   Build using the configure/make in main source tree. --- ---
 
a.   Make sure that autoconf has been run to update the configure script. drh ok  *
b.   Run "make test" to verify that the build works. drh ok  *
c.   Verify the correct version numbers have been installed. drh ok  *
d.   Verify that the --disable-amalgamation option to configure works. --- ---
e.   Works on Linux --- ---
f.   Works on Mac drh ok  *
g.   Works on OpenBSD --- ---
h.   Works on Solaris --- ---
 
17.   Exported symbol checks: tool/symbols.sh --- ---
 
a.   No private symbols exported. (This is also checked by releasetest.tcl) drh ok  *
b.   No undesirable library dependencies drh ok  *
c.   No private symbols exported in MinGW (check using tool/symbols-mingw.sh) --- ---
d.   No undesirable library dependencies on MinGW --- ---
 
18.   Fossil updated to use the latest SQLite. --- ---
 
a.   No compiler warnings --- ---
b.   Used on active websites with no issues drh ok  *
 
19.   Firefox recompiled using lastest SQLite. --- ---
 
a.   No SQLite compiler warnings --- ---
b.   Active use with no issues noted drh ok  *
 
20.   CEROD tests in the test/ subdirectory. --- ---
 
21.   SEE tests using TH3: --- ---
 
a.   see.c --- ---
b.   see-aes128-ofb.c --- ---
c.   see-aes256-ofb.c --- ---
d.   see-rc4.c --- ---
e.   see-aes128-ccm.c --- ---
f.   At least one of the above using test.rc --- ---
g.   At least one of the above using memdebug.rc --- ---
h.   At least one of the above on Linux --- ---
i.   At least one of the above on Mac --- ---
j.   At least one of the above on Windows --- ---
 
22.   ZIPVFS tests: --- ---
 
a.   testfixture ../zipvfs/test/zipvfs.test (See test/README.txt in the ZIPVFS source tree for details.) --- ---
b.   th3make zipvfs.rc test.rc --- ---
c.   th3make zipvfs.rc memdebug.rc --- ---
d.   th3make zipvfs.rc min.rc -DTH3_LOWMEM -DTH3_OMIT_MISUSE; valgrind ./th3 --- ---
e.   th3make min.rc --- ---
f.   At least one of the above on Linux --- ---
g.   At least one of the above on Mac --- ---
h.   At least one of the above on Windows --- ---
 
23.   NX-Devkit compiles and runs "tclsh th3make test.rc nx_compress.o" without error. --- ---
 
24.   Amalgamation autoconf tarball. --- ---
 
a.   Builds --- ---
b.   Works on Linux --- ---
c.   Works on Mac --- ---
 
25.   TEA archive builds correctly and runs: --- ---
 
a.   Linux --- ---
b.   Mac --- ---
 
26.   Run performance tests comparing the new SQLite release against the previous release and a release from one year ago. Document and justify any performance decrease. --- ---
 
a.   The TCL speed*.test scripts --- ---
b.   The TH3 speed tests --- ---
c.   The speedtest1 program --- ---
d.   ./speedtest1 --nosync --size 25 --trace 2>x.txt
time ./sqlite3 x.db <x.txt >/dev/null
--- ---
e.   One or more of the above on linux --- ---
f.   One or more of the above on windows --- ---
g.   One or more of the above on mac --- ---
 
27.   Run "make wordcount; bash run-wordcount.bash $OPTIONS" with options: --- ---
 
a.   sqlite3.c --- ---
b.   sqlite3.c --cachesize 5 --nosync --- ---
 
28.   Compute the size of a standard build (gcc -Os -c sqlite3.c) and and record the size change in the comments --- ---
 
a.   Versus the previous release --- ---
b.   Versus the trunk from 12 months ago --- ---
 
29.   Verify that the amalgamation builds are byte-for-byte identical on all workstation platforms. --- ---
 
a.   linux drh ok  *
b.   mac drh ok  *
c.   openbsd --- ---
d.   windows native mingw --- ---
e.   windows nmake drh ok  *
f.   sparc solaris using autoconf --- ---
 
30.   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. --- ---
 
31.   Cross-platform tests. Verify the ability of databases, WAL files, and rollback journals to be copied and used between 32-bit and 64-bit systems and between big-endian and little-endian systems. --- ---
 
a.   32-big to 64-little, database --- ---
b.   32-big to 64-little, WAL --- ---
c.   32-big to 64-little, rollback --- ---
d.   64-little to 32-big, SEE database --- ---
e.   64-little to 32-big, ZIPVFS database --- ---
f.   64-little to 32-big, CEROD database --- ---
 
32.   Build and verify correct operation of sqlite3_analyzer on: --- ---
 
a.   Linux --- ---
b.   Mac --- ---
c.   Sparc Solaris --- ---
d.   Win32 (MinGW) --- ---
e.   Win32 (MSVC) --- ---
f.   A database containing WITHOUT ROWID tables --- ---
 
33.   Tests for the sessions branch with macros SQLITE_ENABLE_SESSION and SQLITE_ENABLE_PREUPDATE_HOOK --- ---
 
a.   tclsh th3make session.rc test.rc (on windows) --- ---
b.   tclsh th3make session.rc test.rc (on unix) --- ---
c.   tclsh th3make session.rc cov.rc --- ---
d.   tclsh th3make session.rc min.rc -norun -DTH3_LOWMEM -DTH3_OMIT_MISUSE; valgrind ./th3 --- ---
e.   make test (on windows) --- ---
f.   make test (on unix) --- ---
g.   testfixture test/session.test --- ---
 
34.   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. --- ---
 
35.   System.Data.SQLite builds and checks out using the SQLite core
netfx40, debug, release, netCF 2.0/3.5 OK
mistachkin ok  *