SQLite 3.7.10 Status Board

 
1.   Compiler warning checks. (Warnings in the Porter stemmer code are allowed.) --- ok  *
 
a.   Linux GCC -Wall -Wextra (the tool/warnings.sh script) --- ok  *
b.   Mac GCC -Wall -Wextra (the tool/warnings.sh script) --- ok  *
c.   OpenBSD GCC using options -Wall
No warnings on openbsd with "-Wall -Wextra". Gcc version 4.2.1 20070719
dan ok  *
d.   Windows MSVC Win32 /W3 mistachkin ok  *
e.   Windows MSVC Win64 /W3
19 harmless C4267/C4244 warnings
mistachkin ok  *
f.   sh tool/warnings-clang.sh --- ok  *
 
2.   Documentation checks: --- ok  *
 
a.   Latest release on the index.html page --- ok  *
b.   Release announcement in changes.in --- ok  *
c.   Release accouncement in news.html --- ok  *
d.   No unresolved hyperlinks in the documentation build --- ok  *
e.   Requirements marks are up-to-date in both documentation and source code --- ok  *
f.   The compile-time options are all up-to-date (compile.html) --- ok  *
g.   Database footprint is up-to-date (features.html) --- ok  *
h.   Test metrics are up-to-date (testing.html) --- ok  *
i.   Check new/changed documentation for spelling and gramatical mistakes --- ok  *
j.   Verify that this checklist agrees with planning documents --- ok  *
 
3.   Source code change review. "fossil diff --from release --to trunk" --- ok  *
 
a.   No stray changes --- ok  *
b.   All significant changes are mentioned in the "changes" log of the documentation --- ok  *
c.   New code complies with style guidelines --- ok  *
d.   New code complies with design rules --- ok  *
e.   Comments have been updated to reflect code changes --- ok  *
f.   Variables and functions have been renamed to reflect changes in their use --- ok  *
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 indent to yield a 64-bit result do not instead truncate to 32-bits. --- ok  *
 
4.   OMIT, ENABLE, and DISABLE options:
SQLITE_ENABLE_LOCKING_STYLE only works on osx.
--- ok  *
 
a.   tclsh ../tool/omittest.tcl -skip_run --- ok  *
 
5.   Tests for platform Linux x86: --- ok  *
 
a.   tclsh releasetest.tcl dan ok  *
b.   tclsh th3make cov.rc (verify 100% branch test coverage) --- ok  *
c.   tclsh fulltest.tcl fast.rc test.rc --- ok  *
d.   tclsh th3make fast-ex.rc --- ok  *
e.   At least one of the above using GCC 4.1.0 --- ok  *
f.   At least one of the above using GCC 4.4.1 --- ok  *
 
6.   Tests for platform Linux x86_64: --- ok  *
 
a.   tclsh th3make cov.rc (verify 100% branch test coverage) --- ok  *
b.   tclsh releasetest.tcl --- ok  *
c.   tclsh fulltest.tcl fast.rc test.rc --- ok  *
d.   tclsh th3make memdebug.rc --- ok  *
e.   tclsh th3make test-ex.rc --- ok  *
 
7.   Tests for platform Mac OS-X x86: --- ok  *
 
a.   tclsh releasetest.tcl dan ok  *
b.   tclsh fulltest.tcl fast.rc test.rc dan ok  *
 
8.   Tests for platform Mac OS-X PPC: --- ok  *
 
a.   tclsh th3make -Os min.rc
Had to manually remove "#if defined(__APPLE__)" in mem1.c in order to get it to build.
--- ok  *
 
9.   Tests for platform Win32: mistachkin ok  *
 
a.   make fulltest
journaltest.bigfile2-1.3 failed, approved per drh
mistachkin ok  *
b.   th3make test.rc
via msvc
mistachkin ok  *
c.   th3make fast.rc
via MinGW
mistachkin ok  *
d.   At least one of the above using MinGW mistachkin ok  *
e.   At least one of the above using MSVC mistachkin ok  *
 
10.   Tests for platform Win64: mistachkin ok  *
 
