SQLite

Checklist For SQLite 3.7.11
Login
2012-03-20 05:11:52 danok
210. ZIPVFS tests:
2012-03-20 05:11:52 danok
210c. th3make zipvfs.rc memdebug.rc
2012-03-20 05:01:59 danok
210d. th3make zipvfs.rc min.rc; valgrind ./th3
2012-03-20 05:01:59 danok
210e. At least one of the above on Linux
2012-03-20 03:34:07 mikeok
120. Tests for platform Solaris Sparc:
2012-03-20 03:33:49 mikeok
120c. th3make fast.rc
2012-03-20 03:11:14 drhok
130. Other test performed on any available platform:
2012-03-20 03:11:14 drhok
130g. valgrind testfixture permutations.test valgrind
2012-03-20 02:43:47 mikeok
120b. th3make test.rc
2012-03-20 02:43:28 mikeok
120a. make test
2012-03-20 01:39:11 drhok
360. Verify that the new feature checklist has been completed for all enhancements made since the previous release.
2012-03-20 01:38:29 drhok
350. Verify that the bug response checklist has been completed for all bugs found since the previous release.
2012-03-20 01:10:53 drhok
210f. At least one of the above on Mac
2012-03-19 23:29: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.
2012-03-19 23:29:20 drhok
280k. 64-little to 32-big, ZIPVFS database
2012-03-19 23:27:43 drhok
220. NX-Devkit release checklist completed.
2012-03-19 23:11:46 drhok
280l. 64-little to 32-big, CEROD database
2012-03-19 23:10:31 mistachkinok
330. System.Data.SQLite builds and checks out using the SQLite core
2012-03-19 23:01:52 drhok
280j. 64-little to 32-big, SEE database
2012-03-19 22:53:47 drhok
280g. 32-little to 32-big, database
2012-03-19 22:53:47 drhok
280h. 32-little to 32-big, WAL
2012-03-19 22:53:47 drhok
280i. 32-little to 32-big, rollback
2012-03-19 22:53:26 drhok
280d. 64-little to 32-little, database
2012-03-19 22:53:26 drhok
280e. 64-little to 32-little, WAL
2012-03-19 22:53:26 drhok
280f. 64-little to 32-little, rollback
2012-03-19 22:49:17 drhok
280a. 32-big to 64-little, database
2012-03-19 22:49:17 drhok
280b. 32-big to 64-little, WAL
2012-03-19 22:49:17 drhok
280c. 32-big to 64-little, rollback
2012-03-19 22:26:25 drhok
20. Documentation checks:
2012-03-19 22:26:25 drhok
20j. Verify that this checklist agrees with planning documents
2012-03-19 22:26:08 drhok
80. Tests for platform Mac OS-X PPC:
2012-03-19 22:26:08 drhok
80a. tclsh th3make -Os min.rc
2012-03-19 22:00:42 drhok
210g. At least one of the above on Windows
2012-03-19 20:55:55 drhok
140. Sqllogictest:
2012-03-19 20:55:55 drhok
140d. run-all.bat with no errors
2012-03-19 20:16:22 drhok
200. SEE tests using TH3:
2012-03-19 20:16:22 drhok
200c. see-aes256-ofb.c
2012-03-19 20:16:22 drhok
200i. At least one of the above on Mac
2012-03-19 19:49:54 drhok
200e. see-aes128-ccm.c
2012-03-19 19:44:12 drhok
200d. see-rc4.c
2012-03-19 19:33:10 drhok
200a. see.c
2012-03-19 19:33:10 drhok
200b. see-aes128-ofb.c
2012-03-19 19:33:10 drhok
200f. At least one of the above using test.rc
2012-03-19 19:33:10 drhok
200g. At least one of the above using memdebug.rc
2012-03-19 19:33:10 drhok
200h. At least one of the above on Linux
2012-03-19 19:33:10 drhok
200j. At least one of the above on Windows
2012-03-19 19:17:17 drhok
340. Verify that all branches that are no longer active have been closed.
2012-03-19 19:05:07 drhok
310. Tests for the sessions branch with macros SQLITE_ENABLE_SESSION and SQLITE_ENABLE_PREUPDATE_HOOK
2012-03-19 19:04:53 drhok
310e. make test (on windows)
Failures on hook-7.5.2.1 and hook-7.5.2.2, as expected.
2012-03-19 18:30:15 drhok
20f. The compile-time options are all up-to-date (compile.html)
2012-03-19 18:30:15 drhok
20h. Test metrics are up-to-date (testing.html)
2012-03-19 18:20:51 drhok
20g. Database footprint is up-to-date (features.html)
2012-03-19 18:13:46 drhok
310a. tclsh th3make test.rc (on windows)
2012-03-19 18:07:31 drhok
20a. Latest release on the index.html page
2012-03-19 18:07:31 drhok
20b. Release announcement in changes.in
2012-03-19 18:07:31 drhok
20c. Release accouncement in news.html
2012-03-19 18:07:31 drhok
20d. No unresolved hyperlinks in the documentation build
2012-03-19 18:07:31 drhok
20e. Requirements marks are up-to-date in both documentation and source code
2012-03-19 18:07:31 drhok
20i. Check new/changed documentation for spelling and gramatical mistakes
2012-03-19 18:02:49 drhok
100. Tests for platform Android:
2012-03-19 18:02:37 drhok
100a. 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.
2012-03-19 17:38:07 drhok
190. CEROD tests in the test/ subdirectory.
2012-03-19 17:17:29 danok
210b. th3make zipvfs.rc test.rc
2012-03-19 17:14:36 drhok
90. Tests for platform Win32/64:
2012-03-19 17:14:36 drhok
90c. th3make fast.rc
2012-03-19 17:14:36 drhok
90f. At least one of the above using MSVC-64
2012-03-19 17:00:54 drhok
90a. make test
2012-03-19 17:00:54 drhok
90b. th3make test.rc
2012-03-19 17:00:54 drhok
90d. At least one of the above using MinGW
2012-03-19 17:00:54 drhok
90e. At least one of the above using MSVC-32
2012-03-19 16:57:08 drhok
150. Build using the configure/make in main source tree.
2012-03-19 16:57:08 drhok
150h. Works on Solaris
2012-03-19 16:56:13 drhok
250. Run performance tests comparing the new SQLite release against the previous version. Verify no performance regressions.
2012-03-19 16:56:02 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
Using build-fast-shell.sh and realtime measurements.
2012-03-19 16:47:16 danok
210a. testfixture ../zipvfs/test/zipvfs.test (See test/README.txt in the ZIPVFS source tree for details.)
2012-03-19 16:46:53 drhok
250a. The TCL speed*.test scripts
2012-03-19 16:44:05 drhok
250b. The TH3 speed tests
realtime tests only - did not run cachegrind.
2012-03-19 16:35:07 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 using backcompat.test against 3.6.4 and 3.7.1
2012-03-19 16:22:42 danok
320. 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.
veryquick.test passes.
2012-03-19 15:52:05 drhok
290. Build and verify correct operation of sqlite3_analyzer on:
2012-03-19 15:52:05 drhok
290e. Win32 (MSVC)
2012-03-19 15:49:05 drhok
140c. run-all.sh with no errors
2012-03-19 15:47:52 drhok
260. Verify that the amalgamation builds are byte-for-byte identical on all workstation platforms.
2012-03-19 15:47:52 drhok
260g. windows nmake
2012-03-19 15:46:45 danok
290a. Linux
2012-03-19 15:46:45 danok
290b. Mac
2012-03-19 15:46:45 danok
290c. OpenBSD
2012-03-19 15:46:45 danok
290d. Win32 (MinGW)
2012-03-19 15:45:20 drhok
260d. mac snow-leopard
2012-03-19 15:42:16 drhok
260a. linux x86
2012-03-19 15:41:22 drhok
260e. openbsd
2012-03-19 15:41:22 drhok
260h. any unix using autoconf
2012-03-19 15:39:25 drhok
260c. mac leopard
2012-03-19 15:38:01 drhok
260b. linux x64
2012-03-19 15:38:01 drhok
260f. windows native mingw
2012-03-19 15:30:34 drhok
160. Exported symbol checks: tool/symbols.sh
2012-03-19 15:30:34 drhok
160c. No private symbols exported in MinGW (check using tool/symbols-mingw.sh)
2012-03-19 15:30:34 drhok
160d. No undesirable library dependencies on MinGW
2012-03-19 15:26:40 drhok
140a. Checked in latest SQLite amalgamation
2012-03-19 15:26:40 drhok
140b. No compiler warnings
2012-03-19 14:58:53 drhok
10. Compiler warning checks. (Warnings in the Porter stemmer code are allowed.)
2012-03-19 14:58:53 drhok
10e. Windows MSVC Win64 /W3
2012-03-19 14:34:21 drhok
10c. OpenBSD GCC using options -Wall
2012-03-19 14:33:13 drhok
10d. Windows MSVC Win32 /W3
2012-03-19 14:23:47 danok
310c. tclsh th3make cov.rc
2012-03-19 13:48:27 danok
310d. tclsh th3make min.rc -norun; valgrind ./th3
2012-03-19 13:37:42 drhok
10b. Mac GCC -Wall -Wextra (the tool/warnings.sh script)
2012-03-19 13:35:41 drhok
130a. th3make alignment2.rc test.rc
2012-03-19 12:13:06 danok
310b. tclsh th3make test.rc (on unix)
2012-03-19 11:16:39 danok
310f. make test (on unix)
2012-03-19 11:02:54 danok
300. Run the CLI tests found under the tool subfolder in the main source tree and verify correct output.
Tests shell[12345].test pass.
2012-03-19 08:34:06 danok
240. TEA archive builds correctly and runs:
2012-03-19 08:34:06 danok
240a. Linux
2012-03-19 08:34:06 danok
240b. Mac
2012-03-19 08:27:33 danreview
130a. th3make alignment2.rc test.rc
Tests pass here on 32-bit linux. Coverage is relatively low. Is it supposed to be otherwise?
2012-03-19 08:23:51 danok
230. Amalgamation autoconf tarball.
2012-03-19 08:23:51 danok
230a. Builds
2012-03-19 08:23:51 danok
230b. Works on Linux
2012-03-19 08:23:51 danok
230c. Works on Mac
2012-03-19 07:57:40 danok
150f. Works on Mac
2012-03-19 07:32:45 danok
150b. Run "make test" to verify that the build works.
2012-03-19 07:32:45 danok
150c. Verify the correct version numbers have been installed.
2012-03-19 07:32:45 danok
150d. Verify that the --disable-amalgamation option to configure works.
2012-03-19 07:32:45 danok
150e. Works on Linux
2012-03-19 07:32:45 danok
150g. Works on OpenBSD
2012-03-19 07:06:53 danok
150a. Make sure that autoconf has been run to update the configure script.
http://www.sqlite.org/src/info/6f9b265dd0
2012-03-19 06:53:20 danok
110. Tests for platform OpenBSD x86:
2012-03-19 06:53:20 danok
110b. th3make -Os min.rc
2012-03-19 05:07:56 danok
110a. make test
2012-03-19 01:16:49 drhok
30. Source code change review. "fossil diff --from release --to trunk"
2012-03-19 01:16:49 drhok
30a. No stray changes
2012-03-19 01:16:49 drhok
30b. All significant changes are mentioned in the "changes" log of the documentation
2012-03-19 01:16:49 drhok
30c. New code complies with style guidelines
2012-03-19 01:16:49 drhok
30d. New code complies with design rules
2012-03-19 01:16:49 drhok
30e. Comments have been updated to reflect code changes
2012-03-19 01:16:49 drhok
30f. Variables and functions have been renamed to reflect changes in their use
2012-03-19 01:16:49 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.
2012-03-19 01:01:16 drhok
70. Tests for platform Mac OS-X x86:
2012-03-19 01:01:16 drhok
70b. tclsh fulltest.tcl fast.rc test.rc
2012-03-18 22:10:27 drhok
130e. th3make test.rc -DSQLITE_MAX_ATTACHED=62
2012-03-18 22:09:48 drhok
40. OMIT, ENABLE, and DISABLE options:
2012-03-18 22:09:33 drhok
40a. tclsh ../tool/omittest.tcl -skip_run
Except ENABLE_LOCKING_STYLE doesn't work on linux, but we already knew that.
2012-03-18 20:03:45 drhok
130c. th3make test.rc -DSQLITE_THREADSAFE=0
2012-03-18 18:44:17 drhok
60. Tests for platform Linux x86_64:
2012-03-18 18:44:17 drhok
60e. tclsh th3make test-ex.rc
2012-03-18 18:44:01 drhok
130b. th3make test.rc -DHAVE_LOCALTIME_R
2012-03-18 17:43:50 drhok
60c. tclsh fulltest.tcl fast.rc test.rc
2012-03-18 16:46:49 drhok
170. Fossil updated to use the latest SQLite.
2012-03-18 16:46:49 drhok
170b. Fossil test suite passes
2012-03-18 16:10:31 drhok
50. Tests for platform Linux x86:
2012-03-18 16:10:31 drhok
50c. tclsh fulltest.tcl fast.rc test.rc
2012-03-18 16:10:31 drhok
50e. At least one of the above using GCC 4.1.0
2012-03-18 13:41:52 drhok
50d. tclsh th3make fast-ex.rc
2012-03-17 18:33:35 danok
70a. tclsh releasetest.tcl
2012-03-17 18:29:14 drhok
60d. tclsh th3make memdebug.rc
2012-03-17 17:55:43 drhok
50f. At least one of the above using GCC 4.4.1
2012-03-17 17:55:06 drhok
50b. tclsh th3make cov.rc (verify 100% branch test coverage)
2012-03-17 17:12:54 drhok
60b. tclsh releasetest.tcl
2012-03-17 14:16:11 danok
60b. tclsh releasetest.tcl
2012-03-17 14:13:46 drhok
130f. th3make min.rc -Os; valgrind ./th3
2012-03-17 11:06:33 danok
50a. tclsh releasetest.tcl
2012-03-17 03:14:05 drhok
130d. th3make test.rc -ftrapv
2012-03-16 17:30:50 drhok
60a. tclsh th3make cov.rc (verify 100% branch test coverage)
2012-03-16 03:34:24 drhok
180. Firefox recompiled using lastest SQLite.
2012-03-16 03:34:24 drhok
180a. No SQLite compiler warnings
2012-03-16 03:34:24 drhok
180b. Active use with no issues noted
2012-03-16 01:08:14 drhok
170a. No compiler warnings
2012-03-16 01:08:14 drhok
170c. Used on active websites with no issues
2012-03-16 01:07:24 drhok
160a. No private symbols exported. (This is also checked by releasetest.tcl)
2012-03-16 01:07:24 drhok
160b. No undesirable library dependencies
2012-03-16 00:46:00 drhok
10a. Linux GCC -Wall -Wextra (the tool/warnings.sh script)
2012-03-16 00:46:00 drhok
10f. sh tool/warnings-clang.sh