SQLite

Checklist For SQLite 3.8.7.1
Login
2014-10-29 13:56:36 danok
80. Tests for platform Mac OS-X x86:
2014-10-29 13:56:36 danok
80a. tclsh releasetest.tcl
2014-10-29 13:56:13 danpending
80. Tests for platform Mac OS-X x86:
2014-10-29 13:56:13 danpending++
80a. tclsh releasetest.tcl
2014-10-29 13:04:54 drhok
130. Other test performed on any available platform:
2014-10-29 13:04:43 drhok
130i. th3make quick.rc -DSQLITE_ENABLE_STAT4 -valgrind
0 errors out of 1533874 tests in 12921.007 seconds, no valgrind problems, tallis
2014-10-29 12:22:13 drhok
130h. th3make quick.rc -valgrind
0 errors out of 1450988 tests in 10914.446 seconds, no valgrind warnings or errors, tallis
2014-10-29 12:02:42 drhok
40. OMIT, ENABLE, and DISABLE options:
2014-10-29 12:02:39 drhok
40a. tclsh ../tool/omittest.tcl -skip_run -target libsqlite3.a
ENABLE_LOCKING_STYLE does not work on linux. All else is OK.
2014-10-29 12:02:01 drhok
220. NX-Devkit compiles and runs "tclsh th3make test.rc nx_compress.o" without error.
0 errors out of 6638143 tests in 1234.727 seconds, bella
2014-10-29 11:57:40 drhok
130j. th3make quick.rc -DHAVE_MALLOC_H -DHAVE_MALLOC_USABLE_SIZE -valgrind
0 errors out of 1451035 tests in 6974.914 seconds, no valgrind errors or warnings, bella.
2014-10-29 11:49:02 drhok
240. Run performance tests comparing the new SQLite release against the previous release.
2014-10-29 11:48:59 drhok
240a. The speedtest1 program
0.031% slower. 58 bytes larger
2014-10-29 11:45:01 drhok
140. Sqllogictest:
2014-10-29 11:44:58 drhok
140c. run-all.sh with no errors
2014-10-29 11:39:33 danok
130a. th3make alignment2.rc test.rc
requires that sqlite3.c be built with SQLITE_ENABLE_UPDATE_DELETE_LIMIT, ./th3: 0 errors out of 5443918 tests in 1224.700 seconds, ./th3: SQLite 3.8.7.1 2014-10-29 01:27:43 83afe23e553e802c0947c80d0ffdd120423e7c52
2014-10-29 11:38:57 danok
130e. OPTS=-DSQLITE_SMALL_STACK make sqlite3.c; th3make test.rc -DSQLITE_SMALL_STACK
./th3: 0 errors out of 7604127 tests in 1788.529 seconds, ./th3: SQLite 3.8.7.1 2014-10-29 01:27:43 83afe23e553e802c0947c80d0ffdd120423e7c52
2014-10-29 11:37:15 drhok
130q. th3make quick.rc -DSQLITE_TEST_REALLOC_STRESS
0 errors out of 1689786 tests in 739.008 seconds, iMac
2014-10-29 11:35:12 drhpending
220. NX-Devkit compiles and runs "tclsh th3make test.rc nx_compress.o" without error.
2014-10-29 11:34:19 drhok
190. CEROD tests in the test/ subdirectory.
2014-10-29 11:33:48 drhok
30. Source code change review. "fossil diff --from version-3.8.7 --to branch-3.8.7"
2014-10-29 11:33:45 drhok
30j. Verify that the list of APIs exposed via the extension header is up-to-date (sqlite3ext.h)
2014-10-29 11:33:42 drhok
30i. Verify that source code contains no tabs and that surplus whitespace has been removed.
2014-10-29 11:33:37 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-10-29 11:33:34 drhok
30g. Check all calls to sqlite3OsRead() and sqlite3OsWrite() to ensure that offset computations are 64-bit clean.
2014-10-29 11:33:30 drhok
30f. Variables and functions have been renamed to reflect changes in their use
2014-10-29 11:33:27 drhok
30e. Comments have been updated to reflect code changes
2014-10-29 11:33:22 drhok
30d. New code complies with design rules
2014-10-29 11:33:19 drhok
30c. New code complies with style guidelines
2014-10-29 11:33:17 drhok
30b. All significant changes are mentioned in the "changes" log of the documentation
2014-10-29 11:29:29 danok
130p. th3make quick.rc -DSQLITE_ENABLE_RTREE -DSQLITE_ENABLE_FTS4
./th3: 0 errors out of 1481812 tests in 206.512 seconds, ./th3: SQLite 3.8.7.1 2014-10-29 01:27:43 83afe23e553e802c0947c80d0ffdd120423e7c52
2014-10-29 11:28:50 danok
130o. th3make quick.rc -DSQLITE_ENABLE_MEMSYS5 -DTH3_LOWMEM
./th3: 0 errors out of 1382017 tests in 174.177 seconds, ./th3: SQLite 3.8.7.1 2014-10-29 01:27:43 83afe23e553e802c0947c80d0ffdd120423e7c52
2014-10-29 11:28:44 drhpending
140c. run-all.sh with no errors
2014-10-29 11:28:40 drhok
140b. No compiler warnings
2014-10-29 11:28:37 drhok
140a. Checked in latest SQLite amalgamation
2014-10-29 11:26:43 drhok
200. SEE tests using TH3:
2014-10-29 11:26:40 drhok
200a. see.c
quick.rc on bella. 0 errors out of 1435306 tests in 199.611 seconds
2014-10-29 11:25:35 drhok
20. Documentation checks:
2014-10-29 11:25:32 drhok
20g. Check new/changed documentation for spelling and gramatical mistakes
2014-10-29 11:23:03 drhpending
190. CEROD tests in the test/ subdirectory.
2014-10-29 11:22:03 drhpending
200a. see.c
2014-10-29 11:21:14 drhok
130d. th3make test.rc -ftrapv
0 errors out of 7591089 tests in 1744.290 seconds, bella
2014-10-29 11:20:34 drhok
130n. th3make quick.rc -fsigned-char
0 errors out of 1462773 tests in 702.517 seconds, mingw, win7.
2014-10-29 11:19:53 drhpending
130q. th3make quick.rc -DSQLITE_TEST_REALLOC_STRESS
2014-10-29 11:19:10 drhok
130r. th3make test.rc ../th3private/*.test
0 errors out of 454 tests in 23.591 seconds, iMac
2014-10-29 11:19:00 danpending
130p. th3make quick.rc -DSQLITE_ENABLE_RTREE -DSQLITE_ENABLE_FTS4
2014-10-29 11:18:40 drhok
130k. valgrind testfixture permutations.test valgrind
0 errors out of 96702 tests, no valgrind errors or warnings, bella
2014-10-29 11:18:14 danpending
130o. th3make quick.rc -DSQLITE_ENABLE_MEMSYS5 -DTH3_LOWMEM
2014-10-29 11:17:09 danok
130b. th3make test.rc -DHAVE_LOCALTIME_R
./th3: 0 errors out of 7591291 tests in 1854.328 seconds, ./th3: SQLite 3.8.7.1 2014-10-29 01:27:43 83afe23e553e802c0947c80d0ffdd120423e7c52
2014-10-29 11:16:24 drhok
130m. th3make quick.rc -funsigned-char
0 errors out of 1446959 tests in 595.784 seconds
2014-10-29 11:16:21 danok
130l. th3make quick.rc -DSQLITE_TRACE_SIZE_LIMIT=15
./th3: 0 errors out of 1451108 tests in 192.762 seconds, ./th3: SQLite 3.8.7.1 2014-10-29 01:27:43 83afe23e553e802c0947c80d0ffdd120423e7c52
2014-10-29 11:15:36 drhok
20f. The compile-time options are all up-to-date (compile.html)
2014-10-29 11:15:32 drhok
20e. Requirements marks are up-to-date in both documentation and source code
2014-10-29 11:15:06 drhok
20d. No unresolved hyperlinks in the documentation build
2014-10-29 11:15:02 drhok
20c. Release accouncement in news.html
2014-10-29 11:15:00 drhok
20b. Release announcement in changes.in
2014-10-29 11:14:57 drhok
20a. Latest release on the index.html page
2014-10-29 11:11:20 danpending
130l. th3make quick.rc -DSQLITE_TRACE_SIZE_LIMIT=15
2014-10-29 11:10:15 danok
130c. th3make test.rc -DSQLITE_THREADSAFE=0
./th3: 0 errors out of 7534434 tests in 1410.639 seconds, ./th3: SQLite 3.8.7.1 2014-10-29 01:27:43 83afe23e553e802c0947c80d0ffdd120423e7c52
2014-10-29 11:09:47 danpending+
130a. th3make alignment2.rc test.rc
requires that sqlite3.c be built with SQLITE_ENABLE_UPDATE_DELETE_LIMIT
2014-10-29 11:02:39 danpending
130e. OPTS=-DSQLITE_SMALL_STACK make sqlite3.c; th3make test.rc -DSQLITE_SMALL_STACK
2014-10-29 10:59:26 danok
210. ZIPVFS tests:
2014-10-29 10:59:21 danok
210b. th3make zipvfs.rc test.rc
./th3: SQLite 3.8.7.1 2014-10-29 01:27:43 83afe23e553e802c0947c80d0ffdd120423e7c52
2014-10-29 10:58:42 danok
100. Tests for platform Android:
2014-10-29 10:58:32 danok
100a. th3make quick.rc
./th3: architecture: 32-bit little-endian,./th3: 0 errors out of 1455628 tests in 2061.901 seconds, ./th3: SQLite 3.8.7.1 2014-10-29 01:27:43 83afe23e553e802c0947c80d0ffdd120423e7c52
2014-10-29 10:49:23 drhpending
130n. th3make quick.rc -fsigned-char
2014-10-29 10:49:03 drhpending
130m. th3make quick.rc -funsigned-char
2014-10-29 10:47:52 drhok
130g. th3make test.rc -DSQLITE_MAX_ATTACHED=125
0 errors out of 5951796 tests in 4445.453 seconds, iMac
2014-10-29 10:47:08 drhpending
130d. th3make test.rc -ftrapv
2014-10-29 10:46:35 drhok
130f. th3make test.rc CC=clang -fsanitize=undefined
0 errors out of 7591467 tests in 5455.491 seconds, bella
2014-10-29 10:43:57 danpending
130a. th3make alignment2.rc test.rc
2014-10-29 10:43:57 danpending
130b. th3make test.rc -DHAVE_LOCALTIME_R
2014-10-29 10:43:57 danpending
130c. th3make test.rc -DSQLITE_THREADSAFE=0
2014-10-29 10:40:12 danok
230. Amalgamation autoconf tarball.
2014-10-29 10:40:06 danok
230c. Works on Mac
2014-10-29 10:36:46 danok
230b. Works on Linux
2014-10-29 10:36:30 danok
210a. testfixture ../zipvfs/test/zipvfs.test (See test/README.txt in the ZIPVFS source tree for details.)
2014-10-29 10:36:01 danok
230a. Builds
2014-10-29 10:32:05 danok
150. Build using the configure/make in main source tree.
2014-10-29 10:32:05 danok
150a. Make sure that autoconf has been run to update the configure script.
2014-10-29 10:32:05 danok
150b. Run "make test" to verify that the build works.
2014-10-29 10:32:05 danok
150c. Verify the correct version numbers have been installed.
2014-10-29 10:32:05 danok
150d. Verify that the --disable-amalgamation option to configure works.
2014-10-29 10:32:05 danok
150e. Works on Linux
2014-10-29 10:22:08 danpending
210b. th3make zipvfs.rc test.rc
2014-10-29 10:20:36 danpending
210a. testfixture ../zipvfs/test/zipvfs.test (See test/README.txt in the ZIPVFS source tree for details.)
2014-10-29 10:11:23 danpending
100a. th3make quick.rc
2014-10-29 10:07:45 drhpending
130k. valgrind testfixture permutations.test valgrind
2014-10-29 10:06:59 drhok
130s. ./configure; make fulltest
0 errors out of 2538074 tests, bella
2014-10-29 10:01:59 drhok
90. Tests for platform Win32/64:
2014-10-29 10:01:56 drhok
90g. mptester x.db mptest/multiwrite01.test
0 errors out of 76 tests
2014-10-29 10:01:27 drhok
90f. mptester x.db mptest/crash01.test
0 errors out of 94 tests
2014-10-29 10:01:11 drhok
90e. th3make msvc.rc test.rc /RTC1
8 errors out of 5768078 tests in 3108.785 seconds. Errors are req1_malloc02.3?? and result from sqlite3_msize() always returning exactly the number of bytes requested when /RTC1 is used.
2014-10-29 09:57:34 drhok
90d. Verify that EXEs and DLLs generated using MSVC contain the correct version number, product name, description, and copyright as resources.
2014-10-29 09:57:03 drhpending
130j. th3make quick.rc -DHAVE_MALLOC_H -DHAVE_MALLOC_USABLE_SIZE -valgrind
2014-10-29 09:55:02 drhok
90h. nmake /f makefile.msc DEBUG=2 test
0 errors out of 163785 tests
2014-10-29 09:54:31 drhok
50. Tests for platform Linux x86_64:
2014-10-29 09:54:25 drhok
50h. tclsh th3make test.rc CC=clang
0 errors out of 7590967 tests in 1765.669 seconds
2014-10-29 09:28:24 drhpending
130i. th3make quick.rc -DSQLITE_ENABLE_STAT4 -valgrind
2014-10-29 09:27:24 drhok
50i. tclsh th3make fast.rc CC=clang
0 errors out of 7387434 tests in 878.547 seconds
2014-10-29 09:27:22 danpending+
80a. tclsh releasetest.tcl
2014-10-29 09:26:39 drhpending
130g. th3make test.rc -DSQLITE_MAX_ATTACHED=125
2014-10-29 09:25:39 drhok
80b. tclsh fulltest.tcl min.rc
0 errors out of 7214772 tests in 3696.940 seconds
2014-10-29 09:24:39 drhok
10. Compiler warning checks.
2014-10-29 09:24:36 drhok
10b. Mac GCC -Wall -Wextra (the tool/warnings.sh script)
2014-10-29 09:20:28 drhpending
130h. th3make quick.rc -valgrind
2014-10-29 09:16:11 drhok
10d. Windows MSVC Win32 /W3
2014-10-29 09:16:05 drhpending
90h. nmake /f makefile.msc DEBUG=2 test
2014-10-29 09:14:50 drhok
10f. sh tool/warnings-clang.sh
The usual false-positives.
2014-10-29 09:12:08 danpending
80a. tclsh releasetest.tcl
2014-10-29 09:11:44 drhpending
130s. ./configure; make fulltest
2014-10-29 09:10:13 drhpending
50h. tclsh th3make test.rc CC=clang
2014-10-29 09:10:00 drhpending
50i. tclsh th3make fast.rc CC=clang
2014-10-29 09:09:36 drhok
60. Tests for 32-bit x86 Linux
2014-10-29 09:09:33 drhok
60c. tclsh th3make quick.rc -m32
0 errors out of 1455670 tests in 144.288 seconds
2014-10-29 09:09:10 drhpending
130f. th3make test.rc CC=clang -fsanitize=undefined
2014-10-29 09:06:28 drhpending
90e. th3make msvc.rc test.rc /RTC1
2014-10-29 09:04:09 drhok
10c. OpenBSD GCC using options -Wall
2014-10-29 09:03:45 drhok
120. Tests for platform Solaris Sparc:
2014-10-29 09:03:36 drhok
120a. th3make fast.rc
0 errors out of 7393336 tests in 6708.388 seconds
2014-10-29 09:03:02 drhok
90c. th3make fast.rc
0 errors out of 5819986 tests in 3089.434 seconds. mingw, win7.
2014-10-29 08:58:23 drhok
70. Tests for platform Linux ARM (BeagleBoard)
2014-10-29 08:58:20 drhok
70a. tclsh th3make min.rc
0 errors out of 1378499 tests in 3153.523 seconds
2014-10-29 08:57:55 drhok
60b. tclsh th3make test.rc CC=clang -m32
0 errors out of 7591434 tests in 1748.144 seconds, bella
2014-10-29 08:57:21 drhok
50g. tclsh th3make test-ex.rc
16 errors out of 18054882 tests in 20590.825 seconds, bella. All errors are hlr10000.1.1 which was expecting 3.8.7.1 but got 3.8.7. This is a test case problem.
2014-10-29 08:55:33 drhok
50d. tclsh releasetest.tcl
2014-10-29 08:55:22 drhok
50e. tclsh fulltest.tcl fast.rc test.rc
0 errors out of 7591247 tests in 1591.027 seconds, tallis
2014-10-29 03:28:58 drhok
270. Build and verify correct operation of sqlite3_analyzer on:
2014-10-29 03:28:55 drhok
270b. Mac
2014-10-29 03:27:05 drhok
80c. tclsh th3make fast.rc CC=clang
0 errors out of 5797056 tests in 2429.334 seconds
2014-10-29 03:26:38 drhpending
70a. tclsh th3make min.rc
2014-10-29 03:26:31 drhok
70b. Recompile and test Fossil
2014-10-29 03:26:13 drhpending
60b. tclsh th3make test.rc CC=clang -m32
2014-10-29 03:25:57 drhok
60a. tclsh th3make test.rc -m32
0 errors out of 7591247 tests in 1591.027 seconds, bella
2014-10-29 03:25:08 drhok
110. Tests for platform OpenBSD x86:
2014-10-29 03:25:05 drhok
110a. make test
1 errors out of 137108 tests Failures on these tests: percentile-2.1.50
2014-10-29 03:15:05 drhok
90b. th3make test.rc
0 errors out of 5767926 tests in 2161.334 seconds. msvc64, win8.
2014-10-29 03:14:14 drhpending
110a. make test
2014-10-29 03:14:03 drhpending
120a. th3make fast.rc
2014-10-29 03:12:29 drhok
260. Verify that the amalgamation builds are byte-for-byte identical on all workstation platforms.
2014-10-29 03:12:26 drhok
260f. sparc solaris using autoconf
1f45625df220822ada445e22a97ab46bedbfa358 sqlite3.c a79fdd57615753461da56efb1cb1e4017d556def sqlite3.h
2014-10-29 03:04:55 drhok
260c. openbsd
1f45625df220822ada445e22a97ab46bedbfa358 sqlite3.c a79fdd57615753461da56efb1cb1e4017d556def sqlite3.h
2014-10-29 03:02:43 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.
2014-10-29 03:01:42 drhok
270c. Win32
2014-10-29 02:57:56 drhpending
60a. tclsh th3make test.rc -m32
2014-10-29 02:57:13 drhok
50k. ./mptester x.db mptest/multiwrite01.test
0 errors in 76 tests
2014-10-29 02:56:51 drhok
50j. ./mptester x.db mptest/crash01.test
0 errors in 94 tests
2014-10-29 02:56:12 drhpending
80c. tclsh th3make fast.rc CC=clang
2014-10-29 02:54:53 drhok
50f. tclsh th3make memdebug.rc
0 errors out of 7563407 tests in 3355.000 seconds, bella
2014-10-29 02:52:38 drhok
250. Run "make wordcount; bash run-wordcount.bash $OPTIONS" with options:
2014-10-29 02:52:35 drhok
250b. bash run-wordcount.sh sqlite3.c --cachesize 5 --nosync
2014-10-29 02:50:40 drhok
250a. bash run-wordcount.sh sqlite3.c
2014-10-29 02:50:06 drhok
260d. windows native mingw
1f45625df220822ada445e22a97ab46bedbfa358 sqlite3.c a79fdd57615753461da56efb1cb1e4017d556def sqlite3.h
2014-10-29 02:48:32 drhok
270a. Linux
2014-10-29 02:45:41 drhok
160. Exported symbol checks: tool/symbols.sh
2014-10-29 02:45:41 drhok
160a. No private symbols exported. (This is also checked by releasetest.tcl)
2014-10-29 02:45:41 drhok
160b. No undesirable library dependencies
2014-10-29 02:45:41 drhok
160c. No private symbols exported in MinGW (check using tool/symbols-mingw.sh)
2014-10-29 02:45:41 drhok
160d. No undesirable library dependencies on MinGW
2014-10-29 02:44:18 drhok
180. Firefox recompiled using lastest SQLite.
2014-10-29 02:44:18 drhok
180a. No SQLite compiler warnings
2014-10-29 02:44:18 drhok
180b. Active use with no issues noted
2014-10-29 02:43:14 drhok
10e. Windows MSVC Win64 /W3
2014-10-29 02:41:06 drhok
80e. ./mptester x.db mptest/multiwrite01.test
Summary: 0 errors in 76 tests
2014-10-29 02:40:43 drhok
80d. ./mptester x.db mptest/crash01.test
Summary: 0 errors in 94 tests
2014-10-29 02:39:02 drhok
260b. mac
1f45625df220822ada445e22a97ab46bedbfa358 sqlite3.c a79fdd57615753461da56efb1cb1e4017d556def sqlite3.h
2014-10-29 02:36:39 drhpending
90c. th3make fast.rc
2014-10-29 02:36:34 drhpending
90b. th3make test.rc
2014-10-29 02:34:30 drhok
260e. windows nmake
1f45625df220822ada445e22a97ab46bedbfa358 sqlite3.c a79fdd57615753461da56efb1cb1e4017d556def sqlite3.h
2014-10-29 02:31:10 drhok
90a. make fulltestonly
0 errors out of 1167021 tests, msvc64, win8
2014-10-29 02:10:45 drhok
170. Fossil updated to use the latest SQLite.
2014-10-29 02:10:45 drhok
170a. No compiler warnings
2014-10-29 02:10:45 drhok
170b. Used on active websites with no issues
2014-10-29 02:09:47 drhpending
50g. tclsh th3make test-ex.rc
bella
2014-10-29 02:09:24 drhok
50c. tclsh th3make cov.rc -DSQLITE_ENABLE_STAT4 (verify 100% branch test coverage)
0 errors out of 1451840 tests in 230.451 seconds, 100% coverage, bella
2014-10-29 02:03:19 drhok
50b. tclsh th3make cov.rc -DHAVE_MALLOC_H -DHAVE_MALLOC_USABLE_SIZE (verify 100% branch test coverage)
0 errors out of 1372352 tests in 193.502 seconds, 100% coverage, bella
2014-10-29 02:02:36 drhpending
90a. make fulltestonly
2014-10-29 02:02:03 drhok
30a. No stray changes
2014-10-29 02:00:40 drhok
10a. Linux GCC -Wall -Wextra (the tool/warnings.sh script)
The usual false-positives with -O3. No warnings with -O0
2014-10-29 01:59:30 drhpending
50d. tclsh releasetest.tcl
tallis
2014-10-29 01:58:49 drhpending
50f. tclsh th3make memdebug.rc
bella
2014-10-29 01:57:28 drhok
50a. tclsh th3make cov.rc (verify 100% branch test coverage)
0 errors out of 1374851 tests in 191.170 seconds, 100% coverage, bella
2014-10-29 01:56:39 drhpending
50e. tclsh fulltest.tcl fast.rc test.rc
tallis
2014-10-29 01:54:55 drhok
260a. linux
1f45625df220822ada445e22a97ab46bedbfa358 sqlite3.c a79fdd57615753461da56efb1cb1e4017d556def sqlite3.h