SQLite

Checklist For SQLite 3.7.13
Login
2012-06-11 02:02:38 drhok
150. Build using the configure/make in main source tree.
2012-06-11 02:02:28 drhok
150h. Works on Solaris
This is the same as 12a
2012-06-10 23:16:50 drhok
220. NX-Devkit release checklist completed.
Items 1 through 6 and 9. Omitted 7 and 8.
2012-06-10 22:23:26 drhok
20. Documentation checks:
2012-06-10 22:23:26 drhok
20j. Verify that this checklist agrees with planning documents
2012-06-10 21:08:26 drhok
350. Verify that the new feature checklist has been completed for all enhancements made since the previous release.
2012-06-10 21:08:18 drhok
340. Verify that the bug response checklist has been completed for all bugs found since the previous release.
2012-06-10 21:07:12 drhok
330. Verify that all branches that are no longer active have been closed.
2012-06-10 21:03:05 drhok
20a. Latest release on the index.html page
2012-06-10 21:03:05 drhok
20b. Release announcement in changes.in
2012-06-10 21:03:05 drhok
20c. Release accouncement in news.html
2012-06-10 21:03:05 drhok
20d. No unresolved hyperlinks in the documentation build
2012-06-10 21:03:05 drhok
20e. Requirements marks are up-to-date in both documentation and source code
2012-06-10 21:03:05 drhok
20f. The compile-time options are all up-to-date (compile.html)
2012-06-10 21:03:05 drhok
20g. Database footprint is up-to-date (features.html)
2012-06-10 21:03:05 drhok
20h. Test metrics are up-to-date (testing.html)
2012-06-10 21:03:05 drhok
20i. Check new/changed documentation for spelling and gramatical mistakes
2012-06-10 20:40:50 drhok
10. Compiler warning checks. (Warnings in the Porter stemmer code are allowed.)
2012-06-10 20:40:31 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-06-10 20:40:31 drhok
280l. 64-little to 32-big, CEROD database
2012-06-10 20:35:22 drhok
280k. 64-little to 32-big, ZIPVFS database
2012-06-10 20:31:51 drhok
280j. 64-little to 32-big, SEE database
2012-06-10 20:24:11 drhok
280g. 32-little to 32-big, database
2012-06-10 20:24:11 drhok
280h. 32-little to 32-big, WAL
2012-06-10 20:24:11 drhok
280i. 32-little to 32-big, rollback
2012-06-10 20:21:57 drhok
280d. 64-little to 32-little, database
2012-06-10 20:21:57 drhok
280e. 64-little to 32-little, WAL
2012-06-10 20:21:57 drhok
280f. 64-little to 32-little, rollback
2012-06-10 20:18:42 drhok
280a. 32-big to 64-little, database
2012-06-10 20:18:42 drhok
280b. 32-big to 64-little, WAL
2012-06-10 20:18:42 drhok
280c. 32-big to 64-little, rollback
2012-06-10 20:18:06 drhok
10f. sh tool/warnings-clang.sh
2012-06-10 20:07:50 drhok
10c. OpenBSD GCC using options -Wall
2012-06-10 20:07:25 drhok
300. Tests for the sessions branch with macros SQLITE_ENABLE_SESSION and SQLITE_ENABLE_PREUPDATE_HOOK
2012-06-10 20:07:25 drhok
300a. tclsh th3make test.rc (on windows)
2012-06-10 20:07:25 drhok
300e. make test (on windows)
2012-06-10 20:06:09 drhok
260. Verify that the amalgamation builds are byte-for-byte identical on all workstation platforms.
2012-06-10 20:06:09 drhok
260e. openbsd
2012-06-10 19:06:30 drhok
290. Build and verify correct operation of sqlite3_analyzer on:
2012-06-10 19:06:30 drhok
290e. Win32 (MSVC) and verify correct output.
2012-06-10 19:05:45 drhok
290d. Win32 (MinGW)
2012-06-10 19:02:59 drhok
260a. linux x86
2012-06-10 19:02:59 drhok
260h. any unix using autoconf
2012-06-10 19:02:15 drhok
190. CEROD tests in the test/ subdirectory.
2012-06-10 18:58:01 drhok
260f. windows native mingw
2012-06-10 18:47:03 drhok
260g. windows nmake
2012-06-10 18:44:57 drhok
200. SEE tests using TH3:
2012-06-10 18:44:57 drhok
200e. see-aes128-ccm.c
2012-06-10 18:42:25 drhok
210. ZIPVFS tests:
2012-06-10 18:42:25 drhok
210b. th3make zipvfs.rc test.rc
2012-06-10 18:42:25 drhok
210g. At least one of the above on Windows
2012-06-10 11:33:27 drhok
200d. see-rc4.c
2012-06-10 11:33:27 drhok
200i. At least one of the above on Mac
2012-06-10 11:26:06 drhpending
210b. th3make zipvfs.rc test.rc
Prior segfault was caused by an incorrect build. An older version of sqlite3.c was mistakenly used. Retesting now...
2012-06-10 11:17:09 drhfail
210b. th3make zipvfs.rc test.rc
Segfault on windows (MSVC) at 64k.select35.130
2012-06-10 11:13:45 drhok
230. Amalgamation autoconf tarball.
2012-06-10 11:13:45 drhok
240. TEA archive builds correctly and runs:
2012-06-10 11:12:59 drhpending
200d. see-rc4.c
2012-06-10 11:12:59 drhpending
200i. At least one of the above on Mac
2012-06-10 11:12:34 drhpending
210b. th3make zipvfs.rc test.rc
2012-06-10 11:12:34 drhpending
210g. At least one of the above on Windows
2012-06-10 11:06:49 drhok
260d. mac snow-leopard
2012-06-10 11:04:58 drhok
40. OMIT, ENABLE, and DISABLE options:
2012-06-10 11:04:58 drhok
50. Tests for platform Linux x86:
2012-06-10 11:04:58 drhok
60. Tests for platform Linux x86_64:
2012-06-10 11:04:58 drhok
70. Tests for platform Mac OS-X x86:
2012-06-10 11:04:03 drhok
140. Sqllogictest:
2012-06-10 11:04:03 drhok
140d. run-all.bat with no errors
2012-06-10 11:03:34 drhok
80. Tests for platform Mac OS-X PPC:
2012-06-10 11:03:34 drhok
80a. tclsh th3make -Os min.rc
2012-06-10 07:01:58 danok
300d. tclsh th3make min.rc -norun; valgrind ./th3
2012-06-10 02:11:33 drhok
200c. see-aes256-ofb.c
2012-06-10 02:11:33 drhok
200f. At least one of the above using test.rc
2012-06-10 01:43:52 drhpending
200c. see-aes256-ofb.c
2012-06-10 01:43:52 drhpending
200f. At least one of the above using test.rc
2012-06-10 01:41:57 drhok
140c. run-all.sh with no errors
2012-06-10 01:41:40 drhpending
140d. run-all.bat with no errors
2012-06-10 01:40:20 drhok
130. Other test performed on any available platform:
2012-06-10 01:40:20 drhok
130b. th3make test.rc -DHAVE_LOCALTIME_R
2012-06-10 01:14:29 drhok
140a. Checked in latest SQLite amalgamation
2012-06-10 01:14:29 drhok
140b. No compiler warnings
2012-06-10 01:12:34 drhpending
130b. th3make test.rc -DHAVE_LOCALTIME_R
2012-06-09 20:28:57 danok
300b. tclsh th3make test.rc (on unix)
2012-06-09 20:04:57 danok
300c. tclsh th3make cov.rc
2012-06-09 19:32:12 danpending
300b. tclsh th3make test.rc (on unix)
2012-06-09 19:32:12 danpending
300c. tclsh th3make cov.rc
2012-06-09 19:32:12 danpending
300d. tclsh th3make min.rc -norun; valgrind ./th3
2012-06-09 19:28:46 danok
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.
When running "make test", there are errors in superlock-6.6 and zerodamage-3.1. Both are benign.
2012-06-09 19:27:02 danok
300f. make test (on unix)
hook-7.5.2.1 and hook-7.5.2.2 still fail. As expected.
2012-06-09 19:11:14 danok
290a. Linux
2012-06-09 19:11:14 danok
290b. Mac
2012-06-09 19:08:50 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-06-09 19:04:52 danok
230c. Works on Mac
2012-06-09 19:04:52 danok
240b. Mac
2012-06-09 19:01:19 danok
130b. th3make test.rc -DHAVE_LOCALTIME_R
x86 linux
2012-06-09 19:00:55 danok
40a. tclsh ../tool/omittest.tcl -skip_run
SQLITE_ENABLE_LOCKING_STYLE only works on osx.
2012-06-09 18:59:41 danok
230a. Builds
2012-06-09 18:59:41 danok
230b. Works on Linux
2012-06-09 18:59:41 danok
240a. Linux
2012-06-09 18:52:21 danok
150d. Verify that the --disable-amalgamation option to configure works.
2012-06-09 18:52:21 danok
150f. Works on Mac
2012-06-09 18:38:21 danok
150c. Verify the correct version numbers have been installed.
2012-06-09 18:34:44 danok
210d. th3make zipvfs.rc min.rc; valgrind ./th3
2012-06-09 11:50:04 drhok
200b. see-aes128-ofb.c
2012-06-09 11:50:04 drhok
200j. At least one of the above on Windows
2012-06-09 03:00:26 drhok
200a. see.c
2012-06-09 03:00:26 drhok
200g. At least one of the above using memdebug.rc
2012-06-09 03:00:26 drhok
200h. At least one of the above on Linux
2012-06-09 02:59:26 drhok
130c. th3make test.rc -DSQLITE_THREADSAFE=0
2012-06-09 02:59:26 drhok
130e. th3make test.rc -DSQLITE_MAX_ATTACHED=62
2012-06-09 02:58:54 drhok
100. Tests for platform Android:
2012-06-09 02:58:54 drhok
100a. th3make -Os min.rc
2012-06-09 00:20:36 mistachkinok
320. System.Data.SQLite builds and checks out using the SQLite core
netfx40, debug, release, netCF
2012-06-08 18:27:45 danok
210e. At least one of the above on Linux
2012-06-08 18:26:56 danok
210c. th3make zipvfs.rc memdebug.rc
2012-06-08 18:26:56 danok
210f. At least one of the above on Mac
2012-06-08 18:25:58 danok
70b. tclsh fulltest.tcl fast.rc test.rc
2012-06-08 18:25:22 danok
60b. tclsh releasetest.tcl
2012-06-08 17:58:10 drhok
260b. linux x64
2012-06-08 17:58:10 drhok
260c. mac leopard
2012-06-08 17:57:26 drhpending
130c. th3make test.rc -DSQLITE_THREADSAFE=0
2012-06-08 17:57:26 drhpending
200a. see.c
2012-06-08 17:57:26 drhpending
200g. At least one of the above using memdebug.rc
2012-06-08 17:47:03 drhpending
130e. th3make test.rc -DSQLITE_MAX_ATTACHED=62
2012-06-08 17:45:34 drhok
90. Tests for platform Win32/64:
2012-06-08 17:45:34 drhok
90b. th3make test.rc
2012-06-08 17:45:34 drhok
90d. At least one of the above using MinGW
2012-06-08 17:45:17 drhpending
100a. th3make -Os min.rc
2012-06-08 16:52:09 drhok
30. Source code change review. "fossil diff --from release --to trunk"
2012-06-08 16:52:09 drhok
30a. No stray changes
2012-06-08 16:52:09 drhok
30b. All significant changes are mentioned in the "changes" log of the documentation
2012-06-08 16:52:09 drhok
30c. New code complies with style guidelines
2012-06-08 16:52:09 drhok
30d. New code complies with design rules
2012-06-08 16:52:09 drhok
30e. Comments have been updated to reflect code changes
2012-06-08 16:52:09 drhok
30f. Variables and functions have been renamed to reflect changes in their use
2012-06-08 16:52:09 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-06-08 16:34:46 drhok
10b. Mac GCC -Wall -Wextra (the tool/warnings.sh script)
2012-06-08 16:25:23 drhok
90c. th3make fast.rc
2012-06-08 16:25:23 drhok
90f. At least one of the above using MSVC-64
2012-06-08 16:17:58 drhok
170. Fossil updated to use the latest SQLite.
2012-06-08 16:17:58 drhok
170a. No compiler warnings
2012-06-08 16:17:58 drhok
170b. Used on active websites with no issues
2012-06-08 16:17:58 drhok
180. Firefox recompiled using lastest SQLite.
2012-06-08 16:17:58 drhok
180a. No SQLite compiler warnings
2012-06-08 16:17:58 drhok
180b. Active use with no issues noted
2012-06-08 16:14:59 drhok
10a. Linux GCC -Wall -Wextra (the tool/warnings.sh script)
2012-06-08 15:59:49 danok
210a. testfixture ../zipvfs/test/zipvfs.test (See test/README.txt in the ZIPVFS source tree for details.)
2012-06-08 15:56:15 drhok
10e. Windows MSVC Win64 /W3
2012-06-08 15:56:02 drhok
130d. th3make test.rc -ftrapv
2012-06-08 15:53:42 drhpending
90c. th3make fast.rc
2012-06-08 15:51:30 danpending
210c. th3make zipvfs.rc memdebug.rc
2012-06-08 15:51:30 danpending
210f. At least one of the above on Mac
2012-06-08 15:47:09 danpending
210d. th3make zipvfs.rc min.rc; valgrind ./th3
2012-06-08 15:45:18 danpending
210a. testfixture ../zipvfs/test/zipvfs.test (See test/README.txt in the ZIPVFS source tree for details.)
2012-06-08 15:45:18 danpending
210e. At least one of the above on Linux
2012-06-08 15:33:06 danok
70a. tclsh releasetest.tcl
2012-06-08 15:24:41 drhok
10d. Windows MSVC Win32 /W3
2012-06-08 15:24:24 drhpending
90b. th3make test.rc
2012-06-08 15:23:26 drhpending
130d. th3make test.rc -ftrapv
2012-06-08 15:23:09 drhok
90a. make test
2012-06-08 15:23:09 drhok
90e. At least one of the above using MSVC-32
2012-06-08 15:14:19 danprelim
10c. OpenBSD GCC using options -Wall
No errors appart from porter-stemmer with "gcc -DSQLITE_ENABLE_FTS3 -DSQLITE_ENABLE_RTREE -Wall -Wextra -c sqlite3.c"
2012-06-08 15:14:05 dan
10c. OpenBSD GCC using options -Wall
No errors appart from porter-stemmer with "gcc -DSQLITE_ENABLE_FTS3 -DSQLITE_ENABLE_RTREE -Wall -Wextra -c sqlite3.c"
2012-06-08 15:11:53 danok
290c. OpenBSD
2012-06-08 15:10:30 danok
110. Tests for platform OpenBSD x86:
2012-06-08 15:10:30 danok
150g. Works on OpenBSD
2012-06-08 14:59:14 drhok
130a. th3make alignment2.rc test.rc
2012-06-08 14:19:53 drhpending
90a. make test
2012-06-08 14:15:48 drhpending
130a. th3make alignment2.rc test.rc
2012-06-08 14:03:22 danok
50a. tclsh releasetest.tcl
2012-06-08 13:39:36 drhok
50d. tclsh th3make fast-ex.rc
2012-06-08 12:10:26 danok
110b. th3make -Os min.rc
2012-06-08 11:52:32 danpending
60b. tclsh releasetest.tcl
2012-06-08 11:40:16 danok
110a. make test
2012-06-08 11:39:52 danok
70c. tclsh th3make test.rc CC=clang
2012-06-08 11:04:58 danpending
110a. make test
2012-06-08 11:04:58 danpending
110b. th3make -Os min.rc
2012-06-08 10:12:06 drhok
60c. tclsh fulltest.tcl fast.rc test.rc
2012-06-08 10:07:59 drhok
60e. tclsh th3make test-ex.rc
2012-06-08 10:06:00 danpending
70c. tclsh th3make test.rc CC=clang
2012-06-08 10:04:09 danpending
70b. tclsh fulltest.tcl fast.rc test.rc
2012-06-08 10:00:22 danpending
70a. tclsh releasetest.tcl
2012-06-08 02:48:39 drhpending
50d. tclsh th3make fast-ex.rc
2012-06-08 02:48:39 drhpending
60e. tclsh th3make test-ex.rc
2012-06-08 02:46:11 drhok
50c. tclsh fulltest.tcl fast.rc test.rc
2012-06-08 02:46:11 drhok
50f. At least one of the above using GCC 4.4.1
2012-06-08 00:03:30 drhok
130f. th3make min.rc -Os; valgrind ./th3
2012-06-07 22:18:21 drhpending
130f. th3make min.rc -Os; valgrind ./th3
2012-06-07 22:16:53 drhok
60d. tclsh th3make memdebug.rc
2012-06-07 22:16:35 drhok
50b. tclsh th3make cov.rc (verify 100% branch test coverage)
2012-06-07 22:16:35 drhok
50e. At least one of the above using GCC 4.1.0
2012-06-07 20:39:17 drhok
150a. Make sure that autoconf has been run to update the configure script.
2012-06-07 20:39:17 drhok
150b. Run "make test" to verify that the build works.
2012-06-07 20:39:17 drhok
150e. Works on Linux
2012-06-07 20:26:43 drhok
160. Exported symbol checks: tool/symbols.sh
2012-06-07 20:26:43 drhok
160c. No private symbols exported in MinGW (check using tool/symbols-mingw.sh)
2012-06-07 20:26:43 drhok
160d. No undesirable library dependencies on MinGW
2012-06-07 20:21:22 drhok
160a. No private symbols exported. (This is also checked by releasetest.tcl)
2012-06-07 20:21:22 drhok
160b. No undesirable library dependencies
2012-06-07 20:19:55 drhpending
60d. tclsh th3make memdebug.rc
2012-06-07 20:19:39 drhpending
50b. tclsh th3make cov.rc (verify 100% branch test coverage)
2012-06-07 20:19:39 drhpending
50e. At least one of the above using GCC 4.1.0
2012-06-07 20:18:26 drhok
250. Run performance tests comparing the new SQLite release against the previous version. Verify no performance regressions.
2012-06-07 20:18:26 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-06-07 20:09:38 drhok
250a. The TCL speed*.test scripts
2012-06-07 20:06:49 danok
130g. valgrind testfixture permutations.test valgrind
x86 linux
2012-06-07 20:06:43 drhok
250b. The TH3 speed tests
2012-06-07 20:03:06 drhok
60a. tclsh th3make cov.rc (verify 100% branch test coverage)
2012-06-07 19:06:41 drhok
120. Tests for platform Solaris Sparc:
2012-06-07 19:06:41 drhok
120c. th3make fast.rc
2012-06-07 18:56:44 drhprelim
170. Fossil updated to use the latest SQLite.
2012-06-07 18:56:44 drhprelim
170a. No compiler warnings
2012-06-07 18:56:44 drhprelim
170b. Used on active websites with no issues
2012-06-07 18:56:44 drhprelim
180. Firefox recompiled using lastest SQLite.
2012-06-07 18:56:44 drhprelim
180a. No SQLite compiler warnings
2012-06-07 18:56:44 drhprelim
180b. Active use with no issues noted
2012-06-07 18:09:50 drhfail
60a. tclsh th3make cov.rc (verify 100% branch test coverage)
Two branches untested due to recent changes. Working on adding new tests for coverage now.
2012-06-07 18:08:47 drhpending
120c. th3make fast.rc
2012-06-07 18:08:34 drhok
120b. th3make test.rc
2012-06-07 17:43:08 drhpending
50c. tclsh fulltest.tcl fast.rc test.rc
2012-06-07 17:43:08 drhpending
50f. At least one of the above using GCC 4.4.1
2012-06-07 17:42:15 drhpending
120b. th3make test.rc
2012-06-07 17:41:59 drhok
120a. make test
2012-06-07 17:41:27 drhprelim
10f. sh tool/warnings-clang.sh
2012-06-07 17:41:13 drhprelim
10b. Mac GCC -Wall -Wextra (the tool/warnings.sh script)
2012-06-07 17:37:48 prelim
10a. Linux GCC -Wall -Wextra (the tool/warnings.sh script)
2012-06-07 17:22:18 drhok
10a. Linux GCC -Wall -Wextra (the tool/warnings.sh script)
2012-06-07 16:24:30 danpending
130g. valgrind testfixture permutations.test valgrind
2012-06-07 16:21:51 danpending
50a. tclsh releasetest.tcl