SQLite

Checklist For SQLite 3.13.0
Login
2016-05-18 10:55:44 drhok
30. Documentation review:
2016-05-18 10:55:28 drhok
30c. Release accouncement in "news.html".
2016-05-17 23:39:56 drhok
80. Tests for platform Mac OS X (x86):
2016-05-17 20:58:52 danok
80b. tclsh multitest.tcl --omit test-ex (after updating th3private)
2016-05-17 13:09:28 drhok
80d. tclsh releasetest.tcl --platform Failure-Detection - all failures detected
16 failures out of 202 tests in (00:24:47) on macpro SQLite 3.13.0 2016-05-16 14:35:15 995c084bde44e678facc5f5d95a2335ce61e57b0
2016-05-17 11:22:29 drhfail
80d. tclsh releasetest.tcl --platform Failure-Detection - all failures detected
After updating to "Command Line Tools for Xcode version 7.3" the kernel panics have seemingly stopped and the test runs to completion. Later: None of the tests will even build after the Xcode update, due to problems with the TCL library. So even though all the tests failed as expected, they did not fail for the right reason.
2016-05-16 15:41:32 drhok
30i. Check new/changed documentation for spelling and gramatical mistakes.
2016-05-16 15:24:13 drhok
80c. tclsh multitest.tcl --scenario failures - all failures detected
2016-05-16 15:23:56 drhpending
80c. tclsh multitest.tcl --scenario failures - all failures detected
2016-05-16 15:22:09 drhok
80d. tclsh releasetest.tcl --platform Failure-Detection - all failures detected
After updating to "Command Line Tools for Xcode version 7.3" the kernel panics have seemingly stopped and the test runs to completion.
2016-05-16 15:10:21 drhok
100. Tests for platform Windows 7.0/8.x (x86):
2016-05-16 15:10:15 drhok
100c. tclsh test/releasetest.tcl
0 failures out of 1255637 tests in (02:55:23) on poulenc SQLite 3.13.0 2016-05-16 11:55:09 386bcbba8ed733ee84958e6bd6e9d33c150e6c18
2016-05-16 14:12:07 drhfail
80d. tclsh releasetest.tcl --platform Failure-Detection - all failures detected
Kernel panic in ElCapitan.
2016-05-16 13:37:02 drhok
220. NX-Devkit testing
2016-05-16 13:36:58 drhok
220d. Verify failure if run without -DNDS_ENABLE_COMPRESS
2016-05-16 13:36:34 drhok
220c. Test using: tclsh th3make test.rc nxc.o -DNDS_ENABLE_COMPRESS
th3: 0 errors in 6974221 tests. 1206.201 seconds on bella 64-bit little-endian th3: SQLite 3.13.0 2016-05-16 11:55:09 386bcbba8ed733ee84958e6bd6e9d33c150e6c18
2016-05-16 12:47:43 drhfail
220c. Test using: tclsh th3make test.rc nxc.o -DNDS_ENABLE_COMPRESS
th3: 41 errors in 6974246 tests. 1177.111 seconds on bella 64-bit little-endian th3: SQLite 3.13.0 2016-05-16 11:55:09 386bcbba8ed733ee84958e6bd6e9d33c150e6c18d
2016-05-16 12:05:25 drhpending
220c. Test using: tclsh th3make test.rc nxc.o -DNDS_ENABLE_COMPRESS
2016-05-16 12:05:19 drhok
220b. Build using: sh mkdevkit.sh; gcc -o nxc.o -c nx_compress.c
2016-05-16 12:05:15 drhok
220a. 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.
2016-05-16 11:56:44 drhok
60f. tclsh releasetest.tcl --platform Failure-Detection - all failures detected
2016-05-16 11:40:53 drhok
30h. Test metrics are up-to-date (testing.html).
2016-05-16 11:40:48 drhok
30g. Database footprint is up-to-date (features.html).
2016-05-16 11:40:32 drhok
30f. The compile-time options are all up-to-date (compile.html).
2016-05-16 11:39:53 drhok
70. Tests for platform Linux ARM (BeagleBoard)
2016-05-16 11:39:47 drhok
60e. tclsh multitest.tcl --scenario failures - all failures detected
2016-05-16 11:38:29 drhok
60d. Check the "releasetest.tcl" log files for undetected errors.
2016-05-16 11:38:25 drhok
60b. Check the "multitest.tcl" log files for undetected errors.
2016-05-15 01:38:27 drhok+
60a. tclsh multitest.tcl (take care to update ../th3private)
0 failures on 35 th3makes and 170649867 tests in (04:20:58) 4 cores on bella SQLite 3.13.0 2016-05-11 20:03:23 3bfd2621d13b4f842f3af6d35519653f4eb8cad7 0 failures on 35 th3makes and 170694991 tests in (04:22:51) 4 cores on bella SQLite 3.13.0 2016-05-13 17:22:33 b369980f0c4550a9034833caa2c7c85d6030f5ff
2016-05-14 20:28:41 drhok+
190a. see.c
th3: 0 errors in 8047955 tests. 4920.994 seconds on bella 64-bit little-endian th3: SQLite 3.13.0 2016-05-10 20:03:08 20cf8811caf705b482be100baecb3ef72aee2d5a memdebug.rc th3: 0 errors in 8063768 tests. 2190.624 seconds on bella 64-bit little-endian th3: SQLite 3.13.0 2016-05-13 17:22:33 b369980f0c4550a9034833caa2c7c85d6030f5ff test.rc
2016-05-14 19:25:21 drhok+
190e. see-aes128-ccm.c
th3: 0 errors in 7826574 tests. 1122.015 seconds on bella 64-bit little-endian th3: SQLite 3.13.0 2016-05-13 17:22:33 b369980f0c4550a9034833caa2c7c85d6030f5ff th3: 0 errors in 8064199 tests. 2610.834 seconds on bella 64-bit little-endian th3: SQLite 3.13.0 2016-05-13 17:22:33 b369980f0c4550a9034833caa2c7c85d6030f5ff
2016-05-14 18:41:12 drhok
190. SEE tests using TH3:
2016-05-14 18:40:52 drhok
190e. see-aes128-ccm.c
th3: 0 errors in 7826574 tests. 1122.015 seconds on bella 64-bit little-endian th3: SQLite 3.13.0 2016-05-13 17:22:33 b369980f0c4550a9034833caa2c7c85d6030f5ff
2016-05-12 10:37:09 drhok
60a. tclsh multitest.tcl (take care to update ../th3private)
0 failures on 35 th3makes and 170649867 tests in (04:20:58) 4 cores on bella SQLite 3.13.0 2016-05-11 20:03:23 3bfd2621d13b4f842f3af6d35519653f4eb8cad7
2016-05-12 03:56:57 mistachkinok
110. Tests for platform Windows (other):
2016-05-12 03:56:52 mistachkinok
110f. th3make msvc.rc wp81.rc min.rc - Windows Phone 8.1
0 errors in 1551843 tests. 3376.742 seconds on 32-bit little-endian, SQLite 3.13.0 2016-05-11 18:20:10 4533ed352db2e05c7600dbfe5e02cf7f0d6f225a
2016-05-12 02:42:07 mistachkinpending
110f. th3make msvc.rc wp81.rc min.rc - Windows Phone 8.1
2016-05-12 02:39:00 mistachkinok
110d. th3make msvc.rc winrt.rc min.rc - Windows Runtime 8.1
0 errors in 1553027 tests. 4673.381 seconds on 32-bit little-endian, SQLite 3.13.0 2016-05-11 18:20:10 4533ed352db2e05c7600dbfe5e02cf7f0d6f225a
2016-05-11 19:12:10 mistachkinpending
110d. th3make msvc.rc winrt.rc min.rc - Windows Runtime 8.1
2016-05-11 06:55:34 mistachkinok
110e. th3make msvc.rc wp80.rc min.rc - Windows Phone 8.0
0 errors in 1551276 tests. 981.083 seconds on 32-bit little-endian, SQLite 3.13.0 2016-05-10 20:16:43 223640243efc52c14bb2bb540833a2a624eaa41a
2016-05-11 06:24:12 mistachkinpending
110. Tests for platform Windows (other):
2016-05-11 06:24:04 mistachkinpending
110e. th3make msvc.rc wp80.rc min.rc - Windows Phone 8.0
2016-05-11 06:22:29 mistachkinok
110g. 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 1558652 tests. 3771.469 seconds on 32-bit little-endian, SQLite 3.13.0 2016-05-10 20:16:43 223640243efc52c14bb2bb540833a2a624eaa41a
2016-05-11 05:05:43 mistachkinpending
110g. 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-05-11 04:39:27 mistachkinok
110c. th3make msvc.rc winrt.rc min.rc - Windows Runtime 8.0 (ARM)
0 errors in 1552468 tests. 4879.146 seconds on 32-bit little-endian, SQLite 3.13.0 2016-05-10 20:16:43 223640243efc52c14bb2bb540833a2a624eaa41a
2016-05-11 02:54:51 drhok
100e. tclsh releasetest.tcl --platform Failure-Detection - all failures detected
2016-05-11 01:44:07 mistachkinpending
110c. th3make msvc.rc winrt.rc min.rc - Windows Runtime 8.0 (ARM)
2016-05-11 01:35:15 mistachkinok
110b. th3make msvc.rc winrt.rc min.rc - Windows Runtime 8.0 (x86)
0 errors in 1552480 tests. 784.138 seconds on 32-bit little-endian, SQLite 3.13.0 2016-05-10 20:16:43 223640243efc52c14bb2bb540833a2a624eaa41a
2016-05-11 01:04:03 drhok
210. ZIPVFS tests:
2016-05-11 01:03:26 drhok
210d. th3make zipvfs.rc quick.rc -valgrind
th3: 0 errors in 2683727 tests. 21052.180 seconds on bella 64-bit little-endian th3: SQLite 3.13.0 2016-05-09 23:11:47 79ecd0ef20c12198e950a730871444a980a0f1b2
2016-05-11 00:10:33 mistachkinok
340. System.Data.SQLite builds and checks out using the SQLite core.
2016-05-11 00:10:26 mistachkinok
340a. Using Microsoft .NET Framework on Windows
223640243efc52c14bb2bb540833a2a624eaa41a, Debug NetFx46 x86: 0 errors/503 tests, 1285 seconds, Release NetFx46 x86: 0 errors/503 tests, 1007 seconds, Debug NetFx451 x64: 0 errors/503 tests, 1195 seconds, Release NetFx451 x64: 0 errors/503 tests, 1103 seconds, 0 errors/24 tests (Debug NetCF20-ARM/NetCF35-ARM), 0 errors/24 tests (Release NetCF20-ARM/NetCF35-ARM)
2016-05-10 23:25:05 mistachkinok
340b. Using Mono on unix
223640243efc52c14bb2bb540833a2a624eaa41a, Debug Mono 4.2.3 on Ubuntu 15.10 x86_64: 0 errors/503 tests, 548 seconds, Release Mono 4.2.3 on Ubuntu 15.10 x86_64: 0 errors/503 tests, 502 seconds
2016-05-10 22:49:08 mistachkinpending
340b. Using Mono on unix
2016-05-10 22:41:38 drhfail
190e. see-aes128-ccm.c
c5.backup09.ioerr2.67.once... FAILED (2) ==== c5.backup09.ioerr2.67.once ==== Expected: [16 d0e5d033bd876ea90a7d14c3a585c1e3] Got: [16 176ddee7d7fecdb0f643a68d33157d2d] c5.backup09.ioerr2.67.repeat... FAILED (2) ==== c5.backup09.ioerr2.67.repeat ==== Expected: [16 d0e5d033bd876ea90a7d14c3a585c1e3] Got: [16 176ddee7d7fecdb0f643a68d33157d2d]
2016-05-10 22:30:39 drhpending
100c. tclsh test/releasetest.tcl
2016-05-10 22:30:26 drhok
100a. tclsh multitest.tcl (after updating th3private)
0 failures on 29 th3makes and 127631115 tests in (11:40:19) 3 cores on poulenc SQLite 3.13.0 2016-05-09 23:11:47 79ecd0ef20c12198e950a730871444a980a0f1b2
2016-05-10 22:28:53 drhok
100b. tclsh multitest.tcl --scenario failures - verify failures detected
2016-05-10 22:27:25 drhok+
110a. th3make msvc.rc test.rc - Windows 7.0/8.x (x64)
th3: 0 errors in 6189135 tests. 4638.187 seconds on win7dev 64-bit little-endian th3: SQLite 3.13.0 2016-05-10 20:16:43 223640243efc52c14bb2bb540833a2a624eaa41a
2016-05-10 22:26:14 drhok
190d. see-rc4.c
th3: 0 errors in 1609521 tests. 238.858 seconds on bella 64-bit little-endian th3: SQLite 3.13.0 2016-05-10 20:03:08 20cf8811caf705b482be100baecb3ef72aee2d5a
2016-05-10 22:19:46 drhok
190c. see-aes256-ofb.c
th3: 0 errors in 1609521 tests. 238.858 seconds on bella 64-bit little-endian th3: SQLite 3.13.0 2016-05-10 20:03:08 20cf8811caf705b482be100baecb3ef72aee2d5a
2016-05-10 22:13:09 drhok
190h. At least one of the above using "memdebug.rc".
2016-05-10 22:13:05 drhok
190i. At least one of the above on Linux.
2016-05-10 22:13:00 drhok
190a. see.c
th3: 0 errors in 8047955 tests. 4920.994 seconds on bella 64-bit little-endian th3: SQLite 3.13.0 2016-05-10 20:03:08 20cf8811caf705b482be100baecb3ef72aee2d5a memdebug
2016-05-10 21:17:02 mistachkinpending
340a. Using Microsoft .NET Framework on Windows
2016-05-10 21:15:22 drhok
190g. At least one of the above using "test.rc".
2016-05-10 21:07:10 mistachkinpending
340. System.Data.SQLite builds and checks out using the SQLite core.
2016-05-10 20:57:00 drhok
40. Compiler warning checks.
2016-05-10 20:56:53 drhok
40d. Windows (32-bit) MSVC using option /W4
2016-05-10 20:56:41 drhok
190j. At least one of the above on Mac OS X.
2016-05-10 20:56:34 drhok
190f. see-cccrypt.c
th3: 0 errors in 6322008 tests. 2245.503 seconds on macpro 64-bit little-endian th3: SQLite 3.13.0 2016-05-10 20:16:43 223640243efc52c14bb2bb540833a2a624eaa41a
2016-05-10 20:49:04 danok
80a. tclsh releasetest.tcl
2016-05-10 20:46:51 drhok
190k. At least one of the above on Windows.
2016-05-10 20:46:31 drhok
190b. see-aes128-ofb.c
th3: 0 errors in 1621543 tests. 1199.720 seconds on win7dev 32-bit little-endian th3: SQLite 3.13.0 2016-05-10 20:16:43 223640243efc52c14bb2bb540833a2a624eaa41a
2016-05-10 19:25:53 drhfail+
190b. see-aes128-ofb.c
Assertion fault on pager.c:6930 running on win7dev at c9.vdbeaux10
2016-05-10 19:24:10 drhfail
190b. see-aes128-ofb.c
Assertion fault on pager.c:6930 running on win7dev.
2016-05-10 19:23:48 drhfail
190f. see-cccrypt.c
Assertion fault on pager.c:6930.
2016-05-10 18:52:45 drhok
230. Amalgamation autoconf tarball.
2016-05-10 18:52:37 drhok
230e. Works on Windows MSVC
2016-05-10 18:51:27 drhok
230d. Works on Windows MinGW
2016-05-10 18:33:18 drhok
210h. At least one of the above on Windows.
2016-05-10 18:33:10 drhok
210e. th3make zipvfs.rc quick.rc
th3: 0 errors in 2710015 tests. 3976.970 seconds on win7dev 32-bit little-endian th3: SQLite 3.13.0 2016-05-09 23:11:47 79ecd0ef20c12198e950a730871444a980a0f1b2
2016-05-10 18:24:59 drhok
30b. Release announcement in "changes.in".
2016-05-10 18:24:55 drhok
30a. Latest release on the "index.html" page.
2016-05-10 18:24:29 drhok
20. Source code change review. fossil diff --from release --to trunk
2016-05-10 18:24:29 drhok
20a. No stray changes.
2016-05-10 18:24:29 drhok
20b. All significant changes are mentioned in the "changes" log of the documentation.
2016-05-10 18:24:29 drhok
20c. New code complies with style guidelines.
2016-05-10 18:24:29 drhok
20d. New code complies with design rules.
2016-05-10 18:24:29 drhok
20e. Comments have been updated to reflect code changes.
2016-05-10 18:24:29 drhok
20f. Variables and functions have been renamed to reflect changes in their use.
2016-05-10 18:24:29 drhok
20g. Check all calls to sqlite3OsRead() and sqlite3OsWrite() to ensure that offset computations are 64-bit clean.
2016-05-10 18:24:29 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-05-10 18:24:29 drhok
20i. Verify that source code contains no tabs and that surplus whitespace has been removed.
2016-05-10 18:24:29 drhok
20j. Verify that the list of APIs exposed via the extension header is up-to-date (sqlite3ext.h).
2016-05-10 18:24:29 drhok
20k. Significant compile-time options are recognized by the sqlite3_compileoption_used() interface.
2016-05-10 17:49:21 drhpending
210d. th3make zipvfs.rc quick.rc -valgrind
2016-05-10 17:48:56 drhok
210c. th3make zipvfs.rc memdebug.rc
th3: 0 errors in 9837632 tests. 8061.141 seconds on bella 64-bit little-endian th3: SQLite 3.13.0 2016-05-09 23:11:47 79ecd0ef20c12198e950a730871444a980a0f1b2
2016-05-10 17:48:28 drhok
210b. th3make zipvfs.rc test.rc
th3: 0 errors in 8105737 tests. 3583.322 seconds on macpro 64-bit little-endian th3: SQLite 3.13.0 2016-05-09 23:11:47 79ecd0ef20c12198e950a730871444a980a0f1b2
2016-05-10 17:42:48 drhok
300. 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.
2016-05-10 17:42:44 drhok
300e. 64-little to 32-big, ZIPVFS database.
2016-05-10 17:40:23 drhok
300f. 64-little to 32-big, CEROD database.
2016-05-10 17:38:11 drhok
300d. 64-little to 32-big, SEE database.
2016-05-10 17:35:18 drhok
300b. 32-big to 64-little, WAL.
2016-05-10 17:34:56 drhok
300c. 32-big to 64-little, rollback.
2016-05-10 17:34:29 drhok
300a. 32-big to 64-little, database.
2016-05-10 17:31:34 drhok
90. Tests for platform Mac OS X 10.2 (PPC):
2016-05-10 17:31:17 drhok
90a. tclsh th3make quick.rc
th3: 0 errors in 1553062 tests. 4628.289 seconds on crabapple.local. 32-bit big-endian th3: SQLite 3.13.0 2016-05-09 23:11:47 79ecd0ef20c12198e950a730871444a980a0f1b2
2016-05-10 17:25:05 drhok
210g. At least one of the above on Mac OS X.
2016-05-10 17:21:49 drhpending
210e. th3make zipvfs.rc quick.rc
2016-05-10 17:17:23 drhok
110a. th3make msvc.rc test.rc - Windows 7.0/8.x (x64)
th3: 0 errors in 6184973 tests. 5247.581 seconds on win7dev 32-bit little-endian th3: SQLite 3.13.0 2016-05-09 23:11:47 79ecd0ef20c12198e950a730871444a980a0f1b2
2016-05-10 16:22:10 danok
290. 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 using backcompat.test against 3.6.4 and 3.7.3: SQLite 2016-05-09 23:11:47 79ecd0ef20c12198e950a730871444a980a0f1b2 0 errors out of 261 tests on darkstar Linux 64-bit little-endian
2016-05-10 15:49:35 drhok
90c. Verify that Fossil repositories are cross-platform with x86/x64.
2016-05-10 15:46:55 dan---+
290. 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 using backcompat.test against 3.6.4 and 3.7.3: SQLite 2016-05-09 23:11:47 79ecd0ef20c12198e950a730871444a980a0f1b2 0 errors out of 261 tests on darkstar Linux 64-bit little-endian
2016-05-10 15:41:14 drhok
90b. Recompile and test Fossil.
2016-05-10 15:40:54 drhpending
210c. th3make zipvfs.rc memdebug.rc
2016-05-10 15:40:50 drhpending
210b. th3make zipvfs.rc test.rc
2016-05-10 15:27:30 drhpending
110a. th3make msvc.rc test.rc - Windows 7.0/8.x (x64)
2016-05-10 15:20:36 drhok
60g. sh tool/symbols.sh - no incorrect exports or dependencies
2016-05-10 15:19:22 drhok
160. Fossil updated to use the latest SQLite.
2016-05-10 15:19:18 drhok
160b. Used on active websites with no issues.
2016-05-10 15:15:29 drhok
100i. Verify that EXEs and DLLs generated using MSVC contain the correct version number, product name, description, and copyright as resources.
2016-05-10 15:12:28 drhok
100g. nmake /f makefile.msc WIN32HEAP=1 DEBUG=4 fulltestonly
SQLite 2016-05-09 23:11:47 79ecd0ef20c12198e950a730871444a980a0f1b2 1 errors out of 1201589 tests on win7dev Windows NT 32-bit little-endian !Failures on these tests: selectG-100 ! selectG-100 expected: [100000 5000050000 50000.5 1] ! selectG-100 got: [100000 5000050000 50000.5 0] That one error is a timing test that is too slow. But win7dev is a slow machine that WIN32HEAP and DEBUG=4 make even slower. Perviously, this test has run on poulenc, which is much faster. Deemed pass.
2016-05-10 15:08:11 danok
60. Tests for platform Linux x86_64:
2016-05-10 15:08:06 danok
70a. tclsh th3make min.rc
2016-05-10 15:06:13 drhok
210f. At least one of the above on Linux.
2016-05-10 15:06:06 drhok
210a. testfixture ../zipvfs/test/zipvfs.test (See test/README.txt in the ZIPVFS source tree for details.)
SQLite 2016-05-09 23:11:47 79ecd0ef20c12198e950a730871444a980a0f1b2 0 errors out of 63942 tests on bella Linux 64-bit little-endian
2016-05-10 15:05:50 drhok
210i. th3make zipvfs-cov.rc - verify full coverage
th3: 0 errors in 1217972 tests. 332.600 seconds on bella 64-bit little-endian th3: SQLite 3.13.0 2016-05-09 23:11:47 79ecd0ef20c12198e950a730871444a980a0f1b2 Statement coverage: 100.00% hit 1561 missed 0 total 1561 Branch coverage: 100.00% hit 918 missed 0 total 918
2016-05-10 13:18:17 danok
70b. Recompile and test Fossil.
2016-05-10 11:44:49 danpending
70b. Recompile and test Fossil.
2016-05-10 11:39:36 danpending
70a. tclsh th3make min.rc
2016-05-10 10:52:24 drhfail
100g. nmake /f makefile.msc WIN32HEAP=1 DEBUG=4 fulltestonly
SQLite 2016-05-09 23:11:47 79ecd0ef20c12198e950a730871444a980a0f1b2 1 errors out of 1201589 tests on win7dev Windows NT 32-bit little-endian !Failures on these tests: selectG-100 ! selectG-100 expected: [100000 5000050000 50000.5 1] ! selectG-100 got: [100000 5000050000 50000.5 0]
2016-05-10 10:49:26 drhretest
100a. tclsh multitest.tcl (after updating th3private)
Prior failure was due to an incorrect TH3 version. Rerunning the test after updating.
2016-05-10 10:17:52 drhok
130. Tests for platform Solaris (SPARC):
2016-05-10 10:17:48 drhok
130b. tclsh multitest.tcl --quick -q (after updating th3private)
0 failures on 9 th3makes and 12025507 tests in (04:31:38) on sparc.mikeowens.ws SQLite 3.13.0 2016-05-09 23:11:47 79ecd0ef20c12198e950a730871444a980a0f1b2
2016-05-10 10:17:09 drhok
120. Tests for platform OpenBSD (x86):
2016-05-10 10:17:05 drhok
120b. th3make quick.rc
th3: 0 errors in 1645159 tests. 3321.551 seconds on wolfman.devio.us 32-bit little-endian th3: SQLite 3.13.0 2016-05-09 23:11:47 79ecd0ef20c12198e950a730871444a980a0f1b2
2016-05-10 05:44:05 danok
60c. tclsh releasetest.tcl
SQLite 3.13.0 2016-05-09 19:03:42 14e53d0e2f62d82ae1d64a72fd9711548e3bf5ea
2016-05-10 02:58:16 drhfail
100a. tclsh multitest.tcl (after updating th3private)
crash in c1.main02.2 when compiled as: "tclsh th3make msvc.rc quick.rc cov1/main02.test". Works with test.rc or with -v.
2016-05-10 02:43:56 drhpending
100g. nmake /f makefile.msc WIN32HEAP=1 DEBUG=4 fulltestonly
2016-05-10 02:37:59 drhok
100f. nmake /f makefile.msc MEMDEBUG=1 DEBUG=3 fulltestonly
0 errors out of 1202299 tests on poulenc Windows NT 64-bit little-endian
2016-05-10 02:33:23 drhok
120a. make test
2016-05-10 02:33:08 drhok
130a. configure; OPTS=-lrt make test
0 errors out of 134655 tests on sparc.mikeowens.ws SunOS 32-bit big-endian
2016-05-10 01:10:33 drhok
40c. OpenBSD GCC using options -Wall
2016-05-10 01:09:47 drhok
280. Verify that the amalgamation builds are byte-for-byte identical on all workstation platforms.
2016-05-10 01:09:43 drhok
280c. OpenBSD
34f2d1424433e7440b255a24dc95d46e50d6f033 sqlite3.c 6df60269849748d16f0ba9e754c9d791548414e9 sqlite3.h
2016-05-10 01:05:38 drhok
100h. sh tool/symbols-mingw.sh - no incorrect exports or dependencies
2016-05-10 01:04:14 drhpending
130a. configure; OPTS=-lrt make test
2016-05-10 01:03:10 drhpending
130b. tclsh multitest.tcl --quick -q (after updating th3private)
2016-05-10 01:02:58 drhok
130d. Verify that Fossil repositories are cross-platform with x86/x64.
2016-05-10 01:02:53 drhok
130c. Recompile and test Fossil.
2016-05-10 01:02:27 drhok
310. Build and verify correct operation of sqlite3_analyzer on:
2016-05-10 01:02:24 drhok
310c. Solaris (SPARC)
2016-05-10 00:59:19 drhok
280f. Solaris (SPARC) using autoconf.
34f2d1424433e7440b255a24dc95d46e50d6f033 sqlite3.c 6df60269849748d16f0ba9e754c9d791548414e9 sqlite3.h
2016-05-10 00:55:04 drhok
140. Sqllogictest:
2016-05-10 00:54:59 drhok
140d. tclsh run-all.tcl - on windows
0 errors out of 11879758 tests and 1244 invocations in 3592 seconds
2016-05-09 23:29:54 drhok
240. TEA archive builds correctly and runs:
2016-05-09 23:29:51 drhok
240b. Mac OS X
2016-05-09 23:28:55 drhfail
210i. th3make zipvfs-cov.rc - verify full coverage
Errors in zipvfs3.pragma13.12 and zipvfs3.pragma13.13. Two branches missed.
2016-05-09 23:27:56 drhok
240a. Linux
2016-05-09 23:25:34 drhok
230c. Works on Mac OS X.
2016-05-09 23:24:57 drhpending
100f. nmake /f makefile.msc MEMDEBUG=1 DEBUG=3 fulltestonly
2016-05-09 23:23:47 drhok
40e. Windows (64-bit) MSVC using option /W4
2016-05-09 23:20:43 drhok
100d. tclsh test/releasetest.tcl --msvc
0 failures out of 1623840 tests in (02:49:48) on poulenc SQLite 3.13.0 2016-05-09 19:03:42 14e53d0e2f62d82ae1d64a72fd9711548e3bf5ea
2016-05-09 23:13:47 drhok
230b. Works on Linux.
2016-05-09 23:13:43 drhok
230a. Builds.
2016-05-09 23:13:17 drhok
40b. Mac OS X GCC -Wall -Wextra (the "tool/warnings.sh" script)
2016-05-09 23:13:00 drhok
30e. Requirements marks are up-to-date in both documentation and source code.
2016-05-09 23:12:56 drhok
30d. No unresolved hyperlinks in the documentation build.
2016-05-09 23:07:00 drhok
140c. tclsh run-all.tcl - on unix
0 errors out of 11879758 tests and 1244 invocations in 813 seconds
2016-05-09 23:04:45 drhok
50. OMIT, ENABLE, and DISABLE options:
2016-05-09 23:04:40 drhok
50a. tclsh ../tool/omittest.tcl -skip_run -target libsqlite3.a
2016-05-09 22:58:13 drhok
200. SEE using configure; make test
2016-05-09 22:58:08 drhok
200b. Mac
0 errors out of 133794 tests on macpro Darwin 64-bit little-endian
2016-05-09 22:54:10 drhok
40a. Linux GCC -Wall -Wextra (the "tool/warnings.sh" script)
2016-05-09 22:52:54 drhok
150. Build using the configure/make in main source tree.
2016-05-09 22:52:50 drhok
150b. Verify the correct version numbers have been installed.
2016-05-09 22:52:47 drhok
150a. Make sure that autoconf has been run to update the configure script.
2016-05-09 22:43:59 drhok
140b. No SQLite compiler warnings.
2016-05-09 22:43:44 drhok
140a. Checked in latest SQLite amalgamation.
2016-05-09 22:41:34 drhok
200a. Linux
0 errors out of 134401 tests on bella Linux 64-bit little-endian
2016-05-09 22:16:16 drhok
160c. fossil all dbstat --db-check
2016-05-09 22:15:39 drhok
160a. No SQLite compiler warnings.
2016-05-09 22:12:57 drhok
270. Compute the size of a standard build (gcc -Os -c sqlite3.c) and and record the size change in the comments.
2016-05-09 22:12:51 drhok
270b. Versus the trunk from 12 months ago.
3.8.10: 481961 3.13.0: 486049
2016-05-09 22:09:33 drhok
260. Run make wordcount; bash run-wordcount.bash $OPTIONS with options:
2016-05-09 22:09:27 drhok
260b. bash run-wordcount.sh sqlite3.c --cachesize 5 --nosync
2016-05-09 22:08:36 drhok
260a. bash run-wordcount.sh sqlite3.c
2016-05-09 21:22:57 drhok
310d. Windows (MinGW)
2016-05-09 21:21:54 drhok
280d. Windows using native MinGW.
34f2d1424433e7440b255a24dc95d46e50d6f033 sqlite3.c 6df60269849748d16f0ba9e754c9d791548414e9 sqlite3.h
2016-05-09 21:21:11 drhok
280e. Windows using NMAKE.
34f2d1424433e7440b255a24dc95d46e50d6f033 sqlite3.c 6df60269849748d16f0ba9e754c9d791548414e9 sqlite3.h
2016-05-09 21:19:42 drhok+
280a. Linux
34f2d1424433e7440b255a24dc95d46e50d6f033 sqlite3.c 6df60269849748d16f0ba9e754c9d791548414e9 sqlite3.h
2016-05-09 21:19:19 drhok
280b. Mac OS X
34f2d1424433e7440b255a24dc95d46e50d6f033 sqlite3.c 6df60269849748d16f0ba9e754c9d791548414e9 sqlite3.h
2016-05-09 21:18:34 drhok
280a. Linux
34f2d1424433e7440b255a24dc95d46e50d6f033 sqlite3.c 6df60269849748d16f0ba9e754c9d791548414e9 sqlite3.h 34f2d1424433e7440b255a24dc95d46e50d6f033 sqlite3.c 6df60269849748d16f0ba9e754c9d791548414e9 sqlite3.h
2016-05-09 21:17:49 drhok
310e. Windows (MSVC)
2016-05-09 21:16:11 drhok
320. Build and verify sqldiff
2016-05-09 21:16:07 drhok
320c. Windows
2016-05-09 21:15:08 drhok
320b. Mac
2016-05-09 21:13:55 drhok
320a. Linux
2016-05-09 21:13:10 drhok
310b. Mac OS X
2016-05-09 21:12:30 drhok
330. 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-05-09 21:09:07 drhok
310a. Linux
2016-05-09 21:09:07 drhok
310f. A database containing WITHOUT ROWID tables.
2016-05-09 21:07:08 drhok
170. Rebuild and use Firefox with the latest SQLite
2016-05-09 21:07:04 drhok
180. CEROD tests in the "test/" subdirectory.
2016-05-09 20:59:11 danpending
60c. tclsh releasetest.tcl
2016-05-09 20:58:22 danpending
80b. tclsh multitest.tcl --omit test-ex (after updating th3private)
2016-05-09 20:57:34 danpending
80a. tclsh releasetest.tcl
2016-05-09 20:52:46 drhpending
100d. tclsh test/releasetest.tcl --msvc
2016-05-09 20:47:32 drhok
10. Test procedure review.
2016-05-09 20:47:32 drhok
10a. Review the "test/releasetest.tcl" script for completeness and accuracy.
2016-05-09 20:47:32 drhok
10b. Review "multitest.tcl" and "alignment*.rc" scripts in TH3 for completeness.
2016-05-09 20:47:32 drhok
10c. Review this checklist for completeness and accuracy.
2016-05-09 20:46:44 drhok
270a. Versus the previous release.
3.12.0: 485831 3.13.0: 486049
2016-05-09 20:46:08 drhok
250. Run performance tests comparing the new SQLite release against the previous release and/or a release from one year ago. Document and justify any performance decrease.
2016-05-09 20:46:04 drhok
250d. ./speedtest1 --nosync --size 25 --trace 2>x.txt
time ./sqlite3 x.db <x.txt >/dev/null
Ubuntu 3.12.0: 0.877s 3.13.0: 0.837s
2016-05-09 20:44:20 drhok
250e. One or more of the above on Linux.
2016-05-09 20:44:15 drhok
250c. The "speedtest1" program.
Ubuntu 3.12.0: 1032.993M cycles 3.13.0: 1016.890M cycles
2016-05-09 20:41:56 drhok
250g. One or more of the above on Mac OS X.
2016-05-09 20:41:51 drhok
250b. The TH3 speed tests.
On MacPro 3.12.0: 3.223 sec 3.13.0: 3.177 sec
2016-05-09 20:34:59 drhok
250f. One or more of the above on Windows.
2016-05-09 20:34:54 drhok
250a. The Tcl "speed*.test" scripts.
On Win7 3.12.0: 23.564720 sec 3.13.0: 22.984078 sec