SQLite

Release Checklist For SQLite 3.29.0
Login
2019-07-10 17:29:35 drhok
20d. th3make zipvfs.rc quick.rc -valgrind
th3: 0 errors in 2904556 tests. 18711.154 seconds on udell 64-bit little-endian th3: SQLite 3.29.0 2019-07-09 23:35:50 6f328c35947d6b3a0741514757b8944692203e89bdb2e7f9bbce8ad9288be344
2019-07-10 17:29:25 drhpending
20d. th3make zipvfs.rc quick.rc -valgrind
th3: 0 errors in 2904556 tests. 18711.154 seconds on udell 64-bit little-endian th3: SQLite 3.29.0 2019-07-09 23:35:50 6f328c35947d6b3a0741514757b8944692203e89bdb2e7f9bbce8ad9288be344
2019-07-10 17:01:02 drhok
21. NDS-Devkit testing
2019-07-10 17:01:00 drhok
21a. Merge all trunk enhancements into the reuse-schema branch and use that branch to update the devkit.
2019-07-10 14:53:40 drhok
27. Compare performance to the previous release using kvtest.
2019-07-10 14:53:37 drhok
27b. Linux
2019-07-10 14:52:15 drhok
20c. th3make zipvfs.rc memdebug.rc
th3: 0 errors in 11779862 tests. 9504.351 seconds on bella 64-bit little-endian th3: SQLite 3.29.0 2019-07-09 23:35:50 6f328c35947d6b3a0741514757b8944692203e89bdb2e7f9bbce8ad9288be344
2019-07-10 13:52:38 danok
37. Website built procedures
2019-07-10 13:52:36 danok
37b. All build products work on their target platforms
2019-07-10 13:52:34 danok
37a. Compile-time options for build products have been updated as necessary
2019-07-10 13:40:44 drhok
27c. Mac
2019-07-10 13:37:19 drhok
20b. th3make zipvfs.rc test.rc
th3: 0 errors in 9656095 tests. 4876.405 seconds on SQLite-iMac-2018 64-bit little-endian th3: SQLite 3.29.0 2019-07-09 23:35:50 6f328c35947d6b3a0741514757b8944692203e89bdb2e7f9bbce8ad9288be344
2019-07-10 13:18:04 danok
20f. At least one of the above on Linux.
(a) ran on Linux.
2019-07-10 13:17:52 danok
20g. At least one of the above on Mac OS X.
(e) ran on OSX.
2019-07-10 13:17:03 danok
20e. th3make zipvfs.rc quick.rc
th3: 0 errors in 2892393 tests. 917.269 seconds on Dans-iMac.local 64-bit little-endian th3: SQLite 3.29.0 2019-07-09 23:35:50 6f328c35947d6b3a0741514757b8944692203e89bdb2e7f9bbce8ad9288be344 th3: 0 errors in 2889830 tests. 2305.096 seconds on DESKTOP-C1KR53M 32-bit little-endian th3: SQLite 3.29.0 2019-07-09 23:35:50 6f328c35947d6b3a0741514757b8944692203e89bdb2e7f9bbce8ad9288be344
2019-07-10 13:16:29 danok
20e. th3make zipvfs.rc quick.rc
th3: 0 errors in 2892393 tests. 917.269 seconds on Dans-iMac.local 64-bit little-endian th3: 0 errors in 2889830 tests. 2305.096 seconds on DESKTOP-C1KR53M 32-bit little-endian th3: SQLite 3.29.0 2019-07-09 23:35:50 6f328c35947d6b3a0741514757b8944692203e89bdb2e7f9bbce8ad9288be344 th3: SQLite 3.29.0 2019-07-09 23:35:50 6f328c35947d6b3a0741514757b8944692203e89bdb2e7f9bbce8ad9288be344
2019-07-10 13:14:53 danok
21c. Verify the "NDS DevKit" version number shown at the end of the test
SQLite 3.29.0
2019-07-10 13:14:42 danok
21b. Test using: tclsh th3make test.rc nds_devkit.rc
th3: 0 errors in 8439771 tests. 2815.528 seconds on darkstar 64-bit little-endian th3: NDS DevKit 3.29.0 2019-07-10 11:24:33 4d4d5a16f420f89f th3: SQLite 3.29.0 2019-07-09 23:35:50 6f328c35947d6b3a0741514757b8944692203e89bdb2e7f9bbce8ad9288be344
2019-07-10 12:56:53 drhok
20h. At least one of the above on Windows.
th3: 0 errors in 2920697 tests. 1900.965 seconds on SQLiteWin10 64-bit little-endian th3: SQLite 3.29.0 2019-07-09 23:35:50 6f328c35947d6b3a0741514757b8944692203e89bdb2e7f9bbce8ad9288be344
2019-07-10 12:41:11 drhok
29. Verify that the performance and size measurement spreadsheet in the documentation (misc/speed-size-graph.ods) is up-to-date.
2019-07-10 12:36:14 drhok
24. Performance tests using speedtest1 compared against the previous release and a release from about one year ago.
2019-07-10 12:36:12 drhok
24a. Android
2019-07-10 12:28:16 drhok
27a. Android
2019-07-10 12:24:52 drhpending
20h. At least one of the above on Windows.
2019-07-10 12:23:14 drhok
18. SEE tests using TH3:
2019-07-10 12:23:09 drhok
18j. At least one of the above using "memdebug.rc".
2019-07-10 12:23:01 drhok
18c. see-aes256-ofb.c
th3: 0 errors in 7360319 tests. 7130.185 seconds on SQLiteWin10 64-bit little-endian th3: SQLite 3.29.0 2019-07-09 12:03:21 47010bf17cb080cc1c693c84d16b986ea4addf9c54bd7e22de1e0f6b555ea9d1 memdebug
2019-07-10 12:09:24 drhok
2. Source code change review. fossil diff --from release --to trunk
2019-07-10 12:09:21 drhok
2k. Significant compile-time options are recognized by the sqlite3_compileoption_used() interface.
2019-07-10 12:09:19 drhok
2j. Verify that the list of APIs exposed via the extension header is up-to-date (sqlite3ext.h).
2019-07-10 12:09:17 drhok
2i. Verify that source code contains no tabs and that surplus whitespace has been removed.
2019-07-10 12:09:15 drhok
2h. 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]*(/
2019-07-10 12:09:13 drhok
2g. Check all calls to sqlite3OsRead() and sqlite3OsWrite() to ensure that offset computations are 64-bit clean.
2019-07-10 12:09:10 drhok
2f. Variables and functions have been renamed to reflect changes in their use.
2019-07-10 12:09:08 drhok
2e. Comments have been updated to reflect code changes.
2019-07-10 12:09:05 drhok
2d. New code complies with design rules.
2019-07-10 12:09:03 drhok
2c. New code complies with style guidelines.
2019-07-10 12:09:01 drhok
2b. All significant changes are mentioned in the "changes" log of the documentation.
2019-07-10 12:08:57 drhok
2a. No stray changes.
2019-07-10 12:02:56 drhok
3. Documentation review:
2019-07-10 12:02:54 drhok
3c. Release accouncement in "news.html".
2019-07-10 11:54:30 danok
20e. th3make zipvfs.rc quick.rc
th3: 0 errors in 2892393 tests. 917.269 seconds on Dans-iMac.local 64-bit little-endian th3: SQLite 3.29.0 2019-07-09 23:35:50 6f328c35947d6b3a0741514757b8944692203e89bdb2e7f9bbce8ad9288be344
2019-07-10 11:46:02 drhok
3i. Check new/changed documentation for spelling and gramatical mistakes.
2019-07-10 11:27:17 danpending
21b. Test using: tclsh th3make test.rc nds_devkit.rc
Testing with the above.
2019-07-10 11:21:41 danpending
20e. th3make zipvfs.rc quick.rc
osx win32/msvc
2019-07-10 11:21:14 danok
35. Run the rbu/run_rbu_tests.tcl script in the test-dbs project on Linux.
All tests report "round trip test successful."
2019-07-10 11:19:03 drhok
3h. Test metrics are up-to-date (testing.html).
2019-07-10 11:18:57 drhok
3g. Database footprint is up-to-date (features.html).
2019-07-10 11:18:53 drhok
3f. The compile-time options are all up-to-date (compile.html).
2019-07-10 11:18:49 drhok
3e. Requirements marks are up-to-date in both documentation and source code.
2019-07-10 11:18:47 drhok
3d. No unresolved hyperlinks in the documentation build.
2019-07-10 11:18:43 drhok
3b. Release announcement in "changes.in".
2019-07-10 11:18:40 drhok
3a. Latest release on the "index.html" page.
2019-07-10 11:18:33 drhok
1. Test procedure review.
2019-07-10 11:18:32 drhok
1a. Review the "test/releasetest.tcl" script for completeness and accuracy.
2019-07-10 11:18:30 drhok
1b. Review "multitest.tcl" and "alignment*.rc" scripts in TH3 for completeness.
2019-07-10 11:18:28 drhok
1c. Review this checklist for completeness and accuracy.
2019-07-10 11:08:47 danpending
20d. th3make zipvfs.rc quick.rc -valgrind
Linux
2019-07-10 11:07:51 drhpending
20d. th3make zipvfs.rc quick.rc -valgrind
2019-07-10 11:06:50 danpending
20e. th3make zipvfs.rc quick.rc
osx
2019-07-10 11:03:29 drhok
18b. see-aes128-ofb.c
th3: 0 errors in 1793530 tests. 242.932 seconds on udell 64-bit little-endian th3: SQLite 3.29.0 2019-07-09 12:03:21 47010bf17cb080cc1c693c84d16b986ea4addf9c54bd7e22de1e0f6b555ea9d1
2019-07-10 10:46:03 drhok
18e. see-aes128-ccm.c
th3: 0 errors in 1793583 tests. 268.459 seconds on udell 64-bit little-endian th3: SQLite 3.29.0 2019-07-09 12:03:21 47010bf17cb080cc1c693c84d16b986ea4addf9c54bd7e22de1e0f6b555ea9d1
2019-07-10 10:19:48 drhpending
18c. see-aes256-ofb.c
2019-07-10 10:19:42 drh---
18b. see-aes128-ofb.c
2019-07-10 10:19:32 drhpending
18b. see-aes128-ofb.c
2019-07-10 10:19:20 drhpending
20c. th3make zipvfs.rc memdebug.rc
2019-07-10 10:19:16 drhpending
20b. th3make zipvfs.rc test.rc
2019-07-10 10:11:03 drhok
18h. see-aes256-cryptoapi.c
th3: 0 errors in 1797861 tests. 739.857 seconds on SQLiteWin10 64-bit little-endian th3: SQLite 3.29.0 2019-07-09 12:03:21 47010bf17cb080cc1c693c84d16b986ea4addf9c54bd7e22de1e0f6b555ea9d1
2019-07-10 09:41:13 drhok
18n. At least one of the above on Windows.
2019-07-10 09:41:09 drhok
18a. see.c
th3: 0 errors in 1797868 tests. 765.372 seconds on SQLiteWin10 64-bit little-endian th3: SQLite 3.29.0 2019-07-09 12:03:21 47010bf17cb080cc1c693c84d16b986ea4addf9c54bd7e22de1e0f6b555ea9d1
2019-07-10 09:36:41 drhok
6. Tests for platform Linux x86_64:
2019-07-10 09:36:33 drhok
6a. tclsh multitest.tcl
1 failures on 44 th3makes and 215475138 tests in (10:26:18) 3 cores on bella SQLite 3.29.0 2019-07-08 18:35:51 36295dcebcb5487f2a462eabb41900ac28b8e839898ef0fae0aa4730bf9b0671 The one failure is a test-script problem, subsequently fixed. We will rerun this test later. ----------------------------- 0 failures on 44 th3makes and 224719372 tests in (10:43:53) 3 cores on bella SQLite 3.29.0 2019-07-09 17:36:26 b6e17f0139482a22c2fc84552767bc9a293b282499e3a790de069e0e84455fb2
2019-07-10 09:27:54 danok
31. 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 test/backcompat.test: SQLite 2019-07-09 23:35:50 6f328c35947d6b3a0741514757b8944692203e89bdb2e7f9bbce8ad9288be344 0 errors out of 205 tests on darkstar Linux 64-bit little-endian
2019-07-10 01:19:43 drhok
26. Run make wordcount; bash run-wordcount.bash $OPTIONS with options:
2019-07-10 01:19:40 drhok
26b. bash run-wordcount.sh sqlite3.c --cachesize 5 --nosync
2019-07-10 01:17:39 drhok
26a. bash run-wordcount.sh sqlite3.c
2019-07-10 01:13:09 drhok
25. Performance tests using speedtest1 --testset rtree
2019-07-10 01:13:07 drhok
25a. Linux
2019-07-10 01:09:09 drhok
24b. Linux
2019-07-10 00:14:01 drhok
23. TEA archive builds correctly and runs:
2019-07-10 00:13:59 drhok
23a. Linux
2019-07-10 00:13:51 drhok
28. Use the ".selftest" command of the shell to verify that legacy database files are readable and cross-platform
2019-07-10 00:13:49 drhok
28b. Linux
2019-07-10 00:13:45 drhok
28c. Mac
2019-07-10 00:11:14 drhok
15. Build using the configure/make in main source tree.
2019-07-10 00:11:12 drhok
15a. Make sure that autoconf has been run to update the configure script.
2019-07-10 00:11:10 drhok
15b. Verify the correct version numbers have been installed.
2019-07-10 00:10:54 drhok
22. Amalgamation autoconf tarball.
2019-07-10 00:10:52 drhok
22d. Works on Windows MinGW
2019-07-10 00:09:18 drhok
23b. Mac OS X
2019-07-10 00:07:47 drhok
22e. Works on Windows MSVC
2019-07-10 00:06:16 drhok
22c. Works on Mac OS X.
2019-07-10 00:01:54 drhok
22b. Works on Linux.
2019-07-09 23:57:18 drhok
22a. Builds.
2019-07-09 23:47:46 drhok
32. Build and verify correct operation of sqlite3_analyzer on:
2019-07-09 23:47:44 drhok
32b. Mac OS X
2019-07-09 23:47:27 drhok
32c. Windows (MinGW)
2019-07-09 23:44:23 drhok
30. Verify that the amalgamation builds are byte-for-byte identical on all workstation platforms.
2019-07-09 23:44:19 drhok
30d. Windows using native MinGW.
2d855c6c3b0b54c356150b20e97ea1bc90db5c89f46fca046e306170e6d27477 sqlite3.c fa7e70d7eab7b4ae582139cb46aa46ea9ba5be9ad556cffad7ae725ebd45ee54 sqlite3.h
2019-07-09 23:39:01 drhok
28a. iBook PPC
2019-07-09 23:38:54 drhok
9. Tests for platform Mac OS X 10.5 (PPC):
2019-07-09 23:38:51 drhok
9a. .selftest checks (see below)
2019-07-09 23:34:29 drhok
9c. Verify that Fossil repositories are cross-platform with x86/x64.
2019-07-09 23:34:24 drhok
9b. Recompile and test Fossil.
2019-07-09 23:30:29 drhok
32a. Linux
2019-07-09 23:27:51 drhok
33. Build and verify sqldiff
2019-07-09 23:27:48 drhok
33b. Mac
2019-07-09 23:26:37 drhok
33a. Linux
2019-07-09 23:24:33 drhok
30c. Mac OS X (PPC)
2d855c6c3b0b54c356150b20e97ea1bc90db5c89f46fca046e306170e6d27477 sqlite3.c fa7e70d7eab7b4ae582139cb46aa46ea9ba5be9ad556cffad7ae725ebd45ee54 sqlite3.h
2019-07-09 23:16:20 drhok
30b. Mac OS X
2d855c6c3b0b54c356150b20e97ea1bc90db5c89f46fca046e306170e6d27477 sqlite3.c fa7e70d7eab7b4ae582139cb46aa46ea9ba5be9ad556cffad7ae725ebd45ee54 sqlite3.h
2019-07-09 23:12:28 drhok
30a. Linux
2d855c6c3b0b54c356150b20e97ea1bc90db5c89f46fca046e306170e6d27477 sqlite3.c fa7e70d7eab7b4ae582139cb46aa46ea9ba5be9ad556cffad7ae725ebd45ee54 sqlite3.h
2019-07-09 23:11:36 drhok
30e. Windows using NMAKE.
2d855c6c3b0b54c356150b20e97ea1bc90db5c89f46fca046e306170e6d27477 sqlite3.c fa7e70d7eab7b4ae582139cb46aa46ea9ba5be9ad556cffad7ae725ebd45ee54 sqlite3.h
2019-07-09 23:09:16 drhok
27d. Windows
Identical performance on all three versions
2019-07-09 23:05:38 drhok
25b. Windows
year-ago: 10.888 3.28.0: 10.888 3.29.0: 10.825
2019-07-09 23:04:07 drhok
24d. Windows
year ago: 6.374 3.28.0: 6.281 3.29.0: 6.280
2019-07-09 20:49:38 danok
20a. testfixture ../zipvfs/test/zipvfs.test (See test/README.txt for details)
SQLite 2019-07-09 17:36:26 b6e17f0139482a22c2fc84552767bc9a293b282499e3a790de069e0e84455fb2 0 errors out of 81821 tests on darkstar Linux 64-bit little-endian
2019-07-09 20:23:59 drhok
28d. Windows
2019-07-09 20:22:53 drhok
32e. A database containing WITHOUT ROWID tables.
2019-07-09 20:22:51 drhok
32d. Windows (MSVC)
2019-07-09 20:21:57 drhok
33c. Windows
2019-07-09 20:20:10 drhok
10. Tests for platform Windows:
2019-07-09 20:20:06 drhok
10b. tclsh multitest.tcl --msvc --quick on x86
0 failures on 16 th3makes and 23753488 tests in (01:50:48) 2 cores on SQLiteWin10 SQLite 3.29.0 2019-07-08 18:35:51 36295dcebcb5487f2a462eabb41900ac28b8e839898ef0fae0aa4730bf9b0671
2019-07-09 18:29:21 danok
11. Tests for platform OpenBSD (x86):
2019-07-09 18:29:19 danok
11b. th3make quick.rc
th3: 0 errors in 1795680 tests. 868.642 seconds on obsd.my.domain 32-bit little-endian th3: SQLite 3.29.0 2019-07-09 17:36:26 b6e17f0139482a22c2fc84552767bc9a293b282499e3a790de069e0e84455fb2
2019-07-09 18:25:55 danok
11a. make test
SQLite 2019-07-09 17:36:26 b6e17f0139482a22c2fc84552767bc9a293b282499e3a790de069e0e84455fb2 0 errors out of 247594 tests on obsd.my.domain OpenBSD 32-bit little-endian
2019-07-09 18:06:26 danok
12. On an F2FS filesystem with the F2FS_FEATURE_ATOMIC_WRITE feature, test with: $(TOP)/configure && make test OPTS="-DSQLITE_ENABLE_BATCH_ATOMIC_WRITE -DSQLITE_DEBUG -DSQLITE_NO_SYNC"
SQLite 2019-07-09 17:36:26 b6e17f0139482a22c2fc84552767bc9a293b282499e3a790de069e0e84455fb2 0 errors out of 246210 tests on darkstar Linux 64-bit little-endian
2019-07-09 18:05:10 drhok
24c. Mac
year-ago: 4.257s 3.28.0: 4.313s 3.29.0: 4.335s Slower and slower, which is odd because Linux is faster. Not sure what is going on here and we don't have tools on a Mac to dig deeper. But the performance is similar so we give it a pass.
2019-07-09 17:43:49 drhok
10i. Verify that EXEs and DLLs generated using MSVC contain the correct version number, product name, description, and copyright as resources.
2019-07-09 17:42:12 drhok
10h. sh tool/symbols-mingw.sh - no incorrect exports or dependencies
2019-07-09 17:37:18 danok
5. OMIT, ENABLE, and DISABLE options:
2019-07-09 17:37:16 danok
5a. tclsh ../tool/omittest.tcl -skip_run -target libsqlite3.a
ENABLE_LOCKING_STYLE does not work on Linux, as expected. Aside from that one, all builds report success.
2019-07-09 17:32:55 drhok
10c. tclsh multitest.tcl --msvc --scenario failures - verify failures detected
2019-07-09 17:32:06 drhok
10a. tclsh multitest.tcl --msvc
0 failures on 38 th3makes and 170336970 tests in (14:40:39) 2 cores on SQLiteWin10 SQLite 3.29.0 2019-07-08 18:35:51 36295dcebcb5487f2a462eabb41900ac28b8e839898ef0fae0aa4730bf9b0671
2019-07-09 17:15:34 danok
10g. nmake /f makefile.msc WIN32HEAP=1 DEBUG=4 test
SQLite 2019-07-09 12:03:21 47010bf17cb080cc1c693c84d16b986ea4addf9c54bd7e22de1e0f6b555ea9d1 0 errors out of 218288 tests on DESKTOP-C1KR53M Windows NT 32-bit little-endian
2019-07-09 17:15:21 danok
10f. nmake /f makefile.msc MEMDEBUG=1 DEBUG=3 test
SQLite 2019-07-09 12:03:21 47010bf17cb080cc1c693c84d16b986ea4addf9c54bd7e22de1e0f6b555ea9d1 0 errors out of 218295 tests on DESKTOP-C1KR53M Windows NT 32-bit little-endian
2019-07-09 17:01:15 danok
7. Tests for platform Linux ARM (BeagleBoard)
2019-07-09 17:01:10 danok
7b. Recompile and test Fossil.
[fossil clone] works on sqlite.org/src. [fossil rebuild] works.
2019-07-09 17:00:35 danok
7a. tclsh th3make min.rc
th3: 0 errors in 1667597 tests. 4010.448 seconds on beaglebone 32-bit little-endian th3: SQLite 3.29.0 2019-07-09 12:03:21 47010bf17cb080cc1c693c84d16b986ea4addf9c54bd7e22de1e0f6b555ea9d1
2019-07-09 16:54:44 danok
10e. tclsh releasetest.tcl --msvc --platform Failure-Detection - all failures detected
DESKTOP-C1KR53M Windows NT 10.0 intel littleEndian 14 errors from 198 tests in 6 configurations. SQLite version 3.29.0 2019-07-09 12:03:21 47010bf17cb080cc1c693c84d16b986ea4addf9c54bd7e22de1e0f6b555ea9d1 All configurations report "FAILED".
2019-07-09 16:50:39 drhok
18k. At least one of the above with option -DSQLITE_DIRECT_OVERFLOW_READ.
2019-07-09 16:50:34 drhok
18d. see-rc4.c
th3: 0 errors in 1785335 tests. 338.575 seconds on SQLite-iMac-2018.local 64-bit little-endian th3: SQLite 3.29.0 2019-07-09 12:03:21 47010bf17cb080cc1c693c84d16b986ea4addf9c54bd7e22de1e0f6b555ea9d1 quick.rc -DSQLITE_DIRECT_OVERFLOW_READ
2019-07-09 16:49:36 danok
10d. tclsh test/releasetest.tcl --msvc
DESKTOP-C1KR53M Windows NT 10.0 intel littleEndian 0 errors from 2689207 tests in 6 configurations. SQLite version 3.29.0 2019-07-09 12:03:21 47010bf17cb080cc1c693c84d16b986ea4addf9c54bd7e22de1e0f6b555ea9d1
2019-07-09 16:01:13 drhok
18i. At least one of the above using "test.rc".
2019-07-09 16:00:54 drhok
18m. At least one of the above on Mac OS X.
2019-07-09 16:00:50 drhok
18f. see-cccrypt.c
th3: 0 errors in 7548096 tests. 3415.387 seconds on SQLite-iMac-2018.local 64-bit little-endian th3: SQLite 3.29.0 2019-07-09 12:03:21 47010bf17cb080cc1c693c84d16b986ea4addf9c54bd7e22de1e0f6b555ea9d1
2019-07-09 15:43:37 danpending
7b. Recompile and test Fossil.
2019-07-09 15:43:34 danpending
7a. tclsh th3make min.rc
2019-07-09 15:10:38 drhpending
18f. see-cccrypt.c
2019-07-09 15:10:29 drhok
18l. At least one of the above on Linux.
2019-07-09 15:10:23 drhok
18g. see-aes256-openssl.c
th3: 0 errors in 1793531 tests. 235.866 seconds on bella 64-bit little-endian th3: SQLite 3.29.0 2019-07-09 12:03:21 47010bf17cb080cc1c693c84d16b986ea4addf9c54bd7e22de1e0f6b555ea9d1 quick.rc
2019-07-09 14:55:17 drhok
17. CEROD tests in the "test/" subdirectory.
2019-07-09 14:45:45 drhok
19. SEE using configure; make test
2019-07-09 14:45:42 drhok
19b. Mac
2019-07-09 14:30:42 drhok
6g. CC=clang CFLAGS='-fsanitize=address,undefined' ./configure --enable-debug && make test
8 errors out of 248968 tests on bella Linux 64-bit little-endian !Failures on these tests: crash8-1.2 crash8.2.1 crash8-4.4 shell1-1.1.3 shell1-1.3.3 shell3-1.7 sqldiff-1.0 sqldiff-1.1 All errors are memory leaks in external test programs. Dunno yet if we just want to say that this is a "pass" or if we should try to fix the utterly harmless leaks. Decision: call this a "pass"
2019-07-09 14:28:58 drhok
19a. Linux
2019-07-09 14:27:46 drhfail
6g. CC=clang CFLAGS='-fsanitize=address,undefined' ./configure --enable-debug && make test
8 errors out of 248968 tests on bella Linux 64-bit little-endian !Failures on these tests: crash8-1.2 crash8.2.1 crash8-4.4 shell1-1.1.3 shell1-1.3.3 shell3-1.7 sqldiff-1.0 sqldiff-1.1 All errors are memory leaks in external test programs. Dunno yet if we just want to say that this is a "pass" or if we should try to fix the utterly harmless leaks.
2019-07-09 13:55:59 drhok
6f. sh tool/symbols.sh - no incorrect exports or dependencies
2019-07-09 13:55:24 drhok
6d. tclsh multitest.tcl --scenario failures - all failures detected
5 failures on 5 th3makes and 118 tests in (00:00:39) on bella SQLite 3.29.0 2019-07-08 18:35:51 36295dcebcb5487f2a462eabb41900ac28b8e839898ef0fae0aa4730bf9b0671
2019-07-09 13:54:54 drhok
8. Tests for platform Mac OS X:
2019-07-09 13:54:51 drhok
8c. tclsh multitest.tcl --scenario failures - all failures detected
2 failures on 2 th3makes and 42 tests in (00:00:06) on SQLite-iMac-2018 SQLite 3.29.0 2019-07-08 18:35:51 36295dcebcb5487f2a462eabb41900ac28b8e839898ef0fae0aa4730bf9b0671
2019-07-09 13:54:25 drhok
6c. tclsh multitest.tcl --scenario obscure
0 failures on 2 th3makes and 3635097 tests in (00:08:33) on bella SQLite 3.29.0 2019-07-08 18:35:51 36295dcebcb5487f2a462eabb41900ac28b8e839898ef0fae0aa4730bf9b0671
2019-07-09 13:39:17 drhok
8b. tclsh multitest.tcl
0 failures on 39 th3makes and 181397542 tests in (11:25:00) 2 cores on SQLite-iMac-2018 SQLite 3.29.0 2019-07-08 18:35:51 36295dcebcb5487f2a462eabb41900ac28b8e839898ef0fae0aa4730bf9b0671 SQLite-iMac-2018
2019-07-09 13:07:37 drhretest
6a. tclsh multitest.tcl
1 failures on 44 th3makes and 215475138 tests in (10:26:18) 3 cores on bella SQLite 3.29.0 2019-07-08 18:35:51 36295dcebcb5487f2a462eabb41900ac28b8e839898ef0fae0aa4730bf9b0671 The one failure is a test-script problem, subsequently fixed. We will rerun this test later.
2019-07-08 23:21:58 drhok
14. Sqllogictest:
2019-07-08 23:21:54 drhok
14d. tclsh run-all.tcl - on windows
0 errors out of 11879758 tests and 1244 invocations in 2278 seconds
2019-07-08 21:33:44 drhok
13. Trunk changes merged and verified on active branches:
2019-07-08 21:33:41 drhok
13e. reuse-schema
2019-07-08 21:26:11 drhpending
14d. tclsh run-all.tcl - on windows
2019-07-08 21:25:37 drhok
13d. begin-concurrent-pnu-wal2
2019-07-08 21:19:41 drhok
13f. wal2
2019-07-08 21:12:54 drhok
13c. begin-concurrent-pnu
2019-07-08 21:07:55 drhok
14c. tclsh run-all.tcl - on unix
0 errors out of 11879758 tests and 1244 invocations in 863 seconds
2019-07-08 21:06:21 drhok
13b. begin-concurrent
2019-07-08 20:59:52 drhok
13a. apple-osx
2019-07-08 20:52:49 drhpending
14c. tclsh run-all.tcl - on unix
2019-07-08 20:52:43 drhok
14b. No SQLite compiler warnings.
2019-07-08 20:52:40 drhok
14a. Checked in latest SQLite amalgamation.
2019-07-08 20:49:47 drhok
16. Fossil updated to use the latest SQLite.
2019-07-08 20:49:45 drhok
16b. Used on active websites with no issues.
2019-07-08 20:49:43 drhok
16a. No SQLite compiler warnings.
2019-07-08 20:49:40 drhok
16c. fossil all dbstat --db-check
2019-07-08 20:46:07 drhok
4. Compiler warning checks.
2019-07-08 20:46:04 drhok
4b. Mac OS X GCC -Wall -Wextra (the "tool/warnings.sh" script)
2019-07-08 20:39:46 drhok
4c. Windows (32-bit) MSVC using option /W4 (nmake /f makefile.msc)
2019-07-08 20:38:49 drhok
4d. Windows (64-bit) MSVC using option /W4 (nmake /f makefile.msc)
2019-07-08 20:37:43 drhok
4a. Linux GCC -Wall -Wextra (the "tool/warnings.sh" script)
2019-07-08 20:36:24 danok
6e. tclsh releasetest.tcl --platform Failure-Detection - all failures detected
10 errors from 393 tests in 7 configurations. SQLite version 3.29.0 2019-07-08 13:45:02 8fb0c6d5a38e77aa4c5f394fb8af1b0c7c6a4790e932aabc213a3078ee9acaf6 All configurations "failed".
2019-07-08 20:35:03 drhok
34. Build the "atrc" test program and run "./atrc $DB | ./sqlite3 $DB" against multiple databases, visually verify the result
2019-07-08 20:31:55 drhok
36. 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.
2019-07-08 20:26:16 danok
6b. tclsh releasetest.tcl
darkstar Linux 4.15.0-54-generic x86_64 littleEndian 6 errors from 11291041 tests in 17 configurations. SQLite version 3.29.0 2019-07-08 13:45:02 8fb0c6d5a38e77aa4c5f394fb8af1b0c7c6a4790e932aabc213a3078ee9acaf6 All errors are from the "Sanitize" test. They complain about casting out-of-range (double) values to type (int64). SQLite is doing this intentionally to test if a value can be reversibly converted between these types.
2019-07-08 20:18:42 drhok
2l. Compare sqlite3.c and sqlite3.h against the previous release.
2019-07-08 19:40:35 danok
8d. tclsh releasetest.tcl --platform Failure-Detection - all failures detected
8 errors from 197 tests in 7 configurations. SQLite version 3.29.0 2019-07-08 13:45:02 8fb0c6d5a38e77aa4c5f394fb8af1b0c7c6a4790e932aabc213a3078ee9acaf6
2019-07-08 19:37:13 danok
8a. tclsh releasetest.tcl
Dans-iMac.local Darwin 18.6.0 x86_64 littleEndian 8fb0c6d5a38e77aa4c5f394fb8af1b0c7c6a4790 2019-07-08 13:45:02 UTC 0 errors from 6503731 tests in 6 configurations. SQLite version 3.29.0 2019-07-08 13:45:02 8fb0c6d5a38e77aa4c5f394fb8af1b0c7c6a4790e932aabc213a3078ee9acaf6