SQLite

Checklist For SQLite 3.8.7.2
Login
2014-11-18 22:47:44 drhok
130. Other test performed on any available platform:
2014-11-18 20:56:34 drhok
80. Tests for platform Mac OS-X x86:
2014-11-18 20:56:31 drhok
80a. tclsh releasetest.tcl
One error when autovacuum_crash gave a different error from what was expected. Deemed pass.
2014-11-18 20:52:39 drhok
130j. valgrind testfixture permutations.test valgrind
0 errors out of 162530 tests
2014-11-18 19:40:41 drhok
10. Compiler warning checks.
2014-11-18 19:40:38 drhok
10b. Mac GCC -Wall -Wextra (the tool/warnings.sh script)
2014-11-18 19:35:27 drhok
240. Run performance tests comparing the new SQLite release against the previous release.
2014-11-18 19:35:22 drhok
240a. The speedtest1 program
26.580 billion cycles on 3.8.7.2 versus 26.587 billion cycles on 3.8.7.1.
2014-11-18 19:15:16 drhok
10f. sh tool/warnings-clang.sh
2014-11-18 19:04:42 drhok
210. ZIPVFS tests:
2014-11-18 19:04:39 drhok
210a. testfixture ../zipvfs/test/zipvfs.test (See test/README.txt in the ZIPVFS source tree for details.)
0 errors out of 46811 tests
2014-11-18 18:59:49 drhpending
210a. testfixture ../zipvfs/test/zipvfs.test (See test/README.txt in the ZIPVFS source tree for details.)
2014-11-18 18:53:42 drhok
150. Build using the configure/make in main source tree.
2014-11-18 18:53:40 drhok
150c. Verify the correct version numbers have been installed.
2014-11-18 18:53:38 drhok
150d. Verify that the --disable-amalgamation option to configure works.
2014-11-18 18:52:15 drhok
130a. th3make alignment2.rc test.rc
0 errors out of 5490182 tests in 1261.280 seconds
2014-11-18 18:30:30 drhpending
130a. th3make alignment2.rc test.rc
2014-11-18 18:29:59 drhok
130c. th3make test.rc -DSQLITE_THREADSAFE=0
0 errors out of 7596661 tests in 1261.221 seconds
2014-11-18 18:29:44 drhok
130e. OPTS=-DSQLITE_SMALL_STACK make sqlite3.c; th3make quick.rc -DSQLITE_SMALL_STACK
0 errors out of 1483995 tests in 212.321 seconds
2014-11-18 18:25:33 drhpending
130e. OPTS=-DSQLITE_SMALL_STACK make sqlite3.c; th3make quick.rc -DSQLITE_SMALL_STACK
2014-11-18 18:24:08 drhpending
130j. valgrind testfixture permutations.test valgrind
2014-11-18 18:23:14 drhok
130d. th3make test.rc -ftrapv
0 errors out of 7653382 tests in 2148.193 seconds
2014-11-18 18:22:03 drhok
130i. th3make quick.rc -DSQLITE_ENABLE_STAT4 -valgrind
0 errors out of 1561276 tests in 8627.276 seconds
2014-11-18 18:21:42 drhok
130n. th3make quick.rc -DSQLITE_ENABLE_MEMSYS5 -DTH3_LOWMEM
0 errors out of 1407953 tests in 696.093 seconds. Win7
2014-11-18 18:21:05 drhok
130o. th3make quick.rc -DSQLITE_ENABLE_RTREE -DSQLITE_ENABLE_FTS4
0 errors out of 1519991 tests in 352.335 seconds. win8
2014-11-18 18:07:01 drhpending
130c. th3make test.rc -DSQLITE_THREADSAFE=0
2014-11-18 18:06:44 drhok
130b. th3make quick.rc -DHAVE_LOCALTIME_R
0 errors out of 1478491 tests in 164.930 seconds
2014-11-18 18:06:15 drhok
20. Documentation checks:
2014-11-18 18:06:13 drhok
20g. Check new/changed documentation for spelling and gramatical mistakes
2014-11-18 18:05:08 drhpending
130o. th3make quick.rc -DSQLITE_ENABLE_RTREE -DSQLITE_ENABLE_FTS4
2014-11-18 18:04:30 drhpending
130n. th3make quick.rc -DSQLITE_ENABLE_MEMSYS5 -DTH3_LOWMEM
2014-11-18 18:03:59 drhok
130k. th3make quick.rc -DSQLITE_TRACE_SIZE_LIMIT=15
0 errors out of 1490282 tests in 723.360 seconds, win7
2014-11-18 18:02:38 drhok
130f. th3make test.rc CC=clang -fsanitize=undefined
0 errors out of 7653752 tests in 5666.729 seconds
2014-11-18 18:02:07 drhpending
130b. th3make quick.rc -DHAVE_LOCALTIME_R
2014-11-18 18:00:54 drhok
20f. The compile-time options are all up-to-date (compile.html)
2014-11-18 18:00:52 drhok
20e. Requirements marks are up-to-date in both documentation and source code
2014-11-18 18:00:36 drhok
20d. No unresolved hyperlinks in the documentation build
2014-11-18 18:00:33 drhok
20c. Release accouncement in news.html
2014-11-18 17:53:37 drhok
10d. Windows MSVC Win32 /W3
2014-11-18 17:52:39 drhok
130g. th3make quick.rc -DSQLITE_MAX_ATTACHED=125
0 errors out of 1490258 tests in 298.481 seconds, win8
2014-11-18 17:51:17 drhok
40. OMIT, ENABLE, and DISABLE options:
2014-11-18 17:51:14 drhok
40a. tclsh ../tool/omittest.tcl -skip_run -target libsqlite3.a
2014-11-18 17:44:53 drhok
150e. Works on Linux
2014-11-18 17:44:49 drhok
150b. Run "make test" to verify that the build works.
2014-11-18 17:44:16 drhpending
130d. th3make test.rc -ftrapv
2014-11-18 17:43:25 drhpending
130g. th3make quick.rc -DSQLITE_MAX_ATTACHED=125
2014-11-18 17:42:41 drhpending
130k. th3make quick.rc -DSQLITE_TRACE_SIZE_LIMIT=15
2014-11-18 17:42:01 drhpending
40a. tclsh ../tool/omittest.tcl -skip_run -target libsqlite3.a
2014-11-18 17:40:32 drhok
50. Tests for platform Linux x86_64:
2014-11-18 17:40:29 drhok
50d. tclsh releasetest.tcl
2014-11-18 17:37:41 drhok
90. Tests for platform Win32/64:
2014-11-18 17:37:37 drhok
90e. th3make msvc.rc test.rc /RTC1
8 errors out of 5816308 tests. All errors on req1_malloc02.31? as described above.
2014-11-18 17:36:41 drhok
130l. th3make quick.rc -funsigned-char
o errors out of 1490263 tests in 724.494 seconds, win7
2014-11-18 17:36:10 drhok
130r. ./configure; make fulltest
0 errors out of 2538349 tests
2014-11-18 16:57:45 drhok
150a. Make sure that autoconf has been run to update the configure script.
2014-11-18 16:57:26 drhpending
130l. th3make quick.rc -funsigned-char
2014-11-18 16:56:49 drhok
130p. th3make quick.rc -DSQLITE_TEST_REALLOC_STRESS
0 errors out of 1825349 tests in 934.988 seconds. Win7.
2014-11-18 16:34:42 drhpending
130r. ./configure; make fulltest
2014-11-18 16:33:58 drhpending
90e. th3make msvc.rc test.rc /RTC1
2014-11-18 16:32:32 drhok
90b. th3make test.rc
8 errors out of 5816328 tests in 2131.564 seconds. All errors are req1_malloc02.311 and 312 and result from the fact that the memory allocator used gives exact-size allocations. This is a testing problem, not a problem in the code.
2014-11-18 16:30:17 drhok
140. Sqllogictest:
2014-11-18 16:30:13 drhok
140c. run-all.sh with no errors
2014-11-18 16:24:10 drhpending
130p. th3make quick.rc -DSQLITE_TEST_REALLOC_STRESS
2014-11-18 16:23:46 drhok
130m. th3make quick.rc -fsigned-char
0 errors out of 1490263 tests in 724.783 seconds, win7
2014-11-18 16:22:42 drhpending
130f. th3make test.rc CC=clang -fsanitize=undefined
2014-11-18 16:21:51 drhok
130q. th3make test.rc ../th3private/*.test
0 errors out of 668 tests in 8.184 seconds
2014-11-18 16:16:00 drhok
220. NX-Devkit compiles and runs "tclsh th3make test.rc nx_compress.o" without error.
0 errors out of 6686754 tests in 1202.551 seconds
2014-11-18 16:13:40 drhpending
140c. run-all.sh with no errors
2014-11-18 16:13:19 drhok
140b. No compiler warnings
2014-11-18 16:13:04 drhok
140a. Checked in latest SQLite amalgamation
2014-11-18 16:04:16 drhok
120. Tests for platform Solaris Sparc:
2014-11-18 16:04:13 drhok
120a. th3make fast.rc
0 errors out of 7451741 tests in 6846.098 seconds
2014-11-18 16:01:26 drhpending
130m. th3make quick.rc -fsigned-char
2014-11-18 15:58:58 drhok
270. Build and verify correct operation of sqlite3_analyzer on:
2014-11-18 15:58:55 drhok
270c. Win32
2014-11-18 15:58:24 drhpending
130i. th3make quick.rc -DSQLITE_ENABLE_STAT4 -valgrind
2014-11-18 15:56:19 drhok
130h. th3make quick.rc -valgrind
0 errors out of 1478386 tests in 6558.690 seconds, no valgrind errors or warnings.
2014-11-18 15:54:39 drhpending
220. NX-Devkit compiles and runs "tclsh th3make test.rc nx_compress.o" without error.
2014-11-18 15:54:04 drhok
210b. th3make zipvfs.rc test.rc
0 errors out of 8032407 tests in 1794.877 seconds
2014-11-18 15:52:56 drhok
90c. th3make fast.rc
0 errors out of 5865122 tests in 3115.144 seconds. Win7, mingw
2014-11-18 15:50:10 danok
60. Tests for 32-bit x86 Linux
2014-11-18 15:50:01 danok
100. Tests for platform Android:
2014-11-18 15:49:56 danok
100a. th3make quick.rc
/th3: 0 errors out of 1483122 tests in 2077.019 seconds
2014-11-18 15:49:28 danok
80b. tclsh fulltest.tcl min.rc
FINISHED (22:46:34) with 0 errors out of 7344362 tests in 2749.720 seconds
2014-11-18 15:32:52 danok
80c. tclsh th3make fast.rc CC=clang
./th3: 0 errors out of 5842266 tests in 1776.524 seconds
2014-11-18 15:14:52 drhpending
210b. th3make zipvfs.rc test.rc
2014-11-18 15:14:22 drhok
200. SEE tests using TH3:
2014-11-18 15:14:19 drhok
200a. see.c
0 errors out of 1460760 tests in 202.588 seconds
2014-11-18 15:13:55 danok
60c. tclsh th3make quick.rc -m32
./th3: 0 errors out of 1483198 tests in 700.147 seconds
2014-11-18 15:13:28 danpending
80b. tclsh fulltest.tcl min.rc
2014-11-18 15:09:43 drhpending
200a. see.c
2014-11-18 15:08:54 drhok
160. Exported symbol checks: tool/symbols.sh
2014-11-18 15:08:51 drhok
160d. No undesirable library dependencies on MinGW
2014-11-18 15:08:49 drhok
160c. No private symbols exported in MinGW (check using tool/symbols-mingw.sh)
2014-11-18 15:07:37 drhok
60b. tclsh th3make test.rc CC=clang -m32
0 errors out of 7653671 tests in 1772.588 seconds
2014-11-18 15:07:07 drhok
110. Tests for platform OpenBSD x86:
2014-11-18 15:07:03 drhok
110a. make test
1 errors out of 137146 tests Failures on these tests: percentile-2.1.50. This is due to roundoff error in floating point computations and is acceptable.
2014-11-18 15:06:14 drhok
70. Tests for platform Linux ARM (BeagleBoard)
2014-11-18 15:06:11 drhok
70a. tclsh th3make min.rc
0 errors out of 1404247 tests in 3238.482 seconds
2014-11-18 15:05:49 drhpending
90b. th3make test.rc
2014-11-18 15:03:10 drhok
90d. Verify that EXEs and DLLs generated using MSVC contain the correct version number, product name, description, and copyright as resources.
2014-11-18 15:00:36 danpending
80c. tclsh th3make fast.rc CC=clang
2014-11-18 14:56:42 danpending
60c. tclsh th3make quick.rc -m32
2014-11-18 14:56:36 drhok
90f. nmake /f makefile.msc DEBUG=2 test
0 errors out of 164096 tests. Win8, msvc64
2014-11-18 14:56:09 danpending
60b. tclsh th3make test.rc CC=clang -m32
2014-11-18 14:54:29 danok
230. Amalgamation autoconf tarball.
2014-11-18 14:54:29 danok
230c. Works on Mac
2014-11-18 14:48:30 danok
230b. Works on Linux
2014-11-18 14:46:50 drhok
190. CEROD tests in the test/ subdirectory.
2014-11-18 14:36:38 drhpending
90f. nmake /f makefile.msc DEBUG=2 test
2014-11-18 14:35:47 drhok
90a. make fulltestonly
0 errors out of 1167140 tests. Win8, msvc64.
2014-11-18 14:34:49 drhok
10c. OpenBSD GCC using options -Wall
Complaints about strcpy(), strcat(), and sprintf() (used in test code and in the amatch extension). Will fix on the next release.
2014-11-18 14:33:59 danok
230a. Builds
2014-11-18 14:32:58 danpending
100a. th3make quick.rc
2014-11-18 14:32:21 drhpending
110a. make test
2014-11-18 14:32:00 drhok
260. Verify that the amalgamation builds are byte-for-byte identical on all workstation platforms.
2014-11-18 14:31:57 drhok
260c. openbsd
687a18970c4a420f98ee138b93e99bdaacadf525 sqlite3.c 10594b50adadce48993530aad6ab5410e98b576f sqlite3.h
2014-11-18 14:29:44 drhpending
90c. th3make fast.rc
2014-11-18 14:27:19 drhok
60a. tclsh th3make test.rc -m32
0 errors out of 7653290 tests in 1558.920 seconds
2014-11-18 14:14:49 drhok
260d. windows native mingw
687a18970c4a420f98ee138b93e99bdaacadf525 sqlite3.c 687a18970c4a420f98ee138b93e99bdaacadf525 sqlite3.c
2014-11-18 14:10:24 drhok
250. Run "make wordcount; bash run-wordcount.bash $OPTIONS" with options:
2014-11-18 14:10:21 drhok
250b. bash run-wordcount.sh sqlite3.c --cachesize 5 --nosync
2014-11-18 14:09:06 drhok
250a. bash run-wordcount.sh sqlite3.c
2014-11-18 14:07:43 drhpending
80a. tclsh releasetest.tcl
2014-11-18 14:07:08 drhpending
70a. tclsh th3make min.rc
2014-11-18 14:06:16 drhpending
130h. th3make quick.rc -valgrind
2014-11-18 14:05:48 drhok
50f. tclsh th3make memdebug.rc
0 errors out of 7625573 tests in 3454.573 seconds
2014-11-18 14:05:12 drhok
180. Firefox recompiled using lastest SQLite.
Tested by Ben Turner on Mozilla's test servers.
2014-11-18 14:05:12 drhok
180a. No SQLite compiler warnings
Tested by Ben Turner on Mozilla's test servers.
2014-11-18 14:05:12 drhok
180b. Active use with no issues noted
Tested by Ben Turner on Mozilla's test servers.
2014-11-18 14:03:35 drhok
270b. Mac
2014-11-18 14:02:56 drhpending
120a. th3make fast.rc
2014-11-18 14:01:36 drhok
260f. sparc solaris using autoconf
687a18970c4a420f98ee138b93e99bdaacadf525 sqlite3.c 10594b50adadce48993530aad6ab5410e98b576f sqlite3.h
2014-11-18 13:59:57 drhok
170. Fossil updated to use the latest SQLite.
2014-11-18 13:59:57 drhok
170a. No compiler warnings
2014-11-18 13:59:57 drhok
170b. Used on active websites with no issues
2014-11-18 13:57:54 drhpending
60a. tclsh th3make test.rc -m32
2014-11-18 13:56:11 drhok
50i. tclsh th3make fast.rc CC=clang
0 errors out of 7446377 tests in 730.726 seconds
2014-11-18 13:47:52 drhok
270a. Linux
2014-11-18 13:47:11 drhok
280. 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. s
2014-11-18 13:45:57 drhok
160b. No undesirable library dependencies
2014-11-18 13:45:54 drhok
160a. No private symbols exported. (This is also checked by releasetest.tcl)
2014-11-18 13:45:05 drhpending
90a. make fulltestonly
2014-11-18 13:44:51 drhok
50k. ./mptester x.db mptest/multiwrite01.test
0 errors in 76 tests
2014-11-18 13:44:29 drhok
50j. ./mptester x.db mptest/crash01.test
0 errors in 94 tests
2014-11-18 13:43:31 drhpending
50i. tclsh th3make fast.rc CC=clang
bella
2014-11-18 13:43:22 drhpending
50f. tclsh th3make memdebug.rc
bella
2014-11-18 13:43:13 drhpending
50d. tclsh releasetest.tcl
tallis
2014-11-18 13:41:50 drhok
50h. tclsh th3make test.rc CC=clang
0 errors out of 7653335 tests in 1609.319 seconds
2014-11-18 13:40:55 drhok
260e. windows nmake
687a18970c4a420f98ee138b93e99bdaacadf525 sqlite3.c 10594b50adadce48993530aad6ab5410e98b576f sqlite3.h
2014-11-18 13:37:36 drhok
20b. Release announcement in changes.in
2014-11-18 13:37:32 drhok
20a. Latest release on the index.html page
2014-11-18 13:36:49 drhok
10e. Windows MSVC Win64 /W3
2014-11-18 13:36:08 drhok
260a. linux
687a18970c4a420f98ee138b93e99bdaacadf525 sqlite3.c 10594b50adadce48993530aad6ab5410e98b576f sqlite3.h
2014-11-18 13:34:01 drhok
10a. Linux GCC -Wall -Wextra (the tool/warnings.sh script)
The usual false-positives with -O3. No warnings with -O0
2014-11-18 13:33:40 drhok
260b. mac
687a18970c4a420f98ee138b93e99bdaacadf525 sqlite3.c 10594b50adadce48993530aad6ab5410e98b576f sqlite3.h
2014-11-18 13:30:55 drhok
30. Source code change review. "fossil diff --from version-3.8.7.1 --to branch-3.8.7"
2014-11-18 13:30:52 drhok
30j. Verify that the list of APIs exposed via the extension header is up-to-date (sqlite3ext.h)
2014-11-18 13:30:49 drhok
30i. Verify that source code contains no tabs and that surplus whitespace has been removed.
2014-11-18 13:30:23 drhok
30h. 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]*(/
2014-11-18 13:30:19 drhok
30g. Check all calls to sqlite3OsRead() and sqlite3OsWrite() to ensure that offset computations are 64-bit clean.
2014-11-18 13:30:17 drhok
30f. Variables and functions have been renamed to reflect changes in their use
2014-11-18 13:30:14 drhok
30e. Comments have been updated to reflect code changes
2014-11-18 13:30:11 drhok
30d. New code complies with design rules
2014-11-18 13:30:07 drhok
30c. New code complies with style guidelines
2014-11-18 13:30:05 drhok
30b. All significant changes are mentioned in the "changes" log of the documentation
2014-11-18 13:14:09 drhok
50c. tclsh th3make cov.rc -DSQLITE_ENABLE_STAT4 (verify 100% branch test coverage)
0 errors out of 1477648 tests in 239.155 seconds, 100% branch coverage.
2014-11-18 13:07:14 drhok
30a. No stray changes
2014-11-18 13:03:45 drhok
50b. tclsh th3make cov.rc -DHAVE_MALLOC_H -DHAVE_MALLOC_USABLE_SIZE (verify 100% branch test coverage)
0 errors out of 1398026 tests in 193.274 seconds, 100% branch coverage.
2014-11-18 13:03:03 drhok
50a. tclsh th3make cov.rc (verify 100% branch test coverage)
0 errors out of 1400669 tests in 196.605 seconds, 100% branch coverage.
2014-11-18 12:30:58 drhok+
50g. tclsh th3make test-ex.rc
16 errors out of 18054260 tests in 20353.558 seconds. All errors are in hlr10000.1.1 and have to do with the 4-term version number.
2014-11-18 12:30:22 drhok
50g. tclsh th3make test-ex.rc
2014-11-18 12:30:03 drhok
50e. tclsh fulltest.tcl fast.rc test.rc
0 errors out of 78632106 tests in 13025.857 seconds