SQLite

Checklist For SQLite 3.8.12
Login
2015-10-09 13:24:18 danok
80b. tclsh multitest.tcl --omit test-ex
passed, but -m32 tests not run
2015-10-09 13:23:56 danok
310c. tclsh th3make session.rc quick.rc -valgrind
2015-10-08 23:53:09 mistachkinok
110b. th3make msvc.rc winrt.rc min.rc - Windows Runtime 8.0 (x86)
df9ef61f1ba2e3a3420fae84e3eaa2e0e235bc28, 0 errors out of 1486053 tests in 703.698 seconds. 32-bit little-endian
2015-10-08 23:31:25 drhok
60b. Check the "multitest.tcl" log files for undetected errors.
2015-10-08 23:31:04 drhok
60a. tclsh multitest.tcl
0 failures on 31 th3make runs and 168765114 tests in (16:45:10) SQLite 3.8.12 2015-10-08 02:44:42 77b707b77496a08703fe9405e8e4521a4e5b419e
2015-10-08 23:11:06 mistachkinpending
110b. th3make msvc.rc winrt.rc min.rc - Windows Runtime 8.0 (x86)
2015-10-08 22:02:45 mistachkinok
330. System.Data.SQLite builds and checks out using the SQLite core.
df9ef61f1ba2e3a3420fae84e3eaa2e0e235bc28, Debug NetFx46 x86: 0 errors/492 tests, 681 seconds, Release NetFx46 x86: 0 errors/492 tests, 646 seconds, Debug NetFx46 x64: 0 errors/492 tests, 887 seconds, Release NetFx46 x64: 0 errors/492 tests, 883 seconds, 0 errors/24 tests (Debug NetCF20-ARM/NetCF35-ARM), 0 errors/24 tests (Release NetCF20-ARM/NetCF35-ARM)
2015-10-08 19:15:53 danok
310b. tclsh th3make session.rc test.rc (on Unix)
th3: 0 errors out of 7849442 tests in 2198.847 seconds. 64-bit little-endian th3: SQLite 3.8.12 2015-10-08 14:55:30 35b1b8d4b97715030700e37b292bb4f1bb3f44d6
2015-10-08 19:13:08 mistachkinpending
330. System.Data.SQLite builds and checks out using the SQLite core.
2015-10-08 18:46:59 danok
200f. At least one of the above on Linux.
2015-10-08 18:46:42 danok+
200e. th3make zipvfs.rc quick.rc
2015-10-08 18:45:36 danok
310f. testfixture test/session.test
0 errors out of 48505 tests
2015-10-08 18:44:43 danok
300b. Mac OS X
2015-10-08 18:39:50 danpending
310f. testfixture test/session.test
2015-10-08 18:39:07 danpending
310c. tclsh th3make session.rc quick.rc -valgrind
2015-10-08 18:38:47 danpending
310b. tclsh th3make session.rc test.rc (on Unix)
2015-10-08 18:36:37 danok+
310e. make test (on Unix)
0 errors out of 63764 tests
2015-10-08 18:36:29 danok
310e. make test (on Unix)
2015-10-08 17:21:56 danpending
310e. make test (on Unix)
2015-10-08 17:14:55 danok
280. 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.3 and 3.8.3. 0 errors out of 411 tests.
2015-10-08 17:12:33 danok
200c. th3make zipvfs.rc memdebug.rc
2015-10-08 16:46:19 danok
220. Amalgamation autoconf tarball.
2015-10-08 16:46:19 danok
230. TEA archive builds correctly and runs:
2015-10-08 16:46:19 danok
230b. Mac OS X
2015-10-08 16:43:41 danok
220c. Works on Mac OS X.
2015-10-08 16:03:39 danok
230a. Linux
2015-10-08 16:03:34 danok
220b. Works on Linux.
2015-10-08 16:01:57 drhok
40a. Linux GCC -Wall -Wextra (the "tool/warnings.sh" script)
2015-10-08 15:56:55 danok
220a. Builds.
2015-10-08 15:54:55 drhok
300f. A database containing WITHOUT ROWID tables.
2015-10-08 15:54:51 drhok
300a. Linux
2015-10-08 15:51:08 drhok
270e. Windows using NMAKE.
000247965fc7eeb7a05f9a4e81ac8f2cd7dfe928 sqlite3.c 59ba9051065d5d6b9b0641da48ee76207ea2e21b sqlite3.h
2015-10-08 15:38:31 drhok
240f. One or more of the above on Windows.
Using speedtest1: 1 year ago was about 9.9s. Current is about 9.3s. No measurable changes since the previous release.
2015-10-08 15:05:03 danok
200e. th3make zipvfs.rc quick.rc
2015-10-08 15:04:25 danok
200b. th3make zipvfs.rc test.rc
2015-10-08 15:03:37 danok
200a. testfixture ../zipvfs/test/zipvfs.test (See test/README.txt in the ZIPVFS source tree for details.)
0 errors out of 63764 tests (on Linux)
2015-10-08 14:22:33 danok
200d. th3make zipvfs.rc quick.rc -valgrind
2015-10-08 12:10:40 drhok
50. OMIT, ENABLE, and DISABLE options:
2015-10-08 12:10:36 drhok
50a. tclsh ../tool/omittest.tcl -skip_run -target libsqlite3.a
2015-10-08 11:39:43 drhok
40f. sh tool/warnings-clang.sh
false positives only.
2015-10-08 11:37:43 drhok
100b. tclsh multitest.tcl --omit test-ex
0 failures on 24 th3make runs and 109750356 tests in (10:48:54) SQLite 3.8.12 2015-10-07 17:06:17 13adcd038fc20dd1b6f344f79b449b4034f8f8f2, win8
2015-10-08 11:36:02 drhok
110a. th3make msvc.rc test.rc - Windows 7.0/8.x (x64)
th3: 0 errors out of 5965989 tests in 5754.805 seconds. 32-bit little-endian th3: SQLite 3.8.12 2015-10-07 17:06:17 13adcd038fc20dd1b6f344f79b449b4034f8f8f2, win7
2015-10-08 11:33:55 drhok
300c. Solaris (SPARC)
2015-10-08 11:33:07 drhok
270f. Solaris (SPARC) using autoconf.
000247965fc7eeb7a05f9a4e81ac8f2cd7dfe928 sqlite3.c 59ba9051065d5d6b9b0641da48ee76207ea2e21b sqlite3.h
2015-10-08 11:32:46 drhok
270a. Linux
000247965fc7eeb7a05f9a4e81ac8f2cd7dfe928 sqlite3.c 59ba9051065d5d6b9b0641da48ee76207ea2e21b sqlite3.h
2015-10-08 11:30:02 drhok
130. Tests for platform Solaris (SPARC):
2015-10-08 11:29:58 drhok
130b. tclsh multitest.tcl --only quick
0 failures on 7 th3make runs and 11402307 tests in (03:58:46) SQLite 3.8.12 2015-10-07 19:06:21 83dc1ff7fa010715ca7f406a572f4ee444a967d7
2015-10-08 09:40:46 danpending
200c. th3make zipvfs.rc memdebug.rc
on OSX
2015-10-08 09:38:05 danpending
200d. th3make zipvfs.rc quick.rc -valgrind
2015-10-08 09:37:16 danpending
200b. th3make zipvfs.rc test.rc
2015-10-08 09:27:16 danpending
200a. testfixture ../zipvfs/test/zipvfs.test (See test/README.txt in the ZIPVFS source tree for details.)
2015-10-08 09:24:17 danok+
120a. make test
0 errors out of 139294 tests
2015-10-08 09:24:07 danok
120. Tests for platform OpenBSD (x86):
2015-10-08 09:24:01 danok
120b. th3make quick.rc
th3: 0 errors out of 1570101 tests in 839.440 seconds. 32-bit little-endian th3: SQLite 3.8.12 2015-10-08 02:44:42 77b707b77496a08703fe9405e8e4521a4e5b419e
2015-10-08 09:23:37 danok
120a. make test
2015-10-08 09:23:00 danok
160. Build using the configure/make in main source tree.
2015-10-08 09:22:55 danok
160b. Verify the correct version numbers have been installed.
2015-10-08 09:19:36 danok
160a. Make sure that autoconf has been run to update the configure script.
2015-10-08 09:11:02 danok
60f. tclsh releasetest.tcl --platform Failure-Detection - all failures detected
errors reported for all configurations
2015-10-08 09:09:21 danpending
120b. th3make quick.rc
2015-10-08 09:09:13 danpending
120a. make test
2015-10-08 08:56:45 danpending
60a. tclsh multitest.tcl
2015-10-08 08:56:38 danpending
60f. tclsh releasetest.tcl --platform Failure-Detection - all failures detected
2015-10-08 08:47:45 danpending
80b. tclsh multitest.tcl --omit test-ex
2015-10-08 05:58:16 danok+
80a. tclsh releasetest.tcl
0 failures out of 4409620 tests in (05:36:27) SQLite 3.8.12 2015-10-07 16:14:18 d591e860d3d7c61637b4b07989bf176cb337db2c
2015-10-08 05:57:46 danok
80a. tclsh releasetest.tcl
SQLite 3.8.12 2015-10-07 16:14:18 d591e860d3d7c61637b4b07989bf176cb337db2c0 failures out of 4409620 tests in (05:36:27)
2015-10-08 02:46:56 drhok
130a. make test
0 errors out of 139730 tests
2015-10-08 02:23:24 drhok
140. JSON1
2015-10-08 02:23:18 drhok
140b. ./th3make cov.rc json/*.test -DTH3_JSON - manually review coverage
All branches covered.
2015-10-08 02:21:39 drhok
140a. ./th3make test.rc json/*.test -DTH3_JSON
th3: 0 errors out of 71513 tests in 2.907 seconds. 64-bit little-endian th3: SQLite 3.8.12 2015-10-07 17:06:17 13adcd038fc20dd1b6f344f79b449b4034f8f8f2
2015-10-08 02:21:03 drhok
140c. ./th3make quick.rc json/*.test -DTH3_JSON -valgrind
th3: 0 errors out of 29961 tests in 32.094 seconds. 64-bit little-endian th3: SQLite 3.8.12 2015-10-07 17:06:17 13adcd038fc20dd1b6f344f79b449b4034f8f8f2, and no valgrind warnings.
2015-10-08 01:16:00 drhpending
140c. ./th3make quick.rc json/*.test -DTH3_JSON -valgrind
2015-10-08 01:14:49 drhpending
110a. th3make msvc.rc test.rc - Windows 7.0/8.x (x64)
2015-10-08 01:12:23 drhpending
130b. tclsh multitest.tcl --only quick
2015-10-08 01:12:19 drhpending
130a. make test
2015-10-08 01:12:13 drhok
130d. Verify that Fossil repositories are cross-platform with x86/x64.
2015-10-08 01:12:11 drhok
130c. Recompile and test Fossil.
2015-10-08 00:51:56 drhok
250. Run make wordcount; bash run-wordcount.bash $OPTIONS with options:
2015-10-08 00:51:53 drhok
250b. bash run-wordcount.sh sqlite3.c --cachesize 5 --nosync
2015-10-08 00:50:42 drhok
250a. bash run-wordcount.sh sqlite3.c
2015-10-08 00:44:15 drhok
60g. sh tool/symbols.sh - no incorrect exports or dependencies
2015-10-08 00:42:26 drhok
60d. Check the "releasetest.tcl" log files for undetected errors.
2015-10-08 00:41:43 drhok
60c. tclsh releasetest.tcl
0 failures out of 9509899 tests in (08:10:51) SQLite 3.8.12 2015-10-07 13:24:27 f20f9f813f00cefcd427e506a09b0b973c782e3f
2015-10-08 00:16:40 drhok
150. Sqllogictest:
2015-10-08 00:16:35 drhok
150d. tclsh run-all.tcl - on windows
0 errors out of 11879758 tests and 1244 invocations in 3537 seconds, Win7
2015-10-07 21:40:30 drhok
150c. tclsh run-all.tcl - on unix
0 errors out of 11879758 tests and 1244 invocations in 1159 seconds
2015-10-07 21:03:38 drhpending
150c. tclsh run-all.tcl - on unix
2015-10-07 21:02:38 drhpending
150d. tclsh run-all.tcl - on windows
2015-10-07 21:02:32 drhok
150b. No SQLite compiler warnings.
2015-10-07 21:02:29 drhok
150a. Checked in latest SQLite amalgamation.
2015-10-07 20:52:37 drhok
100a. th3make msvc.rc test.rc /RTC1
th3: 0 errors out of 5966474 tests in 6287.078 seconds. 32-bit little-endian th3: SQLite 3.8.12 2015-10-07 17:06:17 13adcd038fc20dd1b6f344f79b449b4034f8f8f2, Win7
2015-10-07 18:47:01 drhpending
100b. tclsh multitest.tcl --omit test-ex
2015-10-07 18:45:04 drhok
20. Source code change review. fossil diff --from release --to trunk
2015-10-07 18:45:02 drhok
20k. Significant compile-time options are recognized by the sqlite3_compileoption_used() interface.
2015-10-07 18:44:55 drhok
20j. Verify that the list of APIs exposed via the extension header is up-to-date (sqlite3ext.h).
2015-10-07 18:44:52 drhok
20i. Verify that source code contains no tabs and that surplus whitespace has been removed.
2015-10-07 18:44:48 drhok
20h. Check all calls to memory allocation routines to ensure that size computations are 64-bit clean. Suggested regular expression for search: /(Re|M)alloc[FORZa-z]*(/
2015-10-07 18:44:44 drhok
20g. Check all calls to sqlite3OsRead() and sqlite3OsWrite() to ensure that offset computations are 64-bit clean.
2015-10-07 18:44:42 drhok
20f. Variables and functions have been renamed to reflect changes in their use.
2015-10-07 18:44:38 drhok
20e. Comments have been updated to reflect code changes.
2015-10-07 18:44:36 drhok
20d. New code complies with design rules.
2015-10-07 18:44:34 drhok
20c. New code complies with style guidelines.
2015-10-07 18:44:31 drhok
20b. All significant changes are mentioned in the "changes" log of the documentation.
2015-10-07 18:44:28 drhok
20a. No stray changes.
2015-10-07 18:07:55 drhok
300e. Windows (MSVC)
2015-10-07 18:01:30 drhok
190j. At least one of the above on Windows.
2015-10-07 18:01:23 drhok
190a. see.c
th3: 0 errors out of 1556799 tests in 559.706 seconds. 64-bit little-endian th3: SQLite 3.8.12 2015-10-07 17:06:17 13adcd038fc20dd1b6f344f79b449b4034f8f8f2, win8, msvc
2015-10-07 17:51:01 drhok
170. Fossil updated to use the latest SQLite.
2015-10-07 17:51:01 drhok
170a. No SQLite compiler warnings.
2015-10-07 17:51:01 drhok
170b. Used on active websites with no issues.
2015-10-07 17:31:54 danok
70. Tests for platform Linux ARM (BeagleBoard)
2015-10-07 17:31:45 danok
70b. Recompile and test Fossil.
2015-10-07 17:29:02 drhok
10. Test procedure review.
2015-10-07 17:29:00 drhok
10c. Review this checklist for completeness and accuracy.
2015-10-07 17:24:01 drhok
10b. Review "multitest.tcl" and "alignment*.rc" scripts in TH3 for completeness.
2015-10-07 17:21:57 drhok
10a. Review the "test/releasetest.tcl" script for completeness and accuracy.
2015-10-07 17:14:42 danok
70a. tclsh th3make min.rc
2015-10-07 17:07:37 drhok
100e. tclsh test/releasetest.tcl --msvc
0 failures out of 1793322 tests in (02:04:40) SQLite 3.8.12 2015-10-07 13:24:27 f20f9f813f00cefcd427e506a09b0b973c782e3f
2015-10-07 14:59:55 danpending
70a. tclsh th3make min.rc
2015-10-07 14:59:39 danok
70a. tclsh th3make min.rc