SQLite

Checklist For SQLite 3.8.6
Login
2014-08-15 08:23:26 danok
50. Tests for platform Linux x86:
2014-08-15 08:23:15 danok
50d. tclsh th3make fast-ex.rc
32-bit little-endian, 0 errors out of 17970883 tests in 17 configurations, SQLite 3.8.6 2014-08-14 19:53:37 3f45b8192dad7fb1f027cbaa694046e3c1b3e278
2014-08-15 02:17:45 drhok
60g. tclsh th3make test-ex.rc
o errors out of 18080624 tests. "bella", 5h46m
2014-08-14 23:38:15 drhok
60e. tclsh fulltest.tcl fast.rc test.rc
0 errors out of 77729934 tests. "bella". 3h25m
2014-08-14 20:28:38 drhok
100p. nmake /f makefile.msc DEBUG=2 test
0 errors out of 166449 tests, win8, vs2012.
2014-08-14 20:05:03 drhretest
100p. nmake /f makefile.msc DEBUG=2 test
Rerun after the assert() fix in btree.c:insertCell()
2014-08-14 19:59:28 drhretest
60g. tclsh th3make test-ex.rc
Rerun after the assert() fix in btree.c:insertCell()
2014-08-14 19:59:18 drhok
60g. tclsh th3make test-ex.rc
Rerun after the assert() fix in btree.c:insertCell()
2014-08-14 19:59:08 drhretest
60e. tclsh fulltest.tcl fast.rc test.rc
Rerun after the assert() fix in btree.c:insertCell()
2014-08-14 19:57:02 drhretest
60g. tclsh th3make test-ex.rc
Rerun after the assert() fix.
2014-08-14 18:21:20 mistachkinok+
350. System.Data.SQLite builds and checks out using the SQLite core
b85106c7606524876a63b809b428345d5de8b869, 0 errors/374 tests (Debug NetFx40-x86/NetFx45-x64), 0 errors/363 tests (Release NetFx40-x86/NetFx45-x64), 0 errors/23 tests (Debug NetCF20-ARM/NetCF35-ARM), 0 errors/23 tests (Release NetCF20-ARM/NetCF35-ARM)
2014-08-14 18:20:43 mistachkinok
350. System.Data.SQLite builds and checks out using the SQLite core
0 errors/374 tests (Debug NetFx40-x86/NetFx45-x64), 0 errors/363 tests (Release NetFx40-x86/NetFx45-x64), 0 errors/23 tests (Debug NetCF20-ARM/NetCF35-ARM), 0 errors/23 tests (Release NetCF20-ARM/NetCF35-ARM)
2014-08-14 17:14:44 danok
50c. tclsh fulltest.tcl fast.rc test.rc
Passed on "cyril". The test.rc/c1.cfg test was rerun due to mysterious SQLITE_READONLY errors showing up the first time.
2014-08-14 13:10:13 drhok
140. Other test performed on any available platform:
2014-08-14 13:10:10 drhok
140i. th3make quick.rc -DTH3_LOWMEM -DTH3_OMIT_MISUSE -DSQLITE_ENABLE_STAT4; valgrind ./th3
0 errors out of 1564809 tests on x64/bella in 2h10m. No valgrind warnings.
2014-08-14 13:06:34 drhok
20. Documentation checks:
2014-08-14 13:06:32 drhok
20i. Check new/changed documentation for spelling and gramatical mistakes
2014-08-14 12:50:48 drhok
20f. The compile-time options are all up-to-date (compile.html)
2014-08-14 12:50:03 drhok
20h. Test metrics are up-to-date (testing.html)
2014-08-14 12:49:59 drhok
20g. Database footprint is up-to-date (features.html)
2014-08-14 12:49:48 drhok
20e. Requirements marks are up-to-date in both documentation and source code
2014-08-14 12:49:31 drhok
20d. No unresolved hyperlinks in the documentation build
2014-08-14 12:49:28 drhok
20c. Release accouncement in news.html
2014-08-14 12:47:50 drhok
140h. th3make quick.rc -DTH3_LOWMEM -DTH3_OMIT_MISUSE; valgrind ./th3
0 errors out of 1484086 tests on x64/bella in 1h45m. No valgrind errors or warnings.
2014-08-14 12:41:57 drhok
20b. Release announcement in changes.in
2014-08-14 12:41:30 drhok
20a. Latest release on the index.html page
2014-08-14 12:17:25 drhok
140a. th3make alignment2.rc test.rc
0 errors out of 5504375 tests, x64/bella, 19m20s
2014-08-14 12:15:00 drhok
140k. th3make cov.rc -DSQLITE_TRACE_SIZE_LIMIT=15 (verify coverage)
0 errors out of 1385743 tests, x64/tallis, 100% coverage, 4m31s
2014-08-14 12:13:43 drhok
140l. th3make quick.rc -DSQLITE_TRACE_SIZE_LIMIT=15
0 errors out of 1484223 tests, x64/tallis, 3m57s
2014-08-14 12:00:50 drhpending
140l. th3make quick.rc -DSQLITE_TRACE_SIZE_LIMIT=15
x64/tallis
2014-08-14 11:59:08 drhpending
140k. th3make cov.rc -DSQLITE_TRACE_SIZE_LIMIT=15 (verify coverage)
x64/tallis
2014-08-14 11:58:05 drhpending
140a. th3make alignment2.rc test.rc
The previous failure was caused by using an older version of TH3. Rerunning now on "bella".
2014-08-14 11:22:42 danok
140f. th3make test.rc CC=clang -fsanitize=undefined
OSX 64-bit little-endian, 0 errors out of 5908128 tests in 27 configurations, SQLite 3.8.6 2014-08-14 02:59:51 f5cce9db109a2bbe9a05b4c01b076a51d5fad8ba
2014-08-14 11:19:30 drhok
210. SEE tests using TH3:
2014-08-14 11:19:27 drhok
210f. At least one of the above using test.rc
2014-08-14 11:19:23 drhok
210d. see-rc4.c
0 errors out of 7526663 tests, x64/tallis, 40m56s
2014-08-14 11:17:28 drhok
140g. th3make test.rc -DSQLITE_MAX_ATTACHED=125
0 errors out of 5713979 tests, win8, msvc.
2014-08-14 11:14:52 drhfail
140a. th3make alignment2.rc test.rc
40 errors in *.where22.862 and *.affinity01.308. The second might be a problem. 23m46s on Tallis.
2014-08-14 11:09:33 danok
140e. OPTS=-DSQLITE_SMALL_STACK make sqlite3.c; th3make test.rc -DSQLITE_SMALL_STACK
64-bit little-endian, 0 errors out of 7571121 tests in 33 configurations, SQLite 3.8.6 2014-08-14 02:59:51 f5cce9db109a2bbe9a05b4c01b076a51d5fad8ba
2014-08-14 11:08:53 danok
140d. th3make test.rc -ftrapv
64-bit little-endian, 0 errors out of 7558101 tests in 33 configurations, SQLite 3.8.6 2014-08-14 02:59:51 f5cce9db109a2bbe9a05b4c01b076a51d5fad8ba
2014-08-14 11:08:21 drhok
140a. th3make alignment2.rc test.rc
40 errors out of 5524657 tests. *.where22.862 and *.affinity01.308. Neither are serious. x64/tallis. 23m46s
2014-08-14 11:08:01 danok
140c. th3make test.rc -DSQLITE_THREADSAFE=0
64-bit little-endian, 0 errors out of 7536432 tests in 33 configurations, SQLite 3.8.6 2014-08-14 02:59:51 f5cce9db109a2bbe9a05b4c01b076a51d5fad8ba
2014-08-14 11:06:43 danok
140b. th3make test.rc -DHAVE_LOCALTIME_R
darkstar, 0 errors out of 7536432 tests in 33 configurations, SQLite 3.8.6 2014-08-14 02:59:51 f5cce9db109a2bbe9a05b4c01b076a51d5fad8ba
2014-08-14 11:02:53 drhok
40. OMIT, ENABLE, and DISABLE options:
2014-08-14 10:57:18 drhpending
140i. th3make quick.rc -DTH3_LOWMEM -DTH3_OMIT_MISUSE -DSQLITE_ENABLE_STAT4; valgrind ./th3
bella/th3b
2014-08-14 10:56:49 drhpending
140h. th3make quick.rc -DTH3_LOWMEM -DTH3_OMIT_MISUSE; valgrind ./th3
bella/th3
2014-08-14 10:54:19 drhok
140q. th3make quick.rc -DSQLITE_TEST_REALLOC_STRESS
0 errors out of 1838890 test. win7, msvc.
2014-08-14 10:53:28 drhok
230. NX-Devkit compiles and runs "tclsh th3make test.rc nx_compress.o" without error.
0 errors out of 6614006 tests. x64/bella. 19m2s.
2014-08-14 10:52:37 drhok
140p. th3make quick.rc -DSQLITE_ENABLE_RTREE -DSQLITE_ENABLE_FTS4
24 errors out of 1513781 tests. Errors are *.ctime03.1.15.[34]. "bella". 3m36s.
2014-08-14 10:47:22 drhpending
140p. th3make quick.rc -DSQLITE_ENABLE_RTREE -DSQLITE_ENABLE_FTS4
x64/bella
2014-08-14 10:46:27 drhok
140m. th3make quick.rc -funsigned-char
0 errors out of 1484195, x64/bella, 3m12s.
2014-08-14 10:43:10 drhpending
140m. th3make quick.rc -funsigned-char
"bella"
2014-08-14 10:42:13 drhok
140n. th3make quick.rc -fsigned-char
0 errors out of 1484197 tests, linux x64 "bella"
2014-08-14 10:40:31 drhpending
140a. th3make alignment2.rc test.rc
"tallis"
2014-08-14 10:38:42 drhpending
140n. th3make quick.rc -fsigned-char
"bella"
2014-08-14 10:37:13 drhpending
140q. th3make quick.rc -DSQLITE_TEST_REALLOC_STRESS
win7, msvc
2014-08-14 10:35:19 drhok
210e. see-aes128-ccm.c
0 errors out of 1465417 tests, linux x64 "bella", quick.rc, 4m5s.
2014-08-14 10:34:13 drhpending+
140g. th3make test.rc -DSQLITE_MAX_ATTACHED=125
2014-08-14 10:33:12 danpending
140g. th3make test.rc -DSQLITE_MAX_ATTACHED=125
on osx
2014-08-14 10:31:56 drhpending
230. NX-Devkit compiles and runs "tclsh th3make test.rc nx_compress.o" without error.
2014-08-14 10:31:43 danpending
140f. th3make test.rc CC=clang -fsanitize=undefined
on osx
2014-08-14 10:29:27 drhpending
210e. see-aes128-ccm.c
2014-08-14 10:29:22 drhpending
210d. see-rc4.c
2014-08-14 10:29:13 danpending
140e. OPTS=-DSQLITE_SMALL_STACK make sqlite3.c; th3make test.rc -DSQLITE_SMALL_STACK
2014-08-14 10:28:10 danpending
140d. th3make test.rc -ftrapv
2014-08-14 10:27:20 danpending
140c. th3make test.rc -DSQLITE_THREADSAFE=0
2014-08-14 10:26:50 danpending
140b. th3make test.rc -DHAVE_LOCALTIME_R
2014-08-14 10:25:46 drhok
220. ZIPVFS tests:
2014-08-14 10:25:31 drhok
80. Tests for platform Mac OS-X x86:
2014-08-14 09:54:11 drhok
130. Tests for platform Solaris Sparc:
2014-08-14 09:54:07 drhok
130b. th3make test.rc
0 errors out of 7562823 tests in 4h16m
2014-08-14 09:12:36 danok
260. Run performance tests comparing the new SQLite release against the previous release and a release from one year ago. Document and justify any performance decrease.
2014-08-14 09:12:29 danok
260a. The TCL speed*.test scripts
On darkstar: 385: 6020359, 6010745, 5975904 uS TOTAL. trunk: 5986745, 5954364, 5945456 uS TOTAL (times for 3 indpendent runs of speed1p.test using each version)
2014-08-14 08:47:38 danok
240. Amalgamation autoconf tarball.
2014-08-14 08:47:33 danok
250. TEA archive builds correctly and runs:
2014-08-14 08:47:01 danok
250a. Linux
2014-08-14 08:45:32 danok
250b. Mac
2014-08-14 08:42:36 danok
240c. Works on Mac
2014-08-14 08:37:30 danok
240b. Works on Linux
2014-08-14 06:11:53 mistachkinpending+
350. System.Data.SQLite builds and checks out using the SQLite core
64-bit debug/release OK, still need 32-bit and WinCE/.NETCF
2014-08-14 06:11:14 mistachkinok
100. Tests for platform Win32/64:
2014-08-14 06:11:07 mistachkinok
100j. At least one of the above on Windows Phone 8.1
MSVC 2013, 32-bit little-endian, 0 errors out of 1390243 tests
2014-08-14 05:55:53 danok
140j. valgrind testfixture permutations.test valgrind
"0 errors out of 97144 tests". x86-64/darkstar. Only errors are the expected misuse errors and one fault injected into os_unix.c (see oserror.test).
2014-08-14 05:52:21 danok
240a. Builds
Running "make dist" creates file sqlite-autoconf-3080600.tar.gz
2014-08-14 05:49:25 danok
300. 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.12 and 3.8.0. Linux x86-64 darkstar.
2014-08-14 05:46:26 danok
220a. testfixture ../zipvfs/test/zipvfs.test (See test/README.txt in the ZIPVFS source tree for details.)
0 errors out of 50045 tests on Linux x86-64 darkstar
2014-08-14 05:40:54 danpending
220a. testfixture ../zipvfs/test/zipvfs.test (See test/README.txt in the ZIPVFS source tree for details.)
2014-08-14 05:36:58 mistachkinpending
100j. At least one of the above on Windows Phone 8.1
2014-08-14 05:14:37 danok
80a. tclsh releasetest.tcl
[f01d42cc8b] passes
2014-08-14 04:25:10 mistachkinpending
350. System.Data.SQLite builds and checks out using the SQLite core
2014-08-14 03:00:17 mistachkinok
100l. Verify that EXEs and DLLs generated using MSVC contain the correct version number, product name, description, and copyright as resources.
2014-08-14 02:50:16 drhok
130c. th3make fast.rc
32 errors out of 1987851 tests, 1h51m
2014-08-14 02:50:03 mistachkinok
100k. At least one of the above on Windows Embedded Compact 2013
MSVC 2012, 32-bit little-endian, 0 errors out of 1391155 tests in 19 configurations
2014-08-14 02:43:53 drhok
220d. th3make zipvfs.rc quick.rc -DTH3_LOWMEM -DTH3_OMIT_MISUSE; valgrind ./th3
32 errors out of 1987851 tests. All errors were *.ctime03.1.37.[34] which can be ignored. Linux x64 "bella" in 6h24m
2014-08-14 01:37:36 mistachkinpending
100k. At least one of the above on Windows Embedded Compact 2013
2014-08-14 01:28:08 mistachkinok
100i. At least one of the above on Windows Phone 8.0
MSVC 2012, 32-bit little-endian, 0 errors out of 1390238 tests
2014-08-14 00:56:27 drhok
150. Sqllogictest:
2014-08-14 00:56:22 drhok
150d. run-all.bat with no errors
0 errors out of 17819637 tests, win8, mingw
2014-08-14 00:55:07 drhpending
130c. th3make fast.rc
2014-08-14 00:53:45 drhok
130a. make test
0 errors out of 137089 tests
2014-08-14 00:52:36 drhok
30. Source code change review. "fossil diff --from release --to trunk"
2014-08-14 00:52:33 drhok
30a. No stray changes
2014-08-14 00:52:31 drhok
30b. All significant changes are mentioned in the "changes" log of the documentation
2014-08-14 00:52:28 drhok
30c. New code complies with style guidelines
2014-08-14 00:52:25 drhok
30d. New code complies with design rules
2014-08-14 00:52:23 drhok
30e. Comments have been updated to reflect code changes
2014-08-14 00:52:20 drhok
30f. Variables and functions have been renamed to reflect changes in their use
2014-08-14 00:52:17 drhok
30i. Verify that source code contains no tabs and that surplus whitespace has been removed.
2014-08-14 00:52:15 drhok
30j. Verify that the list of APIs exposed via the extension header is up-to-date (sqlite3ext.h)
2014-08-14 00:42:40 mistachkinpending
100i. At least one of the above on Windows Phone 8.0
2014-08-14 00:41:28 drhok
130e. Verify that Fossil repositories are cross-platform with x86/x64
2014-08-14 00:38:34 drhpending
130b. th3make test.rc
2014-08-14 00:38:29 drhpending
130a. make test
2014-08-14 00:34:46 drhok
160. Build using the configure/make in main source tree.
2014-08-14 00:34:43 drhok
160g. Works on OpenBSD
2014-08-14 00:34:23 drhok
290. Verify that the amalgamation builds are byte-for-byte identical on all workstation platforms.
2014-08-14 00:34:19 drhok
290c. openbsd
md5sum 37d323bd362b73c20479c8a29f0d4342 sqlite3.c 65ec8d8642fff422ea908e39dbef1d81 sqlite3.h
2014-08-14 00:31:32 drhok
160h. Works on Solaris
2014-08-14 00:31:05 drhok
320. Build and verify correct operation of sqlite3_analyzer on:
2014-08-14 00:31:02 drhok
320c. Sparc Solaris
2014-08-14 00:29:58 drhok
290f. sparc solaris using autoconf
md5sum 37d323bd362b73c20479c8a29f0d4342 sqlite3.c 65ec8d8642fff422ea908e39dbef1d81 sqlite3.h
2014-08-14 00:26:30 drhok
130d. Recompile and test Fossil
2014-08-14 00:26:04 drhok
150c. run-all.sh with no errors
0 errors out of 17819637 tests
2014-08-14 00:10:53 drhpending
150d. run-all.bat with no errors
2014-08-14 00:10:48 drhpending
150c. run-all.sh with no errors
2014-08-14 00:10:43 drhok
150b. No compiler warnings
2014-08-14 00:10:41 drhok
150a. Checked in latest SQLite amalgamation
2014-08-13 23:51:34 mistachkinok
100h. At least one of the above on WinRT (ARM)
MSVC 2012, 32-bit little-endian, 0 errors out of 1391192 tests in 19 configurations
2014-08-13 22:50:22 drhok
30g. Check all calls to sqlite3OsRead() and sqlite3OsWrite() to ensure that offset computations are 64-bit clean.
2014-08-13 22:46:36 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-08-13 22:38:59 mistachkinpending
100h. At least one of the above on WinRT (ARM)
2014-08-13 22:37:15 drhok
10. Compiler warning checks.
2014-08-13 22:37:12 drhok
10f. sh tool/warnings-clang.sh
2014-08-13 22:25:35 drhok
10e. Windows MSVC Win64 /W3
2014-08-13 22:25:32 drhok
10d. Windows MSVC Win32 /W3
2014-08-13 22:24:51 drhok
10b. Mac GCC -Wall -Wextra (the tool/warnings.sh script)
2014-08-13 22:09:49 mistachkinok
100g. At least one of the above on WinRT (x86)
MSVC 2012, 32-bit little-endian, 0 errors out of 1391194 tests in 19 configurations
2014-08-13 21:44:12 mistachkinpending
100g. At least one of the above on WinRT (x86)
2014-08-13 21:05:20 drhok
110. Tests for platform Android:
2014-08-13 21:04:40 drhok
220h. At least one of the above on Windows
2014-08-13 21:04:36 drhok+
220b. th3make zipvfs.rc test.rc
1 error out of 6108361 tests (zipvfs1.req1_bind01.130). The failed test is incompatible with ZIPVFS. Win7, msvc
2014-08-13 20:56:52 danpending
140j. valgrind testfixture permutations.test valgrind
2014-08-13 20:54:59 danok
110a. th3make quick.rc
./th3: 0 errors out of 1488608 tests in 19 configurations
2014-08-13 20:39:08 drhok
220b. th3make zipvfs.rc test.rc
1 error out of 6108361 tests (zipvfs1.req1_bind01.130). The failed test is incompatible with ZIPVFS.
2014-08-13 20:36:57 drhok
340. 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-08-13 20:35:00 drhok
320a. Linux
2014-08-13 20:31:45 drhok
310. 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.
2014-08-13 20:31:42 drhok
310f. 64-little to 32-big, CEROD database
2014-08-13 20:20:50 danpending
80a. tclsh releasetest.tcl
2014-08-13 20:17:13 drhok
260e. One or more of the above on linux
2014-08-13 20:17:02 drhok
260b. The TH3 speed tests
On tallis, 3.8.5: 4.260s, trunk: 4.256s.
2014-08-13 20:07:59 drhok
310e. 64-little to 32-big, ZIPVFS database
2014-08-13 20:03:34 drhok
60. Tests for platform Linux x86_64:
2014-08-13 20:03:30 drhok
60e. tclsh fulltest.tcl fast.rc test.rc
0 errors out of 77729924 tests on "tallis" 4h0m.
2014-08-13 19:55:25 drhok
310d. 64-little to 32-big, SEE database
2014-08-13 19:49:03 drhok
310b. 32-big to 64-little, WAL
2014-08-13 19:48:41 drhok
310c. 32-big to 64-little, rollback
2014-08-13 19:48:30 drhok
310a. 32-big to 64-little, database
2014-08-13 19:46:18 drhok
320b. Mac
2014-08-13 19:46:12 danpending
110a. th3make quick.rc
2014-08-13 19:36:45 drhpending
220d. th3make zipvfs.rc quick.rc -DTH3_LOWMEM -DTH3_OMIT_MISUSE; valgrind ./th3
2014-08-13 19:34:57 drhok
220f. At least one of the above on Linux
2014-08-13 19:34:54 drhok
220c. th3make zipvfs.rc memdebug.rc
0 errors out of 7974511 tests on linux x64 "bella"
2014-08-13 19:34:14 drhok
90. Tests for platform MacOS 10.2 PPC:
2014-08-13 19:34:11 drhok
90a. tclsh th3make quick.rc
24 errors out of 1383763 tests - all errors are *.ctime03.1.21.[34] and are due to compile-time option differences from when the th3.c file was generated on the workstation and compiled on the device.
2014-08-13 19:15:41 danreview
50b. tclsh th3make cov.rc (verify 100% branch test coverage)
A branch at http://www.sqlite.org/src/artifact/d90a1e8acf8b6?ln=446 was not exercised.
2014-08-13 18:05:17 drhok
220g. At least one of the above on Mac
2014-08-13 18:05:13 drhok
220e. th3make quick.rc
0 errors out of 1979889 tests. 17m18s. Mac
2014-08-13 17:47:05 drhpending
90a. tclsh th3make quick.rc
2014-08-13 17:45:26 drhpending
220b. th3make zipvfs.rc test.rc
win7, vs2010
2014-08-13 17:42:01 drhpending
220e. th3make quick.rc
Mac
2014-08-13 17:41:50 drhprelim
220e. th3make quick.rc
Mac
2014-08-13 17:40:15 drhpending
220c. th3make zipvfs.rc memdebug.rc
linux x64 "bella"
2014-08-13 17:20:24 drhok
200. CEROD tests in the test/ subdirectory.
linux x64 "bella"
2014-08-13 17:09:27 drhok
90c. Verify that Fossil repositories are cross-platform with x86/x64.
2014-08-13 17:08:28 drhok
330. Tests for the sessions branch with macros SQLITE_ENABLE_SESSION and SQLITE_ENABLE_PREUPDATE_HOOK
2014-08-13 17:08:24 drhok
330d. tclsh th3make session.rc min.rc -norun -DTH3_LOWMEM -DTH3_OMIT_MISUSE; valgrind ./th3
Linux x64 "bella", 0 errors out of 1381290 tests, 1h27m
2014-08-13 17:07:08 drhok
260g. One or more of the above on mac
2014-08-13 17:07:04 drhok
260c. The speedtest1 program
On mac: 3.8.5: 20.879s, trunk: 20.815s
2014-08-13 16:53:44 drhok+
260d. ./speedtest1 --nosync --size 25 --trace 2>x.txt
time ./sqlite3 x.db <x.txt >/dev/null
win8, x64, vs2012. 2013-08-13: 2.605, 3.8.5: 2.465s, trunk: 2.356s.
2014-08-13 16:49:18 drhok
320f. A database containing WITHOUT ROWID tables
2014-08-13 16:49:15 drhok
320d. Win32 (MinGW)
2014-08-13 16:24:08 drhok
90b. Recompile and test Fossil
2014-08-13 16:01:05 drhpending
60e. tclsh fulltest.tcl fast.rc test.rc
Retest after TH3 changes
2014-08-13 16:00:40 drhretest
60. Tests for platform Linux x86_64:
2014-08-13 15:52:11 drhok
210i. At least one of the above on Mac
2014-08-13 15:52:08 drhok
210c. see-aes256-ofb.c
0 errors out of 1466853 tests. Mac, x64, 12m54s
2014-08-13 15:43:22 drhok
330a. tclsh th3make session.rc test.rc (on windows)
0 errors out of 5737712 tests. Win8, vs2012, x64.
2014-08-13 15:36:26 drhpending
210c. see-aes256-ofb.c
mac, quick.rc
2014-08-13 15:34:35 danok
50a. tclsh releasetest.tcl
[d46adf9d8f] passes on "Linux cyril 3.11.0-26-generic"
2014-08-13 15:30:38 drhok
290d. windows native mingw
md5sum 37d323bd362b73c20479c8a29f0d4342 sqlite3.c 65ec8d8642fff422ea908e39dbef1d81 sqlite3.h
2014-08-13 15:30:13 drhpending
330d. tclsh th3make session.rc min.rc -norun -DTH3_LOWMEM -DTH3_OMIT_MISUSE; valgrind ./th3
2014-08-13 15:29:15 drhok
330b. tclsh th3make session.rc test.rc (on unix)
0 errors out of 7559926 tests, linux x64 "bella"
2014-08-13 15:02:29 drhok
330c. tclsh th3make session.rc cov.rc
0 errors out of 1384080 tests. 95.99% branch coverage
2014-08-13 14:59:54 drhok
330e. make test (on windows)
win8, vs2012, x64: 2 errors out of 163062 tests: hook-7.5.2.1 hook-7.5.2.2
2014-08-13 14:57:10 drhok
330g. testfixture test/session.test
0 errors out of 24882 tests, linux, x64, "bella"
2014-08-13 14:52:54 drhok
210g. At least one of the above using memdebug.rc
2014-08-13 14:51:09 drhok
210h. At least one of the above on Linux
2014-08-13 14:51:05 drhok+
210b. see-aes128-ofb.c
0 errors out of 7543971 tests, linux, "tallis", 1h9m, memdebug.rc
2014-08-13 14:49:28 drhok
210b. see-aes128-ofb.c
0 errors out of 7543971 tests, linux, "tallis", 1h9m.
2014-08-13 14:48:12 drhpending
330e. make test (on windows)
win8, vs2012, x64
2014-08-13 14:46:26 drhok
330f. make test (on unix)
linux, x64, "bella": 3 errors in 206869 tests: hook-7.5.2.1 hook-7.5.2.2 memsubsys1-3.1.4
2014-08-13 14:29:59 drhok
320e. Win32 (MSVC)
2014-08-13 14:28:30 drhok
260f. One or more of the above on windows
2014-08-13 14:28:22 drhok
260d. ./speedtest1 --nosync --size 25 --trace 2>x.txt
time ./sqlite3 x.db <x.txt >/dev/null
win8, x64, vs2012. 3.8.6: 2.465s, trunk: 2.356s.
2014-08-13 14:19:10 drhok
280. Compute the size of a standard build (gcc -Os -c sqlite3.c) and and record the size change in the comments
2014-08-13 14:19:05 drhok
280b. Versus the trunk from 12 months ago
trunk=445264, year-ago=424821. Increase of 4.81%
2014-08-13 14:18:20 drhok
280a. Versus the previous release
trunk=445264, v365=442823. Increase of 0.55%
2014-08-13 14:12:06 drhok
140o. th3make quick.rc -DSQLITE_ENABLE_MEMSYS5
0 errors out of 1407884 tests. win7, vs2010, x64
2014-08-13 14:11:12 drhok
80e. ./mptester x.db mptest/multiwrite01.test
0 errors in 76 tests
2014-08-13 14:10:39 drhok
80d. ./mptester x.db mptest/crash01.test
0 errors in 94 tests
2014-08-13 14:10:21 drhok
160f. Works on Mac
Except, --disable-amalgamation does not work.
2014-08-13 14:06:39 drhok+
160d. Verify that the --disable-amalgamation option to configure works.
--disable-amalgamation generates an incorrect binary on Mac. Works ok without --disable-amalgamation.
2014-08-13 13:44:13 drhok
60. Tests for platform Linux x86_64:
2014-08-13 13:44:07 drhok
60i. tclsh th3make fast.rc CC=clang
0 errors out of 7316020 tests in 10m28s on linux x64 "bella"
2014-08-13 13:42:56 drhok
290b. mac
md5sum 37d323bd362b73c20479c8a29f0d4342 sqlite3.c 65ec8d8642fff422ea908e39dbef1d81 sqlite3.h
2014-08-13 13:39:47 drhpending
60i. tclsh th3make fast.rc CC=clang
2014-08-13 13:39:35 drhok
80c. tclsh th3make fast.rc CC=clang
0 errors out of 5717516 tests. 32m35s
2014-08-13 13:38:35 drhpending
210b. see-aes128-ofb.c
linux, "tallis", memdebug.rc
2014-08-13 13:36:40 drhpending
140o. th3make quick.rc -DSQLITE_ENABLE_MEMSYS5
win7, vs2010, x64
2014-08-13 13:33:10 drhok
210j. At least one of the above on Windows
2014-08-13 13:33:05 drhok
210a. see.c
0 errors out of 1379738 tests, win7, vs2010, min.rc, x64
2014-08-13 13:31:52 drhok
60h. tclsh th3make test.rc CC=clang
0 errors out of 7572053 tests in 26m16s on linux x64 "bella"
2014-08-13 13:31:06 drhok
160e. Works on Linux
2014-08-13 13:31:04 drhok
160d. Verify that the --disable-amalgamation option to configure works.
2014-08-13 13:31:01 drhok
160c. Verify the correct version numbers have been installed.
2014-08-13 13:30:58 drhok
160b. Run "make test" to verify that the build works.
2014-08-13 13:21:11 drhok
270. Run "make wordcount; bash run-wordcount.bash $OPTIONS" with options:
2014-08-13 13:21:08 drhok
270b. bash run-wordcount.sh sqlite3.c --cachesize 5 --nosync
No errors. WITHOUT ROWID is faster in all cases. Linux, x64, "bella"
2014-08-13 13:19:53 drhok+
270a. bash run-wordcount.sh sqlite3.c
No errors. WITHOUT ROWID is faster in all cases. Linux, x64, "bella"
2014-08-13 13:19:31 drhok
270a. bash run-wordcount.sh sqlite3.c
No errors. WITHOUT ROWID is faster in all cases.
2014-08-13 13:15:01 drhok
160a. Make sure that autoconf has been run to update the configure script.
2014-08-13 13:13:16 drhpending
210a. see.c
2014-08-13 13:11:40 drhok
290a. linux
md5sum 37d323bd362b73c20479c8a29f0d4342 sqlite3.c 65ec8d8642fff422ea908e39dbef1d81 sqlite3.h
2014-08-13 13:11:40 drhok
290e. windows nmake
md5sum 37d323bd362b73c20479c8a29f0d4342 sqlite3.c 65ec8d8642fff422ea908e39dbef1d81 sqlite3.h
2014-08-13 13:11:14 drh
290a. linux
md5sum 37d323bd362b73c20479c8a29f0d4342 sqlite3.c 65ec8d8642fff422ea908e39dbef1d81 sqlite3.h
2014-08-13 13:11:14 drh
290e. windows nmake
md5sum 37d323bd362b73c20479c8a29f0d4342 sqlite3.c 65ec8d8642fff422ea908e39dbef1d81 sqlite3.h
2014-08-13 13:07:50 drhok
170. Exported symbol checks: tool/symbols.sh
2014-08-13 13:07:47 drhok
170d. No undesirable library dependencies on MinGW
2014-08-13 13:07:44 drhok
170c. No private symbols exported in MinGW (check using tool/symbols-mingw.sh)
2014-08-13 13:05:58 drhok
170b. No undesirable library dependencies
2014-08-13 13:05:55 drhok
170a. No private symbols exported. (This is also checked by releasetest.tcl)
2014-08-13 13:05:05 drhpending
80c. tclsh th3make fast.rc CC=clang
2014-08-13 11:25:14 danpending
50d. tclsh th3make fast-ex.rc
2014-08-13 11:23:20 danpending
50c. tclsh fulltest.tcl fast.rc test.rc
2014-08-13 11:23:08 danpending
50b. tclsh th3make cov.rc (verify 100% branch test coverage)
2014-08-13 11:20:17 danpending
50a. tclsh releasetest.tcl
2014-08-13 11:16:41 danok
40a. tclsh ../tool/omittest.tcl -skip_run -target libsqlite3.a
As expected, SQLITE_ENABLE_LOCKING_STYLE failed. Tested with gcc 4.7.1.
2014-08-13 10:57:49 drhok
120. Tests for platform OpenBSD x86:
2014-08-13 10:57:46 drhok
120b. th3make quick.rc
0 errors out of 1492332 tests
2014-08-13 10:57:23 drhok
100d. At least one of the above using MinGW
2014-08-13 10:57:19 drhok
100b. th3make test.rc
0 errors out of 5932646 tests. Win7, vs2010, mingw.
2014-08-13 10:56:27 drhok
60e. tclsh fulltest.tcl fast.rc test.rc
0 errors out of 77906894 tests. 4h2m on "tallas"
2014-08-13 10:52:30 drhok
60g. tclsh th3make test-ex.rc
0 errors out of 18081920 tests. 5h35m on "bella"
2014-08-13 10:49:19 drhok
80b. tclsh fulltest.tcl fast.rc test.rc
0 errors out of 60897170 test. 9h33m.
2014-08-13 10:39:18 drhok
70. Tests for platform Linux ARM (BeagleBoard)
2014-08-13 10:39:14 drhok
70a. tclsh th3make min.rc
0 errors out of 1393871 tests
2014-08-13 03:25:14 drhok
100m. th3make msvc.rc test.rc /RTC1
0 errors out of 5724276 tests. Win8, vs2012, x64
2014-08-13 03:24:17 drhpending
60g. tclsh th3make test-ex.rc
2014-08-13 03:23:59 drhok+
60f. tclsh th3make memdebug.rc
0 errors out of 7572245 tests 51n15s
2014-08-13 03:23:27 drhok
60f. tclsh th3make memdebug.rc
0 errors out of 7572245 tests
2014-08-13 03:11:32 drhpending
100b. th3make test.rc
Win7, vs2010, mingw
2014-08-13 03:10:08 drhok
100e. At least one of the above using MSVC-32
2014-08-13 03:09:59 drhok
100c. th3make fast.rc
0 errors out of 5524104 tests. Win7, vs2010, x32
2014-08-13 03:08:59 drhpending
70a. tclsh th3make min.rc
2014-08-13 03:08:16 drhpending
120b. th3make quick.rc
2014-08-13 03:07:23 drhok
70b. Recompile and test Fossil
2014-08-13 02:59:50 drhok
120a. make test
1 error (percentile-2.1.50) out of 137035 tests
2014-08-13 02:47:59 drhok
190. Firefox recompiled using lastest SQLite.
2014-08-13 02:47:56 drhok
190a. No SQLite compiler warnings
2014-08-13 02:47:52 drhok
190b. Active use with no issues noted
2014-08-13 02:47:44 drhok
180. Fossil updated to use the latest SQLite.
2014-08-13 02:47:41 drhok
180a. No compiler warnings
2014-08-13 02:47:38 drhok
180b. Used on active websites with no issues
2014-08-13 02:46:51 drhok
10c. OpenBSD GCC using options -Wall
2014-08-13 02:46:35 drhpending
120a. make test
2014-08-13 02:35:00 drhok
100o. mptester x.db mptest/multiwrite01.test
0 errors in 76 tests, win8, vs2012, x64
2014-08-13 02:34:24 drhok
100n. mptester x.db mptest/crash01.test
0 errors out of 94 tests, on win8, vs2012, x64
2014-08-13 02:32:54 drhpending
100m. th3make msvc.rc test.rc /RTC1
VS2012, x64, win8
2014-08-13 02:30:42 drhpending
60f. tclsh th3make memdebug.rc
2014-08-13 02:30:03 drhok
60k. ./mptester x.db mptest/multiwrite01.test
0 errors in 76 tests
2014-08-13 02:29:40 drhok
60j. ./mptester x.db mptest/crash01.test
0 errors in 94 tests
2014-08-13 02:26:34 drhpending
60e. tclsh fulltest.tcl fast.rc test.rc
2014-08-13 00:59:22 drhok
100f. At least one of the above using MSVC-64
2014-08-13 00:59:18 drhok
100a. make fulltestonly
0 errors out of 1134705 tests. msvc64 on win8.
2014-08-13 00:06:20 drhfail+++
100c. th3make fast.rc
Infinite loop on 64k.where37.131 on win7. Same test works fine with test.rc or on win8. Compiler bug? Need to investigate further.
2014-08-13 00:05:36 drhfail++
100c. th3make fast.rc
Infinie loop on 64k.where37.131 on win7. Same test works fine with test.rc or on win8. Compiler bug? Need to investigate further.
2014-08-12 23:58:54 drhfail+
100c. th3make fast.rc
Infinite loop on 64k.where37.
2014-08-12 23:58:39 drhfail
100c. th3make fast.rc
Infinie loop on 64k.where37.
2014-08-12 23:55:11 drhok
60c. tclsh th3make cov.rc -DSQLITE_ENABLE_STAT4 (verify 100% branch test coverage)
0 errors out of 1459212 tests, 100% coverage, on "bella"
2014-08-12 23:52:40 drhpending
100a. make fulltestonly
msvc x64 win8
2014-08-12 21:34:02 drhok
140r. ./configure; make fulltest
1 error (memsubsys1-3.1.4) out of 2240287 tests. Tallis. 45m44s
2014-08-12 20:48:30 drhfail
60c. tclsh th3make cov.rc -DSQLITE_ENABLE_STAT4 (verify 100% branch test coverage)
No errors. But 16 branches not evaluated. Need to update TH3 and retest. 4m23s.
2014-08-12 20:47:04 drhok
100p. nmake /f makefile.msc DEBUG=2 test
0 errors out of 166468 tests on x64, win8
2014-08-12 20:46:19 drhpending
100c. th3make fast.rc
win7, msvc32
2014-08-12 20:44:48 drhpending
60c. tclsh th3make cov.rc -DSQLITE_ENABLE_STAT4 (verify 100% branch test coverage)
2014-08-12 20:41:38 drhok
60b. tclsh th3make cov.rc -DHAVE_MALLOC_H -DHAVE_MALLOC_USABLE_SIZE (verify 100% branch test coverage)
0 errors out of 1387786 tests in 3m35.954s on "bella"
2014-08-12 20:38:52 drhpending
80b. tclsh fulltest.tcl fast.rc test.rc
2014-08-12 20:36:53 drhpending
60b. tclsh th3make cov.rc -DHAVE_MALLOC_H -DHAVE_MALLOC_USABLE_SIZE (verify 100% branch test coverage)
2014-08-12 20:36:48 drhok
60a. tclsh th3make cov.rc (verify 100% branch test coverage)
0 errors out of 1390115 tests on "bella"
2014-08-12 20:33:22 drhok
10a. Linux GCC -Wall -Wextra (the tool/warnings.sh script)
False-positive "array subscript is above array bounds" when using -O3. There are compiler bugs. No other warnings.
2014-08-12 20:31:08 drhpending
140r. ./configure; make fulltest
On "tallis"
2014-08-12 20:28:11 drhpending
100p. nmake /f makefile.msc DEBUG=2 test
x64, win8
2014-08-07 19:03:54 danok
60d. tclsh releasetest.tcl
2014-08-07 15:46:37 danpending
60d. tclsh releasetest.tcl