SQLite 3.7.9 Status Board

 
1.   Compiler warning checks. (Warnings in the Porter stemmer code are allowed.) drh ok  *
 
a.   Linux GCC -Wall -Wextra (the tool/warnings.sh script) drh ok  *
b.   Mac GCC -Wall -Wextra (the tool/warnings.sh script) drh ok  *
c.   OpenBSD GCC using options -Wall drh ok  *
d.   Windows MSVC Win32 /W3 drh ok  *
e.   Windows MSVC Win64 /W3
21 harmless warnings
mistachkin ok  *
f.   sh tool/warnings-clang.sh drh ok  *
 
2.   Documentation checks: drh ok  *
 
a.   Latest release on the index.html page drh ok  *
b.   Release announcement in changes.in drh ok  *
c.   Release accouncement in news.html drh ok  *
d.   No unresolved hyperlinks in the documentation build drh ok  *
e.   The compile-time options are all up-to-date (compile.html) drh ok  *
f.   Database footprint is up-to-date (features.html) drh ok  *
g.   Test metrics are up-to-date (testing.html) drh ok  *
h.   Check new/changed documentation for spelling and gramatical mistakes drh ok  *
i.   Verify that this checklist agrees with planning documents drh ok  *
j.   Community feedback solicited for this checklist drh ok  *
 
3.   Source code change review. "fossil diff --from release --to trunk" drh ok  *
 
a.   No stray changes drh ok  *
b.   All significant changes are mentioned in the "changes" log of the documentation drh ok  *
c.   New code complies with style guidelines drh ok  *
d.   New code complies with design rules drh ok  *
e.   Comments have been updated to reflect code changes drh ok  *
f.   Variables and functions have been renamed to reflect changes in their use drh ok  *
 
4.   OMIT, ENABLE, and DISABLE options: drh ok  *
 
a.   tclsh ../tool/omittest.tcl -skip_run drh ok  *
 
5.   Tests for platform Linux x86: drh ok  *
 
a.   tclsh releasetest.tcl drh ok  *
b.   tclsh th3make cov.rc (verify 100% branch test coverage) drh ok  *
c.   tclsh fulltest.tcl fast.rc test.rc drh ok  *
d.   tclsh th3make fast-ex.rc drh ok  *
e.   At least one of the above using GCC 4.1.0 drh ok  *
f.   At least one of the above using GCC 4.4.1 drh ok  *
 
6.   Tests for platform Linux x86_64: drh ok  *
 
a.   tclsh th3make cov.rc (verify 100% branch test coverage) drh ok  *
b.   tclsh releasetest.tcl drh ok  *
c.   tclsh fulltest.tcl fast.rc test.rc drh ok  *
d.   tclsh th3make memdebug.rc drh ok  *
e.   tclsh th3make test-ex.rc drh ok  *
 
7.   Tests for platform Mac OS-X x86: drh ok  *
 
a.   tclsh releasetest.tcl dan ok  *
b.   tclsh fulltest.tcl fast.rc test.rc dan ok  *
 
8.   Tests for platform Max OS-X PPC: drh ok  *
 
a.   tclsh th3make -Os min.rc drh ok  *
 
9.   Tests for platform Win32: drh ok  *
 
a.   make fulltest
Errors in loadext.test due to differences in error messages between unix and windows.
drh ok  *
b.   th3make test.rc mistachkin ok  *
c.   th3make fast.rc mistachkin ok  *
d.   At least one of the above using MinGW mistachkin ok  *
e.   At least one of the above using MSVC drh ok  *
 
10.   Tests for platform Win64: drh ok  *
 
a.   make fulltest
Unable to run this test for want of an MSVC-compatible 64-bit libtcl.
drh ok  *
b.   th3make test.rc drh ok  *
c.   th3make fast.rc drh ok  *
 
11.   Tests for platform Android: drh ok  *
 
a.   th3make -Os min.rc drh ok  *
 
12.   Tests for platform OpenBSD x86: drh ok  *
 
a.   make test drh ok  *
b.   th3make -Os min.rc drh ok  *
 
13.   Other test performed on any available platform: drh ok  *
 
a.   th3make alignment2.rc test.rc drh ok  *
b.   th3make test.rc -DHAVE_LOCALTIME_R drh ok  *
c.   th3make test.rc -DSQLITE_THREADSAFE=0 drh ok  *
d.   th3make test.rc -ftrapv drh ok  *
e.   th3make test.rc -DSQLITE_MAX_ATTACHED=62 drh ok  *
f.   th3make min.rc -Os; valgrind ./th3 drh ok  *
g.   valgrind testfixture veryquick.test drh ok  *
 
14.   Sqllogictest: drh ok  *
 
a.   Checked in latest SQLite amalgamation drh ok  *
b.   No compiler warnings drh ok  *
c.   run-all.sh with no errors drh ok  *
d.   run-all.bat with no errors mistachkin ok  *
 
15.   Build using the configure/make in main source tree. drh ok  *
 
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. drh ok  *
e.   Works on Linux drh ok  *
f.   Works on Mac dan ok  *
g.   Works on OpenBSD drh ok  *
 
