SQLite

Checklist For SQLite 3.19.0
Login
2017-05-22 13:51:59 drhok
30. Documentation review:
2017-05-22 13:51:59 drhok
30a. Latest release on the "index.html" page.
2017-05-22 13:51:59 drhok
30b. Release announcement in "changes.in".
2017-05-22 13:51:59 drhok
30c. Release accouncement in "news.html".
2017-05-22 13:51:59 drhok
30d. No unresolved hyperlinks in the documentation build.
2017-05-22 13:51:59 drhok
30e. Requirements marks are up-to-date in both documentation and source code.
2017-05-22 13:51:59 drhok
30f. The compile-time options are all up-to-date (compile.html).
2017-05-22 13:51:59 drhok
30g. Database footprint is up-to-date (features.html).
2017-05-22 13:51:59 drhok
30h. Test metrics are up-to-date (testing.html).
2017-05-22 13:51:19 drhok
190. ZIPVFS tests:
2017-05-22 13:51:14 drhok
190h. At least one of the above on Windows.
2017-05-22 13:51:08 drhok
190e. th3make zipvfs.rc quick.rc
th3: 0 errors in 2837728 tests. 1591.313 seconds on DESKTOP-8U9G1N8 64-bit little-endian th3: SQLite 3.19.0 2017-05-22 13:06:45 3dd6fe53c7ae6ebe2393e956d040e00b8cd0589674d20aafe1585aaa61325bbe Windows10
2017-05-22 13:49:45 drhok
30i. Check new/changed documentation for spelling and gramatical mistakes.
2017-05-22 13:37:48 drhok
170. SEE tests using TH3:
2017-05-22 13:37:42 drhok
170e. see-aes128-ccm.c
th3: 0 errors in 1705482 tests. 255.048 seconds on bella 64-bit little-endian th3: SQLite 3.19.0 2017-05-22 13:06:45 3dd6fe53c7ae6ebe2393e956d040e00b8cd0589674d20aafe1585aaa61325bbe
2017-05-22 13:37:10 drhok
170d. see-rc4.c
th3: 0 errors in 1689276 tests. 317.064 seconds on macpro01 64-bit little-endian th3: SQLite 3.19.0 2017-05-19 23:04:04 50ad60ded54aa22dfdf519ed5da6451de790e22a972ff299f7976fbdce7a0579
2017-05-22 13:36:40 drhok
280. Verify that the performance and size measurement spreadsheet in the documentation (misc/speed-size-graph.ods) is up-to-date.
2017-05-22 13:33:26 drhok
310. Build and verify correct operation of sqlite3_analyzer on:
2017-05-22 13:33:22 drhok
310c. Windows (MinGW)
2017-05-22 13:32:27 drhok
170c. see-aes256-ofb.c
th3: 0 errors in 1705247 tests. 229.674 seconds on bella 64-bit little-endian th3: SQLite 3.19.0 2017-05-22 13:06:45 3dd6fe53c7ae6ebe2393e956d040e00b8cd0589674d20aafe1585aaa61325bbe
2017-05-22 13:26:04 drhok
170g. At least one of the above using "test.rc".
2017-05-22 13:25:59 drhok
170j. At least one of the above on Mac OS X.
2017-05-22 13:25:52 drhok
170f. see-cccrypt.c
th3: 0 errors in 6448409 tests. 2319.951 seconds on macpro01 64-bit little-endian th3: SQLite 3.19.0 2017-05-19 23:04:04 50ad60ded54aa22dfdf519ed5da6451de790e22a972ff299f7976fbdce7a0579
2017-05-22 13:20:40 drhok
210. Amalgamation autoconf tarball.
2017-05-22 13:20:31 drhok
210d. Works on Windows MinGW
2017-05-22 13:09:46 drhok
170k. At least one of the above on Windows.
2017-05-22 13:09:35 drhok
170b. see-aes128-ofb.c
th3: 0 errors in 1708981 tests. 618.145 seconds on DESKTOP-8U9G1N8 64-bit little-endian th3: SQLite 3.19.0 2017-05-19 23:04:04 50ad60ded54aa22dfdf519ed5da6451de790e22a972ff299f7976fbdce7a0579 Win10 MSVC
2017-05-22 13:07:37 drhok
210e. Works on Windows MSVC
See check-in https://www.sqlite.org/src/info/3dd6fe53c7ae6ebe
2017-05-22 12:52:27 drhfail
210e. Works on Windows MSVC
The msvc.h file is not included in the tarball.
2017-05-22 12:37:10 drhok
60. Tests for platform Linux x86_64:
2017-05-22 12:37:07 drhok
60b. Check the "multitest.tcl" log files for undetected errors.
2017-05-22 12:37:03 drhok
60e. tclsh multitest.tcl --scenario failures - all failures detected
2017-05-20 14:44:30 drhok
100. Tests for platform Windows:
2017-05-20 14:44:25 drhok
100i. Verify that EXEs and DLLs generated using MSVC contain the correct version number, product name, description, and copyright as resources.
2017-05-20 14:40:09 drhok
100h. sh tool/symbols-mingw.sh - no incorrect exports or dependencies
2017-05-20 14:38:17 drhok
100e. tclsh releasetest.tcl --platform Failure-Detection - all failures detected
2017-05-20 14:34:53 drhok
100d. tclsh test/releasetest.tcl --msvc
0 failures out of 1975375 tests in (02:28:10) on DESKTOP-8U9G1N8 SQLite 3.19.0 2017-05-19 23:04:04 50ad60ded54aa22dfdf519ed5da6451de790e22a972ff299f7976fbdce7a0579
2017-05-20 11:38:15 drhpending
100d. tclsh test/releasetest.tcl --msvc
2017-05-20 11:37:22 drhok
100g. nmake /f makefile.msc WIN32HEAP=1 DEBUG=4 test
SQLite 2017-05-19 23:04:04 50ad60ded54aa22dfdf519ed5da6451de790e22a972ff299f7976fbdce7a0579 0 errors out of 114137 tests on DESKTOP-8U9G1N8 Windows NT 64-bit little-endian
2017-05-20 11:36:04 drhok
100b. tclsh multitest.tcl --msvc --quick on x86
0 failures on 15 th3makes and 20943197 tests in (04:05:23) on win7dev SQLite 3.19.0 2017-05-19 12:32:32 35f721045dfe3f82e016938ab1a668bfc37b6b57b8813c c963ef640ec82de58d
2017-05-20 11:07:51 drhok
60a. tclsh multitest.tcl (take care to update ../th3private)
0 failures on 42 th3makes and 184140405 tests in (06:18:23) 3 cores on bella SQLite 3.19.0 2017-05-19 23:04:04 50ad60ded54aa22dfdf519ed5da6451de790e22a972ff299f7976fbdce7a0579
2017-05-20 02:44:34 drhok
100f. nmake /f makefile.msc MEMDEBUG=1 DEBUG=3 test
SQLite 2017-05-19 23:04:04 50ad60ded54aa22dfdf519ed5da6451de790e22a972ff299f7976fbdce7a0579 0 errors out of 113072 tests on DESKTOP-8U9G1N8 Windows NT 64-bit little-endian
2017-05-20 00:25:56 drhok
100c. tclsh multitest.tcl --msvc --scenario failures - verify failures detected
2017-05-19 23:55:43 drhok
270. Use the ".selftest" command of the shell to verify that legacy database files are readable and cross-platform
2017-05-19 23:55:39 drhok
270a. iBook PPC
2017-05-19 22:08:42 drhok
100a. tclsh multitest.tcl --msvc (after updating th3private)
0 failures on 36 th3makes and 139020115 tests in (08:37:00) 3 cores on DESKTOP-8U9G1N8 SQLite 3.19.0 2017-05-19 12:32:32 35f721045dfe3f82e016938ab1a668bfc37b6b57b8813cc963ef640ec82de58d
2017-05-19 21:10:11 drhpending
100b. tclsh multitest.tcl --msvc --quick on x86
2017-05-19 17:24:11 drhok
90. Tests for platform Mac OS X 10.2 (PPC):
2017-05-19 17:24:06 drhok
90a. tclsh th3make quick.rc
th3: 44 errors in 1987590 tests. 12894.028 seconds on crabapple.local. 32-bit big-endian th3: SQLite 3.19.0 2017-05-16 09:49:42 7940bff32aa6ea868a53680822d148b7ec7a075c01ae9e0d5ad9859bcc339054 All errors are do to the configuration difference between the workstation where th3.c was created and the iBook where the file was compiled and run.
2017-05-19 16:04:12 drhok
270b. Linux
2017-05-19 16:02:24 drhok
270d. Windows
2017-05-19 16:02:20 drhok
270c. Mac
2017-05-19 16:00:08 drhok
310d. Windows (MSVC)
2017-05-19 15:58:43 drhok
320. Build and verify sqldiff
2017-05-19 15:58:38 drhok
320c. Windows
2017-05-19 15:50:56 drhok
180. SEE using configure; make test
2017-05-19 15:50:49 drhok
180b. Mac
SQLite 2017-05-12 14:05:11 a123cb93307a6c48bd711d6af9828c87a1365e023f6fe4ca6eae264c8ec5e0c0 0 errors out of 140067 tests on macpro01 Darwin 64-bit little-endian
2017-05-19 15:49:04 drhok
230. Performance tests using speedtest1 compared against the previous release and a release from about one year ago.
2017-05-19 15:48:59 drhok
230a. Android
3.13.0: 101.309s 3.18.0: 95.595s 3.19.0: 93.469s
2017-05-19 15:39:48 drhok
240. Performance tests using speedtest1 --testset rtree
2017-05-19 15:39:43 drhok
240b. Windows
2017-05-19 15:35:56 drhok
230c. Mac
3.13.0: 6.211 3.18.0: 5.411 3.19.0: 5.469 This shows 3.19.0 being about 1% slower than 3.18.0. But both later versions are clearly faster than 3.13.0 from a year ago so we will call this a pass.
2017-05-19 15:26:24 drhok
260. Compare performance to the previous release using kvtest.
2017-05-19 15:26:19 drhok
260c. Mac
2017-05-19 15:16:12 drhok
260a. Android
2017-05-19 15:07:13 drhok
260b. Linux
2017-05-19 14:59:57 drhok
260d. Windows
Unable to discern a repeatable performance difference on Win7. On this machine, however, --blob-api database access with 1GB of 10K +- 2K blobs is between 3x and 4x faster than direct disk I/O.
2017-05-19 14:00:19 drhok
230d. Windows
Tested on win7. Performance difference is much smaller than jitter and is hence unmeasureable.
2017-05-19 13:47:06 drhok
240a. Linux
3.13.0: 11.058s 3.18.0: 7.505s 3.19.0: 7.418s
2017-05-19 13:44:27 drhok
230b. Linux
3.13.0: 4.739s 3.18.0: 4.263s 3.19.0: 4.233s
2017-05-19 13:38:39 drhok
290. Verify that the amalgamation builds are byte-for-byte identical on all workstation platforms.
2017-05-19 13:38:29 drhok
290d. Windows using native MinGW.
d3ade7b824dfa54fc0c5523777850ac426322e4e sqlite3.c 36ba310f9cc251dd5f4f837aef15edf18e24fd90 sqlite3.h
2017-05-19 13:35:09 drhok
290e. Windows using NMAKE.
d3ade7b824dfa54fc0c5523777850ac426322e4e sqlite3.c 36ba310f9cc251dd5f4f837aef15edf18e24fd90 sqlite3.h
2017-05-19 13:28:13 drhok
250. Run make wordcount; bash run-wordcount.bash $OPTIONS with options:
2017-05-19 13:28:09 drhok
250b. bash run-wordcount.sh sqlite3.c --cachesize 5 --nosync
2017-05-19 13:25:30 drhok
250a. bash run-wordcount.sh sqlite3.c
2017-05-19 13:15:45 drhok
180a. Linux
SQLite 2017-05-12 14:05:11 a123cb93307a6c48bd711d6af9828c87a1365e023f6fe4ca6eae264c8ec5e0c0 0 errors out of 140682 tests on bella Linux 64-bit little-endian
2017-05-19 13:12:32 drhpending
90a. tclsh th3make quick.rc
2017-05-19 13:12:06 drhok
120. Sqllogictest:
2017-05-19 13:12:01 drhok
120d. tclsh run-all.tcl - on windows
0 errors out of 11879758 tests and 1244 invocations in 3633 seconds Win7
2017-05-19 13:09:14 drhok
200. NDS-Devkit testing
2017-05-19 13:09:10 drhok
200a. 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 updated. No new tag or hashes in fossil yet.
2017-05-19 13:07:12 drhok
160. CEROD tests in the "test/" subdirectory.
2017-05-19 13:06:47 drhok
170i. At least one of the above on Linux.
2017-05-19 13:06:42 drhok
170h. At least one of the above using "memdebug.rc".
2017-05-19 13:06:36 drhok
170a. see.c
th3: 0 errors in 8210269 tests. 4802.147 seconds on bella 64-bit little-endian th3: SQLite 3.19.0 2017-05-16 09:49:42 7940bff32aa6ea868a53680822d148b7ec7a075c01ae9e0d5ad9859bcc339054 memdebug.rc on bella
2017-05-19 12:55:30 drhok
40. Compiler warning checks.
2017-05-19 12:55:26 drhok
40c. OpenBSD GCC using options -Wall
Some warnings with "-O3 -Wall" (tool/warnings.sh script). To do with explicitly casting away (const) from pointers etc. Not likely to be problems. Deemed pass.
2017-05-19 12:42:08 drhpending
120d. tclsh run-all.tcl - on windows
2017-05-19 12:41:40 drhpending
100a. tclsh multitest.tcl --msvc (after updating th3private)
2017-05-19 12:12:35 drhok
40d. Windows (32-bit) MSVC using option /W4 (nmake /f makefile.msc)
2017-05-19 12:10:34 drhok
40e. Windows (64-bit) MSVC using option /W4 (nmake /f makefile.msc)
2017-05-19 12:01:38 drhok
90c. Verify that Fossil repositories are cross-platform with x86/x64.
2017-05-19 12:01:32 drhok
90b. Recompile and test Fossil.
2017-05-19 11:42:59 drhok
140. Fossil updated to use the latest SQLite.
2017-05-19 11:42:59 drhok
140a. No SQLite compiler warnings.
2017-05-19 11:42:59 drhok
140b. Used on active websites with no issues.
2017-05-19 11:42:59 drhok
140c. fossil all dbstat --db-check
2017-05-19 11:42:37 drhok
150. Rebuild and use Firefox with the latest SQLite
2017-05-19 11:33:28 drhok
310b. Mac OS X
2017-05-19 11:22:40 drhok
310e. A database containing WITHOUT ROWID tables.
2017-05-19 11:22:33 drhok
310a. Linux
2017-05-17 19:35:19 danok
190g. At least one of the above on Mac OS X.
2017-05-17 19:35:11 danok
190c. th3make zipvfs.rc memdebug.rc
th3: 0 errors in 10035380 tests. 8585.259 seconds on Chanphen-Kruatawongs-iMac.local th3: SQLite 3.19.0 2017-05-16 09:49:42 7940bff32aa6ea868a53680822d148b7ec7a075c01ae9e0d5ad9859bcc339054
2017-05-17 17:55:09 danok
190d. th3make zipvfs.rc quick.rc -valgrind
th3: 0 errors in 2818941 tests. 27499.147 seconds on darkstar 64-bit little-endian th3: SQLite 3.19.0 2017-05-16 09:49:42 7940bff32aa6ea868a53680822d148b7ec7a075c01ae9e0d5ad9859bcc339054
2017-05-17 13:09:01 danok
200c. Verify the "NDS DevKit" version number shown at the end of the test
th3: NDS DevKit 3.19.0 2017-05-17 11:43:28 223e826af3ee8989
2017-05-17 13:08:42 danok
200b. Test using: tclsh th3make test.rc nds_devkit.rc
th3: 0 errors in 7055501 tests. 1460.257 seconds on darkstar 64-bit little-endian th3: NDS DevKit 3.19.0 2017-05-17 11:43:28 223e826af3ee8989 th3: SQLite 3.19.0 2017-05-16 09:49:42 7940bff32aa6ea868a53680822d148b7ec7a075c01ae9e0d5ad9859bcc339054
2017-05-17 11:53:28 danok
290b. Mac OS X
d3ade7b824dfa54fc0c5523777850ac426322e4e sqlite3.c 36ba310f9cc251dd5f4f837aef15edf18e24fd90 sqlite3.h #define SQLITE_SOURCE_ID "2017-05-16 09:49:42 7940bff32aa6ea868a53..."
2017-05-17 11:52:07 danok
320b. Mac
Builds. sqldiff1.test passes. rbudiff.test passes.
2017-05-17 11:51:20 danok
320a. Linux
Builds. sqldiff1.test passes. rbudiff.test passes.
2017-05-17 11:47:35 danok
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.
gcc -I. ../trunk/src/shell.c ./sqlite3-all.c -o shell -ldl -lm -lpthread generates a working shell tool.
2017-05-17 11:41:23 danok
330. Run the rbu/run_rbu_tests.tcl script in the test-dbs project on Linux.
2017-05-17 11:31:28 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.8.2 and 3.7.3. SQLite 2017-05-16 09:49:42 7940bff32aa6ea868a53680822d148b7ec7a075c01ae9e0d5ad9859bcc339054 0 errors out of 265 tests on darkstar Linux 64-bit little-endian
2017-05-17 11:28:24 danok
220. TEA archive builds correctly and runs:
2017-05-17 11:28:17 danok
220a. Linux
2017-05-17 11:26:30 danok
220b. Mac OS X
2017-05-17 11:25:11 danok
210c. Works on Mac OS X.
2017-05-17 11:22:11 danok
210b. Works on Linux.
2017-05-17 11:18:34 danok
210a. Builds.
2017-05-17 11:16:30 danreview
200a. 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 updated. No new tag or hashes in fossil yet.
2017-05-17 11:15:48 danpending
200b. Test using: tclsh th3make test.rc nds_devkit.rc
2017-05-17 11:03:04 danok
190f. At least one of the above on Linux.
2017-05-17 11:02:58 danok
190b. th3make zipvfs.rc test.rc
th3: 0 errors in 10037671 tests. 2874.649 seconds on darkstar 64-bit little-endian th3: SQLite 3.19.0 2017-05-16 09:49:42 7940bff32aa6ea868a53680822d148b7ec7a075c01ae9e0d5ad9859bcc339054
2017-05-17 10:30:09 danok
190i. th3make zipvfs-cov.rc - verify full coverage
th3: 0 errors in 1247801 tests. 398.145 seconds on darkstar 64-bit little-endian th3: SQLite 3.19.0 2017-05-16 09:49:42 7940bff32aa6ea868a53680822d148b7ec7a075c01ae9e0d5ad9859bcc339054 Statement coverage: 100.00% hit 1590 missed 0 total 1590 Branch coverage: 100.00% hit 941 missed 0 total 941
2017-05-17 09:51:47 danpending
190i. th3make zipvfs-cov.rc - verify full coverage
2017-05-17 09:51:25 danpending
190b. th3make zipvfs.rc test.rc
2017-05-17 09:51:04 danpending
190d. th3make zipvfs.rc quick.rc -valgrind
2017-05-17 09:40:01 danpending
190c. th3make zipvfs.rc memdebug.rc
On OSX.
2017-05-17 09:39:50 dan---
190e. th3make zipvfs.rc quick.rc
2017-05-17 09:38:08 danok
190a. testfixture ../zipvfs/test/zipvfs.test (See test/README.txt for details)
SQLite 2017-05-16 09:49:42 7940bff32aa6ea868a53680822d148b7ec7a075c01ae9e0d5ad9859bcc339054 0 errors out of 85575 tests on darkstar Linux 64-bit little-endian
2017-05-17 09:29:01 danpending
190e. th3make zipvfs.rc quick.rc
On OSX.
2017-05-17 09:26:48 danpending
190a. testfixture ../zipvfs/test/zipvfs.test (See test/README.txt for details)
2017-05-17 07:33:20 danreview+
60a. tclsh multitest.tcl (take care to update ../th3private)
t05: cov.rc -DSQLITE_ENABLE_STAT4 -D_HAVE_SQLITE_CONFIG_H...... FAIL (00:05:58) Coverage misses 1 out of 24054 branches t31: test.rc alignment4.rc -m32 CC=clang....................... FAIL (00:00:18) Missing output file t31/th3-out.txt t44: fast.rc -fsanitize=undefined.............................. FAIL (00:23:07) t44/th3.c:200064:51: runtime error: null pointer passed as argument 1, which is declared to never be null (http://www.sqlite.org/src/artifact/1e448d204045c?ln=870)
2017-05-17 06:44:23 danreview
60a. tclsh multitest.tcl (take care to update ../th3private)
t05: cov.rc -DSQLITE_ENABLE_STAT4 -D_HAVE_SQLITE_CONFIG_H...... FAIL (00:05:58) Coverage misses 1 out of 24054 branches t31: test.rc alignment4.rc -m32 CC=clang....................... FAIL (00:00:18) Missing output file t31/th3-out.txt t44: fast.rc -fsanitize=undefined.............................. FAIL (00:23:07) t44/th3.c:200064:51: runtime error: null pointer passed as argument 1, which is declared to never be null
2017-05-17 06:12:42 danok
80. Tests for platform Mac OS X:
2017-05-17 06:11:45 danok
80c. tclsh multitest.tcl --scenario failures - all failures detected
All scenarios report "FAIL".
2017-05-17 06:06:33 danok
80b. tclsh multitest.tcl --omit test-ex (after updating th3private)
0 failures on 33 th3makes and 135675060 tests in (11:20:32) 2 cores on Chanphen-Kruatawongs-iMac.local SQLite 3.19.0 2017-05-16 09:49:42 7940bff32aa6ea868a53680822d148b7ec7a075c01ae9e0d5ad9859bcc339054
2017-05-16 20:16:21 danok
70. Tests for platform Linux ARM (BeagleBoard)
2017-05-16 20:16:11 danok
70a. tclsh th3make min.rc
th3: 0 errors in 1618134 tests. 4048.926 seconds on beaglebone 32-bit little-endian th3: SQLite 3.19.0 2017-05-16 09:49:42 7940bff32aa6ea868a53680822d148b7ec7a075c01ae9e0d5ad9859bcc339054
2017-05-16 18:31:32 danok
130. Build using the configure/make in main source tree.
2017-05-16 18:31:24 danok
130b. Verify the correct version numbers have been installed.
Version 3.19.0 of the shell, library and tcl extension installed.
2017-05-16 18:21:23 danok
130a. Make sure that autoconf has been run to update the configure script.
configure script specifies version 3.19.0.
2017-05-16 18:19:23 danok
70b. Recompile and test Fossil.
[fossil all rebuild] works. [fossil sync] works. Fossil commit [27e65b07].
2017-05-16 17:43:34 danpending
70b. Recompile and test Fossil.
2017-05-16 17:30:42 danpending
70a. tclsh th3make min.rc
2017-05-16 17:14:40 danpending
80b. tclsh multitest.tcl --omit test-ex (after updating th3private)
2017-05-16 17:12:59 dan---
80c. tclsh multitest.tcl --scenario failures - all failures detected
2017-05-16 17:12:48 danok
80d. tclsh releasetest.tcl --platform Failure-Detection - all failures detected
All configurations reported "FAIL". 20 failures out of 394 tests in (00:11:11) on Chanphen-Kruatawongs-iMac.local SQLite 3.19.0 2017-05-16 09:49:42 7940bff32aa6ea868a53680822d148b7ec7a075c01ae9e0d5ad9859bcc339054
2017-05-16 17:11:34 danok
80c. tclsh multitest.tcl --scenario failures - all failures detected
All configurations reported "FAIL". 20 failures out of 394 tests in (00:11:11) on Chanphen-Kruatawongs-iMac.local SQLite 3.19.0 2017-05-16 09:49:42 7940bff32aa6ea868a53680822d148b7ec7a075c01ae9e0d5ad9859bcc339054
2017-05-16 17:11:28 dan---+
80c. tclsh multitest.tcl --scenario failures - all failures detected
All configurations reported "FAIL". 20 failures out of 394 tests in (00:11:11) on Chanphen-Kruatawongs-iMac.local SQLite 3.19.0 2017-05-16 09:49:42 7940bff32aa6ea868a53680822d148b7ec7a075c01ae9e0d5ad9859bcc339054
2017-05-16 16:49:46 danok
80a. tclsh releasetest.tcl
0 failures out of 4071673 tests in (02:37:25) 2 cores on Chanphen-Kruatawongs-iMac.local; SQLite 3.19.0 2017-05-16 09:49:42 7940bff32aa6ea868a53680822d148b7ec7a075c01ae9e0d5ad9859bcc339054
2017-05-16 16:45:51 danok
290a. Linux
d3ade7b824dfa54fc0c5523777850ac426322e4e sqlite3.c 36ba310f9cc251dd5f4f837aef15edf18e24fd90 sqlite3.h #define SQLITE_SOURCE_ID "2017-05-16 09:49:42 7940bff32aa6ea868a5..."
2017-05-16 16:44:47 danok
290c. OpenBSD
SHA1 (sqlite3.c) = d3ade7b824dfa54fc0c5523777850ac426322e4e SHA1 (sqlite3.h) = 36ba310f9cc251dd5f4f837aef15edf18e24fd90 #define SQLITE_SOURCE_ID "2017-05-16 09:49:42 7940bff32aa6ea868a5..."
2017-05-16 16:44:33 dan---+
290c. OpenBSD
SHA1 (sqlite3.c) = d3ade7b824dfa54fc0c5523777850ac426322e4e SHA1 (sqlite3.h) = 36ba310f9cc251dd5f4f837aef15edf18e24fd90 #define SQLITE_SOURCE_ID "2017-05-16 09:49:42 7940bff32aa6ea868a5..."
2017-05-16 16:42:58 danok
110. Tests for platform OpenBSD (x86):
2017-05-16 16:42:52 danok
110b. th3make quick.rc
th3: 0 errors in 1745574 tests. 805.521 seconds on obsd.my.domain 32-bit little-endian; th3: SQLite 3.19.0 2017-05-16 09:49:42 7940bff32aa6ea868a53680822d148b7ec7a075c01ae9e0d5ad9859bcc339054
2017-05-16 16:38:29 danok
110a. make test
SQLite 2017-05-16 09:49:42 7940bff32aa6ea868a53680822d148b7ec7a075c01ae9e0d5ad9859bcc339054; 0 errors out of 140531 tests on obsd.my.domain OpenBSD 32-bit little-endian
2017-05-16 16:26:28 danpending
110b. th3make quick.rc
2017-05-16 16:25:37 danpending
110a. make test
2017-05-16 16:13:36 danpending
60a. tclsh multitest.tcl (take care to update ../th3private)
2017-05-16 16:08:04 danok
60f. tclsh releasetest.tcl --platform Failure-Detection - all failures detected
All configurations report "FAIL". 26 failures out of 786 tests in (00:08:31) on darkstar; SQLite 3.19.0 2017-05-16 09:49:42 7940bff32aa6ea868a53680822d148b7ec7a075c01ae9e0d5ad9859bcc339054
2017-05-16 16:07:58 dan---+
60f. tclsh releasetest.tcl --platform Failure-Detection - all failures detected
All configurations report "FAIL". 26 failures out of 786 tests in (00:08:31) on darkstar; SQLite 3.19.0 2017-05-16 09:49:42 7940bff32aa6ea868a53680822d148b7ec7a075c01ae9e0d5ad9859bcc339054
2017-05-16 15:55:32 danok
60d. Check the "releasetest.tcl" log files for undetected errors.
2017-05-16 15:49:32 danok
60c. tclsh releasetest.tcl
0 failures out of 9600619 tests in (01:38:56) 3 cores on darkstar; SQLite 3.19.0 2017-05-16 09:49:42 7940bff32aa6ea868a53680822d148b7ec7a075c01ae9e0d5ad9859bcc339054
2017-05-16 14:09:06 danpending
80a. tclsh releasetest.tcl
2017-05-16 13:42:45 danpending
60c. tclsh releasetest.tcl
2017-05-16 13:42:39 danok
60g. sh tool/symbols.sh - no incorrect exports or dependencies
Script reports sqlite3session_*** and sqlite3changeset_*** symbols as "surplus".
2017-05-16 11:19:05 danok
40b. Mac OS X GCC -Wall -Wextra (the "tool/warnings.sh" script)
2017-05-16 11:07:55 danok
50. OMIT, ENABLE, and DISABLE options:
2017-05-16 11:07:50 danok
50a. tclsh ../tool/omittest.tcl -skip_run -target libsqlite3.a
ENABLE_LOCKING_STYLE does not build on Linux.
2017-05-16 09:55:32 danreview
40c. OpenBSD GCC using options -Wall
Some warnings with "-O3 -Wall" (tool/warnings.sh script). To do with explicitly casting away (const) from pointers etc. Not likely to be problems.
2017-05-16 09:36:51 danok
40a. Linux GCC -Wall -Wextra (the "tool/warnings.sh" script)
2017-05-15 18:28:21 drhok
20. Source code change review. fossil diff --from release --to trunk
2017-05-15 18:28:21 drhok
20g. Check all calls to sqlite3OsRead() and sqlite3OsWrite() to ensure that offset computations are 64-bit clean.
2017-05-15 18:28:21 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-05-15 18:28:21 drhok
20j. Verify that the list of APIs exposed via the extension header is up-to-date (sqlite3ext.h).
2017-05-15 18:28:21 drhok
20k. Significant compile-time options are recognized by the sqlite3_compileoption_used() interface.
2017-05-15 18:28:21 drhok
20l. Compare sqlite3.c and sqlite3.h against the previous release.
2017-05-15 18:00:09 drhok
20a. No stray changes.
2017-05-15 18:00:09 drhok
20b. All significant changes are mentioned in the "changes" log of the documentation.
2017-05-15 18:00:09 drhok
20c. New code complies with style guidelines.
2017-05-15 18:00:09 drhok
20d. New code complies with design rules.
2017-05-15 18:00:09 drhok
20e. Comments have been updated to reflect code changes.
2017-05-15 18:00:09 drhok
20f. Variables and functions have been renamed to reflect changes in their use.
2017-05-15 18:00:09 drhok
20i. Verify that source code contains no tabs and that surplus whitespace has been removed.
2017-05-15 17:52:30 drhok
10. Test procedure review.
2017-05-15 17:52:30 drhok
10a. Review the "test/releasetest.tcl" script for completeness and accuracy.
2017-05-15 17:52:30 drhok
10b. Review "multitest.tcl" and "alignment*.rc" scripts in TH3 for completeness.
2017-05-15 17:52:30 drhok
10c. Review this checklist for completeness and accuracy.
2017-05-13 20:32:06 drhok
120b. No SQLite compiler warnings.
2017-05-13 20:32:02 drhok
120a. Checked in latest SQLite amalgamation.
2017-05-13 20:31:58 drhok
120c. tclsh run-all.tcl - on unix
0 errors out of 11879758 tests and 1244 invocations in 774 seconds
2017-05-13 17:07:31 drhok
150a. Routine use with no problems
2017-05-13 17:07:27 drhok
150d. ./mach web-platform-tests IndexedDB
Expected results: 1260 Unexpected results: 0
2017-05-13 17:05:55 drhok
150c. ./mach xpcshell-test dom/indexedDB
Expected results: 205 Unexpected results: 0
2017-05-13 17:04:14 drhok
150b. ./mach mochitest dom/indexedDB
1 INFO Passed: 26767 2 INFO Failed: 0