SQLite

Checklist For SQLite 3.7.17
Login
2013-05-19 20:27:04 drhok
20. Documentation checks:
2013-05-19 20:27:02 drhok
20j. Verify that this checklist agrees with planning documents
2013-05-19 20:24:33 drhok
30. Source code change review. "fossil diff --from release --to trunk"
2013-05-19 20:24:30 drhok
30g. 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.
2013-05-19 16:20:45 drhok
90. Tests for platform Win32/64:
2013-05-19 16:20:43 drhok
90i. At least one of the above on Windows Phone
Problem in th3convertFilename() in TH3 fixed
2013-05-19 16:20:30 drhok
90h. At least one of the above on WinRT (ARM)
Problem in th3convertFilename() in TH3 fixed
2013-05-19 00:23:19 mistachkinok
90g. At least one of the above on WinRT (x86)
test.rc
2013-05-18 23:10:08 mistachkinpending
90g. At least one of the above on WinRT (x86)
2013-05-18 17:46:20 drhok
30i. Verify that the list of APIs exposed via the extension header is up-to-date (sqlite3ext.h)
2013-05-18 17:45:54 drhok
20i. Check new/changed documentation for spelling and gramatical mistakes
2013-05-18 17:45:51 drhok
20h. Test metrics are up-to-date (testing.html)
2013-05-18 17:45:46 drhok
20g. Database footprint is up-to-date (features.html)
2013-05-18 17:45:44 drhok
20f. The compile-time options are all up-to-date (compile.html)
2013-05-18 17:45:40 drhok
20d. No unresolved hyperlinks in the documentation build
2013-05-18 17:45:38 drhok
20c. Release accouncement in news.html
2013-05-18 17:45:34 drhok
20b. Release announcement in changes.in
2013-05-18 17:45:31 drhok
20a. Latest release on the index.html page
2013-05-18 10:20:33 mistachkinok
90j. Verify that EXEs and DLLs generated using MSVC contain the correct version number, product name, description, and copyright as resources.
2013-05-18 10:16:34 mistachkinfail
90i. At least one of the above on Windows Phone
min.rc, psow01.100 in the c2 and cC configs
2013-05-18 06:33:44 mistachkinfail
90h. At least one of the above on WinRT (ARM)
same results as WinRT x86
2013-05-18 00:02:20 mistachkinfail
90g. At least one of the above on WinRT (x86)
psow01.100 in the c2, cC, wal1, speed1, speed1wal, wal3, wal4 configs
2013-05-17 22:57:54 mistachkinpending
90g. At least one of the above on WinRT (x86)
2013-05-17 20:26:38 mistachkinok
90f. At least one of the above using MSVC-64
2013-05-17 20:26:26 mistachkinok
90c. th3make fast.rc
superset fulltest, x64 MSVC Win7, all ok except false alarm with extra1_release_mem_win
2013-05-17 20:16:23 drhok
30h. Verify that source code contains no tabs and that surplus whitespace has been removed.
2013-05-17 20:15:04 drhok
30f. Variables and functions have been renamed to reflect changes in their use
2013-05-17 20:15:00 drhok
30e. Comments have been updated to reflect code changes
2013-05-17 20:14:57 drhok
30d. New code complies with design rules
2013-05-17 20:14:54 drhok
30c. New code complies with style guidelines
2013-05-17 20:14:51 drhok
30b. All significant changes are mentioned in the "changes" log of the documentation
2013-05-17 20:14:48 drhok
30a. No stray changes
2013-05-17 19:07:06 drhok
20e. Requirements marks are up-to-date in both documentation and source code
Several requirements marks are obsolete or have changed. But we aren't going to worry about that for this release. We'll fix these on the next go around.
2013-05-17 18:43:53 drhok
40. OMIT, ENABLE, and DISABLE options:
2013-05-17 18:43:50 drhok
50. Tests for platform Linux x86:
2013-05-17 18:43:45 drhok
60. Tests for platform Linux x86_64:
2013-05-17 18:43:42 drhok
70. Tests for platform Mac OS-X x86:
2013-05-17 18:43:29 drhok
130. Other test performed on any available platform:
2013-05-17 18:43:20 drhok
280. 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.
2013-05-17 18:43:17 drhok
280f. 64-little to 32-big, CEROD database
2013-05-17 17:37:56 danok
130h. th3make cov.rc -DSQLITE_TRACE_SIZE_LIMIT=15 (verify coverage)
2013-05-17 17:23:53 drhok
280e. 64-little to 32-big, ZIPVFS database
2013-05-17 17:23:49 drhok
280d. 64-little to 32-big, SEE database
2013-05-17 17:19:23 drhok
10a. Linux GCC -Wall -Wextra (the tool/warnings.sh script)
2013-05-17 17:19:12 danok
130i. th3make min.rc -DSQLITE_TRACE_SIZE_LIMIT=15 -O6
2013-05-17 16:46:48 danreview
130h. th3make cov.rc -DSQLITE_TRACE_SIZE_LIMIT=15 (verify coverage)
missed 6 branches
2013-05-17 16:44:05 danok
130c. th3make test.rc -DSQLITE_THREADSAFE=0
2013-05-17 16:43:35 drhok
280a. 32-big to 64-little, database
2013-05-17 16:43:35 drhok
280b. 32-big to 64-little, WAL
2013-05-17 16:43:35 drhok
280c. 32-big to 64-little, rollback
2013-05-17 16:42:00 danok
130b. th3make test.rc -DHAVE_LOCALTIME_R
2013-05-17 16:41:31 danok
50a. tclsh releasetest.tcl
2013-05-17 16:39:04 drhok
80. Tests for platform Mac OS-X PPC:
2013-05-17 16:39:00 drhok
80a. tclsh th3make -Os min.rc
2013-05-17 16:16:48 danpending
130i. th3make min.rc -DSQLITE_TRACE_SIZE_LIMIT=15 -O6
2013-05-17 16:14:31 danpending
130h. th3make cov.rc -DSQLITE_TRACE_SIZE_LIMIT=15 (verify coverage)
2013-05-17 16:13:13 danpending
130c. th3make test.rc -DSQLITE_THREADSAFE=0
2013-05-17 16:12:34 danpending
130b. th3make test.rc -DHAVE_LOCALTIME_R
2013-05-17 16:10:34 danok
130f. th3make min.rc -Os -DTH3_LOWMEM; valgrind ./th3
2013-05-17 15:56:42 danok
130g. valgrind testfixture permutations.test valgrind
2013-05-17 15:55:05 danok
270. 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 with backcompat.test against 3.6.4, 3.7.1 and 3.7.6.
2013-05-17 15:40:52 drhok
130a. th3make alignment2.rc test.rc
prior failures were due to TH3 problems that are now fixed.
2013-05-17 15:34:34 danok
230. Amalgamation autoconf tarball.
2013-05-17 15:34:34 danok
240. TEA archive builds correctly and runs:
2013-05-17 15:34:22 danok
240b. Mac
2013-05-17 15:32:58 danok
230c. Works on Mac
2013-05-17 15:28:52 danok
240a. Linux
2013-05-17 15:27:12 danok
230b. Works on Linux
2013-05-17 15:14:51 danok
230a. Builds
2013-05-17 15:09:12 drhok
100. Tests for platform Android:
2013-05-17 15:08:14 drhfail
130a. th3make alignment2.rc test.rc
17 errors all in mmap2.jrnlmode01
2013-05-17 15:07:18 drhpending
80a. tclsh th3make -Os min.rc
2013-05-17 14:43:36 danok
100a. th3make -Os min.rc
2013-05-17 14:30:20 danpending
130f. th3make min.rc -Os -DTH3_LOWMEM; valgrind ./th3
2013-05-17 14:27:25 danpending
130g. valgrind testfixture permutations.test valgrind
2013-05-17 14:25:44 drhok
300. Tests for the sessions branch with macros SQLITE_ENABLE_SESSION and SQLITE_ENABLE_PREUPDATE_HOOK
2013-05-17 14:25:40 drhok
300d. tclsh th3make session.rc min.rc -norun -DTH3_LOWMEM; valgrind ./th3
2013-05-17 14:23:15 danpending
100a. th3make -Os min.rc
2013-05-17 14:15:03 drhpending
130a. th3make alignment2.rc test.rc
2013-05-17 13:41:06 drhok
300a. tclsh th3make session.rc test.rc (on windows)
2013-05-17 13:38:19 drhok
140. Sqllogictest:
2013-05-17 13:36:47 drhok
210. ZIPVFS tests:
2013-05-17 13:36:44 drhok
210a. testfixture ../zipvfs/test/zipvfs.test (See test/README.txt in the ZIPVFS source tree for details.)
2013-05-17 13:25:29 drhok
210c. th3make zipvfs.rc memdebug.rc
2013-05-17 13:21:58 drhpending
300d. tclsh th3make session.rc min.rc -norun -DTH3_LOWMEM; valgrind ./th3
2013-05-17 13:15:45 drhpending
300a. tclsh th3make session.rc test.rc (on windows)
2013-05-17 13:14:32 drhok
300c. tclsh th3make session.rc cov.rc
88 untested branches in the core
2013-05-17 13:10:05 drhok
300b. tclsh th3make session.rc test.rc (on unix)
2013-05-17 13:00:16 drhok
70e. ./mptester x.db mptest/multiwrite01.test
2013-05-17 13:00:13 drhok
70d. ./mptester x.db mptest/crash01.test
2013-05-17 12:58:04 drhok
90m. mptester x.db mptest/multiwrite01.test
2013-05-17 12:58:02 drhok
90l. mptester x.db mptest/crash01.test
2013-05-17 12:56:55 drhok
60j. ./mptester x.db mptest/multiwrite01.test
2013-05-17 12:56:51 drhok
60i. ./mptester x.db mptest/crash01.test
2013-05-17 12:53:06 drhok
300e. make test (on windows)
2013-05-17 12:18:05 drhok
210f. At least one of the above on Linux
2013-05-17 12:17:56 drhok
210d. th3make zipvfs.rc min.rc -DTH3_LOWMEM; valgrind ./th3
2013-05-17 10:59:07 drhok
300g. testfixture test/session.test
2013-05-17 10:58:10 drhok
300f. make test (on unix)
2013-05-17 10:50:07 drhpending
210d. th3make zipvfs.rc min.rc -DTH3_LOWMEM; valgrind ./th3
2013-05-17 10:38:01 drhok
200. SEE tests using TH3:
2013-05-17 10:37:58 drhok
200e. see-aes128-ccm.c
2013-05-17 10:32:05 drhok
200f. At least one of the above using test.rc
2013-05-17 10:32:02 drhok
200d. see-rc4.c
2013-05-17 09:47:07 danok
50d. tclsh th3make fast-ex.rc
2013-05-17 09:47:02 danok
50c. tclsh fulltest.tcl fast.rc test.rc
2013-05-17 09:46:57 danok
70a. tclsh releasetest.tcl
2013-05-17 09:46:02 danok
70c. tclsh th3make fast.rc CC=clang
2013-05-17 09:45:58 danok
70b. tclsh fulltest.tcl fast.rc test.rc
2013-05-17 09:45:38 danok
60f. tclsh th3make test-ex.rc
2013-05-17 09:45:30 danok
60d. tclsh fulltest.tcl fast.rc test.rc
2013-05-17 09:45:25 danok
60c. tclsh releasetest.tcl
2013-05-17 08:06:50 mistachkinok
90d. At least one of the above using MinGW
fast.rc
2013-05-17 02:17:54 drhpending
200f. At least one of the above using test.rc
2013-05-17 02:17:48 drhpending
200d. see-rc4.c
2013-05-17 02:03:37 drhok
200h. At least one of the above on Linux
2013-05-17 02:03:35 drhok
200g. At least one of the above using memdebug.rc
2013-05-17 02:03:31 drhok
200c. see-aes256-ofb.c
2013-05-17 02:03:10 drhok
260. Verify that the amalgamation builds are byte-for-byte identical on all workstation platforms.
2013-05-17 02:03:07 drhok
260f. sparc solaris using autoconf
2013-05-17 02:02:38 drhok
120. Tests for platform Solaris Sparc:
2013-05-17 02:02:35 drhok
120c. th3make fast.rc
2013-05-17 01:51:55 drhok
290. Build and verify correct operation of sqlite3_analyzer on:
2013-05-17 01:51:52 drhok
290d. Win32 (MinGW)
2013-05-17 01:26:16 mistachkinok
140d. run-all.bat with no errors
2013-05-17 01:24:38 drhok
260d. windows native mingw
2013-05-17 01:22:50 drhok
210h. At least one of the above on Windows
2013-05-17 01:19:26 mistachkinok
90k. th3make msvc.rc test.rc /RTC1
32-bit x86 Win7
2013-05-17 01:09:39 drhok
290e. Win32 (MSVC) and verify correct output.
2013-05-17 01:07:45 drhok
210g. At least one of the above on Mac
2013-05-17 01:07:42 drhok
210e. th3make min.rc
2013-05-17 00:59:02 drhok
200a. see.c
2013-05-17 00:59:02 drhok
200j. At least one of the above on Windows
2013-05-17 00:54:32 drhok
200b. see-aes128-ofb.c
2013-05-17 00:54:32 drhok
200i. At least one of the above on Mac
2013-05-17 00:52:28 drhok
190. CEROD tests in the test/ subdirectory.
2013-05-17 00:49:29 drhok
260c. openbsd
2013-05-17 00:42:44 drhok
290c. Sparc Solaris
2013-05-17 00:42:37 drhok
290b. Mac
2013-05-17 00:41:30 drhok
260b. mac
2013-05-17 00:37:48 drhok
260a. linux
2013-05-17 00:37:48 drhok
260e. windows nmake
2013-05-17 00:35:10 drhok
160. Exported symbol checks: tool/symbols.sh
2013-05-17 00:35:03 drhok
160c. No private symbols exported in MinGW (check using tool/symbols-mingw.sh)
On windows8
2013-05-17 00:35:03 drhok
160d. No undesirable library dependencies on MinGW
On windows8
2013-05-17 00:34:32 drhpending
120c. th3make fast.rc
2013-05-17 00:30:59 drhok
150. Build using the configure/make in main source tree.
2013-05-17 00:30:56 drhok
150h. Works on Solaris
2013-05-16 23:32:37 mistachkinpending
140d. run-all.bat with no errors
2013-05-16 23:30:05 mistachkinok
90e. At least one of the above using MSVC-32
2013-05-16 23:29:55 mistachkinok
90b. th3make test.rc
with msvc.rc
2013-05-16 23:28:47 mistachkinpending
90f. At least one of the above using MSVC-64
2013-05-16 23:28:39 mistachkinpending
90e. At least one of the above using MSVC-32
2013-05-16 23:28:30 mistachkinpending
90c. th3make fast.rc
superset fulltest, x64 MSVC Win7
2013-05-16 22:23:03 mistachkinpending
90b. th3make test.rc
2013-05-16 20:59:37 drhok
210b. th3make zipvfs.rc test.rc
2013-05-16 20:29:00 drhpending
210b. th3make zipvfs.rc test.rc
2013-05-16 20:28:05 drhok
220. NX-Devkit compiles and runs "tclsh th3make test.rc nx_compress.o" without error.
Rerun using fast.rc instead of test.rc. Also ran test.rc on the specific tests that failed.
2013-05-16 19:52:40 danpending
70c. tclsh th3make fast.rc CC=clang
2013-05-16 19:51:45 danpending
70b. tclsh fulltest.tcl fast.rc test.rc
2013-05-16 19:49:53 danpending
70a. tclsh releasetest.tcl
2013-05-16 19:36:22 drhok
10. Compiler warning checks. (Warnings in the Porter stemmer code are allowed.)
2013-05-16 19:36:20 drhok
10b. Mac GCC -Wall -Wextra (the tool/warnings.sh script)
2013-05-16 19:34:48 drhok
10f. sh tool/warnings-clang.sh
2013-05-16 19:26:30 drhpending
10f. sh tool/warnings-clang.sh
2013-05-16 19:24:50 drhok
180. Firefox recompiled using lastest SQLite.
2013-05-16 19:24:50 drhok
180a. No SQLite compiler warnings
2013-05-16 19:24:50 drhok
180b. Active use with no issues noted
2013-05-16 18:58:10 drhfail
220. NX-Devkit compiles and runs "tclsh th3make test.rc nx_compress.o" without error.
Failures on c5.main40 and on pager40.120.
2013-05-16 18:57:58 danok
10c. OpenBSD GCC using options -Wall
2013-05-16 18:56:41 danok
150f. Works on Mac
2013-05-16 18:56:34 drhok
170. Fossil updated to use the latest SQLite.
2013-05-16 18:48:06 danok
150g. Works on OpenBSD
2013-05-16 18:45:05 drhok
310. 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.
2013-05-16 18:40:00 drhok
290a. Linux
2013-05-16 18:38:34 drhpending
220. NX-Devkit compiles and runs "tclsh th3make test.rc nx_compress.o" without error.
2013-05-16 18:33:17 danok
150d. Verify that the --disable-amalgamation option to configure works.
2013-05-16 18:27:54 drhok
10a. Linux GCC -Wall -Wextra (the tool/warnings.sh script)
2013-05-16 18:24:59 danok
60e. tclsh th3make memdebug.rc
2013-05-16 18:02:48 danok
150e. Works on Linux
2013-05-16 18:02:37 danok
150c. Verify the correct version numbers have been installed.
2013-05-16 17:59:27 danok
150b. Run "make test" to verify that the build works.
2013-05-16 17:51:36 danok
60g. tclsh th3make test.rc CC=clang
2013-05-16 17:31:33 danok
60h. tclsh th3make fast.rc CC=clang
2013-05-16 17:18:18 danok
150a. Make sure that autoconf has been run to update the configure script.
2013-05-16 17:01:49 danpending
60h. tclsh th3make fast.rc CC=clang
2013-05-16 17:01:41 danpending
60g. tclsh th3make test.rc CC=clang
2013-05-16 16:58:36 danok
60b. tclsh th3make cov.rc -DHAVE_MALLOC_H -DHAVE_MALLOC_USABLE_SIZE (verify 100% branch test coverage)
2013-05-16 16:58:30 danok
60a. tclsh th3make cov.rc (verify 100% branch test coverage)
2013-05-16 16:51:33 danpending
60e. tclsh th3make memdebug.rc
2013-05-16 16:49:40 danpending
60b. tclsh th3make cov.rc -DHAVE_MALLOC_H -DHAVE_MALLOC_USABLE_SIZE (verify 100% branch test coverage)
2013-05-16 16:48:59 danpending
60a. tclsh th3make cov.rc (verify 100% branch test coverage)
2013-05-16 16:47:15 danpending
50a. tclsh releasetest.tcl
2013-05-16 15:24:41 drhok
110. Tests for platform OpenBSD x86:
2013-05-16 15:24:38 drhok
110b. th3make -Os min.rc
Fixed TH3 to work on systems that do not support memory-mapped I/O
2013-05-16 13:04:21 drhok
170b. Used on active websites with no issues
2013-05-16 12:50:16 mistachkinok
320. System.Data.SQLite builds and checks out using the SQLite core
netfx40, debug, release, netCF
2013-05-16 10:54:53 drhok
120b. th3make test.rc
2013-05-16 10:48:40 danok
60e. tclsh th3make memdebug.rc
2013-05-16 09:33:20 mistachkinfail
320. System.Data.SQLite builds and checks out using the SQLite core
assert failure, debug build, netFx40, sqlite3.c, 9ffff3d052, line 52099
2013-05-16 01:05:13 drhok
170a. No compiler warnings
2013-05-16 01:04:31 drhok
140a. Checked in latest SQLite amalgamation
2013-05-16 01:04:27 drhok
140c. run-all.sh with no errors
After fixing HAVING clause name resolution, all tests pass.
2013-05-16 00:58:32 mistachkinok
90a. make fulltestonly
2013-05-16 00:28:05 drhok
130e. th3make test.rc -DSQLITE_MAX_ATTACHED=62
On windows8 x64 with MSVC
2013-05-16 00:27:29 drhfail
110b. th3make -Os min.rc
40 failures in mmap1.test and main40.test. Likely this is a test problem due to the lack of support for mmap on OpenBSD, but it does need to be investigated and fixed.
2013-05-15 23:56:37 drhok
130d. th3make test.rc -ftrapv
2013-05-15 23:46:50 drhfail
140c. run-all.sh with no errors
23 errors
2013-05-15 23:38:10 drhok
110a. make test
2013-05-15 23:34:53 drhpending
130e. th3make test.rc -DSQLITE_MAX_ATTACHED=62
On windows8
2013-05-15 23:32:11 drhpending
120b. th3make test.rc
2013-05-15 23:30:53 drhok
120a. make test
The usual e_expr-31.2.4 problem due to floating-point hardware differences.
2013-05-15 23:24:53 drhpending
140c. run-all.sh with no errors
2013-05-15 23:24:16 drhok
140b. No compiler warnings
2013-05-15 23:22:34 drhpending
130d. th3make test.rc -ftrapv
2013-05-15 23:21:21 drhpending
110a. make test
2013-05-15 23:17:05 drhpending
120a. make test
2013-05-15 23:14:28 drhok
160a. No private symbols exported. (This is also checked by releasetest.tcl)
2013-05-15 23:14:28 drhok
160b. No undesirable library dependencies
2013-05-15 23:11:39 drhok
250. Run performance tests comparing the new SQLite release against the previous version. Verify no performance regressions.
2013-05-15 23:11:30 drhok
250c. 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
Slight performance regression due to increased use of sqlite3WalkExpr(). Acceptable for this release. Will attempt to optimize as part of the next release.
2013-05-15 23:06:16 mistachkinok
10d. Windows MSVC Win32 /W3
2013-05-15 20:05:32 danok
50b. tclsh th3make cov.rc (verify 100% branch test coverage)
2013-05-15 19:48:29 danpending
50d. tclsh th3make fast-ex.rc
2013-05-15 19:48:22 danpending
50c. tclsh fulltest.tcl fast.rc test.rc
2013-05-15 19:48:16 danpending
50b. tclsh th3make cov.rc (verify 100% branch test coverage)
2013-05-15 19:47:10 danpending
50a. tclsh releasetest.tcl
2013-05-15 19:40:34 danok
60b. tclsh th3make cov.rc -DHAVE_MALLOC_H -DHAVE_MALLOC_USABLE_SIZE (verify 100% branch test coverage)
2013-05-15 19:40:20 danok
60a. tclsh th3make cov.rc (verify 100% branch test coverage)
2013-05-15 19:37:04 danpending
60e. tclsh th3make memdebug.rc
2013-05-15 19:36:56 danpending
60d. tclsh fulltest.tcl fast.rc test.rc
2013-05-15 19:36:49 danpending
60c. tclsh releasetest.tcl
2013-05-15 19:36:43 danpending
60b. tclsh th3make cov.rc -DHAVE_MALLOC_H -DHAVE_MALLOC_USABLE_SIZE (verify 100% branch test coverage)
2013-05-15 19:36:34 danpending
60f. tclsh th3make test-ex.rc
2013-05-15 19:36:14 danpending
60a. tclsh th3make cov.rc (verify 100% branch test coverage)
2013-05-15 19:27:40 danok
40a. tclsh ../tool/omittest.tcl -skip_run
2013-05-15 19:08:27 drhok
250a. The TCL speed*.test scripts
Easily faster than 3.7.15
2013-05-15 19:06:09 drhok
250b. The TH3 speed tests
Versus 3.7.15, 3.7.17 beta is clearly faster.
2013-05-15 18:56:09 drhok
10e. Windows MSVC Win64 /W3
2013-05-15 18:54:29 drhok
10a. Linux GCC -Wall -Wextra (the tool/warnings.sh script)