16.   Exported symbol checks: tool/symbols.sh drh ok  *
 
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) drh ok  *
d.   No undesirable library dependencies on MinGW drh ok  *
 
17.   Fossil updated to use the latest SQLite. drh ok  *
 
a.   No compiler warnings drh ok  *
b.   Fossil test suite passes drh ok  *
c.   Used on active websites with no issues drh ok  *
 
18.   Firefox recompiled using lastest SQLite. drh ok  *
 
a.   No SQLite compiler warnings drh ok  *
b.   Active use with no issues noted drh ok  *
 
19.   CEROD tests in the test/ subdirectory. drh ok  *
 
20.   SEE tests using TH3: drh ok  *
 
a.   see.c drh ok  *
b.   see-aes128-ofb.c drh ok  *
c.   see-aes256-ofb.c drh ok  *
d.   see-rc4.c drh ok  *
e.   see-aes128-ccm.c
Two minor sizing errors due to the large (32-byte) reserved region with CCM.
drh ok  *
f.   At least one of the above using test.rc drh ok  *
g.   At least one of the above using memdebug.rc drh ok  *
h.   At least one of the above on Linux drh ok  *
i.   At least one of the above on Mac drh ok  *
j.   At least one of the above on Windows mistachkin ok  *
 
21.   ZIPVFS tests: drh ok  *
 
a.   testfixture ../zipvfs/test/zipvfs.test (See test/README.txt in the ZIPVFS source tree for details.) dan ok  *
b.   th3make zipvfs.rc test.rc drh ok  *
c.   th3make zipvfs.rc memdebug.rc dan ok  *
d.   th3make zipvfs.rc min.rc; valgrind ./th3
Valgrind runs out of memory, but no application errors are detected.
drh ok  *
e.   At least one of the above on Linux dan ok  *
f.   At least one of the above on Mac dan ok  *
g.   At least one of the above on Windows mistachkin ok  *
 
22.   Amalgamation autoconf tarball. dan ok  *
 
a.   Builds dan ok  *
b.   Works on Linux dan ok  *
c.   Works on Mac dan ok  *
 
23.   TEA archive builds correctly and runs: dan ok  *
 
a.   Linux dan ok  *
b.   Mac dan ok  *
 
24.   Run performance tests comparing the new SQLite release against the previous version. Verify no performance regressions. drh ok  *
 
a.   The TCL speed*.test scripts drh ok  *
b.   The TH3 speed tests drh ok  *
c.   sqlite3 sqlite.fossil .dump >speed-c.sql
fossil timeline -R sqlite.fossil -n 300 -sqltrace 2>>speed-c.sql
fossil rebuild sqlite.fossil -sqltrace 2>>speed-c.sql
drh ok  *
 
25.   Verify that the amalgamation builds are byte-for-byte identical on all workstation platforms. drh ok  *
 
a.   linux x86 drh ok  *
b.   linux x64 drh ok  *
c.   mac leopard drh ok  *
d.   mac snow-leopard drh ok  *
e.   openbsd drh ok  *
f.   windows native mingw drh ok  *
g.   windows nmake mistachkin ok  *
h.   any unix using autoconf drh ok  *
 
26.   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.6.4 and 3.7.1
dan ok  *
 
27.   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. drh ok  *
 
a.   32-big to 64-little, database drh ok  *
b.   32-big to 64-little, WAL drh ok  *
c.   32-big to 64-little, rollback drh ok  *
d.   64-little to 32-little, database drh ok  *
e.   64-little to 32-little, WAL drh ok  *
f.   64-little to 32-little, rollback drh ok  *
g.   32-little to 32-big, database drh ok  *
h.   32-little to 32-big, WAL drh ok  *
i.   32-little to 32-big, rollback drh ok  *
j.   64-little to 32-big, SEE database drh ok  *
k.   64-little to 32-big, ZIPVFS database drh ok  *
l.   64-little to 32-big, CEROD database drh ok  *
 
28.   Build and verify correct operation of sqlite3_analyzer on: drh ok  *
 
a.   Linux dan ok  *
b.   Mac dan ok  *
c.   OpenBSD drh ok  *
d.   Win32 (MinGW) mistachkin ok  *
e.   Win32 (MSVC) drh ok  *
 
29.   Run the CLI tests found under the tool subfolder in the main source tree and verify correct output. drh ok  *
 
30.   Tests for branches tracking trunk. drh ok  *
 
a.   sessions, TCL drh ok  *
b.   sessions, TH3 drh ok  *
c.   apple-osx, TCL
Errors in dbstatus.test when run on a Mac - due to the OSX-specific changes in mem1.c.
drh ok  *
d.   apple-osx, TH3 drh ok  *
 
31.   Verify that all branches that are no longer active have been closed. drh ok  *
 
32.   Verify that the bug response checklist has been completed for all bugs found since the previous release. drh ok  *
 
33.   Verify that the new feature checklist has been completed for all enhancements made since the previous release. drh ok  *