a.   make fulltest
via msvc/x64/2008
mistachkin ok  *
b.   th3make test.rc
via msvc/x64/2008
mistachkin ok  *
c.   th3make fast.rc
via msvc/x64/2008
mistachkin ok  *
 
11.   Tests for platform Android: --- ok  *
 
a.   th3make -Os min.rc
wal1.wal37.104 failed because CPP macro "unix" is not defined on Android. There were no other errors. Consider this a pass and fix wal37 later.
--- ok  *
 
12.   Tests for platform OpenBSD x86: --- ok  *
 
a.   make test dan ok  *
b.   th3make -Os min.rc dan ok  *
 
13.   Other test performed on any available platform: --- ok  *
 
a.   th3make alignment2.rc test.rc dan ok  *
b.   th3make test.rc -DHAVE_LOCALTIME_R dan ok  *
c.   th3make test.rc -DSQLITE_THREADSAFE=0 dan ok  *
d.   th3make test.rc -ftrapv dan ok  *
e.   th3make test.rc -DSQLITE_MAX_ATTACHED=62 dan ok  *
f.   th3make min.rc -Os; valgrind ./th3 dan ok  *
g.   valgrind testfixture veryquick.test
Instead run "valgrind testfixture permutations.test valgrind"
dan ok  *
 
14.   Sqllogictest: --- ok  *
 
a.   Checked in latest SQLite amalgamation --- ok  *
b.   No compiler warnings --- ok  *
c.   run-all.sh with no errors --- ok  *
d.   run-all.bat with no errors --- ok  *
 
15.   Build using the configure/make in main source tree. --- ok  *
 
a.   Make sure that autoconf has been run to update the configure script. --- ok  *
b.   Run "make test" to verify that the build works. dan ok  *
c.   Verify the correct version numbers have been installed. dan ok  *
d.   Verify that the --disable-amalgamation option to configure works. dan ok  *
e.   Works on Linux dan ok  *
f.   Works on Mac dan ok  *
g.   Works on OpenBSD dan ok  *
 
16.   Exported symbol checks: tool/symbols.sh --- ok  *
 
a.   No private symbols exported. (This is also checked by releasetest.tcl) --- ok  *
b.   No undesirable library dependencies --- ok  *
c.   No private symbols exported in MinGW (check using tool/symbols-mingw.sh) --- ok  *
d.   No undesirable library dependencies on MinGW --- ok  *
 
17.   Fossil updated to use the latest SQLite. --- ok  *
 
a.   No compiler warnings --- ok  *
b.   Fossil test suite passes --- ok  *
c.   Used on active websites with no issues --- ok  *
 
18.   Firefox recompiled using lastest SQLite. --- ok  *
 
a.   No SQLite compiler warnings --- ok  *
b.   Active use with no issues noted --- ok  *
 
19.   CEROD tests in the test/ subdirectory. --- ok  *
 
20.   SEE tests using TH3: --- ok  *
 
a.   see.c --- ok  *
b.   see-aes128-ofb.c --- ok  *
c.   see-aes256-ofb.c --- ok  *
d.   see-rc4.c --- ok  *
e.   see-aes128-ccm.c --- ok  *
f.   At least one of the above using test.rc --- ok  *
g.   At least one of the above using memdebug.rc --- ok  *
h.   At least one of the above on Linux --- ok  *
i.   At least one of the above on Mac --- ok  *
j.   At least one of the above on Windows --- ok  *
 
21.   ZIPVFS tests: --- 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 --- ok  *
c.   th3make zipvfs.rc memdebug.rc dan ok  *
d.   th3make zipvfs.rc min.rc; valgrind ./th3 dan ok  *
e.   At least one of the above on Linux
21a ran on linux
dan ok  *
f.   At least one of the above on Mac
21c ran on osx
dan ok  *
g.   At least one of the above on Windows --- ok  *
 
22.   NX-Devkit Tests --- ok  *
 
