| 2025-02-04 22:41:54
| drh | ok
|
| 30. Compare performance to the previous release using kvtest. |
| 2025-02-04 22:41:52
| drh | ok
|
| 30a. Linux |
| 2025-02-04 22:35:42
| drh | ok
|
| 30b. Mac |
| 2025-02-04 21:37:13
| drh | ok
|
| 28. Performance tests using speedtest1 --testcase mix1 speedtest.db
compared against prior releases.
See the header comment on test/speedtest1.c
for guidance on how to compile the latest speedtest1.c against historical amalgamations. |
| 2025-02-04 21:37:11
| drh | ok
|
| 28a. Linux |
| 2025-02-04 21:37:08
| drh | ok
|
| 28b. Mac |
| 2025-02-04 21:04:30
| drh | ok
|
| 26. NDS-Devkit testing - see https://sqlite.org/devops/doc/trunk/build/release-actions-drh.md#sec9.0 for additional guidance. |
| 2025-02-04 21:04:28
| drh | ok
|
| 26a. Merge all trunk enhancements into the reuse-schema branch and use that branch to update the devkit. |
| 2025-02-04 21:04:03
| drh | ok
|
| 26c. Verify the "NDS DevKit" version number shown at the end of the test |
| 2025-02-04 21:04:00
| drh | ok
|
| 26b. Test using: tclsh th3make debug.rc nds_devkit.rc -v ← Note that the -v
option is needed in order to see the NDS DevKit version number in the output. |
| 2025-02-04 20:40:37
| drh | ok
|
| 30c. Windows |
| 2025-02-04 20:36:44
| drh | ok
|
| 28c. Windows |
| 2025-02-04 20:29:22
| drh | ok
|
| 25. ZIPVFS tests. (See also https://sqlite.org/devops/doc/trunk/build/zipvfs.md) |
| 2025-02-04 20:29:18
| drh | ok
|
| 25e. Windows: tclsh multitest.tcl --scenario zipvfs |
| 0 failures on 7 jobs, 2898922 tests in 07:07, 8 cores, w23 (64-bit) |
| 2025-02-04 20:20:34
| drh | ok
|
| 24. SEE tests using TH3. From the TH3 source directory with the sibling ../see for the SEE sources. |
| 2025-02-04 20:20:32
| drh | ok
|
| 24c. Windows: nmake clean see-test |
| 0 failures on 12 jobs, 10065593 tests in 16:59, 8 cores, w23 (64-bit) |
| 2025-02-04 20:10:10
| drh | ok
|
| 29. Run make wordcount and do tests on current and prior versions: |
| 2025-02-04 20:10:08
| drh | ok
|
| 29b. rm -f wc.db && ./wordcount wc.db $BIGTEXT --all --cachesize 5 --nosync |
| 2025-02-04 20:00:57
| drh | ok
|
| 29a. rm -f wc.db && ./wordcount wc.db $BIGTEXT --all |
| 2025-02-04 19:50:26
| drh | ok
|
| 25c. Linux: tclsh multitest.tcl --scenario zipvfs --extra --valgrind --omit 'quick[23]' |
| 0 failures on 6 jobs, 1847486 tests in 38:50, 8 cores, r20 (64-bit) |
| 2025-02-04 19:49:07
| drh | ok
|
| 12. Tests for platform Windows (64-bit): |
| 2025-02-04 19:49:04
| drh | ok
|
| 12c. In sibling TH3 checkout: tclsh multitest.tcl --msvc --scenario failures - verify failures detected |
| 2025-02-04 19:47:56
| drh | ok
|
| 12b. In sibling TH3 checkout: nmake releasetest |
| 0 failures on 69 jobs, 207501918 tests in 04:40:24, 8 cores, w23 (64-bit)
SQLite 3.49.0 2025-02-04 02:38:23 317e9a470fba2a4b717b9cb66488b8fccb44810a80f3a7deaf1ea81906e2b8d2 |
| 2025-02-04 18:40:19
| drh | ok
|
| 25d. Mac: tclsh multitest.tcl --scenario zipvfs |
| 0 failures on 8 jobs, 3744802 tests in 02:51, 4 cores, minimac (64-bit) |
| 2025-02-04 18:35:55
| drh | ok
|
| 25b. testfixture test/testrunner.tcl --zipvfs <ZIPVFS-source-directory> zipvfs |
| 0 errors out of 70457 tests in 02:28 on r20 Linux 64-bit
SQLite 2025-02-04 02:38:23 317e9a470fba2a4b717b9cb66488b8fccb44810a80f3a7deaf1e |
| 2025-02-04 18:35:39
| drh | ok
|
| 25a. Verify that the configure script version number agrees with the SQLite version number |
| 2025-02-04 18:26:47
| drh | ok
|
| 24b. Mac: make clean see-test |
| 0 failures on 12 jobs, 10077585 tests in 06:12, 4 cores, minimac (64-bit) |
| 2025-02-04 16:28:05
| drh | ok
|
| 23. CEROD tests in the "test/" subdirectory. |
| 2025-02-04 16:27:29
| drh | ok
|
| 9. Tests for platform MacOS ARM: |
| 2025-02-04 16:27:25
| drh | ok
|
| 9b. In sibling TH3 checkout: make releasetest |
| 0 failures on 70 jobs, 248449063 tests in 03:57:53, 4 cores, minimac (64-bit)
SQLite 3.49.0 2025-02-04 02:38:23 317e9a470fba2a4b717b9cb66488b8fccb44810a80f3a7deaf1ea81906e2b8d2 |
| 2025-02-04 14:53:44
| drh | ok
|
| 6. Tests for platform Linux x86_64: |
| 2025-02-04 14:53:41
| drh | ok
|
| 6i. In sibling th3 checkout: make releasetest |
| 0 failures on 75 jobs, 262274463 tests in 01:10:10, 16 cores, r21 (32/64-bit)
SQLite 3.49.0 2025-02-04 02:38:23 317e9a470fba2a4b717b9cb66488b8fccb44810a80f3a7deaf1ea81906e2b8d2 |
| 2025-02-04 14:52:08
| drh | ok
|
| 12e. Verify that EXEs and DLLs generated using MSVC contain the correct version number, product name, description, and copyright as resources. |
| 2025-02-04 14:50:48
| drh | ok
|
| 12d. nmake /f Makefile.msc verify-source releasetest |
| 0 errors out of 4095864 tests in 50:39 on w23 Windows NT 64-bit
SQLite 2025-02-04 02:38:23 317e9a470fba2a4b717b9cb66488b8fccb44810a80f3a7deaf1e |
| 2025-02-04 14:13:55
| drh | ok
|
| 8. Tests for platform MacOS x64: |
| 2025-02-04 14:13:52
| drh | ok
|
| 8c. In sibling TH3 checkout: tclsh multitest.tcl --scenario failures - all failures detected |
| 2025-02-04 14:11:34
| drh | ok
|
| 8b. In sibling TH3 checkout: make devtest |
| 0 failures on 6 jobs, 3242847 tests in 09:00, 2 cores, SQLite-iMac-2018 (64-bit) |
| 2025-02-04 13:46:13
| drh | ok
|
| 12f. After updating Fossil to use the latest SQLite, verify that it compiles without warnings and that it works |
| 2025-02-04 13:45:50
| drh | pending
|
| 8b. In sibling TH3 checkout: make devtest |
| 2025-02-04 13:43:05
| drh | ok
|
| 8a. ./configure && make verify-source releasetest |
| 0 errors out of 6134731 tests in 01:38:48 on SQLite-iMac-2018 Darwin 64-bit
SQLite 2025-02-04 02:38:23 317e9a470fba2a4b717b9cb66488b8fccb44810a80f3a7deaf1e |
| 2025-02-04 13:42:46
| drh | pending
|
| 6i. In sibling th3 checkout: make releasetest |
| 2025-02-04 13:42:33
| drh | ok
|
| 6k. In sibling th3 checkout: tclsh multitest.tcl --scenario failures - all failures detected |
| 2025-02-04 13:41:35
| drh | ok
|
| 6j. In sibling th3 checkout: tclsh multitest.tcl --scenario coverage |
| 0 failures on 4 jobs, 7714419 tests in 17:30, 16 cores, r21 (64-bit) |
| 2025-02-04 13:33:47
| drh | ok
|
| 24a. Linux: make clean see-test |
| 0 failures on 12 jobs, 10364450 tests in 06:21, 8 cores, r20 (64-bit) |
| 2025-02-04 13:33:07
| drh | pending
|
| 12d. nmake /f Makefile.msc verify-source releasetest |
| 2025-02-04 13:33:00
| drh | ---
|
| 12c. In sibling TH3 checkout: tclsh multitest.tcl --msvc --scenario failures - verify failures detected |
| 2025-02-04 13:32:32
| drh | pending
|
| 12c. In sibling TH3 checkout: tclsh multitest.tcl --msvc --scenario failures - verify failures detected |
| 2025-02-04 13:32:23
| drh | ok
|
| 12a. Review the first part of doc/compile-for-windows.md for correctness. Ensure that the local build environment is correct, especially the TCLDIR variable. |
| 2025-02-04 13:31:41
| drh | ok
|
| 11. Tests for platform Windows (32-bit): |
| 2025-02-04 13:31:38
| drh | ok
|
| 11c. In sibling TH3 checkout: tclsh multitest.tcl --msvc --scenario failures - verify failures detected |
| 2025-02-04 13:31:16
| drh | ok
|
| 11b. In sibling TH3 checkout: nmake devtest |
| 0 failures on 6 jobs, 3215947 tests in 07:57, 8 cores, w23 (32-bit) |
| 2025-02-04 13:22:55
| drh | ok
|
| 6f. Run auxiliary test script in the /usr subdirectory of the TH3 repository |
| 2025-02-04 13:20:42
| drh | ok
|
| 6g. Verify that the SQLITE_HAVE_SQLITE3R is needed when building the CLI using sqlite3r.c: ./configure --enable-all && make sqlite3r.c shell.c && gcc -DSQLITE_ENABLE_DBPAGE_VTAB -DSQLITE_HAVE_SQLITE3R sqlite3r.c shell.c -ldl -lpthread && ./a.out '' .recover |
| 2025-02-04 13:20:04
| drh | ok
|
| 6e. CC=clang CFLAGS='-fsanitize=thread' ./configure && make threadtest5 && ./threadtest5 |
| 2025-02-04 13:19:23
| drh | ok
|
| 11e. Verify that EXEs and DLLs generated using MSVC contain the correct version number, product name, description, and copyright as resources. |
| 2025-02-04 13:17:36
| drh | ok
|
| 11d. nmake /f Makefile.msc verify-source releasetest |
| 0 errors out of 4093144 tests in 50:42 on w23 Windows NT 32-bit
SQLite 2025-02-04 02:38:23 317e9a470fba2a4b717b9cb66488b8fccb44810a80f3a7deaf1e |
| 2025-02-04 13:15:56
| drh | ok
|
| 6d. Test the reuse-schema branch with ./configure --enable-all && make "OPTS=-DSQLITE_ENABLE_SHARED_SCHEMA" sdevtest |
| 0 errors out of 882552 tests in 02:58 on r21 Linux 64-bit
SQLite 2025-02-03 15:17:31 858163f93893b0f481b27e39f4f7b3f51290606ad96e5f38cea2 |
| 2025-02-04 13:12:31
| drh | pending
|
| 6d. Test the reuse-schema branch with ./configure --enable-all && make "OPTS=-DSQLITE_ENABLE_SHARED_SCHEMA" sdevtest |
| 2025-02-04 13:11:54
| drh | ok
|
| 6c. ./configure --enable-debug --enable-all && make parse.c && CC=clang CFLAGS='-fsanitize=address,undefined' make -e test |
| SQLite 2025-02-04 02:38:23 317e9a470fba2a4b717b9cb66488b8fccb44810a80f3a7deaf1ea81906e2b8d2
0 errors out of 393810 tests on r21 Linux 64-bit |
| 2025-02-04 12:13:12
| drh | pending
|
| 9b. In sibling TH3 checkout: make releasetest |
| 2025-02-04 12:12:55
| drh | ok
|
| 9a. ./configure && make verify-source releasetest. Optionally add --enable-test-status to configure |
| 0 errors out of 6134863 tests in 31:06 on minimac Darwin 64-bit
SQLite 2025-02-04 02:38:23 317e9a470fba2a4b717b9cb66488b8fccb44810a80f3a7deaf1e |
| 2025-02-04 12:11:28
| drh | pending
|
| 11d. nmake /f Makefile.msc verify-source releasetest |
| 2025-02-04 12:11:18
| drh | ok
|
11a. Review the "32-bit Builds" section of doc/compile-for-windows.md for accuracy and completeness. Ensure that your build environment is set up correctly. You probably want:- set TCLDIR=c:\tcl32
- set PATH=c:\tcl32\bin;%PATH%
|
| 2025-02-04 12:09:14
| drh | ok
|
| 7. Tests for platform Linux ARM (RaspberryPI) |
| 2025-02-04 12:09:12
| drh | ok
|
| 7b. In sibling TH3 checkout: make devtest |
| 0 failures on 6 jobs, 3294564 tests in 10:53, 2 cores, pi5 (64-bit) |
| 2025-02-04 12:08:54
| drh | pending
|
| 8a. ./configure && make verify-source releasetest |
| 2025-02-04 12:08:02
| drh | ok
|
| 6a. ./configure && make verify-source releasetest |
| 0 errors out of 14921450 tests in 26:41 on r21 Linux 64-bit
SQLite 2025-02-04 02:38:23 317e9a470fba2a4b717b9cb66488b8fccb44810a80f3a7deaf1e |
| 2025-02-04 12:02:13
| drh | ok
|
| 10. Tests for platform MacOS (PPC): |
| 2025-02-04 12:02:11
| drh | ok
|
| 10c. Recompile and test Fossil. |
| 2025-02-04 12:02:00
| drh | ok
|
| 10b. Build sqlite3_rsync. Use it to sync a Fossil repo from a little-endian machine then verify that the synced repo is correct. This demonstrates that databases are x-platform between big- and little-ending systems. |
| 2025-02-04 12:00:28
| drh | ok
|
| 10a. .selftest checks (see below) |
| 2025-02-04 11:55:43
| drh | ok
|
| 7a. ./configure && make verify-source devtest |
| 0 errors out of 882162 tests in 12:47 on pi5 Linux 64-bit
SQLite 2025-02-04 02:38:23 317e9a470fba2a4b717b9cb66488b8fccb44810a80f3a7deaf1e |
| 2025-02-04 11:40:03
| drh | ok
|
| 15. Building The TCL Extension. Detailed procedures document at
https://sqlite.org/src/doc/trunk/doc/tcl-extension-testing.md |
| 2025-02-04 11:40:00
| drh | ok
|
| 15c. Tested on Windows |
| 2025-02-04 11:35:25
| drh | ok
|
| 15a. Tested on Linux |
| 2025-02-04 11:30:46
| drh | ok
|
| 15b. Tested on Mac |
| 2025-02-04 11:00:01
| drh | ok
|
| 21. Fossil updated to use the latest SQLite. |
| 2025-02-04 10:59:58
| drh | ok
|
| 21i. Do the above on Windows |
| 2025-02-04 10:59:56
| drh | ok
|
| 21f. Do the above on Linux |
| 2025-02-04 10:52:49
| drh | ok
|
| 21g. Do the above on Mac |
| 2025-02-04 10:52:45
| drh | ok
|
| 21h. Do the above on RaspberryPi |
| 2025-02-04 10:52:40
| drh | ok
|
| 21e. fossil all repack |
| 2025-02-04 10:52:38
| drh | ok
|
| 21d. fossil all sync --all |
| 2025-02-04 10:52:35
| drh | ok
|
| 21c. fossil all test-integrity -d |
| 2025-02-04 10:48:25
| drh | ok
|
| 21b. Used on active websites with no issues. |
| 2025-02-04 10:02:06
| drh | ok
|
| 19. Dbsqlfuzz tests |
| 2025-02-04 10:02:03
| drh | ok
|
| 19d. Mac: FUZZDB=$CORPUS make run-fuzzcheck |
| 2025-02-04 10:01:59
| drh | ok
|
| 19c. Linux: FUZZDB=$CORPUS make run-fuzzcheck |
| 2025-02-03 23:22:51
| drh | ok
|
| 5. OMIT, ENABLE, and DISABLE options: |
| 2025-02-03 23:22:48
| drh | ok
|
| 5c. tclsh tool/omittest-msvc.tcl ← on Windows |
| 2025-02-03 23:22:33
| drh | ok
|
| 5a. Recent compile-time options have been added to the omittest.tcl and omittest-msvc.tcl scripts and checked in. |
| 2025-02-03 23:22:30
| drh | ok
|
| 5b. tclsh tool/omittest.tcl ← on Linux |
| 2025-02-03 20:05:12
| drh | ok
|
| 6h. From a read-only source tree: $SRC/configure && make devtest |
| 0 errors out of 882166 tests in 02:28 on r20 Linux 64-bit
SQLite 2025-02-03 18:53:02 408fa57f048e05a261fb62b45ae44b8a97c97fc01e3776124cbe |
| 2025-02-03 20:04:47
| drh | ok
|
| 4. Compiler warning checks. |
| 2025-02-03 20:04:45
| drh | ok
|
| 4c. CFLAGS='-O0' ./configure --enable-debug --enable-all && scan-build make sqlite3 |
| 2025-02-03 19:58:16
| drh | ok
|
| 6b. sh tool/symbols.sh - no incorrect exports or dependencies |
| 2025-02-03 19:57:54
| drh | ok
|
| 4a. Linux GCC -Wall -Wextra (the "tool/warnings.sh" script) |
| 2025-02-03 19:56:18
| drh | ok
|
| 4b. Mac OS X GCC -Wall -Wextra (the "tool/warnings.sh" script) |
| 2025-02-03 19:51:37
| drh | ok
|
16. Verify the "install" make target using DESTDIR:
- Create a new temporary directory. Call it $tempdir.
- fossil clean -x && ./configure && make install DESTDIR=$tempdir
- Verify correct installation using tree $tempdir
|
.
`-- usr
|-- local
| |-- bin
| | `-- sqlite3
| |-- include
| | |-- sqlite3ext.h
| | `-- sqlite3.h
| |-- lib
| | |-- libsqlite3.a
| | |-- libsqlite3.so -> libsqlite3.so.3.49.0
| | |-- libsqlite3.so.0 -> libsqlite3.so.3.49.0
| | |-- libsqlite3.so.3.49.0
| | `-- pkgconfig
| | `-- sqlite3.pc
| `-- share
| `-- man
| `-- man1
| `-- sqlite3.1
`-- share
`-- tcltk
`-- tcl8.6
`-- sqlite3
|-- libtclsqlite3.so
`-- pkgIndex.tcl
|
| 2025-02-03 19:49:41
| drh | ok
|
16. Verify the "install" make target using DESTDIR:
- Create a new temporary directory. Call it $tempdir.
- fossil clean -x && ./configure && make install DESTDIR=$tempdir
- Verify correct installation using tree $tempdir
|
.
`-- usr
|-- local
| |-- bin
| | `-- sqlite3
| |-- include
| | |-- sqlite3ext.h
| | `-- sqlite3.h
| |-- lib
| | |-- libsqlite3.a
| | |-- libsqlite3.so -> libsqlite3.so.3.49.0
| | |-- libsqlite3.so.0 -> libsqlite3.so.3.49.0
| | |-- libsqlite3.so.3.49.0
| | `-- pkgconfig
| | `-- sqlite3.pc
| `-- share
| `-- man
| `-- man1
| `-- sqlite3.1
`-- share
`-- tcltk
`-- tcl8.6
`-- sqlite3
|-- libtclsqlite3.so
`-- pkgIndex.tcl
|
| 2025-02-03 19:48:06
| drh | ok
|
16. Verify the "install" make target using DESTDIR:
- Create a new temporary directory. Call it $tempdir.
- fossil clean -x && ./configure && make install DESTDIR=$tempdir
- Verify correct installation using tree $tempdir
|
.
%u2514%u2500%u2500 usr
%u251C%u2500%u2500 local
%u2502%A0%A0 %u251C%u2500%u2500 bin
%u2502%A0%A0 %u2502%A0%A0 %u2514%u2500%u2500 sqlite3
%u2502%A0%A0 %u251C%u2500%u2500 include
%u2502%A0%A0 %u2502%A0%A0 %u251C%u2500%u2500 sqlite3ext.h
%u2502%A0%A0 %u2502%A0%A0 %u2514%u2500%u2500 sqlite3.h
%u2502%A0%A0 %u251C%u2500%u2500 lib
%u2502%A0%A0 %u2502%A0%A0 %u251C%u2500%u2500 libsqlite3.a
%u2502%A0%A0 %u2502%A0%A0 %u251C%u2500%u2500 libsqlite3.so -> libsqlite3.so.3.49.0
%u2502%A0%A0 %u2502%A0%A0 %u251C%u2500%u2500 libsqlite3.so.0 -> libsqlite3.so.3.49.0
%u2502%A0%A0 %u2502%A0%A0 %u251C%u2500%u2500 libsqlite3.so.3.49.0
%u2502%A0%A0 %u2502%A0%A0 %u2514%u2500%u2500 pkgconfig
%u2502%A0%A0 %u2502%A0%A0 %u2514%u2500%u2500 sqlite3.pc
%u2502%A0%A0 %u2514%u2500%u2500 share
%u2502%A0%A0 %u2514%u2500%u2500 man
%u2502%A0%A0 %u2514%u2500%u2500 man1
%u2502%A0%A0 %u2514%u2500%u2500 sqlite3.1
%u2514%u2500%u2500 share
%u2514%u2500%u2500 tcltk
%u2514%u2500%u2500 tcl8.6
%u2514%u2500%u2500 sqlite3
%u251C%u2500%u2500 libtclsqlite3.so
%u2514%u2500%u2500 pkgIndex.tcl
|
| 2025-02-03 19:47:46
| drh | ok
|
16. Verify the "install" make target using DESTDIR:
- Create a new temporary directory. Call it $tempdir.
- fossil clean -x && ./configure && make install DESTDIR=$tempdir
- Verify correct installation using tree $tempdir
|
| 2025-02-03 19:47:00
| drh | ok
|
| 21a. No SQLite compiler warnings. |
| 2025-02-03 19:41:27
| drh | ok
|
| 37. Build the "atrc" test program and run "./atrc $DB | ./sqlite3 $DB" against multiple databases, visually verify the result |
| 2025-02-03 18:08:02
| drh | pending
|
| 19c. Linux: FUZZDB=$CORPUS make run-fuzzcheck |
| 2025-02-03 18:07:53
| drh | pending
|
| 19d. Mac: FUZZDB=$CORPUS make run-fuzzcheck |
| 2025-02-03 18:07:43
| drh | retest
|
| 19c. Linux: FUZZDB=$CORPUS make run-fuzzcheck |
| UAF found in FTS5 |
| 2025-02-03 18:07:36
| stephan | ok
|
| 14. WASM |
| Tested with emsdk 4.0.0, but 4.0.1 and 3.4.74 are also known to work.
Retested after https://sqlite.org/src/info/9f27379d |
| 2025-02-03 17:27:43
| drh | ok
|
| 22. Wapp updated to use the latest SQLite |
| 2025-02-03 17:27:41
| drh | ok
|
| 22c. https://sqlite.org/src/ext/officeipaddr |
| 2025-02-03 17:27:23
| drh | ok
|
| 22b. https://sqlite.org/src/ext/logview |
| 2025-02-03 17:25:24
| drh | ok
|
| 22a. Used for this checklist - verify on the CGI-environment page |
| 2025-02-03 17:25:15
| drh | ok
|
| 19e. Windows: fuzzcheck $CORPUS -spinner |
| 2025-02-03 17:25:10
| drh | fail
|
| 19d. Mac: FUZZDB=$CORPUS make run-fuzzcheck |
| 2025-02-03 17:25:06
| drh | fail
|
| 19c. Linux: FUZZDB=$CORPUS make run-fuzzcheck |
| UAF found in FTS5 |
| 2025-02-03 16:51:29
| drh | pending
|
| 19e. Windows: fuzzcheck $CORPUS -spinner |
| 2025-02-03 16:51:24
| drh | pending
|
| 19d. Mac: FUZZDB=$CORPUS make run-fuzzcheck |
| 2025-02-03 16:48:57
| drh | pending
|
| 19c. Linux: FUZZDB=$CORPUS make run-fuzzcheck |
| 2025-02-03 16:48:52
| drh | ok
|
| 19b. Check-in CORPUS as an unversioned file in the dbsqlfuzz repository |
| 2025-02-03 16:48:50
| drh | ok
|
| 19a. Develop a new CORPUS database by running dbsqlfuzz for 10 billion iterations |
| 2025-02-03 16:23:39
| drh | ok
|
| 18. Trunk changes merged and verified on active branches.
See https://sqlite.org/devops/doc/trunk/build/release-actions-drh.md
for detailed instructions. |
| 2025-02-03 16:23:37
| drh | ok
|
| 18g. reuse-schema-see (in the see-base repository) |
| 2025-02-03 16:20:45
| dan | ok
|
| 40. Website built procedures |
| 2025-02-03 16:20:42
| dan | ok
|
| 40a. Compile-time options for build products have been updated as necessary |
| 2025-02-03 16:20:38
| dan | ok
|
| 40b. All build products work on their target platforms |
| They do. Windows builds work without any special variables set. |
| 2025-02-03 16:13:29
| drh | ok
|
| 18f. client-see (in the see-base repository) |
| 2025-02-03 16:13:27
| drh | ok
|
| 18e. see (in the see-base repository) |
| 2025-02-03 16:13:25
| drh | ok
|
| 18d. reuse-schema (from trunk) |
| 2025-02-03 15:21:43
| dan | ok
|
| 38. Run the rbu/run_rbu_tests.tcl script in the test-dbs project on Linux. |
| All tests report "round trip test successful.". |
| 2025-02-03 15:19:12
| dan | ok
|
| 33. 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.15.0, 3.41.0 and 3.8.1.
SQLite 2025-02-02 18:01:32 602d4dd69ec9a724c69cb41ab15376ec731bfd4894fac0a2b25076b857786c6d
0 errors out of 403 tests on ws1 Linux 64-bit |
| 2025-02-03 15:19:08
| dan | ---
|
| 33. 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.15.0, 3.41.0 and 3.8.1.
SQLite 2025-02-02 18:01:32 602d4dd69ec9a724c69cb41ab15376ec731bfd4894fac0a2b25076b857786c6d
0 errors out of 403 tests on ws1 Linux 64-bit |
| 2025-02-03 15:18:05
| dan | ok
|
| 13. Tests for platform OpenBSD (x86): |
| 2025-02-03 15:18:03
| dan | ok
|
| 13b. In sibling TH3 directory: make devtest |
| 4c35b06c371c2cd5ffe3b74f777033981fb56364 ../sqlite3.c
0 failures on 6 jobs, 3279253 tests in 30:58, foo.. (64-bit) |
| 2025-02-03 15:17:21
| dan | ok
|
| 13a. ./configure && make devtest |
| 0 errors out of 880948 tests in 39:23 on foo.. OpenBSD 64-bit
SQLite 2025-02-03 14:04:27 76c8435a5f390001038b8ee94322ff478c9d5f29501ed1c5891c |
| 2025-02-03 15:15:34
| dan | ok
|
| 17. 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". Check that test script "atomic2.test" really did run, and did not report "No f2fs atomic-batch-write support. Skipping tests...". |
| SQLite 2025-02-02 18:01:32 602d4dd69ec9a724c69cb41ab15376ec731bfd4894fac0a2b25076b857786c6d
0 errors out of 329952 tests on ws1 Linux 64-bit
atomic2.test did run. |
| 2025-02-03 15:15:09
| dan | ---
|
| 33. 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. |
| SQLite 2025-02-02 18:01:32 602d4dd69ec9a724c69cb41ab15376ec731bfd4894fac0a2b25076b857786c6d
0 errors out of 329952 tests on ws1 Linux 64-bit
atomic2.test did run. |
| 2025-02-03 15:15:00
| dan | ok
|
| 33. 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. |
| SQLite 2025-02-02 18:01:32 602d4dd69ec9a724c69cb41ab15376ec731bfd4894fac0a2b25076b857786c6d
0 errors out of 329952 tests on ws1 Linux 64-bit
atomic2.test did run. |
| 2025-02-03 15:14:42
| drh | ok
|
| 18c. bedrock (from wal2) |
| 2025-02-03 15:09:38
| drh | ok
|
| 18b. wal2 (from trunk) |
| 2025-02-03 15:09:35
| drh | ok
|
| 18a. begin-concurrent (from trunk) |
| 2025-02-03 14:29:46
| drh | ok
|
| 27. Amalgamation autoconf tarball. |
| 2025-02-03 14:29:43
| drh | ok
|
| 27c. Works on Mac OS X. |
| 2025-02-03 14:26:40
| drh | ok
|
| 27d. Works on Windows MSVC |
| 2025-02-03 14:26:36
| drh | ok
|
| 27b. Works on Linux. |
| 2025-02-03 14:20:43
| drh | ok
|
| 27a. Builds (using "make amalgamation-tarball" and/or "make snapshot-tarball"). |
| Still requires "autoconf" to be installed due to the TEA code. |
| 2025-02-03 14:17:12
| drh | ok
|
31. Verify database file format compatibility:
- Build the CLI ("sqlite3" or "sqlite3.exe")
- Have ready a check-out of the https://sqlite.org/test-dbs Fossil repository
containing the test databases in sibling directory "../dbs".
- Start the CLI.
- .cd ../dbs
- .read selftest.txt
Verify that all tests pass. |
| 2025-02-03 14:17:09
| drh | ok
|
| 31d. Mac x64 |
| 2025-02-03 14:16:28
| drh | ok
|
| 31b. Linux x64 |
| 2025-02-03 14:15:07
| drh | ok
|
| 31f. Windows 32-bit |
| 2025-02-03 14:14:55
| drh | ok
|
| 31c. Linux ARM |
| 2025-02-03 14:11:42
| drh | ok
|
| 31g. Windows 64-bit |
| 2025-02-03 14:03:40
| drh | ok
|
| 31a. iBook PPC |
| 2025-02-03 14:02:33
| drh | ok
|
| 31e. Mac ARM |
| 2025-02-03 13:54:44
| drh | ok
|
| 36. Build and verify sqlite3_rsync |
| 2025-02-03 13:54:41
| drh | ok
|
| 36c. Windows |
| 2025-02-03 13:54:18
| drh | ok
|
| 35. Build and verify sqldiff |
| 2025-02-03 13:54:16
| drh | ok
|
| 35c. Windows |
| 2025-02-03 13:53:59
| drh | ok
|
| 34. Build and verify correct operation of sqlite3_analyzer on: |
| 2025-02-03 13:53:56
| drh | ok
|
| 34c. Windows |
| 2025-02-03 13:52:05
| drh | ok
|
| 36b. Mac |
| 2025-02-03 13:52:02
| drh | ok
|
| 35b. Mac |
| 2025-02-03 13:50:34
| drh | ok
|
| 36a. Linux |
| 2025-02-03 13:50:31
| drh | ok
|
| 35a. Linux |
| 2025-02-03 13:48:01
| drh | ok
|
| 34a. Linux |
| 2025-02-03 13:35:45
| drh | ok
|
| 34b. Mac |
| 2025-02-03 13:30:01
| drh | ok
|
| 20. Sqllogictest: |
| 2025-02-03 13:29:58
| drh | ok
|
| 20c. tclsh run-all.tcl |
| 0 errors out of 11879758 tests and 1244 invocations in 630 seconds |
| 2025-02-03 13:26:04
| drh | ok
|
| 32. Verify that the amalgamation builds are byte-for-byte identical on all workstation platforms. |
| 2025-02-03 13:25:58
| drh | ok
|
| 32b. Linux (ARM) |
| 021f927dbaae6849d7616b9d2415542905b50bb70624e76c4db72f855fc64f32 sqlite3.c
4b98b99f55da562e81baf9bf7df1e89eb74c5920dba4e2c47b00c9c869b7c9ab sqlite3.h
8c8d86869ef4dacba56a62860da9a79eb2670c6106461d2b785a57ca04c471bd shell.c |
| 2025-02-03 13:25:26
| drh | ok
|
| 32e. Mac (ARM) |
| 021f927dbaae6849d7616b9d2415542905b50bb70624e76c4db72f855fc64f32 sqlite3.c
4b98b99f55da562e81baf9bf7df1e89eb74c5920dba4e2c47b00c9c869b7c9ab sqlite3.h
8c8d86869ef4dacba56a62860da9a79eb2670c6106461d2b785a57ca04c471bd shell.c |
| 2025-02-03 13:25:05
| drh | ok
|
| 32d. Mac (PPC) |
| 021f927dbaae6849d7616b9d2415542905b50bb70624e76c4db72f855fc64f32 sqlite3.c
4b98b99f55da562e81baf9bf7df1e89eb74c5920dba4e2c47b00c9c869b7c9ab sqlite3.h
8c8d86869ef4dacba56a62860da9a79eb2670c6106461d2b785a57ca04c471bd shell.c |
| 2025-02-03 13:24:29
| drh | ok
|
| 32c. Mac (x64) |
| 021f927dbaae6849d7616b9d2415542905b50bb70624e76c4db72f855fc64f32 sqlite3.c
4b98b99f55da562e81baf9bf7df1e89eb74c5920dba4e2c47b00c9c869b7c9ab sqlite3.h
8c8d86869ef4dacba56a62860da9a79eb2670c6106461d2b785a57ca04c471bd shell.c |
| 2025-02-03 13:24:09
| drh | ok
|
| 32a. Linux (x64) |
| 021f927dbaae6849d7616b9d2415542905b50bb70624e76c4db72f855fc64f32 sqlite3.c
4b98b99f55da562e81baf9bf7df1e89eb74c5920dba4e2c47b00c9c869b7c9ab sqlite3.h
8c8d86869ef4dacba56a62860da9a79eb2670c6106461d2b785a57ca04c471bd shell.c |
| 2025-02-03 13:23:10
| drh | ok
|
| 32f. Windows using NMAKE. |
| 021f927dbaae6849d7616b9d2415542905b50bb70624e76c4db72f855fc64f32 sqlite3.c
4b98b99f55da562e81baf9bf7df1e89eb74c5920dba4e2c47b00c9c869b7c9ab sqlite3.h
8c8d86869ef4dacba56a62860da9a79eb2670c6106461d2b785a57ca04c471bd shell.c |
| 2025-02-03 11:31:00
| drh | fail
|
| 32f. Windows using NMAKE. |
| 2025-02-03 11:25:49
| drh | ok
|
| 32b. Linux (ARM) |
| 0f61394a972583784068d40f9dd2c10b5f7dea5f41c4eea1bdfef9d713f61de0 sqlite3.c
fcd298d36744919c5bbb9eef00fb512b0d605be26cc2ce0e3e7a6b9a6c670a12 sqlite3.h
8c8d86869ef4dacba56a62860da9a79eb2670c6106461d2b785a57ca04c471bd shell.c |
| 2025-02-03 11:25:03
| drh | ok
|
| 32d. Mac (PPC) |
| 0f61394a972583784068d40f9dd2c10b5f7dea5f41c4eea1bdfef9d713f61de0 sqlite3.c
fcd298d36744919c5bbb9eef00fb512b0d605be26cc2ce0e3e7a6b9a6c670a12 sqlite3.h
8c8d86869ef4dacba56a62860da9a79eb2670c6106461d2b785a57ca04c471bd shell.c |
| 2025-02-03 11:24:35
| drh | ok
|
| 32e. Mac (ARM) |
| 0f61394a972583784068d40f9dd2c10b5f7dea5f41c4eea1bdfef9d713f61de0 sqlite3.c
fcd298d36744919c5bbb9eef00fb512b0d605be26cc2ce0e3e7a6b9a6c670a12 sqlite3.h
8c8d86869ef4dacba56a62860da9a79eb2670c6106461d2b785a57ca04c471bd shell.c |
| 2025-02-03 11:24:20
| drh | ok
|
| 32a. Linux (x64) |
| 0f61394a972583784068d40f9dd2c10b5f7dea5f41c4eea1bdfef9d713f61de0 sqlite3.c
fcd298d36744919c5bbb9eef00fb512b0d605be26cc2ce0e3e7a6b9a6c670a12 sqlite3.h
8c8d86869ef4dacba56a62860da9a79eb2670c6106461d2b785a57ca04c471bd shell.c |
| 2025-02-03 11:23:40
| drh | pending
|
| 20c. tclsh run-all.tcl |
| 2025-02-03 11:21:06
| drh | ok
|
| 20b. No SQLite compiler warnings. |
| 2025-02-03 11:20:52
| drh | ok
|
| 20a. Checked in latest SQLite amalgamation. |
| 2025-02-03 11:17:08
| drh | ok
|
| 39. 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. |
| 2025-02-02 10:57:18
| stephan | ok
|
| 14. WASM |
| Tested with emsdk 4.0.0, but 4.0.1 and 3.4.74 are also known to work. |
| 2025-02-02 10:45:37
| stephan | ok
|
| 14d. Click on the test links - confirm correct results. |
| Tested with emsdk 4.0.0. |
| 2025-02-02 10:45:33
| stephan | ok
|
| 14c. Run "althttpd --enable-sab --popup --max-age 1" then visit the HOST:PORT/index.html in a web-browser. |
| Tested with emsdk 4.0.0. |
| 2025-02-02 10:45:29
| stephan | ok
|
| 14b. (On Linux) ./configure --enable-all && cd ext/wasm && make |
| Tested with emsdk 4.0.0. |
| 2025-02-02 10:45:25
| stephan | ok
|
| 14a. Build and install Fiddle according to website maintenance instructions at https://sqlite.org/devops/doc/trunk/build/website-build.md. Run simple tests. |
| Tested with emsdk 4.0.0. |