SQLite

Checklist For SQLite 3.17.0
Login
2017-02-12 21:11:09 drhok+
100f. nmake /f makefile.msc MEMDEBUG=1 DEBUG=3 test
SQLite 2017-02-09 17:12:22 798fb9d70d2e5f95e64237b04d6692360133381a 0 errors out of 112902 tests on DESKTOP-8U9G1N8 Windows NT 64-bit little-endian SQLite 2017-02-11 15:02:23 b2e49ae36bfd00a1d0b70a9de9d23d2e16d1c7ca 0 errors out of 112901 tests on DESKTOP-8U9G1N8 Windows NT 64-bit little-endian
2017-02-12 20:52:50 drhok+
100d. tclsh test/releasetest.tcl --msvc
0 failures out of 1959590 tests in (02:02:22) on DESKTOP-8U9G1N8 SQLite 3.17.0 2017-02-09 17:12:22 798fb9d70d2e5f95e64237b04d6692360133381a 0 failures out of 1959538 tests in (02:03:28) on DESKTOP-8U9G1N8 SQLite 3.17.0 2017-02-11 15:02:23 b2e49ae36bfd00a1d0b70a9de9d23d2e16d1c7ca
2017-02-12 10:36:27 drhok+
60a. tclsh multitest.tcl (take care to update ../th3private)
0 failures on 42 th3makes and 182108515 tests in (05:11:09) 3 cores on bella SQLite 3.17.0 2017-02-09 17:12:22 798fb9d70d2e5f95e64237b04d6692360133381a 0 failures on 42 th3makes and 182114770 tests in (05:25:24) 3 cores on bella SQLite 3.17.0 2017-02-11 15:02:23 b2e49ae36bfd00a1d0b70a9de9d23d2e16d1c7ca
2017-02-12 03:12:53 drhok+
100b. tclsh multitest.tcl --quick on x86
0 failures on 15 th3makes and 20760885 tests in (03:56:30) on win7dev SQLite 3.17.0 2017-02-09 17:12:22 798fb9d70d2e5f95e64237b04d6692360133381a 0 failures on 15 th3makes and 20762136 tests in (03:57:21) on win7dev SQLite 3.17.0 2017-02-11 15:02:23 b2e49ae36bfd00a1d0b70a9de9d23d2e16d1c7ca
2017-02-12 02:39:34 drhok+
80a. tclsh releasetest.tcl
0 failures out of 4657851 tests in (02:37:43) on macpro01 SQLite 3.17.0 2017-02-09 17:12:22 798fb9d70d2e5f95e64237b04d6692360133381a 0 failures out of 4657973 tests in (02:37:31) on macpro01 SQLite 3.17.0 2017-02-11 15:02:23 b2e49ae36bfd00a1d0b70a9de9d23d2e16d1c7ca
2017-02-11 07:20:35 danok
200. ZIPVFS tests:
2017-02-11 07:20:20 danok
200d. th3make zipvfs.rc quick.rc -valgrind
th3: 0 errors in 2770033 tests. 24322.550 seconds on darkstar 64-bit little-endian th3: SQLite 3.17.0 2017-02-09 17:12:22 798fb9d70d2e5f95e64237b04d6692360133381a ==32082== total heap usage: 373,212,623 allocs, 373,212,622 frees, 2,445,661,674,186 bytes allocated ==32082== ERROR SUMMARY: 0 errors from 0 contexts (suppressed: 0 from 0)
2017-02-11 02:38:35 mistachkinok
110. Tests for alternative and special-purpose Windows systems
2017-02-11 02:38:30 mistachkinok
110b. th3make msvc.rc winrt.rc min.rc - Windows Runtime 8.0 (ARM)
798fb9d70d2e5f95e64237b04d6692360133381a, 0 errors in 1615636 tests. 5030.960 seconds on 32-bit little-endian
2017-02-11 00:02:02 mistachkinpending
110b. th3make msvc.rc winrt.rc min.rc - Windows Runtime 8.0 (ARM)
2017-02-10 22:51:56 mistachkinok
110d. th3make msvc.rc wp80.rc min.rc - Windows Phone 8.0
798fb9d70d2e5f95e64237b04d6692360133381a, 0 errors in 1614366 tests. 984.548 seconds on 32-bit little-endian
2017-02-10 22:51:22 mistachkinok
110e. th3make msvc.rc wp81.rc min.rc - Windows Phone 8.1
798fb9d70d2e5f95e64237b04d6692360133381a, 0 errors in 1614373 tests. 3374.545 seconds on 32-bit little-endian
2017-02-10 22:33:56 mistachkinok
350. System.Data.SQLite builds and checks out using the SQLite core.
2017-02-10 22:33:51 mistachkinok
350b. Using Mono on unix
798fb9d70d2e5f95e64237b04d6692360133381a, Debug Mono 4.6.1 on Ubuntu 15.10 x86_64: 0 errors/569 tests, 589 seconds, Release Mono 4.6.1 on Ubuntu 15.10 x86_64: 0 errors/569 tests, 547 seconds
2017-02-10 22:25:58 mistachkinpending
110d. th3make msvc.rc wp80.rc min.rc - Windows Phone 8.0
2017-02-10 22:09:26 mistachkinpending
110. Tests for alternative and special-purpose Windows systems
2017-02-10 22:09:19 mistachkinpending
350. System.Data.SQLite builds and checks out using the SQLite core.
2017-02-10 21:53:02 mistachkinok
350a. Using Microsoft .NET Framework on Windows
798fb9d70d2e5f95e64237b04d6692360133381a, Debug NetFx46 x86: 0 errors/569 tests, 968 seconds, Release NetFx46 x86: 0 errors/569 tests, 933 seconds, Debug NetFx451 x64: 0 errors/569 tests, 946 seconds, Release NetFx451 x64: 0 errors/569 tests, 920 seconds, 0 errors/24 tests (Debug NetCF20-ARM/NetCF35-ARM), 0 errors/24 tests (Release NetCF20-ARM/NetCF35-ARM)
2017-02-10 21:52:36 mistachkinpending
350b. Using Mono on unix
2017-02-10 21:52:28 mistachkinpending
110e. th3make msvc.rc wp81.rc min.rc - Windows Phone 8.1
2017-02-10 20:51:24 mistachkinok
110c. th3make msvc.rc winrt.rc min.rc - Windows Runtime 8.1
798fb9d70d2e5f95e64237b04d6692360133381a, 0 errors in 1615653 tests. 7427.643 seconds on 32-bit little-endian
2017-02-10 19:55:36 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.
798fb9d70d2e5f95e64237b04d6692360133381a, 0 errors in 1622442 tests. 3955.743 seconds on 32-bit little-endian
2017-02-10 18:14:31 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.
2017-02-10 18:08:48 mistachkinpending
350a. Using Microsoft .NET Framework on Windows
2017-02-10 18:07:24 mistachkinok
110a. th3make msvc.rc winrt.rc min.rc - Windows Runtime 8.0 (x86)
798fb9d70d2e5f95e64237b04d6692360133381a, 0 errors in 1615638 tests. 785.024 seconds on 32-bit little-endian
2017-02-10 17:57:10 drhok
30. Documentation review:
2017-02-10 17:57:05 drhok
30i. Check new/changed documentation for spelling and gramatical mistakes.
2017-02-10 17:56:58 drhok
30c. Release accouncement in "news.html".
2017-02-10 17:55:06 mistachkinpending
110c. th3make msvc.rc winrt.rc min.rc - Windows Runtime 8.1
2017-02-10 17:38:36 mistachkinpending
110a. th3make msvc.rc winrt.rc min.rc - Windows Runtime 8.0 (x86)
2017-02-10 16:34:38 drhok
100. Tests for platform Windows:
2017-02-10 16:34:32 drhok
100i. Verify that EXEs and DLLs generated using MSVC contain the correct version number, product name, description, and copyright as resources.
2017-02-10 16:33:48 drhok
100g. nmake /f makefile.msc WIN32HEAP=1 DEBUG=4 test
SQLite 2017-02-09 17:12:22 798fb9d70d2e5f95e64237b04d6692360133381a 0 errors out of 113959 tests on DESKTOP-8U9G1N8 Windows NT 64-bit little-endian
2017-02-10 14:36:07 drhok
100f. nmake /f makefile.msc MEMDEBUG=1 DEBUG=3 test
SQLite 2017-02-09 17:12:22 798fb9d70d2e5f95e64237b04d6692360133381a 0 errors out of 112902 tests on DESKTOP-8U9G1N8 Windows NT 64-bit little-endian
2017-02-10 14:31:59 drhok
200h. At least one of the above on Windows.
2017-02-10 14:31:44 drhok
200e. th3make zipvfs.rc quick.rc
th3: 0 errors in 2830781 tests. 3998.995 seconds on win7dev 32-bit little-endian th3: SQLite 3.17.0 2017-02-09 17:12:22 798fb9d70d2e5f95e64237b04d6692360133381a
2017-02-10 14:07:44 danok
120. Tests for platform OpenBSD (x86):
2017-02-10 14:07:32 danok
120b. th3make quick.rc
th3: 0 errors in 1730318 tests. 679.285 seconds on obsd.my.domain 32-bit little-endian th3: SQLite 3.17.0 2017-02-09 17:12:22 798fb9d70d2e5f95e64237b04d6692360133381a
2017-02-10 14:06:38 drhok++
120a. make test
SQLite 2017-02-09 17:12:22 798fb9d70d2e5f95e64237b04d6692360133381a 0 errors out of 140648 tests on wolfman.devio.us OpenBSD 32-bit little-endian
2017-02-10 14:06:21 drhok+
120a. make test
2017-02-10 14:04:38 drhok
100e. tclsh releasetest.tcl --platform Failure-Detection - all failures detected
2017-02-10 14:00:29 drhok
100d. tclsh test/releasetest.tcl --msvc
0 failures out of 1959590 tests in (02:02:22) on DESKTOP-8U9G1N8 SQLite 3.17.0 2017-02-09 17:12:22 798fb9d70d2e5f95e64237b04d6692360133381a
2017-02-10 14:00:24 danok
120a. make test
fuzzcheck: 0 errors out of 33550 tests in 41.883 seconds SQLite 2017-02-09 17:12:22 798fb9d70d2e5f95e64237b04d6692360133381a 0 errors out of 140698 tests on obsd.my.domain OpenBSD 32-bit little-endian
2017-02-10 13:51:40 danpending
120b. th3make quick.rc
2017-02-10 13:50:43 danpending+
120a. make test
fuzzcheck: 0 errors out of 33550 tests in 41.883 seconds
2017-02-10 13:49:46 danpending
120a. make test
2017-02-10 13:47:07 danok
200g. At least one of the above on Mac OS X.
(c) ran on osx.
2017-02-10 13:46:49 danok
200c. th3make zipvfs.rc memdebug.rc
th3: 0 errors in 8223939 tests. 15875.892 seconds on Chanphen-Kruatawongs-iMac.local 64-bit little-endian th3: SQLite 3.17.0 2017-02-09 17:12:22 798fb9d70d2e5f95e64237b04d6692360133381a
2017-02-10 13:43:35 drhok
30h. Test metrics are up-to-date (testing.html).
2017-02-10 13:43:23 drhok
20. Source code change review. fossil diff --from release --to trunk
2017-02-10 13:43:23 drhok
20f. Variables and functions have been renamed to reflect changes in their use.
2017-02-10 13:43:23 drhok
20g. Check all calls to sqlite3OsRead() and sqlite3OsWrite() to ensure that offset computations are 64-bit clean.
2017-02-10 13:43:23 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]*(/
2017-02-10 13:43:23 drhok
20i. Verify that source code contains no tabs and that surplus whitespace has been removed.
2017-02-10 13:43:23 drhok
20j. Verify that the list of APIs exposed via the extension header is up-to-date (sqlite3ext.h).
2017-02-10 13:43:01 drhok
20k. Significant compile-time options are recognized by the sqlite3_compileoption_used() interface.
2017-02-10 13:42:14 drhok
180. SEE tests using TH3:
2017-02-10 13:42:10 drhok
180d. see-rc4.c
th3: 0 errors in 1670517 tests. 251.958 seconds on bella 64-bit little-endian th3: SQLite 3.17.0 2017-02-09 17:12:22 798fb9d70d2e5f95e64237b04d6692360133381a
2017-02-10 13:41:49 drhok
30g. Database footprint is up-to-date (features.html).
2017-02-10 13:41:35 drhok
40. Compiler warning checks.
2017-02-10 13:41:31 drhok
40c. OpenBSD GCC using options -Wall
2017-02-10 13:36:58 drhok
180a. see.c
th3: 0 errors in 1670446 tests. 214.529 seconds on bella 64-bit little-endian th3: SQLite 3.17.0 2017-02-09 17:12:22 798fb9d70d2e5f95e64237b04d6692360133381a
2017-02-10 13:28:48 drhok
270. Compare performance to the previous release using kvtest.
2017-02-10 13:28:45 drhok
270b. Linux
1.170 to 1.143 (2.3% faster)
2017-02-10 13:26:51 drhok
300. Verify that the amalgamation builds are byte-for-byte identical on all workstation platforms.
2017-02-10 13:26:48 drhok
300c. OpenBSD
3a8ee628b6f53216342767536d975309da1248d1 sqlite3.c 3103d3da7ea57a8c42963efed095ace7102302ad sqlite3.h
2017-02-10 13:23:01 drhpending
200e. th3make zipvfs.rc quick.rc
on windows
2017-02-10 13:20:12 drhok
10. Test procedure review.
2017-02-10 13:20:09 drhok
10a. Review the "test/releasetest.tcl" script for completeness and accuracy.
2017-02-10 13:17:57 drhok
270c. Mac
1.652 to 1.621 (1.9% faster)
2017-02-10 13:16:10 drhok
240. Performance tests using speedtest1 compared against the previous release and a release from about one year ago.
2017-02-10 13:16:04 drhok
240c. Mac
4.939 to 4.779 (3.2% faster)
2017-02-10 13:10:27 drhok
270d. Windows
1.363 to 1.342 (1.5% faster) on win7dev with --blob-api
2017-02-10 12:21:51 drhok
40d. Windows (32-bit) MSVC using option /W4 (nmake /f makefile.msc USE_FULLWARN=1)
2017-02-10 12:19:47 drhok
180j. At least one of the above on Mac OS X.
2017-02-10 12:19:32 drhok
180f. see-cccrypt.c
th3: 0 errors in 1654111 tests. 247.705 seconds on macpro01 64-bit little-endian th3: SQLite 3.17.0 2017-02-09 17:12:22 798fb9d70d2e5f95e64237b04d6692360133381a
2017-02-10 12:08:59 drhok
190. SEE using configure; make test
2017-02-10 12:08:54 drhok
190b. Mac
SQLite 2017-02-08 16:01:57 77b470b0df73dc5ae5ad2f0170ef7c50558c7c88 0 errors out of 139920 tests on macpro01 Darwin 64-bit little-endian
2017-02-10 11:55:58 drhok
100c. tclsh multitest.tcl --scenario failures - verify failures detected
2017-02-10 11:54:20 drhok
100a. tclsh multitest.tcl (after updating th3private)
0 failures on 36 th3makes and 138039061 tests in (09:42:45) 2 cores on DESKTOP-8U9G1N8 SQLite 3.17.0 2017-02-09 17:12:22 798fb9d70d2e5f95e64237b04d6692360133381a
2017-02-10 11:52:12 drhok
80. Tests for platform Mac OS X:
2017-02-10 11:52:04 drhok
80b. tclsh multitest.tcl --omit test-ex (after updating th3private)
0 failures on 33 th3makes and 134118669 tests in (07:12:01) 2 cores on macpro01 SQLite 3.17.0 2017-02-09 17:12:22 798fb9d70d2e5f95e64237b04d6692360133381a
2017-02-10 09:45:52 danok
210. NDS-Devkit testing
2017-02-10 09:45:45 danok+
210b. Test using: tclsh th3make test.rc nds_devkit.rc
th3: 0 errors in 6982330 tests. 1429.832 seconds on darkstar 64-bit little-endian th3: NDS DevKit 3.17.0 2017-02-10 09:14:35 6e1b95f3de0a542d th3: SQLite 3.17.0 2017-02-09 17:12:22 798fb9d70d2e5f95e64237b04d6692360133381a
2017-02-10 09:45:31 danok
210c. Verify the "NDS DevKit" version number shown at the end of the test
th3: NDS DevKit 3.17.0 2017-02-10 09:14:35 6e1b95f3de0a542d
2017-02-10 09:41:29 danok
210b. Test using: tclsh th3make test.rc nds_devkit.rc
th3: 0 errors in 6982330 tests. 1429.832 seconds on darkstar 64-bit little-endian th3: NDS DevKit 3.17.0 2017-02-10 09:14:35 6e1b95f3de0a542d
2017-02-10 09:20:49 danpending
80b. tclsh multitest.tcl --omit test-ex (after updating th3private)
2017-02-10 09:19:43 danok
70. Tests for platform Linux ARM (BeagleBoard)
2017-02-10 09:19:35 danok
70a. tclsh th3make min.rc
th3: 0 errors in 1619422 tests. 4791.346 seconds on beaglebone 32-bit little-endian th3: SQLite 3.17.0 2017-02-09 17:12:22 798fb9d70d2e5f95e64237b04d6692360133381a
2017-02-10 09:16:49 danpending
210b. Test using: tclsh th3make test.rc nds_devkit.rc
2017-02-10 09:14:08 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-02-10 09:09:10 danok
200i. th3make zipvfs-cov.rc - verify full coverage
th3: 0 errors in 1229220 tests. 347.605 seconds on darkstar 64-bit little-endian th3: SQLite 3.17.0 2017-02-09 17:12:22 798fb9d70d2e5f95e64237b04d6692360133381a Statement coverage: 100.00% hit 1573 missed 0 total 1573 Branch coverage: 100.00% hit 931 missed 0 total 931
2017-02-10 09:06:47 danok+
310. 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 backcompat.test. SQLite 2017-02-09 17:12:22 798fb9d70d2e5f95e64237b04d6692360133381a 0 errors out of 265 tests on darkstar Linux 64-bit little-endian
2017-02-10 09:06:28 danok
310. 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 backcompat.test.
2017-02-10 09:04:24 dan---
200e. th3make zipvfs.rc quick.rc
2017-02-10 09:04:10 danpending
200c. th3make zipvfs.rc memdebug.rc
on osx.
2017-02-10 09:03:46 dan---
200c. th3make zipvfs.rc memdebug.rc
2017-02-10 09:03:08 danpending
200d. th3make zipvfs.rc quick.rc -valgrind
2017-02-10 09:00:21 danpending
200e. th3make zipvfs.rc quick.rc
on osx.
2017-02-10 09:00:04 danpending
200i. th3make zipvfs-cov.rc - verify full coverage
2017-02-10 08:57:45 danpending
200c. th3make zipvfs.rc memdebug.rc
2017-02-10 08:56:00 danok
200f. At least one of the above on Linux.
(a) and (b) ran on Linux.
2017-02-10 08:55:34 danok
200b. th3make zipvfs.rc test.rc
th3: 0 errors in 9943792 tests. 2536.998 seconds on darkstar 64-bit little-endian th3: SQLite 3.17.0 2017-02-09 17:12:22 798fb9d70d2e5f95e64237b04d6692360133381a
2017-02-10 08:55:16 danok
200a. testfixture ../zipvfs/test/zipvfs.test (See test/README.txt in the ZIPVFS source tree for details.)
SQLite 2017-02-09 17:12:22 798fb9d70d2e5f95e64237b04d6692360133381a 0 errors out of 85659 tests on darkstar Linux 64-bit little-endian
2017-02-10 08:55:08 danpending+
200a. testfixture ../zipvfs/test/zipvfs.test (See test/README.txt in the ZIPVFS source tree for details.)
SQLite 2017-02-09 17:12:22 798fb9d70d2e5f95e64237b04d6692360133381a 0 errors out of 85659 tests on darkstar Linux 64-bit little-endian
2017-02-10 08:54:12 danpending
70a. tclsh th3make min.rc
2017-02-10 08:54:04 danok
70b. Recompile and test Fossil.
[fossil all rebuild] works. [fossil update], [fossil open] seem to work.
2017-02-10 08:53:49 danok
70a. tclsh th3make min.rc
[fossil all rebuild] works. [fossil update], [fossil open] seem to work.
2017-02-10 08:09:06 danpending
200a. testfixture ../zipvfs/test/zipvfs.test (See test/README.txt in the ZIPVFS source tree for details.)
2017-02-10 08:08:56 danpending
200b. th3make zipvfs.rc test.rc
2017-02-10 08:06:58 danok
200a. testfixture ../zipvfs/test/zipvfs.test (See test/README.txt in the ZIPVFS source tree for details.)
2017-02-10 08:01:49 danok
80c. tclsh multitest.tcl --scenario failures - all failures detected
2 failures on 2 th3makes and 42 tests in (00:00:28) on Chanphen-Kruatawongs-iMac.local SQLite 3.17.0 2017-02-09 17:12:22 798fb9d70d2e5f95e64237b04d6692360133381a
2017-02-10 07:51:11 danpending
70b. Recompile and test Fossil.
2017-02-10 07:46:13 danpending
70a. tclsh th3make min.rc
2017-02-10 07:38:36 danok
60. Tests for platform Linux x86_64:
2017-02-10 07:38:30 danok
60d. Check the "releasetest.tcl" log files for undetected errors.
2017-02-10 03:48:26 drhok
260. Run make wordcount; bash run-wordcount.bash $OPTIONS with options:
2017-02-10 03:48:20 drhok
260b. bash run-wordcount.sh sqlite3.c --cachesize 5 --nosync
39.825 to 32.037 (20% faster) on bella
2017-02-10 03:45:41 drhok
260a. bash run-wordcount.sh sqlite3.c
27.231 to 22.671 (17% faster) on bella
2017-02-10 03:41:19 drhok
250. Performance tests using speedtest1 --testset rtree
2017-02-10 03:41:14 drhok
250b. Windows
35.339 to 25.374 (28% faster) on win7dev
2017-02-10 03:37:58 drhok
240d. Windows
17.508 to 16.866 (3.7% faster) on win2dev
2017-02-10 03:29:08 drhok
250a. Linux
11.421 to 7.788 (33% faster)
2017-02-10 03:27:25 drhok
240b. Linux
3.909 to 3.789 (3% faster)
2017-02-10 03:23:01 drhok
180g. At least one of the above using "test.rc".
2017-02-10 03:22:53 drhok+
180e. see-aes128-ccm.c
th3: 0 errors in 8133109 tests. 2417.506 seconds on bella 64-bit little-endian th3: SQLite 3.17.0 2017-02-09 17:12:22 798fb9d70d2e5f95e64237b04d6692360133381a test.rc
2017-02-10 03:22:38 drhok
180e. see-aes128-ccm.c
2017-02-10 02:40:22 drhok
220. Amalgamation autoconf tarball.
2017-02-10 02:40:18 drhok
220d. Works on Windows MinGW
2017-02-10 02:36:54 drhok
230. TEA archive builds correctly and runs:
2017-02-10 02:36:50 drhok
230b. Mac OS X
2017-02-10 02:33:12 drhok
220e. Works on Windows MSVC
2017-02-10 02:30:56 drhok
180k. At least one of the above on Windows.
2017-02-10 02:30:49 drhok
180b. see-aes128-ofb.c
th3: 0 errors in 1707035 tests. 1236.487 seconds on win7dev 32-bit little-endian th3: SQLite 3.17.0 2017-02-09 17:12:22 798fb9d70d2e5f95e64237b04d6692360133381a quick.rc
2017-02-10 02:24:40 drhok
220c. Works on Mac OS X.
2017-02-10 02:23:21 drhok
180i. At least one of the above on Linux.
2017-02-10 02:23:17 drhok
180h. At least one of the above using "memdebug.rc".
2017-02-10 02:23:10 drhok
180c. see-aes256-ofb.c
th3: 0 errors in 8131312 tests. 4533.525 seconds on bella 64-bit little-endian th3: SQLite 3.17.0 2017-02-09 17:12:22 798fb9d70d2e5f95e64237b04d6692360133381a memdebug.rc
2017-02-10 02:19:12 drhok
220a. Builds.
2017-02-10 02:18:40 drhok
230a. Linux
2017-02-10 02:16:45 drhok
220b. Works on Linux.
2017-02-10 02:02:03 drhok
140. Build using the configure/make in main source tree.
2017-02-10 02:02:03 drhok
140a. Make sure that autoconf has been run to update the configure script.
2017-02-10 02:02:03 drhok
140b. Verify the correct version numbers have been installed.
2017-02-10 01:58:53 drhok
320. Build and verify correct operation of sqlite3_analyzer on:
2017-02-10 01:58:49 drhok
320c. Windows (MinGW)
2017-02-10 01:57:16 drhok
300d. Windows using native MinGW.
3a8ee628b6f53216342767536d975309da1248d1 sqlite3.c 3103d3da7ea57a8c42963efed095ace7102302ad sqlite3.h
2017-02-10 01:53:24 drhok
130. Sqllogictest:
2017-02-10 01:53:18 drhok
130c. tclsh run-all.tcl - on unix
0 errors out of 11879758 tests and 1244 invocations in 753 seconds
2017-02-10 01:52:53 drhok
130d. tclsh run-all.tcl - on windows
0 errors out of 11879758 tests and 1244 invocations in 3401 seconds
2017-02-10 01:46:53 drhok
330. Build and verify sqldiff
2017-02-10 01:46:49 drhok
330c. Windows
2017-02-10 01:43:15 drhok
330b. Mac
2017-02-10 01:39:38 drhok
320b. Mac OS X
2017-02-10 01:36:41 drhok
130b. No SQLite compiler warnings.
2017-02-10 01:36:37 drhok
130a. Checked in latest SQLite amalgamation.
2017-02-10 01:35:12 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.
2017-02-10 01:34:04 drhok
330a. Linux
2017-02-10 01:33:23 drhok
320a. Linux
2017-02-10 01:33:19 drhok
320e. A database containing WITHOUT ROWID tables.
2017-02-10 01:29:34 drhok
270a. Android
1.131 to 0.998 (11.8% faster) with x10k.db on GalaxyS3 Android 4.4.2
2017-02-10 01:24:18 drhok
240a. Android
72.689 vs 68.639 (5.6% faster) on GalaxyS3 Android 4.4.2.
2017-02-10 01:13:31 drhok
170. CEROD tests in the "test/" subdirectory.
2017-02-10 01:03:38 drhok
90. Tests for platform Mac OS X 10.2 (PPC):
2017-02-10 01:03:18 drhok
90a. tclsh th3make quick.rc
th3: 0 errors in 1982594 tests. 12033.773 seconds on crabapple.local. 32-bit big-endian th3: SQLite 3.17.0 2017-02-09 17:12:22 798fb9d70d2e5f95e64237b04d6692360133381a
2017-02-10 01:00:16 drhok
190a. Linux
SQLite 2017-02-08 16:01:57 77b470b0df73dc5ae5ad2f0170ef7c50558c7c88 0 errors out of 140535 tests on bella Linux 64-bit little-endian
2017-02-10 00:56:09 drhok
60f. tclsh releasetest.tcl --platform Failure-Detection - all failures detected
2017-02-10 00:51:26 drhok
100h. sh tool/symbols-mingw.sh - no incorrect exports or dependencies
2017-02-10 00:49:19 drhok
60e. tclsh multitest.tcl --scenario failures - all failures detected
5 failures on 5 th3makes and 118 tests in (00:00:32) on bella SQLite 3.17.0 2017-02-09 17:12:22 798fb9d70d2e5f95e64237b04d6692360133381a
2017-02-10 00:46:58 drhok
100b. tclsh multitest.tcl --quick on x86
0 failures on 15 th3makes and 20760885 tests in (03:56:30) on win7dev SQLite 3.17.0 2017-02-09 17:12:22 798fb9d70d2e5f95e64237b04d6692360133381a
2017-02-10 00:45:30 drhok
60b. Check the "multitest.tcl" log files for undetected errors.
2017-02-10 00:44:51 drhok
60a. tclsh multitest.tcl (take care to update ../th3private)
0 failures on 42 th3makes and 182108515 tests in (05:11:09) 3 cores on bella SQLite 3.17.0 2017-02-09 17:12:22 798fb9d70d2e5f95e64237b04d6692360133381a
2017-02-09 23:13:53 drhok
40e. Windows (64-bit) MSVC using option /W4 (nmake /f makefile.msc USE_FULLWARN=1)
2017-02-09 23:09:04 drhok
320d. Windows (MSVC)
2017-02-09 23:07:25 drhok
300e. Windows using NMAKE.
3a8ee628b6f53216342767536d975309da1248d1 sqlite3.c 3103d3da7ea57a8c42963efed095ace7102302ad sqlite3.h
2017-02-09 23:06:19 drhok
290. Verify that the performance and size measurement spreadsheet in the documentation (misc/speed-size-graph.ods) is up-to-date.
2017-02-09 23:05:51 drhok
280. Use dbselftest to verify that legacy database files are readable and cross-platform
2017-02-09 23:05:46 drhok
280d. Windows
SQLite 2017-02-09 17:12:22 798fb9d70d2e5f95e64237b04d6692360133381a 0 errors out of 357 tests on 6 databases
2017-02-09 23:01:16 drhok
50. OMIT, ENABLE, and DISABLE options:
2017-02-09 23:01:13 drhok
50a. tclsh ../tool/omittest.tcl -skip_run -target libsqlite3.a
2017-02-09 23:00:49 drhok
300b. Mac OS X
3a8ee628b6f53216342767536d975309da1248d1 sqlite3.c 3103d3da7ea57a8c42963efed095ace7102302ad sqlite3.h
2017-02-09 23:00:42 drhok
300a. Linux
3a8ee628b6f53216342767536d975309da1248d1 sqlite3.c 3103d3da7ea57a8c42963efed095ace7102302ad sqlite3.h
2017-02-09 22:57:21 drhok
280c. Mac
SQLite 2017-02-09 17:12:22 798fb9d70d2e5f95e64237b04d6692360133381a 0 errors out of 357 tests on 6 databases
2017-02-09 22:56:39 drhok
280b. Linux
SQLite 2017-02-09 17:12:22 798fb9d70d2e5f95e64237b04d6692360133381a 0 errors out of 357 tests on 6 databases
2017-02-09 22:51:36 drhok
60g. sh tool/symbols.sh - no incorrect exports or dependencies
2017-02-09 22:49:46 drhok
40b. Mac OS X GCC -Wall -Wextra (the "tool/warnings.sh" script)
2017-02-09 22:49:00 drhok
80d. tclsh releasetest.tcl --platform Failure-Detection - all failures detected
2017-02-09 22:31:13 drhok
80a. tclsh releasetest.tcl
0 failures out of 4657851 tests in (02:37:43) on macpro01 SQLite 3.17.0 2017-02-09 17:12:22 798fb9d70d2e5f95e64237b04d6692360133381a
2017-02-09 20:54:08 danok
60c. tclsh releasetest.tcl
0 failures out of 9746664 tests in (01:43:37) 3 cores on darkstar SQLite 3.17.0 2017-02-09 17:12:22 798fb9d70d2e5f95e64237b04d6692360133381a
2017-02-09 20:37:35 drhok
280a. iBook PPC
SQLite 2017-02-09 17:12:22 798fb9d70d2e5f95e64237b04d6692360133381a 0 errors out of 357 tests on 6 databases
2017-02-09 20:28:32 drhok
160. Rebuild and use Firefox with the latest SQLite
2017-02-09 20:28:28 drhok
160a. Routine use with no problems
2017-02-09 20:27:55 drhok
160d. ./mach web-platform-tests IndexedDB
2017-02-09 20:25:47 drhok
160c. ./mach xpcshell-test dom/indexedDB
2017-02-09 20:24:46 drhok
90c. Verify that Fossil repositories are cross-platform with x86/x64.
2017-02-09 20:24:41 drhok
90b. Recompile and test Fossil.
2017-02-09 20:23:40 drhok
160b. ./mach mochitest dom/indexedDB
2017-02-09 20:05:25 drhok
150. Fossil updated to use the latest SQLite.
2017-02-09 20:05:21 drhok
150c. fossil all dbstat --db-check
2017-02-09 20:00:29 drhok
150b. Used on active websites with no issues.
2017-02-09 20:00:25 drhok
150a. No SQLite compiler warnings.
2017-02-09 19:54:29 drhok
40a. Linux GCC -Wall -Wextra (the "tool/warnings.sh" script)
2017-02-09 19:53:16 drhok
30e. Requirements marks are up-to-date in both documentation and source code.
2017-02-09 19:53:10 drhok
30d. No unresolved hyperlinks in the documentation build.
2017-02-09 19:52:56 drhok
30f. The compile-time options are all up-to-date (compile.html).
2017-02-09 19:51:38 drhok
30b. Release announcement in "changes.in".
2017-02-09 19:51:34 drhok
30a. Latest release on the "index.html" page.
2017-02-09 19:51:25 drhok
20e. Comments have been updated to reflect code changes.
2017-02-09 19:51:21 drhok
20d. New code complies with design rules.
2017-02-09 19:51:17 drhok
20c. New code complies with style guidelines.
2017-02-09 19:51:13 drhok
20a. No stray changes.
2017-02-09 19:51:06 drhok
20b. All significant changes are mentioned in the "changes" log of the documentation.
2017-02-09 19:51:00 drhok
10c. Review this checklist for completeness and accuracy.
2017-02-09 19:09:57 drhok
10b. Review "multitest.tcl" and "alignment*.rc" scripts in TH3 for completeness.