a.   th3make test.rc nx_compress.o --- ok  *
b.   th3make test.rc nx_compress.o -DSQLITE_DIRECT_OVERFLOW_READ --- ok  *
c.   th3make test.rc nx_compress.o -DSQLITE_MULTIPLEX_CHUNK_SIZE=196608 --- ok  *
d.   gcc -DNX_COMPRESS_DEFAULT=0 -c -o nx_compress.o nx_compress.c
th3make test.rc nx_compress.o -DSQLITE_MULTIPLEX_CHUNK_SIZE=196608
--- ok  *
e.   One or more of a) through d) above on unix --- ok  *
f.   One or more of a) through d) above on windows --- ok  *
g.   VACUUM and PRAGMA integrity_check on a multi-gigabyte database --- ok  *
h.   nx_sqlite3_analyze a multi-gigabyte database --- ok  *
 
23.   Amalgamation autoconf tarball. --- ok  *
 
a.   Builds dan ok  *
b.   Works on Linux dan ok  *
c.   Works on Mac dan ok  *
 
24.   TEA archive builds correctly and runs: --- ok  *
 
a.   Linux dan ok  *
b.   Mac --- ok  *
 
25.   Run performance tests comparing the new SQLite release against the previous version. Verify no performance regressions. --- ok  *
 
a.   The TCL speed*.test scripts --- ok  *
b.   The TH3 speed tests
Faster under cachegrind. Realtime performance is mixed.
--- 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
--- ok  *
 
26.   Verify that the amalgamation builds are byte-for-byte identical on all workstation platforms. --- ok  *
 
a.   linux x86 --- ok  *
b.   linux x64 --- ok  *
c.   mac leopard --- ok  *
d.   mac snow-leopard --- ok  *
e.   openbsd --- ok  *
f.   windows native mingw --- ok  *
g.   windows nmake --- ok  *
h.   any unix using autoconf --- ok  *
 
27.   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  *
 
28.   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. --- ok  *
 
a.   32-big to 64-little, database --- ok  *
b.   32-big to 64-little, WAL --- ok  *
c.   32-big to 64-little, rollback --- ok  *
d.   64-little to 32-little, database --- ok  *
e.   64-little to 32-little, WAL --- ok  *
f.   64-little to 32-little, rollback --- ok  *
g.   32-little to 32-big, database --- ok  *
h.   32-little to 32-big, WAL --- ok  *
i.   32-little to 32-big, rollback --- ok  *
j.   64-little to 32-big, SEE database --- ok  *
k.   64-little to 32-big, ZIPVFS database
Using the nx-devkit.
--- ok  *
l.   64-little to 32-big, CEROD database --- ok  *
 
29.   Build and verify correct operation of sqlite3_analyzer on: --- ok  *
 
a.   Linux --- ok  *
b.   Mac --- ok  *
c.   OpenBSD --- ok  *
d.   Win32 (MinGW) --- ok  *
e.   Win32 (MSVC) --- ok  *
 
30.   Run the CLI tests found under the tool subfolder in the main source tree and verify correct output. --- ok  *
 
31.   Tests for the sessions branch with macros SQLITE_ENABLE_SESSIONS and SQLITE_ENABLE_PREUPDATE_HOOK --- ok  *
 
a.   tclsh th3make test.rc (on windows) --- ok  *
b.   tclsh th3make test.rc (on unix)
tclsh th3make -DSQLITE_ENABLE_SESSIONS -DSQLITE_ENABLE_PREUPDATE_HOOK test.rc
dan ok  *
c.   tclsh th3make cov.rc dan ok  *
d.   tclsh th3make min.rc -norun; valgrind ./th3 dan ok  *
e.   make fulltest (on windows)
21 errors out of 2,373,207 tests. None of them critical. Because this is a separate branch and is not the code being released, we'll accept these errors for now and deal with them later.
drh ok  *
f.   make test (on unix) dan ok  *
 
32.   The apple-osx branch is merged with trunk and basic tests work. This is a separate unreleased branch and is not expected to pass all tests. --- ok  *
 
33.   System.Data.SQLite builds and checks out using the SQLite core mistachkin ok  *
 
34.   Verify that all branches that are no longer active have been closed. --- ok  *
 
35.   Verify that the bug response checklist has been completed for all bugs found since the previous release. --- ok  *
 
36.   Verify that the new feature checklist has been completed for all enhancements made since the previous release. --- ok  *