SQLite

Release Checklist for SQLite 3.47.0
Login
2024-10-21 16:14:29 danreview
13b. In sibling TH3 directory: make devtest
a3b54a821d2423cbc8361efdf711aaf82e51514a sqlite3.c 1 failures on 6 jobs, 2361948 tests in 14:55, foo.. (64-bit) The failure is in building [th3make quick2.rc droid.rc]. sqlite3.c:26954:12: fatal error: 'malloc.h' file not found
2024-10-21 16:14:15 danok
13. Tests for platform OpenBSD (x86):
2024-10-21 16:14:09 danok
13b. In sibling TH3 directory: make devtest
a3b54a821d2423cbc8361efdf711aaf82e51514a sqlite3.c 1 failures on 6 jobs, 2361948 tests in 14:55, foo.. (64-bit) The failure is in building [th3make quick2.rc droid.rc]. sqlite3.c:26954:12: fatal error: 'malloc.h' file not found
2024-10-21 15:38:32 danok
40. Website built procedures
2024-10-21 15:38:30 danok
40b. All build products work on their target platforms
2024-10-21 15:38:27 danok
40a. Compile-time options for build products have been updated as necessary
2024-10-21 15:35:11 drhok
12. Tests for platform Windows (64-bit):
2024-10-21 15:35:08 drhok
12e. Verify that EXEs and DLLs generated using MSVC contain the correct version number, product name, description, and copyright as resources.
2024-10-21 15:33:25 drhok
12c. In sibling TH3 checkout: tclsh multitest.tcl --msvc --scenario failures - verify failures detected
2024-10-21 15:32:27 drhok
12b. In sibling TH3 checkout: nmake releasetest
0 failures on 69 jobs, 207260660 tests in 04:27:38, 8 cores, w23 (64-bit) SQLite 3.47.0 2024-10-20 07:19:38 7a7162293c8fdb0078fe56948d697703539dd23273b2072990d4391c761e6ae2
2024-10-21 14:44:18 danok
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 against 3.41, 3.8.1 and 3.15.0 using backcompat.test.
2024-10-21 14:26:33 danpending
13b. In sibling TH3 directory: make devtest
2024-10-21 14:25:16 danok
13a. ./configure && make devtest
0 errors out of 877711 tests in 21:58 on foo.. OpenBSD 64-bit SQLite 2024-10-21 10:47:24 9f642b3dbc8febfacad97076030f44e9b40067e27222f2bcb848
2024-10-21 14:22:39 danpending
13a. ./configure && make devtest
0 errors out of 877711 tests in 21:58 on foo.. OpenBSD 64-bit SQLite 2024-10-21 10:47:24 9f642b3dbc8febfacad97076030f44e9b40067e27222f2bcb848
2024-10-21 14:16:35 danok
15. 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 2024-10-21 10:47:24 9f642b3dbc8febfacad97076030f44e9b40067e27222f2bcb84813c5765d3d2a 0 errors out of 329398 tests on ws1 Linux 64-bit
2024-10-21 14:09:43 danpending
15. 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...".
2024-10-21 14:09:38 danok
15. 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...".
2024-10-21 14:09:35 danok
15. 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...".
2024-10-21 13:59:34 danpending
13a. ./configure && make devtest
2024-10-21 12:59:39 drhok
14. WASM
2024-10-21 12:59:37 drhok
14c. Run "althttpd --enable-sab --popop" then visit the HOST:PORT/index.html in a web-browser.
Run on localhost builds, where the equivalent is "make httpd" from the ext/wasm dir.
2024-10-21 12:55:11 stephanok
14c. Run "althttpd --enable-sab --popop" then visit the HOST:PORT/index.html in a web-browser.
Run on localhost builds, where the equivalent is "make httpd" from the ext/wasm dir.
2024-10-21 11:21:55 drhok
38. Run the rbu/run_rbu_tests.tcl script in the test-dbs project on Linux.
2024-10-21 11:03:34 drhok
1. Test procedure review.
2024-10-21 11:03:32 drhok
1d. Review dev-ops procedures and make any needed updates and corrections.
2024-10-21 11:03:30 drhok
1c. Review this checklist for completeness and accuracy.
2024-10-21 11:03:27 drhok
1b. Review "multitest.tcl" and "alignment*.rc" scripts in TH3 for completeness.
2024-10-21 11:03:25 drhok
1a. Review "test/testrunner.tcl" and "test/testrunner_data.tcl" for completeness and accuracy.
2024-10-21 11:03:21 drhok
3. Documentation review:
2024-10-21 11:03:19 drhok
3h. Check new/changed documentation for spelling and gramatical mistakes.
2024-10-21 11:03:15 drhok
3g. Test metrics are up-to-date (testing.html).
2024-10-21 11:03:13 drhok
3f. Database footprint is up-to-date (features.html).
2024-10-21 11:03:10 drhok
3e. The compile-time options are all up-to-date (compile.html).
2024-10-21 11:03:06 drhok
3d. No unresolved hyperlinks in the documentation build.
2024-10-21 11:03:04 drhok
3c. Release accouncement in "news.html".
2024-10-21 11:03:01 drhok
3b. Release announcement in "changes.in".
2024-10-21 11:02:59 drhok
3a. Latest release on the "index.html" page.
2024-10-21 10:34:51 drhpending
12b. In sibling TH3 checkout: nmake releasetest
2024-10-21 10:32:15 drhok
12d. nmake /f Makefile.msc verify-source releasetest
0 errors out of 4078348 tests in 43:54 on w23 Windows NT 64-bit SQLite 2024-10-20 07:19:38 7a7162293c8fdb0078fe56948d697703539dd23273b2072990d4
2024-10-21 09:59:24 drhpending
12d. nmake /f Makefile.msc verify-source releasetest
2024-10-21 09:55:20 drhok
14b. (On Linux) ./configure --enable-all && cd ext/wasm && make
2024-10-21 09:55:03 drhok
6. Tests for platform Linux x86_64:
2024-10-21 09:54:59 drhok
6k. From a read-only source tree: $SRC/configure && make test
SQLite 2024-10-20 07:19:38 7a7162293c8fdb0078fe56948d697703539dd23273b2072990d4391c761e6ae2 0 errors out of 330597 tests on bella Linux 64-bit All memory allocations freed - no leaks
2024-10-21 09:53:15 drhok
14a. Build and install Fiddle according to website maintenance instructions at https://sqlite.org/devops/doc/trunk/build/website-build.md. Run simple tests.
2024-10-21 09:52:19 drhok
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.
2024-10-21 09:52:16 drhok
12f. After updating Fossil to use the latest SQLite, verify that it compiles without warnings and that it works
2024-10-21 09:43:34 drhok
9. Tests for platform MacOS ARM:
2024-10-21 09:43:31 drhok
9b. In sibling TH3 checkout: make releasetest
0 failures on 71 jobs, 251048694 tests in 04:04:59, 4 cores, minimac (64-bit) SQLite 3.47.0 2024-10-20 07:19:38 7a7162293c8fdb0078fe56948d697703539dd23273b2072990d4391c761e6ae2
2024-10-21 09:43:16 drhok
7. Tests for platform Linux ARM (RaspberryPI)
2024-10-21 09:43:12 drhok
7b. In sibling TH3 checkout: make devtest
0 failures on 6 jobs, 3272144 tests in 37:19, 2 cores, pi4 (32-bit)
2024-10-21 09:42:38 drhok
7b. In sibling TH3 checkout: make devtest
0 failures on 71 jobs, 251048694 tests in 04:04:59, 4 cores, minimac (64-bit) SQLite 3.47.0 2024-10-20 07:19:38 7a7162293c8fdb0078fe56948d697703539dd23273b207
2024-10-21 00:39:50 drhok
9a. ./configure && make verify-source releasetest. Optionally add --enable-test-status to configure
0 errors out of 6114600 tests in 31:03 on minimac Darwin 64-bit SQLite 2024-10-20 07:19:38 7a7162293c8fdb0078fe56948d697703539dd23273b2072990d4
2024-10-21 00:39:33 drhok
7a. ./configure && make verify-source devtest
0 errors out of 879209 tests in 39:52 on pi4 Linux 32-bit SQLite 2024-10-20 07:19:38 7a7162293c8fdb0078fe56948d697703539dd23273b2072990d4
2024-10-20 22:41:33 drhok
6j. 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
2024-10-20 22:40:22 drhok
6i. Run auxiliary test script in the /usr subdirectory of the TH3 repository
2024-10-20 22:21:49 drhok
8c. In sibling TH3 checkout: tclsh multitest.tcl --scenario failures - all failures detected
2024-10-20 22:21:47 drhok
8. Tests for platform MacOS x64:
2024-10-20 22:21:19 drhok
8b. In sibling TH3 checkout: make devtest
0 failures on 6 jobs, 3260866 tests in 08:54, 2 cores, SQLite-iMac-2018 (64-bit)
2024-10-20 22:11:13 drhok
8a. ./configure && make verify-source releasetest
0 errors out of 6114425 tests in 01:37:18 on SQLite-iMac-2018 Darwin 64-bit SQLite 2024-10-20 07:19:38 7a7162293c8fdb0078fe56948d697703539dd23273b2072990d4
2024-10-20 01:12:49 drhok
6h. CC=clang CFLAGS='-fsanitize=thread' ./configure && make threadtest5 && ./threadtest5
2024-10-19 21:59:15 drhok
6g. Test the reuse-schema branch with ./configure --enable-all && make "OPTS=-DSQLITE_ENABLE_SHARED_SCHEMA" sdevtest
0 errors out of 879400 tests in 02:58 on r21 Linux 64-bit SQLite 2024-10-16 15:14:56 93f0febab4b1da711c2238aaff00b4eff276831b516990040e29
2024-10-19 21:54:45 drhok
6f. ./configure --enable-debug --enable-all && make parse.c && CC=clang CFLAGS='-fsanitize=address,undefined' make -e test
SQLite 2024-10-19 13:38:51 5a594dbcd533aa1e37acea1702db993672c3c0e621add9ea26a497c52037617f 0 errors out of 392116 tests on r21 Linux 64-bit All memory allocations freed - no leaks Maximum memory usage: 9158664 bytes
2024-10-19 19:34:53 drhok
6e. sh tool/symbols.sh - no incorrect exports or dependencies
2024-10-19 19:33:52 drhok
6c. In sibling th3 checkout: tclsh multitest.tcl --scenario failures - all failures detected
2024-10-19 17:23:53 drhok
11. Tests for platform Windows (32-bit):
2024-10-19 17:23:50 drhok
11c. In sibling TH3 checkout: tclsh multitest.tcl --msvc --scenario failures - verify failures detected
2024-10-19 17:23:38 drhok
4. Compiler warning checks.
2024-10-19 17:23:36 drhok
4c. Clang-6.0.0: CFLAGS='-O0' ./configure --enable-debug --enable-all && scan-build make sqlite3
2024-10-19 17:13:24 drhok
11b. In sibling TH3 checkout: nmake devtest
0 failures on 6 jobs, 3206523 tests in 07:11, 8 cores, w23 (32-bit)
2024-10-19 17:13:04 drhok
6b. In sibling th3 checkout: tclsh multitest.tcl --scenario coverage
0 failures on 4 jobs, 7685431 tests in 16:40, 16 cores, r21 (64-bit)
2024-10-19 16:56:23 drhok
4a. Linux GCC -Wall -Wextra (the "tool/warnings.sh" script)
2024-10-19 16:55:35 drhok
4b. Mac OS X GCC -Wall -Wextra (the "tool/warnings.sh" script)
2024-10-19 16:54:21 drhok
4d. Clang-10.0.0: CFLAGS='-O0' ./configure --enable-debug --enable-all && scan-build make sqlite3
2024-10-19 16:53:42 drhok
6a. In sibling th3 checkout: make releasetest
0 failures on 75 jobs, 261841427 tests in 01:09:01, 16 cores, r21 (32/64-bit) SQLite 3.47.0 2024-10-19 13:20:34 5f23036a87f443c82fa7fd48fdac16a31128bb9288b71f97228c29bcfeb632fb
2024-10-19 16:49:42 drhok
11e. Verify that EXEs and DLLs generated using MSVC contain the correct version number, product name, description, and copyright as resources.
2024-10-19 16:44:53 drhok
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%
2024-10-19 16:44:41 drhok
11d. nmake /f Makefile.msc verify-source releasetest
0 errors out of 4075862 tests in 44:10 on w23 Windows NT 32-bit SQLite 2024-10-19 13:20:34 5f23036a87f443c82fa7fd48fdac16a31128bb9288b71f97228c
2024-10-19 13:47:32 drhok
6d. ./configure && make verify-source releasetest
0 errors out of 15001302 tests in 25:52 on r21 Linux 64-bit SQLite 2024-10-19 13:20:34 5f23036a87f443c82fa7fd48fdac16a31128bb9288b71f97228c
2024-10-19 12:01:24 drhok
24. NDS-Devkit testing
2024-10-19 12:01:22 drhok
24c. Verify the "NDS DevKit" version number shown at the end of the test
2024-10-19 12:01:20 drhok
24b. Test using: tclsh th3make debug.rc nds_devkit.rc
2024-10-19 12:01:18 drhok
24a. Merge all trunk enhancements into the reuse-schema branch and use that branch to update the devkit.
2024-10-18 23:07:41 drhok
23. ZIPVFS tests:
2024-10-18 23:07:38 drhok
23c. Linux: tclsh multitest.tcl --scenario zipvfs --extra --valgrind --omit 'quick[23]'
0 failures on 6 jobs, 1836344 tests in 30:03, 16 cores, r21 (64-bit)
2024-10-18 23:02:55 drhok
23e. Windows: tclsh multitest.tcl --scenario zipvfs
0 failures on 8 jobs, 3775927 tests in 07:00, 8 cores, w23 (64-bit)
2024-10-18 23:02:26 drhok
23d. Mac: tclsh multitest.tcl --scenario zipvfs
0 failures on 8 jobs, 3756279 tests in 02:48, 4 cores, minimac (64-bit)
2024-10-18 22:28:23 drhok
23b. testfixture test/testrunner.tcl --zipvfs <ZIPVFS-source-directory> zipvfs
0 errors out of 70836 tests in 02:39 on bella Linux 64-bit Requires Tcl8.6. Does not work for Tcl9.0. That aspect needs to be fixed, but since Tcl is only used for testing and is not embedded in the project it does not have to be fixed during this release cycle.
2024-10-18 19:49:17 drhok
23a. Verify that the configure script version number agrees with the SQLite version number
2024-10-18 19:38:03 drhok
5. OMIT, ENABLE, and DISABLE options:
2024-10-18 19:38:00 drhok
5b. tclsh tool/omittest.tcl ← on Linux
2024-10-18 17:55:00 drhok
5a. Recent compile-time options have been added to the omittest.tcl and omittest-msvc.tcl scripts and checked in.
2024-10-18 17:54:54 drhok
5c. tclsh tool/omittest-msvc.tcl ← on Windows
2024-10-18 17:52:32 drhok
16. Trunk changes merged and verified on active branches. See https://sqlite.org/devops/doc/trunk/build/release-actions-drh.md for detailed instructions.
2024-10-18 17:52:29 drhok
16g. reuse-schema-see (in the see-base repository)
2024-10-18 17:43:00 drhok
21. CEROD tests in the "test/" subdirectory.
2024-10-18 17:42:53 drhok
22. SEE tests using TH3. From the TH3 source directory with the sibling ../see for the SEE sources.
2024-10-18 17:42:50 drhok
22c. Windows: nmake clean see-test
0 failures on 12 jobs, 10024704 tests in 16:20, 8 cores, w23 (64-bit)
2024-10-18 17:34:37 drhok
22a. Linux: make clean see-test
0 failures on 12 jobs, 10324936 tests in 06:09, 8 cores, r20 (64-bit)
2024-10-18 17:23:13 drhok
19. Fossil updated to use the latest SQLite.
2024-10-18 17:23:11 drhok
19i. Do the above on Windows
2024-10-18 17:17:58 drhok
22b. Mac: make clean see-test
Source tree tested: ../see 0 failures on 12 jobs, 10042266 tests in 06:11, 4 cores, minimac (64-bit)
2024-10-18 17:16:23 drhok
25. Amalgamation autoconf tarball.
2024-10-18 17:16:20 drhok
25d. Works on Windows MSVC
2024-10-18 17:12:41 drhok
28. Compare performance to the previous release using kvtest.
2024-10-18 17:12:39 drhok
28c. Windows
2024-10-18 17:11:16 drhok
26. Performance tests using speedtest1 compared against the previous release and a release from about one year ago.
2024-10-18 17:11:14 drhok
26e. Windows with --testset rtree
2024-10-18 17:09:12 drhok
26d. Windows
2024-10-18 16:58:00 drhok
34. Build and verify correct operation of sqlite3_analyzer on:
2024-10-18 16:57:58 drhok
34c. Windows
2024-10-18 16:57:54 drhok
34b. Mac OS X
2024-10-18 16:57:29 drhok
35. Build and verify sqldiff
2024-10-18 16:57:27 drhok
35c. Windows
2024-10-18 16:56:14 drhok
30. Use the ".selftest" command of the shell to verify that legacy database files are readable and cross-platform
2024-10-18 16:56:11 drhok
30f. Windows 32-bit
2024-10-18 16:54:31 drhok
30g. Windows 64-bit
2024-10-18 16:54:18 drh---
19i. Do the above on Windows
2024-10-18 16:54:09 drhok
19i. Do the above on Windows
2024-10-18 16:51:54 drhok
17. Dbsqlfuzz tests
2024-10-18 16:51:51 drhok
17e. Windows: fuzzcheck $CORPUS -spinner
2024-10-18 16:44:44 drhok
19g. Do the above on Mac
2024-10-18 16:44:39 drhok
19e. fossil all repack
2024-10-18 16:44:37 drhok
19d. fossil all sync --all
2024-10-18 16:44:34 drhok
19c. fossil all test-integrity -d
2024-10-18 16:40:20 drhok
19h. Do the above on RaspberryPi
2024-10-18 16:40:06 drhok
17d. Mac: FUZZDB=$CORPUS make run-fuzzcheck
2024-10-18 16:40:02 drhok
18. Sqllogictest:
2024-10-18 16:39:58 drhok
18c. tclsh run-all.tcl
0 errors out of 11879758 tests and 1244 invocations in 949 seconds
2024-10-18 16:24:01 drhok
18b. No SQLite compiler warnings.
2024-10-18 16:23:59 drhok
18a. Checked in latest SQLite amalgamation.
2024-10-18 16:20:07 drhok
19f. Do the above on Linux
2024-10-18 16:19:32 drhok
20. Wapp updated to use the latest SQLite
2024-10-18 16:19:29 drhok
20c. https://sqlite.org/src/ext/officeipaddr
2024-10-18 16:19:27 drhok
20b. https://sqlite.org/src/ext/logview
2024-10-18 16:18:41 drhok
20a. Used for this checklist - verify on the CGI-environment page
2024-10-18 15:59:08 drhok
16f. client-see (in the see-base repository)
2024-10-18 15:59:06 drhok
16e. see (in the see-base repository)
2024-10-18 15:59:03 drhok
16d. reuse-schema (from trunk)
2024-10-18 15:58:55 drhok
16c. bedrock (from wal2)
2024-10-18 15:58:53 drhok
16b. wal2 (from trunk)
2024-10-18 15:58:51 drhok
16a. begin-concurrent (from trunk)
2024-10-18 15:51:46 drhok
19b. Used on active websites with no issues.
2024-10-18 15:51:43 drhok
19a. No SQLite compiler warnings.
2024-10-18 15:51:14 drhok
17b. Check-in CORPUS as an unversioned file in the dbsqlfuzz repository
2024-10-18 15:51:11 drhok
17a. Develop a new CORPUS database by running dbsqlfuzz for 10 billion iterations
2024-10-18 15:47:34 drhok
17c. Linux: FUZZDB=$CORPUS make run-fuzzcheck
2024-10-18 15:47:05 drhok
37. Build the "atrc" test program and run "./atrc $DB | ./sqlite3 $DB" against multiple databases, visually verify the result
2024-10-18 15:43:24 drhok
31. Verify that the performance and size measurement spreadsheet in the documentation (misc/speed-size-graph.ods) is up-to-date.
2024-10-18 15:43:18 drhok
25b. Works on Linux.
2024-10-18 15:37:25 drhok
25c. Works on Mac OS X.
2024-10-18 15:32:42 drhok
25a. Builds.
2024-10-18 15:32:11 drhok
26c. Mac
2024-10-18 15:31:24 drhok
28b. Mac
2024-10-18 15:28:40 drhok
28a. Linux
2024-10-18 15:27:21 drhok
26b. Linux with --testset rtree
2024-10-18 15:24:33 drhok
26a. Linux
2024-10-18 15:23:08 drhok
27. Run make wordcount and do tests on current and prior versions:
2024-10-18 15:23:06 drhok
27b. rm -f wc.db && ./wordcount wc.db $BIGTEXT --all --cachesize 5 --nosync
2024-10-18 15:21:30 drhok
27a. rm -f wc.db && ./wordcount wc.db $BIGTEXT --all
2024-10-18 15:18:45 drhok
29. Check JSON performance
2024-10-18 15:18:42 drhok
29b. Verify JSON performance against the previous release
2024-10-18 15:18:39 drhok
29a. Run the procedures described in test/json/README.md
2024-10-18 15:18:13 drhok
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.
2024-10-18 15:16:45 drhok
34a. Linux
2024-10-18 15:16:09 drhok
30c. Linux ARM
2024-10-18 15:16:03 drhok
35a. Linux
2024-10-18 15:15:30 drhok
30b. Linux x64
2024-10-18 15:15:14 drhok
30d. Mac x64
2024-10-18 15:14:24 drhok
34b. Mac OS X
2024-10-18 15:14:01 drhok
35b. Mac
2024-10-18 15:12:17 drhok
30e. Mac ARM
2024-10-18 15:11:50 drhok
32. Verify that the amalgamation builds are byte-for-byte identical on all workstation platforms.
2024-10-18 15:11:47 drhok
32c. Mac OS X
4ae0a89c1a4a23dac23140018e0c0737d1bb6960e1aa2ba52cc81f0dd9ecfa94 sqlite3.c e5d13a83c5eae4e518a642c95e6d679d96775739616c84d8def82eaa8239f232 sqlite3.h
2024-10-17 21:03:59 drhok
32f. Windows using NMAKE.
4ae0a89c1a4a23dac23140018e0c0737d1bb6960e1aa2ba52cc81f0dd9ecfa94 sqlite3.c e5d13a83c5eae4e518a642c95e6d679d96775739616c84d8def82eaa8239f232 sqlite3.h
2024-10-17 20:59:53 drhok
32e. Mac OS X (ARM)
4ae0a89c1a4a23dac23140018e0c0737d1bb6960e1aa2ba52cc81f0dd9ecfa94 sqlite3.c e5d13a83c5eae4e518a642c95e6d679d96775739616c84d8def82eaa8239f232 sqlite3.h
2024-10-17 20:59:34 drhok
32a. Linux (x64)
4ae0a89c1a4a23dac23140018e0c0737d1bb6960e1aa2ba52cc81f0dd9ecfa94 sqlite3.c e5d13a83c5eae4e518a642c95e6d679d96775739616c84d8def82eaa8239f232 sqlite3.h
2024-10-17 20:59:12 drhok
32b. Linux (ARM)
4ae0a89c1a4a23dac23140018e0c0737d1bb6960e1aa2ba52cc81f0dd9ecfa94 sqlite3.c e5d13a83c5eae4e518a642c95e6d679d96775739616c84d8def82eaa8239f232 sqlite3.h
2024-10-17 20:55:47 drhok
2. Source code change review. fossil diff --from release --to trunk
2024-10-17 20:55:45 drhok
2b. All significant changes are mentioned in the "changes" log of the documentation.
2024-10-17 19:30:31 drhok
2l. Significant compile-time options are recognized by the sqlite3_compileoption_used() interface.
2024-10-17 19:30:26 drhok
2k. Verify that the list of APIs exposed via the extension header is up-to-date (sqlite3ext.h).
2024-10-17 19:28:59 drhok
2f. Verify that the azProhibitedFunctions list in the safeModeAuth() function of the CLI is complete and up-to-date.
2024-10-17 19:12:04 drhok
36. Build and verify sqlite3_rsync
2024-10-17 19:12:01 drhok
36b. Mac
2024-10-17 19:08:17 drhok
36c. Windows
2024-10-17 18:53:54 drhok
36a. Linux
2024-10-17 18:45:21 drhok
30a. iBook PPC
ok
2024-10-17 18:45:08 drhok
30a. iBook PPC
Previous comment entered into the wrong box. (Need to add an undo feature to this checklist program!). Even so, .selftest has been tested on PPC and shown to pass.
2024-10-17 18:44:01 drhok
30a. iBook PPC
2024-10-17 18:43:55 drhok
32d. Mac OS X (PPC)
Verified against Linux-x64 on SQLite version 8563728deeb1d3ead9f (2024-10-17 18:12:03)
2024-10-17 18:43:30 drhok
30a. iBook PPC
Verified against Linux-x64 on SQLite version 8563728deeb1d3ead9f (2024-10-17 18:12:03)
2024-10-17 18:37:45 drhok
10. Tests for platform MacOS (PPC):
2024-10-17 18:37:42 drhok
10c. Recompile and test Fossil.
2024-10-17 18:27:57 drhok
10a. .selftest checks (see below)
2024-10-17 18:24:34 drhok
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.
2024-10-17 18:13:34 drhok
2m. Compare sqlite3.c and sqlite3.h against the previous release.
2024-10-17 18:13:27 drhok
2j. Verify that source code contains no tabs and that surplus whitespace has been removed.
2024-10-17 18:12:43 drhok
2e. Comments have been updated to reflect code changes.
2024-10-17 18:12:38 drhok
2a. No stray changes.
2024-10-17 18:12:35 drhok
2d. New code complies with design rules.
2024-10-17 18:12:32 drhok
2c. New code complies with style guidelines.
2024-10-17 18:12:25 drhok
2g. Variables and functions have been renamed to reflect changes in their use.
2024-10-17 18:12:11 drhok
2i. 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]*(/
2024-10-17 17:57:02 drhok
2h. Check all calls to sqlite3OsRead() and sqlite3OsWrite() to ensure that offset computations are 64-bit clean.
2024-10-17 12:41:21 stephanok
14d. Click on the test links - confirm correct results.
Re-confirmed after [0a32624015f16fd] using both an in-tree build and a dist zip bundle.