SQLite

Checklist For SQLite 3.16.0
Login
2017-01-05 14:48:54 drhok
160c. ./mach web-platform-tests IndexedDB
1204 passed, no errors. SQLite 2017-01-05 13:52:54 ca185808ade195875918b5bad1762bcd8ec39457
2017-01-05 14:32:00 drhok
160a. ./mach mochitest dom/indexedDB
26725 passed. No errors. SQLite 2017-01-05 13:52:54 ca185808ade195875918b5bad1762bcd8ec39457
2017-01-05 14:30:29 drhok
160b. ./mach xpcshell-test dom/indexedDB
203 tests passed (1 skipped) for SQLite 2017-01-05 13:52:54 ca185808ade195875918b5bad1762bcd8ec39457
2017-01-03 21:30:33 drhok+++
60a. tclsh multitest.tcl (take care to update ../th3private)
0 failures on 39 th3makes and 175130566 tests in (05:02:03) 3 cores on bella SQLite 3.16.0 2016-12-30 00:09:14 f57952bac652901e1bd48b68301941efbcf29dc4 0 failures on 40 th3makes and 176896500 tests in (05:11:27) 3 cores on bella SQLite 3.16.0 2016-12-30 17:40:14 14d855d2b2b5b3485e0673d11405db7266b34c6d 0 failures on 40 th3makes and 176933761 tests in (05:02:27) 3 cores on bella SQLite 3.16.0 2017-01-01 12:44:07 2c4d167ccd4be591487f404de9ee629fd484c8bf 0 failures on 40 th3makes and 177257436 tests in (05:14:40) 3 cores on bella SQLite 3.16.1 2017-01-03 16:03:22 a60b60d6b6ba3e3b17b7bb7d7e19ea0e6b40fa68
2017-01-03 19:04:52 drhok++
80a. tclsh releasetest.tcl
0 failures out of 4718538 tests in (03:50:47) on macpro01 SQLite 3.16.0 2016-12-29 19:48:46 afcdc4a60e357d171156e0de705bf7ad1b37daab0 0 failures out of 4721133 tests in (02:41:42) on macpro01 SQLite 3.16.0 2017-01-01 12:44:07 2c4d167ccd4be591487f404de9ee629fd484c8bf 0 failures out of 4720955 tests in (02:43:49) on macpro01 SQLite 3.16.1 2017-01-03 16:03:22 a60b60d6b6ba3e3b17b7bb7d7e19ea0e6b40fa68
2017-01-03 18:02:58 drhok++
100a. tclsh multitest.tcl (after updating th3private)
0 failures on 34 th3makes and 133561145 tests in (08:17:16) 3 cores on DESKTOP-8U9G1N8 SQLite 3.16.0 2016-12-30 15:16:20 a0971e713682a73d8c7c20511db256c20d2f6388 0 failures on 34 th3makes and 137777415 tests in (09:24:17) 3 cores on DESKTOP-8U9G1N8 SQLite 3.16.0 2017-01-01 12:44:07 2c4d167ccd4be591487f404de9ee629fd484c8bf On 3.16.1 with --quick: 0 failures on 13 th3makes and 16469167 tests in (01:21:41) on DESKTOP-8U9G1N8 SQLite 3.16.1 2017-01-03 16:03:22 a60b60d6b6ba3e3b17b7bb7d7e19ea0e6b40fa68
2017-01-03 17:56:28 drhok+++
60c. tclsh releasetest.tcl
0 failures out of 9760347 tests in (02:04:42) 2 cores on bella SQLite 3.16.0 2016-12-29 19:48:46 afcdc4a60e357d171156e0de705bf7ad1b37daab Later: 4 failures out of 9765790 tests in (01:57:29) 2 cores on bella SQLite 3.16.0 2016-12-30 17:40:14 14d855d2b2b5b3485e0673d11405db7266b34c6d Run on a RAM-disk; all failures are the result of insufficient disk space. Later still: 0 failures out of 9764392 tests in (01:29:48) 3 cores on bella SQLite 3.16.0 2017-01-01 12:44:07 2c4d167ccd4be591487f404de9ee629fd484c8bf 3.16.1: 0 failures out of 9766045 tests in (01:43:20) 3 cores on darkstar SQLite 3.16.1 2017-01-03 16:03:22 a60b60d6b6ba3e3b17b7bb7d7e19ea0e6b40fa68
2017-01-02 11:57:11 drhok
30. Documentation review:
2017-01-02 11:57:07 drhok
30c. Release accouncement in "news.html".
2017-01-02 11:57:02 drhok
30i. Check new/changed documentation for spelling and gramatical mistakes.
2017-01-02 11:48:06 danok
210. NX-Devkit testing
2017-01-02 11:48:06 danok
210a. Verify that devkit sources are up-to-date with SQLite and ZIPVFS by running update-src.sh and mkdevkit.tcl in the sbin subdirectory of the devkit source tree. Record nds_sqlite3.[ch] hashes in the comment.
2017-01-02 11:48:06 danok
210c. Test using: tclsh th3make test.rc nxc.o -DNDS_ENABLE_COMPRESS
2017-01-02 02:31:33 drhok+
100a. tclsh multitest.tcl (after updating th3private)
0 failures on 34 th3makes and 133561145 tests in (08:17:16) 3 cores on DESKTOP-8U9G1N8 SQLite 3.16.0 2016-12-30 15:16:20 a0971e713682a73d8c7c20511db256c20d2f6388 0 failures on 34 th3makes and 137777415 tests in (09:24:17) 3 cores on DESKTOP-8U9G1N8 SQLite 3.16.0 2017-01-01 12:44:07 2c4d167ccd4be591487f404de9ee629fd484c8bf
2017-01-01 21:30:09 drhok++
60c. tclsh releasetest.tcl
0 failures out of 9760347 tests in (02:04:42) 2 cores on bella SQLite 3.16.0 2016-12-29 19:48:46 afcdc4a60e357d171156e0de705bf7ad1b37daab Later: 4 failures out of 9765790 tests in (01:57:29) 2 cores on bella SQLite 3.16.0 2016-12-30 17:40:14 14d855d2b2b5b3485e0673d11405db7266b34c6d Run on a RAM-disk; all failures are the result of insufficient disk space. Later still: 0 failures out of 9764392 tests in (01:29:48) 3 cores on bella SQLite 3.16.0 2017-01-01 12:44:07 2c4d167ccd4be591487f404de9ee629fd484c8bf
2017-01-01 19:11:17 drhok+
80b. tclsh multitest.tcl --omit test-ex (after updating th3private)
0 failures on 35 th3makes and 142464388 tests in (08:57:04) 2 cores on macpro01 SQLite 3.16.0 2016-12-30 17:40:14 14d855d2b2b5b3485e0673d11405db7266b34c6d Later using the -quick option: 0 failures on 13 th3makes and 16221307 tests in (00:41:47) on macpro01 SQLite 3.16.0 2017-01-01 12:44:07 2c4d167ccd4be591487f404de9ee629fd484c8bf
2017-01-01 18:01:52 drhok+
80a. tclsh releasetest.tcl
0 failures out of 4718538 tests in (03:50:47) on macpro01 SQLite 3.16.0 2016-12-29 19:48:46 afcdc4a60e357d171156e0de705bf7ad1b37daab0 0 failures out of 4721133 tests in (02:41:42) on macpro01 SQLite 3.16.0 2017-01-01 12:44:07 2c4d167ccd4be591487f404de9ee629fd484c8bf
2017-01-01 17:59:55 drhok++
60a. tclsh multitest.tcl (take care to update ../th3private)
0 failures on 39 th3makes and 175130566 tests in (05:02:03) 3 cores on bella SQLite 3.16.0 2016-12-30 00:09:14 f57952bac652901e1bd48b68301941efbcf29dc4 0 failures on 40 th3makes and 176896500 tests in (05:11:27) 3 cores on bella SQLite 3.16.0 2016-12-30 17:40:14 14d855d2b2b5b3485e0673d11405db7266b34c6d 0 failures on 40 th3makes and 176933761 tests in (05:02:27) 3 cores on bella SQLite 3.16.0 2017-01-01 12:44:07 2c4d167ccd4be591487f404de9ee629fd484c8bf
2017-01-01 07:50:41 danok
200. ZIPVFS tests:
2017-01-01 07:50:20 danok
200d. th3make zipvfs.rc quick.rc -valgrind
th3: 0 errors in 2782598 tests. 24467.051 seconds on darkstar 64-bit little-endian th3: SQLite 3.16.0 2016-12-30 17:40:14 14d855d2b2b5b3485e0673d11405db7266b34c6d ERROR SUMMARY: 0 errors from 0 contexts (suppressed: 0 from 0)
2017-01-01 07:50:15 danpending+
200d. th3make zipvfs.rc quick.rc -valgrind
th3: 0 errors in 2782598 tests. 24467.051 seconds on darkstar 64-bit little-endian th3: SQLite 3.16.0 2016-12-30 17:40:14 14d855d2b2b5b3485e0673d11405db7266b34c6d ERROR SUMMARY: 0 errors from 0 contexts (suppressed: 0 from 0)
2017-01-01 07:49:39 danok
200g. At least one of the above on Mac OS X.
20C
2017-01-01 07:49:21 dan---+
200g. At least one of the above on Mac OS X.
20C
2017-01-01 07:49:12 danok
200c. th3make zipvfs.rc memdebug.rc
th3: 0 errors in 8262353 tests. 15480.046 seconds on Chanphen-Kruatawongs-iMac.local 64-bit little-endian
2016-12-31 16:29:39 drhok
100. Tests for platform Windows:
2016-12-31 16:29:33 drhok
100g. nmake /f makefile.msc WIN32HEAP=1 DEBUG=4 fulltestonly
SQLite 2016-12-30 17:40:14 14d855d2b2b5b3485e0673d11405db7266b34c6d 0 errors out of 1212507 tests on DESKTOP-8U9G1N8 Windows NT 64-bit little-endian
2016-12-31 16:08:13 drhok+
240a. Android
3.9.2: 118.319s 3.15.0: 98.730s 3.16.0: 94.206s
2016-12-31 15:54:01 drhok
20. Source code change review. fossil diff --from release --to trunk
2016-12-31 15:54:01 drhok
20g. Check all calls to sqlite3OsRead() and sqlite3OsWrite() to ensure that offset computations are 64-bit clean.
2016-12-31 15:54:01 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]*(/
2016-12-31 15:54:01 drhok
20i. Verify that source code contains no tabs and that surplus whitespace has been removed.
2016-12-31 15:54:01 drhok
20j. Verify that the list of APIs exposed via the extension header is up-to-date (sqlite3ext.h).
2016-12-31 15:53:10 drhok
100h. sh tool/symbols-mingw.sh - no incorrect exports or dependencies
2016-12-31 15:50:36 drhok
100i. Verify that EXEs and DLLs generated using MSVC contain the correct version number, product name, description, and copyright as resources.
2016-12-31 15:41:34 drhok
30h. Test metrics are up-to-date (testing.html).
2016-12-31 15:41:31 drhok
30g. Database footprint is up-to-date (features.html).
2016-12-31 15:13:03 drhok
10. Test procedure review.
2016-12-31 15:13:03 drhok
10a. Review the "test/releasetest.tcl" script for completeness and accuracy.
2016-12-31 15:13:03 drhok
10b. Review "multitest.tcl" and "alignment*.rc" scripts in TH3 for completeness.
2016-12-31 15:13:03 drhok
10c. Review this checklist for completeness and accuracy.
2016-12-31 15:12:46 drhok
40. Compiler warning checks.
2016-12-31 15:12:29 drhok
220. Amalgamation autoconf tarball.
2016-12-31 15:12:26 drhok
220e. Works on Windows MSVC
2016-12-31 15:12:23 drhok
220d. Works on Windows MinGW
2016-12-31 14:58:23 drhok
240. Performance tests using speedtest1 compared against the previous release and a release from about one year ago.
2016-12-31 14:58:18 drhok
240b. Linux
3.9.2: 5.402s 3.15.0: 4.635s 3.16.0: 4.346s
2016-12-31 14:54:26 drhok+
240d. Windows
On win7dev with MSVC 32-bit. 3.9.2: 52.062s 3.15.0: 41.738s 3.16.0: 40.576s
2016-12-31 14:52:30 drhok
240c. Mac
3.9.2: 7.895s 3.15.0: 6.258s 3.16.0: 5.792s
2016-12-31 14:40:46 drhok
240d. Windows
3.9.2: 52.062s 3.15.0: 41.738s 3.16.0: 40.576s
2016-12-31 14:40:02 drhok
240a. Android
Using --size 10 3.9.2: 10.189s 3.15.0: 7.971s 3.16.0: 7.553s
2016-12-31 14:21:50 drhok
200h. At least one of the above on Windows.
2016-12-31 14:21:25 drhok
200e. th3make zipvfs.rc quick.rc
th3: 0 errors in 2841604 tests. 4015.885 seconds on win7dev 32-bit little-endian th3: SQLite 3.16.0 2016-12-30 17:40:14 14d855d2b2b5b3485e0673d11405db7266b34c6d
2016-12-31 13:54:57 drhok+
250a. bash run-wordcount.sh sqlite3.c
22% faster on Win7. 31% faster on Android. On android, with --replace --without-rowid 3.15 is 103.596s vs 21.46s for 3.16. Almost 5x faster.
2016-12-31 12:54:14 drhok
250. Run make wordcount; bash run-wordcount.bash $OPTIONS with options:
2016-12-31 12:54:10 drhok
250b. bash run-wordcount.sh sqlite3.c --cachesize 5 --nosync
15% faster on Linux
2016-12-31 12:46:32 drhok
180. SEE tests using TH3:
2016-12-31 12:46:27 drhok
180e. see-aes128-ccm.c
th3: 0 errors in 1664474 tests. 357.159 seconds on macpro01 64-bit little-endian th3: SQLite 3.16.0 2016-12-30 17:40:14 14d855d2b2b5b3485e0673d11405db7266b34c6d
2016-12-31 12:29:51 drhok
260. Verify that the performance and size measurement spreadsheet in the documentation (misc/speed-size-graph.ods) is up-to-date.
2016-12-31 12:19:23 drhok
190. SEE using configure; make test
2016-12-31 12:19:18 drhok
190b. Mac
Works if using the default "any" codec (i.e. sqlite3-see.c). But fails if the CCCrypt() function is detected within -lcccrypt and it attempts to use sqlite3-cccrypt.c instead. SQLite 2016-12-30 17:40:14 14d855d2b2b5b3485e0673d11405db7266b34c6d 0 errors out of 139834 tests on macpro01 Darwin 64-bit little-endian
2016-12-31 12:18:37 drhok
180f. see-cccrypt.c
th3: 0 errors in 1664244 tests. 277.987 seconds on macpro01 64-bit little-endian th3: SQLite 3.16.0 2016-12-30 17:40:14 14d855d2b2b5b3485e0673d11405db7266b34c6d
2016-12-31 11:49:21 drhok
100f. nmake /f makefile.msc MEMDEBUG=1 DEBUG=3 fulltestonly
SQLite 2016-12-30 17:40:14 14d855d2b2b5b3485e0673d11405db7266b34c6d 0 errors out of 1209786 tests on DESKTOP-8U9G1N8 Windows NT 64-bit little-endian
2016-12-31 11:42:24 danreview
190b. Mac
Works if using the default "any" codec (i.e. sqlite3-see.c). But fails if the CCCrypt() function is detected within -lcccrypt and it attempts to use sqlite3-cccrypt.c instead.
2016-12-31 10:58:08 danok+
210d. Verify failure if run without -DNDS_ENABLE_COMPRESS
Segfaults in first test without that option.
2016-12-31 10:57:54 danok
210d. Verify failure if run without -DNDS_ENABLE_COMPRESS
Segfaults.
2016-12-31 10:56:32 danprelim
210c. Test using: tclsh th3make test.rc nxc.o -DNDS_ENABLE_COMPRESS
Works only if -DSQLITE_ENABLE_URI_00_ERROR is added to the th3 command line. This is because this option is hardcoded into nds_sqlite3.c.
2016-12-31 10:14:04 danok
190a. Linux
SQLite 2016-12-30 17:40:14 14d855d2b2b5b3485e0673d11405db7266b34c6d 0 errors out of 140445 tests on darkstar Linux 64-bit little-endian Works if (1) build is done in root of source tree and (2) $(SRCROOT)/../sqlite/ is the root of an SQLite source tree in which a build has been run (to generate interim *.h files like parse.h).
2016-12-31 10:02:54 danok
210b. Build using: sh mkdevkit.sh; gcc -o nxc.o -c nx_compress.c
-rw-r--r-- 1 dan users 11256 Dec 31 17:03 nxc.o
2016-12-31 10:01:45 danprelim
210a. Verify that devkit sources are up-to-date with SQLite and ZIPVFS by running update-src.sh and mkdevkit.tcl in the sbin subdirectory of the devkit source tree. Record nds_sqlite3.[ch] hashes in the comment.
Sources are up to date. No hashes in the commit yet on the grounds that there will probably be another commit to the main project yet.
2016-12-31 09:55:10 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 against 3.7.3 and 3.8.2 using the backcompat.test script.
2016-12-31 09:52:27 danok
70. Tests for platform Linux ARM (BeagleBoard)
2016-12-31 09:52:19 danok
70a. tclsh th3make min.rc
th3: 0 errors in 1630244 tests. 4832.934 seconds on beaglebone 32-bit little-endian th3: SQLite 3.16.0 2016-12-30 17:40:14 14d855d2b2b5b3485e0673d11405db7266b34c6d
2016-12-31 09:49:23 danok
200f. At least one of the above on Linux.
a, b, d and i.
2016-12-31 09:48:53 danok
200b. th3make zipvfs.rc test.rc
th3: 0 errors in 9989367 tests. 2717.122 seconds on darkstar 64-bit little-endian th3: SQLite 3.16.0 2016-12-30 17:40:14 14d855d2b2b5b3485e0673d11405db7266b34c6d
2016-12-31 09:14:12 danok
230. TEA archive builds correctly and runs:
2016-12-31 09:14:04 danok
230b. Mac OS X
2016-12-31 09:12:49 danok
220c. Works on Mac OS X.
2016-12-31 09:05:42 danok
230a. Linux
2016-12-31 09:05:21 danok
220b. Works on Linux.
2016-12-31 09:05:15 danok
220a. Builds.
2016-12-31 08:56:11 danok
200i. th3make zipvfs-cov.rc - verify full coverage
Statement coverage: 100.00% hit 1573 missed 0 total 1573 Branch coverage: 100.00% hit 931 missed 0 total 931
2016-12-31 08:40:10 danok
70b. Recompile and test Fossil.
[fossil sync] works. [fossil -all rebuild] works.
2016-12-31 08:38:45 danpending
200d. th3make zipvfs.rc quick.rc -valgrind
2016-12-31 08:37:26 danpending
200i. th3make zipvfs-cov.rc - verify full coverage
2016-12-31 08:29:58 danpending
200c. th3make zipvfs.rc memdebug.rc
On OSX
2016-12-31 08:19:13 danpending
200b. th3make zipvfs.rc test.rc
2016-12-31 08:13:32 danpending
70b. Recompile and test Fossil.
2016-12-31 07:55:27 mistachkinok
110. Tests for alternative and special-purpose Windows systems
2016-12-31 07:55:22 mistachkinok
110b. th3make msvc.rc winrt.rc min.rc - Windows Runtime 8.0 (ARM)
0 errors in 1626290 tests. 5221.114 seconds on 32-bit little-endian, SQLite 3.16.0 2016-12-30 17:40:14 14d855d2b2b5b3485e0673d11405db7266b34c6d
2016-12-31 06:17:16 danpending
70a. tclsh th3make min.rc
2016-12-31 05:08:11 mistachkinpending
110b. th3make msvc.rc winrt.rc min.rc - Windows Runtime 8.0 (ARM)
2016-12-31 04:03:37 drhok
80. Tests for platform Mac OS X:
2016-12-31 04:03:33 drhok
80d. tclsh releasetest.tcl --platform Failure-Detection - all failures detected
2016-12-31 04:03:13 drhok
60. Tests for platform Linux x86_64:
2016-12-31 04:03:07 drhok+
60c. tclsh releasetest.tcl
0 failures out of 9760347 tests in (02:04:42) 2 cores on bella SQLite 3.16.0 2016-12-29 19:48:46 afcdc4a60e357d171156e0de705bf7ad1b37daab Later: 4 failures out of 9765790 tests in (01:57:29) 2 cores on bella SQLite 3.16.0 2016-12-30 17:40:14 14d855d2b2b5b3485e0673d11405db7266b34c6d Run on a RAM-disk; all failures are the result of insufficient disk space.
2016-12-31 03:58:10 drhok
90. Tests for platform Mac OS X 10.2 (PPC):
2016-12-31 03:58:05 drhok
90a. tclsh th3make quick.rc
th3: 0 errors in 1626801 tests. 5103.281 seconds on crabapple.local. 32-bit big-endian th3: SQLite 3.16.0 2016-12-30 17:40:14 14d855d2b2b5b3485e0673d11405db7266b34c6d
2016-12-31 03:57:09 drhok
80c. tclsh multitest.tcl --scenario failures - all failures detected
2016-12-31 03:51:57 drhok
80b. tclsh multitest.tcl --omit test-ex (after updating th3private)
0 failures on 35 th3makes and 142464388 tests in (08:57:04) 2 cores on macpro01 SQLite 3.16.0 2016-12-30 17:40:14 14d855d2b2b5b3485e0673d11405db7266b34c6d
2016-12-31 03:27:52 mistachkinok
110e. th3make msvc.rc wp81.rc min.rc - Windows Phone 8.1
0 errors in 1625022 tests. 3259.299 seconds on 32-bit little-endian, SQLite 3.16.0 2016-12-30 17:40:14 14d855d2b2b5b3485e0673d11405db7266b34c6d
2016-12-31 03:15:10 drhok
100e. tclsh releasetest.tcl --platform Failure-Detection - all failures detected
2016-12-31 03:10:18 mistachkinok
110f. th3make msvc.rc wince.rc min.rc - Windows Embedded Compact 2013 - When tests are going to be run on the [Hyper-V based] emulator, no-mmap.rc must be used as well.
0 errors in 1632648 tests. 3953.518 seconds on 32-bit little-endian, SQLite 3.16.0 2016-12-30 17:40:14 14d855d2b2b5b3485e0673d11405db7266b34c6d
2016-12-31 02:40:16 drhok
100d. tclsh test/releasetest.tcl --msvc
0 failures out of 1969394 tests in (02:09:52) on DESKTOP-8U9G1N8 SQLite 3.16.0 2016-12-30 17:40:14 14d855d2b2b5b3485e0673d11405db7266b34c6d
2016-12-31 02:28:36 mistachkinok
320. System.Data.SQLite builds and checks out using the SQLite core.
2016-12-31 02:28:31 mistachkinok
320b. Using Mono on unix
14d855d2b2b5b3485e0673d11405db7266b34c6d, Debug Mono 4.6.1 on Ubuntu 15.10 x86_64: 0 errors/568 tests, 717 seconds, Release Mono 4.6.1 on Ubuntu 15.10 x86_64: 0 errors/568 tests, 664 seconds
2016-12-31 02:28:21 mistachkinok
320a. Using Microsoft .NET Framework on Windows
14d855d2b2b5b3485e0673d11405db7266b34c6d, Debug NetFx46 x86: 0 errors/568 tests, 1055 seconds, Release NetFx46 x86: 0 errors/568 tests, 932 seconds, Debug NetFx451 x64: 0 errors/568 tests, 936 seconds, Release NetFx451 x64: 0 errors/568 tests, 934 seconds, 0 errors/24 tests (Debug NetCF20-ARM/NetCF35-ARM), 0 errors/24 tests (Release NetCF20-ARM/NetCF35-ARM)
2016-12-31 01:55:40 drhok
180i. At least one of the above on Linux.
2016-12-31 01:55:34 drhok
180h. At least one of the above using "memdebug.rc".
2016-12-31 01:55:27 drhok
180c. see-aes256-ofb.c
th3: 0 errors in 8173328 tests. 4800.608 seconds on bella 64-bit little-endian th3: SQLite 3.16.0 2016-12-30 17:40:14 14d855d2b2b5b3485e0673d11405db7266b34c6d
2016-12-31 01:52:59 mistachkinpending
110e. th3make msvc.rc wp81.rc min.rc - Windows Phone 8.1
2016-12-31 01:51:44 mistachkinpending
110f. th3make msvc.rc wince.rc min.rc - Windows Embedded Compact 2013 - When tests are going to be run on the [Hyper-V based] emulator, no-mmap.rc must be used as well.
2016-12-31 00:13:17 mistachkinok
110c. th3make msvc.rc winrt.rc min.rc - Windows Runtime 8.1
0 errors in 1626275 tests. 7313.492 seconds on 32-bit little-endian, SQLite 3.16.0 2016-12-30 17:40:14 14d855d2b2b5b3485e0673d11405db7266b34c6d
2016-12-31 00:02:59 drhpending
100d. tclsh test/releasetest.tcl --msvc
2016-12-31 00:02:17 drhok
100c. tclsh multitest.tcl --scenario failures - verify failures detected
2016-12-31 00:01:51 drhok
180b. see-aes128-ofb.c
th3: 0 errors in 1715076 tests. 1245.665 seconds on win7dev 32-bit little-endian th3: SQLite 3.16.0 2016-12-30 17:40:14 14d855d2b2b5b3485e0673d11405db7266b34c6d
2016-12-31 00:00:05 drhok
100a. tclsh multitest.tcl (after updating th3private)
0 failures on 34 th3makes and 133561145 tests in (08:17:16) 3 cores on DESKTOP-8U9G1N8 SQLite 3.16.0 2016-12-30 15:16:20 a0971e713682a73d8c7c20511db256c20d2f6388
2016-12-30 23:56:16 drhok
180j. At least one of the above on Mac OS X.
2016-12-30 23:56:11 drhok
180g. At least one of the above using "test.rc".
2016-12-30 23:56:04 drhok
180d. see-rc4.c
th3: 0 errors in 6420271 tests. 6621.476 seconds on sqlite-imac 64-bit little-endian th3: SQLite 3.16.0 2016-12-30 17:40:14 14d855d2b2b5b3485e0673d11405db7266b34c6d
2016-12-30 23:53:24 drhok+
60a. tclsh multitest.tcl (take care to update ../th3private)
0 failures on 39 th3makes and 175130566 tests in (05:02:03) 3 cores on bella SQLite 3.16.0 2016-12-30 00:09:14 f57952bac652901e1bd48b68301941efbcf29dc4 0 failures on 40 th3makes and 176896500 tests in (05:11:27) 3 cores on bella SQLite 3.16.0 2016-12-30 17:40:14 14d855d2b2b5b3485e0673d11405db7266b34c6d
2016-12-30 23:16:16 mistachkinpending
320b. Using Mono on unix
2016-12-30 22:57:18 mistachkinpending
320a. Using Microsoft .NET Framework on Windows
2016-12-30 22:55:01 mistachkinpending
320. System.Data.SQLite builds and checks out using the SQLite core.
2016-12-30 22:54:52 mistachkinpending
110. Tests for alternative and special-purpose Windows systems
2016-12-30 22:23:57 mistachkinok
110d. th3make msvc.rc wp80.rc min.rc - Windows Phone 8.0
0 errors in 1625022 tests. 1145.842 seconds on 32-bit little-endian, SQLite 3.16.0 2016-12-30 17:40:14 14d855d2b2b5b3485e0673d11405db7266b34c6d
2016-12-30 22:09:02 drhok
180k. At least one of the above on Windows.
2016-12-30 22:08:39 drhok
180a. see.c
th3: 0 errors in 1715055 tests. 1311.666 seconds on win7dev 32-bit little-endian th3: SQLite 3.16.0 2016-12-30 17:40:14 14d855d2b2b5b3485e0673d11405db7266b34c6d
2016-12-30 22:06:34 mistachkinpending
110c. th3make msvc.rc winrt.rc min.rc - Windows Runtime 8.1
2016-12-30 22:05:59 drhok
90c. Verify that Fossil repositories are cross-platform with x86/x64.
2016-12-30 22:04:25 drhok
90b. Recompile and test Fossil.
2016-12-30 22:00:07 mistachkinpending
110d. th3make msvc.rc wp80.rc min.rc - Windows Phone 8.0
2016-12-30 21:40:59 mistachkinok
110a. th3make msvc.rc winrt.rc min.rc - Windows Runtime 8.0 (x86)
0 errors in 1626271 tests. 817.156 seconds on 32-bit little-endian, SQLite 3.16.0 2016-12-30 17:40:14 14d855d2b2b5b3485e0673d11405db7266b34c6d
2016-12-30 21:35:13 drhok
130. Sqllogictest:
2016-12-30 21:35:07 drhok
130d. tclsh run-all.tcl - on windows
0 errors out of 11879758 tests and 1244 invocations in 3478 seconds
2016-12-30 21:16:50 mistachkinpending
110a. th3make msvc.rc winrt.rc min.rc - Windows Runtime 8.0 (x86)
2016-12-30 20:42:08 drhok
130c. tclsh run-all.tcl - on unix
0 errors out of 11879758 tests and 1244 invocations in 1043 seconds
2016-12-30 20:22:53 drhok
130b. No SQLite compiler warnings.
2016-12-30 20:22:45 drhok
130a. Checked in latest SQLite amalgamation.
2016-12-30 20:20:56 drhok
120. Tests for platform OpenBSD (x86):
2016-12-30 20:20:52 drhok
120b. th3make quick.rc
th3: 0 errors in 1627998 tests. 2420.317 seconds on wolfman.devio.us 32-bit little-endian th3: SQLite 3.16.0 2016-12-30 17:40:14 14d855d2b2b5b3485e0673d11405db7266b34c6d
2016-12-30 20:20:04 drhok
290. Build and verify correct operation of sqlite3_analyzer on:
2016-12-30 20:20:00 drhok
290c. Windows (MinGW)
2016-12-30 20:16:36 drhok
290d. Windows (MSVC)
2016-12-30 20:15:03 drhok
300. Build and verify sqldiff
2016-12-30 20:15:00 drhok
300c. Windows
2016-12-30 20:13:13 drhok
290b. Mac OS X
2016-12-30 20:13:09 drhok
300b. Mac
2016-12-30 20:08:29 drhok
290e. A database containing WITHOUT ROWID tables.
2016-12-30 20:08:21 drhok
310. 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.
2016-12-30 20:07:11 drhok
300a. Linux
2016-12-30 20:07:02 danok
200a. testfixture ../zipvfs/test/zipvfs.test (See test/README.txt in the ZIPVFS source tree for details.)
SQLite 2016-12-30 17:40:14 14d855d2b2b5b3485e0673d11405db7266b34c6d
2016-12-30 20:05:33 drhok
290a. Linux
2016-12-30 20:03:22 drhok
60g. sh tool/symbols.sh - no incorrect exports or dependencies
2016-12-30 19:29:13 drhok
250a. bash run-wordcount.sh sqlite3.c
22% faster on Win7. 31% faster on Android.
2016-12-30 19:26:24 drhok
120a. make test
SQLite 2016-12-30 17:40:14 14d855d2b2b5b3485e0673d11405db7266b34c6d 0 errors out of 140562 tests on wolfman.devio.us OpenBSD 32-bit little-endian
2016-12-30 18:48:01 drhok
270. Verify that the amalgamation builds are byte-for-byte identical on all workstation platforms.
2016-12-30 18:47:51 drhok
270d. Windows using native MinGW.
911cb36ff8ce628b560f5e44df99193b02f4ed99 sqlite3.c 4ccb5fd9fc8a0302e955880b38590ee221c3d696 sqlite3.h
2016-12-30 18:46:19 drhok
270b. Mac OS X
911cb36ff8ce628b560f5e44df99193b02f4ed99 sqlite3.c 4ccb5fd9fc8a0302e955880b38590ee221c3d696 sqlite3.h
2016-12-30 18:44:56 drhok
270c. OpenBSD
911cb36ff8ce628b560f5e44df99193b02f4ed99 sqlite3.c 4ccb5fd9fc8a0302e955880b38590ee221c3d696 sqlite3.h
2016-12-30 18:44:25 drhok
270e. Windows using NMAKE.
911cb36ff8ce628b560f5e44df99193b02f4ed99 sqlite3.c 4ccb5fd9fc8a0302e955880b38590ee221c3d696 sqlite3.h
2016-12-30 18:38:17 drhok
270a. Linux
911cb36ff8ce628b560f5e44df99193b02f4ed99 sqlite3.c 4ccb5fd9fc8a0302e955880b38590ee221c3d696 sqlite3.h
2016-12-30 18:28:13 drhok
170. CEROD tests in the "test/" subdirectory.
2016-12-30 18:25:47 drhok
40c. OpenBSD GCC using options -Wall
2016-12-30 11:54:13 drhok
60f. tclsh releasetest.tcl --platform Failure-Detection - all failures detected
2016-12-30 11:47:26 drhok
60e. tclsh multitest.tcl --scenario failures - all failures detected
2016-12-30 11:46:18 drhok
60b. Check the "multitest.tcl" log files for undetected errors.
2016-12-30 11:46:04 drhok
140. Build using the configure/make in main source tree.
2016-12-30 11:46:04 drhok
140a. Make sure that autoconf has been run to update the configure script.
2016-12-30 11:46:04 drhok
140b. Verify the correct version numbers have been installed.
2016-12-30 11:40:47 drhok
60a. tclsh multitest.tcl (take care to update ../th3private)
0 failures on 39 th3makes and 175130566 tests in (05:02:03) 3 cores on bella SQLite 3.16.0 2016-12-30 00:09:14 f57952bac652901e1bd48b68301941efbcf29dc4
2016-12-30 03:33:28 drhpending
60a. tclsh multitest.tcl (take care to update ../th3private)
2016-12-30 03:32:34 drhok
60d. Check the "releasetest.tcl" log files for undetected errors.
2016-12-30 03:32:22 drhok
60c. tclsh releasetest.tcl
0 failures out of 9760347 tests in (02:04:42) 2 cores on bella SQLite 3.16.0 2016-12-29 19:48:46 afcdc4a60e357d171156e0de705bf7ad1b37daab
2016-12-30 03:19:05 drhok
100b. tclsh multitest.tcl --quick on x86
0 failures on 12 th3makes and 14844207 tests in (02:32:28) on win7dev SQLite 3.16.0 2016-12-30 00:09:14 f57952bac652901e1bd48b68301941efbcf29dc4
2016-12-30 03:14:51 drhok
80a. tclsh releasetest.tcl
0 failures out of 4718538 tests in (03:50:47) on macpro01 SQLite 3.16.0 2016-12-29 19:48:46 afcdc4a60e357d171156e0de705bf7ad1b37daab
2016-12-30 01:30:03 drhok
160. Rebuild and use Firefox with the latest SQLite
2016-12-30 01:05:46 drhpending
160. Rebuild and use Firefox with the latest SQLite
2016-12-30 01:05:24 drhpending
80a. tclsh releasetest.tcl
2016-12-30 01:05:10 drhpending
100b. tclsh multitest.tcl --quick on x86
2016-12-30 01:05:04 drhpending
100a. tclsh multitest.tcl (after updating th3private)
2016-12-30 00:21:34 drhok
150. Fossil updated to use the latest SQLite.
2016-12-30 00:21:34 drhok
150a. No SQLite compiler warnings.
2016-12-30 00:21:34 drhok
150b. Used on active websites with no issues.
2016-12-30 00:21:34 drhok
150c. fossil all dbstat --db-check
2016-12-29 21:52:36 drhok
30a. Latest release on the "index.html" page.
2016-12-29 21:52:36 drhok
30b. Release announcement in "changes.in".
2016-12-29 21:52:36 drhok
30d. No unresolved hyperlinks in the documentation build.
2016-12-29 21:52:36 drhok
30e. Requirements marks are up-to-date in both documentation and source code.
2016-12-29 21:52:36 drhok
30f. The compile-time options are all up-to-date (compile.html).
2016-12-29 21:51:52 drhok
20a. No stray changes.
2016-12-29 21:51:52 drhok
20b. All significant changes are mentioned in the "changes" log of the documentation.
2016-12-29 21:51:52 drhok
20c. New code complies with style guidelines.
2016-12-29 21:51:52 drhok
20d. New code complies with design rules.
2016-12-29 21:51:52 drhok
20e. Comments have been updated to reflect code changes.
2016-12-29 21:51:52 drhok
20f. Variables and functions have been renamed to reflect changes in their use.
2016-12-29 21:51:52 drhok
20k. Significant compile-time options are recognized by the sqlite3_compileoption_used() interface.
2016-12-29 21:15:36 drhok
50. OMIT, ENABLE, and DISABLE options:
2016-12-29 21:15:29 drhok
50a. tclsh ../tool/omittest.tcl -skip_run -target libsqlite3.a
2016-12-29 19:49:34 drhok
40d. Windows (32-bit) MSVC using option /W4 (nmake /f makefile.msc USE_FULLWARN=1)
2016-12-29 19:49:18 drhok
40b. Mac OS X GCC -Wall -Wextra (the "tool/warnings.sh" script)
2016-12-29 19:48:56 drhok
40e. Windows (64-bit) MSVC using option /W4 (nmake /f makefile.msc USE_FULLWARN=1)
2016-12-29 19:37:00 drhok
40a. Linux GCC -Wall -Wextra (the "tool/warnings.sh" script)