SQLite

Checklist For SQLite 3.7.12
Login
2012-05-13 02:52:40 danok
60b. tclsh releasetest.tcl
2012-05-13 02:52:40 danok
60c. tclsh fulltest.tcl fast.rc test.rc
2012-05-13 02:52:40 danok
130f. th3make min.rc -Os; valgrind ./th3
2012-05-12 22:42:23 drhok
20. Documentation checks:
2012-05-12 22:42:23 drhok
20j. Verify that this checklist agrees with planning documents
2012-05-12 22:38:31 drhok
20i. Check new/changed documentation for spelling and gramatical mistakes
2012-05-12 22:29:18 drhok
340. Verify that the bug response checklist has been completed for all bugs found since the previous release.
2012-05-12 22:29:18 drhok
350. Verify that the new feature checklist has been completed for all enhancements made since the previous release.
2012-05-12 22:28:27 drhok
220. NX-Devkit release checklist completed.
TH3 tests only
2012-05-12 20:26:00 drhok
330. Verify that all branches that are no longer active have been closed.
2012-05-12 20:25:05 drhok
20f. The compile-time options are all up-to-date (compile.html)
2012-05-12 20:25:05 drhok
20h. Test metrics are up-to-date (testing.html)
2012-05-12 20:23:36 drhok
30. Source code change review. "fossil diff --from release --to trunk"
2012-05-12 20:23:36 drhok
30a. No stray changes
2012-05-12 20:23:36 drhok
30b. All significant changes are mentioned in the "changes" log of the documentation
2012-05-12 20:23:36 drhok
30c. New code complies with style guidelines
2012-05-12 20:23:36 drhok
30d. New code complies with design rules
2012-05-12 20:23:36 drhok
30e. Comments have been updated to reflect code changes
2012-05-12 20:23:36 drhok
30f. Variables and functions have been renamed to reflect changes in their use
2012-05-12 20:23:36 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-05-12 19:59:51 drhok
170. Fossil updated to use the latest SQLite.
2012-05-12 19:59:32 drhok
170b. Fossil test suite passes
Not a complete test. But spot checking does not uncover any problems.
2012-05-12 19:58:50 drhok
90b. th3make test.rc
2012-05-12 19:58:50 drhok
90e. At least one of the above using MSVC-32
2012-05-12 19:42:48 drhok
20g. Database footprint is up-to-date (features.html)
2012-05-12 19:40:18 drhok
10. Compiler warning checks. (Warnings in the Porter stemmer code are allowed.)
2012-05-12 19:40:18 drhok
10a. Linux GCC -Wall -Wextra (the tool/warnings.sh script)
2012-05-12 19:38:14 drhok
170a. No compiler warnings
2012-05-12 19:38:14 drhok
170c. Used on active websites with no issues
2012-05-12 19:24:14 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-05-12 19:24:14 drhok
280k. 64-little to 32-big, ZIPVFS database
2012-05-12 19:19:22 drhok
280l. 64-little to 32-big, CEROD database
2012-05-12 19:16:26 drhok
280j. 64-little to 32-big, SEE database
2012-05-12 19:01:09 danpending
60b. tclsh releasetest.tcl
Retesting after parser change.
2012-05-12 19:01:09 danpending
60c. tclsh fulltest.tcl fast.rc test.rc
Retesting after parser change.
2012-05-12 19:01:09 danpending
130f. th3make min.rc -Os; valgrind ./th3
Retesting after parser change.
2012-05-12 18:55:24 drhpending
60b. tclsh releasetest.tcl
Retesting after parser change.
2012-05-12 18:53:00 drhpending
60c. tclsh fulltest.tcl fast.rc test.rc
Retesting after parser change.
2012-05-12 18:47:47 mistachkinok
320. System.Data.SQLite builds and checks out using the SQLite core
netfx40, debug, release, netCF
2012-05-12 18:32:05 review
60b. tclsh releasetest.tcl
Retest after the parser fix for legacy table constraint syntax.
2012-05-12 18:32:05 review
60c. tclsh fulltest.tcl fast.rc test.rc
Retest after the parser fix for legacy table constraint syntax.
2012-05-12 18:32:05 review
130f. th3make min.rc -Os; valgrind ./th3
Retest after the parser fix for legacy table constraint syntax.
2012-05-12 17:21:23 drhok
180. Firefox recompiled using lastest SQLite.
2012-05-12 17:21:23 drhok
180a. No SQLite compiler warnings
2012-05-12 17:21:23 drhok
180b. Active use with no issues noted
2012-05-12 17:10:18 drhok
280g. 32-little to 32-big, database
2012-05-12 17:10:18 drhok
280h. 32-little to 32-big, WAL
2012-05-12 17:10:18 drhok
280i. 32-little to 32-big, rollback
2012-05-12 17:07:45 drhok
280d. 64-little to 32-little, database
2012-05-12 17:07:45 drhok
280e. 64-little to 32-little, WAL
2012-05-12 17:07:45 drhok
280f. 64-little to 32-little, rollback
2012-05-12 17:05:41 drhok
280a. 32-big to 64-little, database
2012-05-12 17:05:41 drhok
280b. 32-big to 64-little, WAL
2012-05-12 17:05:41 drhok
280c. 32-big to 64-little, rollback
2012-05-12 16:04:23 drhok
260. Verify that the amalgamation builds are byte-for-byte identical on all workstation platforms.
2012-05-12 16:04:23 drhok
260a. linux x86
2012-05-12 16:01:54 drhok
260e. openbsd
2012-05-12 15:49:30 drhok
210. ZIPVFS tests:
2012-05-12 15:49:30 drhok
210g. At least one of the above on Windows
2012-05-12 15:49:08 drhok
140. Sqllogictest:
2012-05-12 15:49:08 drhok
140d. run-all.bat with no errors
2012-05-12 15:48:45 drhok
80. Tests for platform Mac OS-X PPC:
2012-05-12 15:48:45 drhok
80a. tclsh th3make -Os min.rc
2012-05-12 15:00:16 ok
310. 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.
2012-05-12 15:00:02 dan
310. 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-05-12 14:22:48 ok
70. Tests for platform Mac OS-X x86:
2012-05-12 14:22:38 danok
70a. tclsh releasetest.tcl
2012-05-12 14:21:56 danok
300. Tests for the sessions branch with macros SQLITE_ENABLE_SESSION and SQLITE_ENABLE_PREUPDATE_HOOK
2012-05-12 14:21:56 danok
300d. tclsh th3make min.rc -norun; valgrind ./th3
2012-05-12 13:27:58 danok
300b. tclsh th3make test.rc (on unix)
2012-05-12 13:27:22 drhok
260c. mac leopard
2012-05-12 13:24:29 drhok
260d. mac snow-leopard
2012-05-12 13:19:34 drhok
260b. linux x64
2012-05-12 13:19:19 drhok
260g. windows nmake
2012-05-12 13:18:26 drhok
260f. windows native mingw
2012-05-12 13:14:41 drhok
260h. any unix using autoconf
Mac OSX 10.2 "Jaguar" on an old iBook.
2012-05-12 13:10:45 drhpending
80a. tclsh th3make -Os min.rc
2012-05-12 13:10:15 drhpending
210g. At least one of the above on Windows
2012-05-12 12:51:00 drhok
40. OMIT, ENABLE, and DISABLE options:
2012-05-12 12:51:00 drhok
40a. tclsh ../tool/omittest.tcl -skip_run
2012-05-12 12:22:22 drhpending
40a. tclsh ../tool/omittest.tcl -skip_run
2012-05-12 12:20:37 drhok
250. Run performance tests comparing the new SQLite release against the previous version. Verify no performance regressions.
2012-05-12 12:20:37 drhok
250a. The TCL speed*.test scripts
2012-05-12 12:18:08 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
2012-05-12 11:59:49 danok
300c. tclsh th3make cov.rc
2012-05-12 11:53:20 drhpending
140d. run-all.bat with no errors
2012-05-12 11:46:58 danpending
300c. tclsh th3make cov.rc
2012-05-12 11:45:00 danok
300f. make test (on unix)
2012-05-12 11:44:32 danpending
300d. tclsh th3make min.rc -norun; valgrind ./th3
2012-05-12 11:33:39 danpending
300b. tclsh th3make test.rc (on unix)
2012-05-12 11:31:59 danpending
300f. make test (on unix)
2012-05-12 11:09:53 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-05-12 10:53:32 drhok
190. CEROD tests in the test/ subdirectory.
2012-05-12 10:53:02 drhok
60. Tests for platform Linux x86_64:
2012-05-12 10:53:02 drhok
60e. tclsh th3make test-ex.rc
2012-05-12 10:52:35 drhok
50. Tests for platform Linux x86:
2012-05-12 10:52:35 drhok
50d. tclsh th3make fast-ex.rc
2012-05-12 04:49:20 danok
210c. th3make zipvfs.rc memdebug.rc
2012-05-12 04:49:20 danok
210d. th3make zipvfs.rc min.rc; valgrind ./th3
2012-05-12 04:49:20 danok
210f. At least one of the above on Mac
2012-05-12 03:40:47 drhok
200. SEE tests using TH3:
2012-05-12 03:40:47 drhok
200b. see-aes128-ofb.c
2012-05-12 03:40:47 drhok
200g. At least one of the above using memdebug.rc
2012-05-12 03:40:47 drhok
200j. At least one of the above on Windows
2012-05-12 03:19:24 drhok
130. Other test performed on any available platform:
2012-05-12 03:19:24 drhok
130a. th3make alignment2.rc test.rc
2012-05-12 02:45:25 drhok
140a. Checked in latest SQLite amalgamation
2012-05-12 02:45:25 drhok
140b. No compiler warnings
2012-05-12 02:45:25 drhok
140c. run-all.sh with no errors
2012-05-12 02:35:16 drhok
130d. th3make test.rc -ftrapv
2012-05-12 02:11:54 drhok
130b. th3make test.rc -DHAVE_LOCALTIME_R
2012-05-12 02:11:20 drhok
50a. tclsh releasetest.tcl
The usual failure on notify2-3 in unlock_notify. All else passes.
2012-05-12 01:58:50 drhok
90. Tests for platform Win32/64:
2012-05-12 01:58:16 drhok
170a. No compiler warnings
2012-05-12 01:58:16 drhok
170c. Used on active websites with no issues
2012-05-12 01:57:57 drhpending
170a. No compiler warnings
2012-05-12 01:57:57 drhpending
170c. Used on active websites with no issues
2012-05-12 01:57:23 drhok
200d. see-rc4.c
2012-05-12 01:49:07 drhok
100. Tests for platform Android:
2012-05-12 01:49:07 drhok
110. Tests for platform OpenBSD x86:
2012-05-12 01:49:07 drhok
160. Exported symbol checks: tool/symbols.sh
2012-05-12 01:48:29 drhok
130c. th3make test.rc -DSQLITE_THREADSAFE=0
2012-05-12 01:47:16 drhpending
200d. see-rc4.c
2012-05-12 01:47:16 drhpending
200j. At least one of the above on Windows
2012-05-12 01:45:24 drhok
200e. see-aes128-ccm.c
c2.pragma10.mpc-1[01] fail due to the db file size differences resulting from the CCM signatures. All else works.
2012-05-12 01:33:12 drhok
200c. see-aes256-ofb.c
2012-05-12 01:33:12 drhok
200h. At least one of the above on Linux
2012-05-12 01:26:26 drhpending
200b. see-aes128-ofb.c
2012-05-12 01:26:26 drhpending
200g. At least one of the above using memdebug.rc
2012-05-12 01:17:53 drhok
200a. see.c
2012-05-12 01:17:53 drhok
200f. At least one of the above using test.rc
2012-05-12 01:17:53 drhok
200i. At least one of the above on Mac
2012-05-12 01:17:19 drhpending
50a. tclsh releasetest.tcl
2012-05-12 01:17:19 drhpending
60e. tclsh th3make test-ex.rc
2012-05-12 01:15:24 drhok
60b. tclsh releasetest.tcl
shell1-3.3.1 failed in a couple of tests due to long pathnames and the output of ".databases" being clipped.
2012-05-11 23:18:35 drhpending
200a. see.c
2012-05-11 23:18:35 drhpending
200f. At least one of the above using test.rc
2012-05-11 23:18:35 drhpending
200i. At least one of the above on Mac
2012-05-11 23:16:27 drhok
120. Tests for platform Solaris Sparc:
2012-05-11 23:16:08 drhok
120a. make test
e_expr-31.2.4 fails due to differences in floating-point handling on sparc.
2012-05-11 23:13:04 drhok
290. Build and verify correct operation of sqlite3_analyzer on:
2012-05-11 23:13:04 drhok
290d. Win32 (MinGW)
2012-05-11 23:08:50 drhok
290e. Win32 (MSVC) and verify correct output.
2012-05-11 23:06:36 drhok
150. Build using the configure/make in main source tree.
2012-05-11 23:06:36 drhok
150h. Works on Solaris
2012-05-11 23:05:56 drhok
70b. tclsh fulltest.tcl fast.rc test.rc
2012-05-11 22:32:45 drhok
50c. tclsh fulltest.tcl fast.rc test.rc
2012-05-11 22:32:45 drhok
50e. At least one of the above using GCC 4.1.0
2012-05-11 19:31:42 danpending
210f. At least one of the above on Mac
2012-05-11 19:31:28 danok
210e. At least one of the above on Linux
2012-05-11 19:30:10 pending
70a. tclsh releasetest.tcl
2012-05-11 19:29:32 danpending
210c. th3make zipvfs.rc memdebug.rc
2012-05-11 19:29:32 danpending
210d. th3make zipvfs.rc min.rc; valgrind ./th3
2012-05-11 19:28:27 danok
130g. valgrind testfixture permutations.test valgrind
linux/x86_64
2012-05-11 18:53:54 mistachkinok
300a. tclsh th3make test.rc (on windows)
2012-05-11 18:52:37 drhok
60c. tclsh fulltest.tcl fast.rc test.rc
Manually repeated the alignment7 tests after changes.
2012-05-11 18:52:00 drhok
130f. th3make min.rc -Os; valgrind ./th3
2012-05-11 17:36:42 drhpending
50d. tclsh th3make fast-ex.rc
2012-05-11 17:36:30 danok
210a. testfixture ../zipvfs/test/zipvfs.test (See test/README.txt in the ZIPVFS source tree for details.)
2012-05-11 17:36:30 danok
210b. th3make zipvfs.rc test.rc
2012-05-11 17:34:54 drhok
100a. th3make -Os min.rc
One error on wal37.104 is expected because Android GCC does not define the macro "unix".
2012-05-11 17:24:23 drhpending
120a. make test
2012-05-11 17:24:23 drhpending
150h. Works on Solaris
2012-05-11 17:22:44 drhok
160c. No private symbols exported in MinGW (check using tool/symbols-mingw.sh)
2012-05-11 17:22:44 drhok
160d. No undesirable library dependencies on MinGW
2012-05-11 17:20:57 drhpending
130c. th3make test.rc -DSQLITE_THREADSAFE=0
2012-05-11 17:19:54 drhok
130e. th3make test.rc -DSQLITE_MAX_ATTACHED=62
2012-05-11 17:19:01 drhpending
50c. tclsh fulltest.tcl fast.rc test.rc
2012-05-11 17:19:01 drhpending
50e. At least one of the above using GCC 4.1.0
2012-05-11 17:18:31 drhpending
60c. tclsh fulltest.tcl fast.rc test.rc
Retesting after fixing test script issues for alignment7
2012-05-11 17:17:52 drhpending
70b. tclsh fulltest.tcl fast.rc test.rc
2012-05-11 16:53:10 mistachkinpending
300a. tclsh th3make test.rc (on windows)
2012-05-11 16:42:54 mistachkinok
300e. make test (on windows)
failed: hook-7.5.2.1 hook-7.5.2.2
2012-05-11 16:41:38 drhok
120c. th3make fast.rc
2012-05-11 16:40:43 drhpending
130e. th3make test.rc -DSQLITE_MAX_ATTACHED=62
2012-05-11 16:40:43 drhpending
130f. th3make min.rc -Os; valgrind ./th3
2012-05-11 16:40:19 drhpending
100a. th3make -Os min.rc
2012-05-11 16:31:01 drhfail
60c. tclsh fulltest.tcl fast.rc test.rc
22 errors in alignment7
2012-05-11 16:00:41 danok
290a. Linux
2012-05-11 16:00:41 danok
290b. Mac
2012-05-11 16:00:41 danok
290c. OpenBSD
2012-05-11 15:57:57 drhok
20d. No unresolved hyperlinks in the documentation build
2012-05-11 15:57:57 drhok
20e. Requirements marks are up-to-date in both documentation and source code
2012-05-11 15:42:28 drhok
70c. tclsh th3make test.rc CC=clang
2012-05-11 15:41:33 drhok
90c. th3make fast.rc
2012-05-11 15:41:33 drhok
90d. At least one of the above using MinGW
2012-05-11 15:27:02 drhok
20a. Latest release on the index.html page
2012-05-11 15:27:02 drhok
20b. Release announcement in changes.in
2012-05-11 15:27:02 drhok
20c. Release accouncement in news.html
2012-05-11 15:23:04 danok
240. TEA archive builds correctly and runs:
2012-05-11 15:23:04 danok
240a. Linux
2012-05-11 15:23:04 danok
240b. Mac
2012-05-11 15:20:17 danok
230. Amalgamation autoconf tarball.
2012-05-11 15:20:17 danok
230a. Builds
2012-05-11 15:20:17 danok
230b. Works on Linux
2012-05-11 15:20:17 danok
230c. Works on Mac
2012-05-11 15:13:43 drhok
60d. tclsh th3make memdebug.rc
Run on x86 by mistake
2012-05-11 15:12:04 drhok
60d. tclsh th3make memdebug.rc
2012-05-11 14:58:52 drhok
120b. th3make test.rc
2012-05-11 14:51:16 danok
150a. Make sure that autoconf has been run to update the configure script.
2012-05-11 14:51:16 danok
150b. Run "make test" to verify that the build works.
2012-05-11 14:51:16 danok
150c. Verify the correct version numbers have been installed.
2012-05-11 14:51:16 danok
150d. Verify that the --disable-amalgamation option to configure works.
2012-05-11 14:51:16 danok
150e. Works on Linux
2012-05-11 14:51:16 danok
150f. Works on Mac
2012-05-11 14:51:16 danok
150g. Works on OpenBSD
2012-05-11 14:45:40 drhok
90b. th3make test.rc
2012-05-11 14:45:40 drhok
90f. At least one of the above using MSVC-64
2012-05-11 14:22:09 drhok
110b. th3make -Os min.rc
2012-05-11 13:46:28 drhok
90a. make test
2012-05-11 13:46:28 drhok
90e. At least one of the above using MSVC-32
2012-05-11 13:40:58 drhok
110a. make test
2012-05-11 13:23:21 drhok
10c. OpenBSD GCC using options -Wall
2012-05-11 13:18:25 drhok
10e. Windows MSVC Win64 /W3
2012-05-11 13:17:45 drhok
10b. Mac GCC -Wall -Wextra (the tool/warnings.sh script)
2012-05-11 13:10:50 drhok
10a. Linux GCC -Wall -Wextra (the tool/warnings.sh script)
2012-05-11 13:10:50 drhok
10d. Windows MSVC Win32 /W3
2012-05-11 13:10:50 drhok
10f. sh tool/warnings-clang.sh
2012-05-11 12:45:08 drhok
50f. At least one of the above using GCC 4.4.1
2012-05-11 12:42:16 drhok
50b. tclsh th3make cov.rc (verify 100% branch test coverage)
2012-05-11 12:21:13 drhok
160a. No private symbols exported. (This is also checked by releasetest.tcl)
2012-05-11 12:21:13 drhok
160b. No undesirable library dependencies
2012-05-11 12:19:00 drhok
250b. The TH3 speed tests
2012-05-11 12:16:51 drhok
60a. tclsh th3make cov.rc (verify 100% branch test coverage)
2012-05-03 14:01:35 danok
70a. tclsh releasetest.tcl
2012-05-03 12:02:24 danok
60b. tclsh releasetest.tcl
2012-05-03 08:59:53 danfail
50b. tclsh th3make cov.rc (verify 100% branch test coverage)
Missing this branch: http://www.sqlite.org/src/artifact/cb55e84b?ln=427
2012-05-01 18:18:39 danok
50a. tclsh releasetest.tcl
2012-04-19 19:29:38 ok
130d. th3make test.rc -ftrapv
2012-04-19 19:06:41 ok
70c. tclsh th3make test.rc CC=clang
2012-04-19 19:06:23 ok
160a. No private symbols exported. (This is also checked by releasetest.tcl)
2012-04-19 19:06:23 ok
160b. No undesirable library dependencies
2012-04-19 19:01:33 ok
250b. The TH3 speed tests
2012-04-19 18:32:07 ok
40a. tclsh ../tool/omittest.tcl -skip_run
2012-04-19 17:21:08 ok
10e. Windows MSVC Win64 /W3
2012-04-19 15:55:44 ok
10f. sh tool/warnings-clang.sh
2012-04-19 15:55:31 ok
10d. Windows MSVC Win32 /W3
2012-04-19 15:54:46 ok
10b. Mac GCC -Wall -Wextra (the tool/warnings.sh script)
2012-04-19 15:53:06 ok
10c. OpenBSD GCC using options -Wall
2012-04-19 15:49:49 ok
10a. Linux GCC -Wall -Wextra (the tool/warnings.sh script)