SQLite

Timeline
Login

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

About branch wal2

This branch contains the two-wal-files patch only. This patch adds an extra journal mode enabled by "PRAGMA journal_mode = wal2". The advantage of this journal mode over regular "wal" mode is that writers may continue writing to one wal file while the other is checkpointed. The fossil trunk is periodically merged into this branch.

100 most recent check-ins related to "wal2"
2024-12-16
18:29
Merge divergence-reduction changes into the bedrock branch. (check-in: ec5d7025 user: drh tags: bedrock)
18:16
Sync wal2 with trunk. (Leaf check-in: caadbe0c user: drh tags: wal2)
18:13
Further reduction in divergence from trunk. (check-in: e4406a6e user: drh tags: wal2)
18:04
Code formatting changes to make trunk more like wal2. (check-in: 8f725472 user: drh tags: trunk)
17:46
Reduce divergence of wal2 from trunk. (check-in: 90d744d6 user: drh tags: wal2)
13:38
Merge all the latest trunk/wal2 enhancements and fixes into the bedrock branch. (check-in: a0cf2621 user: drh tags: bedrock)
13:32
Sync with trunk. (check-in: eab61945 user: drh tags: wal2)
13:25
Changes for better alignment with the wal2 branch. (check-in: 4fab85b3 user: drh tags: trunk)
13:05
Synchronize the WASM code with trunk. (check-in: 3619baa1 user: drh tags: wal2)
12:41
Merge all the latest trunk enhancements and fixes into the wal2 branch. (check-in: 011ce4ae user: drh tags: wal2)
12:08
Remove unnecessary end-of-line whitespace. (check-in: ae580443 user: drh tags: trunk)
2024-12-14
17:36
Merge changes from wal2, including the fix to prevent non-PASSIVE checkpoints from ever taking the writer lock. (check-in: eb8449ea user: dan tags: bedrock)
17:19
Update to walRestartLog() function to make it shorter easier to merge with branch "bedrock". (check-in: 88d7fb2a user: dan tags: wal2)
16:50
Fix a problem with non-PASSIVE wal2 checkpoints sometimes taking the WRITER lock. (check-in: 11d7865a user: dan tags: wal2)
16:41
Do not attempt to switch wal files when writing if the current transaction read from both wal files. This fix is already on branch 'bedrock'. (check-in: 693cc8e8 user: dan tags: wal2)
2024-12-13
20:18
Fix a problem with the output of "PRAGMA wal_checkpoint" introduced long ago by [63483e22c775183e]. (check-in: c5f7bba8 user: dan tags: wal2)
17:01
Merge all recent trunk enhancements and fixes into the wal2 branch. Addendum: This was part of an attempt to reduce divergence. I'm still trying to figure out the best way to do that. (Closed-Leaf check-in: be32067a user: drh tags: mistake)
2024-12-09
21:26
Fix a problem with non-PASSIVE wal2 checkpoints sometimes taking the WRITER lock. (check-in: 1a59cae3 user: dan tags: cf8f1552-commit-instr)
2024-12-07
23:29
Merge the latest trunk fixes and enhancements into the bedrock branch. (check-in: 08cfa7e8 user: drh tags: bedrock)
23:24
Update the wal2 branch with the latest trunk enhancements and fixes. (check-in: d3ce95f7 user: drh tags: wal2)
21:16
Version 3.47.2 for wal2 (Leaf check-in: 11fd09db user: drh tags: wal2-3.47)
19:57
Yet another iteration of the solution to the floating-point conversion problem - this what avoids complaints about oversize double values from -fsanitize. (check-in: fc6904a5 user: drh tags: trunk)
2024-11-18
20:44
Merge the divergence reduction into the bedrock branch. (check-in: e03dd0bd user: drh tags: bedrock)
20:30
Continue to reduce divergence between wal2 and trunk. (check-in: 9591ab7c user: drh tags: wal2)
18:45
Reduce divergence from begin-concurrent. (check-in: 84d41e9d user: drh tags: trunk)
18:27
Realign trunk and wal2. (check-in: dcf27687 user: drh tags: wal2)
18:03
Attempt to reduce divergence from trunk. (check-in: ffe9f9cc user: drh tags: wal2)
17:05
Attempt to reduce divergence with the wal2 branch. (check-in: e0d8f991 user: drh tags: trunk)
15:34
Merge the latest trunk changes into the bedrock branch. (check-in: 59a7eb29 user: drh tags: bedrock)
15:30
Merge the latest trunk changes into the wal2 branch. (check-in: d19aeff6 user: drh tags: wal2)
14:15
Remove the .POSIX entries from the makefiles because they cause portability problems rather than solve them. (check-in: e1330ecf user: stephan tags: trunk)
2024-10-25
20:06
Merge the latest trunk enhancements and especially autosetup into the bedrock branch. (check-in: 86a305b9 user: drh tags: bedrock)
19:40
Merge the latest trunk enhancements and especially the autosetup changes into the wal2 branch. (check-in: 4ddea432 user: drh tags: wal2)
15:28
Update the compile-for-*.md documents. (check-in: c4da7fa2 user: drh tags: trunk)
2024-10-21
17:10
Update the bedrock branch to version 3.47.0 (check-in: d2d954d4 user: drh tags: bedrock)
17:05
Update the wal2 branch to version 3.47.0 (check-in: d34b6a91 user: drh tags: wal2)
16:30
Version 3.47.0 (check-in: 03a9703e user: drh tags: trunk, release, major-release, version-3.47.0)
2024-10-16
15:09
Merge the latest trunk enhancements into the bedrock branch. (check-in: d5289de4 user: drh tags: bedrock)
15:03
Merge the latest trunk enhancements into the wal2 branch. (check-in: 2e96c8bb user: drh tags: wal2)
14:05
Add has_tclconfig to the tidy makefile target. (check-in: 309e6d6f user: stephan tags: trunk)
2024-09-30
17:57
Merge the latest trunk enhancements, via the wal2 branch, into the bedrock branch. (check-in: fd6ff551 user: dan tags: bedrock)
17:53
Fix a usan warning in test_hexio.c on this branch. (check-in: 59fba028 user: dan tags: wal2)
17:32
Merge the latest trunk enhancements, including fix for assert() failure in fts5, into the wal2 branch. (check-in: ab635618 user: dan tags: wal2)
17:28
In fts5, avoid starting a new merge of level L if there exists already an ongoing merge of a level less than L. (check-in: 350c6e75 user: dan tags: trunk)
14:41
Merge the latest trunk enhancements into the wal2 branch. (check-in: 0f9e2fce user: drh tags: wal2)
2024-09-28
19:52
Fix the CLI so that the --bom option only outputs a single BOM, not two. (check-in: 76b6331e user: drh tags: trunk)
2024-09-06
15:45
Update the bedrock branch to include all the latest enhancements from trunk. (check-in: 4a3386cc user: drh tags: bedrock)
15:42
Merge the latest trunk enhancement into the wal2 branch. (check-in: f3e3ad69 user: drh tags: wal2)
15:01
Resolve the "No rule to make target '0'" error when building with --disable-tcl. (check-in: d94541ae user: stephan tags: trunk)
2024-09-04
16:54
Update the bedrock branch to include all of the latest trunk enhancements. (check-in: cf8f1552 user: drh tags: bedrock)
16:46
Merge all the latest trunk enhancements into the wal2 branch. (check-in: 9f530343 user: drh tags: wal2)
16:01
Fix a bug in the parsing of some corner-case JSON PATH strings that contain escaped double-quotes. (check-in: 60ac55c4 user: drh tags: trunk)
2024-08-29
23:43
Merge the latest trunk enhancement into the bedrock branch through the wal2 intermediary. (check-in: ff94464c user: drh tags: bedrock)
23:33
Merge all the latest trunk enhancements into the wal2 branch. (check-in: dfecc79c user: drh tags: wal2)
18:32
All makefiles are responsive to OPTIONS=... command-line arguments, and add the RHS value of OPTIONS= to builds and to lemon and other build steps that might respond to -D or -U options. (check-in: 854b3776 user: drh tags: trunk)
2024-08-16
19:04
Merge all the latest trunk enhancements, and especially the order-by-subquery optimization, into the bedrock branch, via wal2. (check-in: d0591db3 user: drh tags: bedrock)
18:58
Merge the latest trunk enhancements into the wal2 branch. (check-in: a78208b5 user: drh tags: wal2)
18:51
If a subquery has an ORDER BY clause and that ordering is helpful in satisfying the ORDER BY or GROUP BY of the outer query without doing an extra sort, then omit or reduce the sort in the outer query. Call this the "order-by-subquery optimization". (check-in: 7a0cdc7e user: drh tags: trunk)
11:26
Fix handling of COLLATE. Add test cases for the same. Code cleanup for improved understandability and maintainability. (Closed-Leaf check-in: 41a41c17 user: drh tags: order-by-subquery)
2024-08-10
20:02
Merge the latest branch-3.46 changes into wal2 as a new sub-branch called wal2-3.46. (Leaf check-in: b917d07f user: drh tags: wal2-3.46)
2024-08-09
10:56
Fix some signed/unsigned compiler warnings on this branch. (check-in: 681d2280 user: dan tags: wal2)
10:50
Fix some signed/unsigned compiler warnings on this branch. (check-in: d615d529 user: dan tags: bedrock)
2024-08-01
00:47
Merge the latest trunk enhancements into the bedrock branch. (check-in: c1f616ce user: drh tags: bedrock)
00:38
Merge the latest trunk enhancements into the wal2 branch. (check-in: eac58205 user: drh tags: wal2)
2024-07-31
22:36
Fix the tclsqlite.c TCL interface module so that it works with both Tcl8 and Tcl9. Make changes across the TCL-based test harness to enable SQLite to be tested with either Tcl8 or Tcl9. Get the --with-tcl= argument on the configure script working. Testing changes only - no changes to the SQLite core. I believe the previous merge attempt didn't work because of errors in the merge itself, not because of faults in the code. Trying again... (check-in: ea9d88f9 user: drh tags: trunk)
2024-05-23
14:09
Version 3.46.0 for the bedrock branch (check-in: 483d112a user: drh tags: bedrock)
14:05
Version 3.46.0 for the wal2 branch. (check-in: fdc0e148 user: drh tags: wal2)
13:25
Version 3.46.0 (check-in: 96c92aba user: drh tags: trunk, release, major-release, version-3.46.0)
2024-05-21
15:24
Merge the latest trunk enhancements into the bedrock branch. (check-in: c65a82f1 user: drh tags: bedrock)
15:20
Merge the latest trunk enhancements into the wal2 branch. (check-in: d4217d9f user: drh tags: wal2)
14:54
Do not attempt to run mmapcorrupt.test with builds that do not support mmap(). (check-in: 54a49f18 user: dan tags: trunk)
2024-04-15
14:45
Merge all of the latest trunk enhancements into the bedrock branch. (check-in: 16dac180 user: drh tags: bedrock)
14:39
Merge the latest trunk enhancements into the wal2 branch. (check-in: 4a72acbc user: drh tags: wal2)
2024-04-12
18:46
If a build fails in testrunner.tcl, do not attempt to run the jobs that depend on that build. Instead, report those jobs as having been skipped. (check-in: b40580be user: drh tags: trunk)
2024-04-08
12:02
Merge the latest trunk enhancements, and especially the enhancement to the WHERE-clause push-down optimization, into the bedrock branch. (check-in: 0f93b52c user: drh tags: bedrock)
11:57
Merge the latest trunk enhancements into the wal2 branch. (check-in: 59ccea7d user: drh tags: wal2)
11:50
Enhance the WHERE-clause push-down optimization so that it is able to push down WHERE clause terms that contain uncorrelated subqueries. (check-in: 69ec714b user: drh tags: trunk)
2024-04-05
14:54
Merge the latest trunk enhancements into the bedrock branch. (check-in: 7a2a64b6 user: drh tags: bedrock)
14:50
Merge the latest trunk enhancements into the wal2 branch. (check-in: a8a8a2db user: drh tags: wal2)
13:56
Check-in [a9657c87c53c1922] is wrong: the IndexedExpr.bMaybeNullRow flag is required for virtual columns if they are part of an outer join. Add a test case (derived from dbsqlfuzz b9e65e2f110df998f1306571fae7af6c01e4d92b) to prove it. (check-in: 4484ec6d user: drh tags: trunk)
2024-03-26
10:45
Merge all recent trunk enhancements into the bedrock branch. (check-in: 33d3453f user: drh tags: bedrock)
10:42
Merge all recent trunk enhancements into the wal2 branch. (check-in: c2139d82 user: drh tags: wal2)
2024-03-25
20:35
The RAISE() operator is not a constant expression and cannot participate in the VALUE-as-coroutine optimization. dbsqlfuzz 74cf7c9904360322a6c917e4934b127543d1cd51 (check-in: 6a06dc73 user: drh tags: trunk)
2024-03-18
18:55
Merge the latest trunk enhancements into the bedrock branch. (check-in: 10ab5e85 user: drh tags: bedrock)
18:51
Merge the latest trunk enhancements into the wal2 branch. (check-in: c0af1242 user: drh tags: wal2)
18:03
Remove unnecessary blank lines from build commands in the default Makefile.in. (check-in: 76fb3a90 user: drh tags: trunk)
2024-03-13
18:00
Merge the latest trunk enhancements into the bedrock branch. (check-in: 5c8e80f4 user: drh tags: bedrock)
17:55
Merge the latest trunk enhancements into the wal2 branch. (check-in: 2b12da72 user: drh tags: wal2)
16:32
Minor change to the "mdevtest" and "sdevtest" in testrunner.tcl, to make it easier to add configurations in branches. (check-in: 9349d94e user: drh tags: trunk)
2024-01-30
16:53
Merge the changes from the 3.45.1 patch release into the wal2 branch. (check-in: 5e980265 user: drh tags: wal2-3.45)
2024-01-13
20:36
Merge latest wal2 changes into this branch. (check-in: c39f6585 user: dan tags: bedrock)
20:21
Merge latest trunk changes into this branch. (check-in: 68c2b8d0 user: dan tags: wal2)
2024-01-12
11:44
Have the shell tool automatically enable SQLITE_CONFIG_DQS_DDL when executing a ".dump" script against an empty db. (check-in: f47a5f4e user: dan tags: trunk)
2024-01-04
16:28
Merge the latest trunk enhancements into the bedrock branch. (check-in: 707f79c7 user: drh tags: bedrock)
16:16
Merge the latest trunk enhancements into the wal2 branch. (check-in: 8fb42df8 user: drh tags: wal2)
13:01
Restructure some code to fix what appears to be a false-positive UBSAN warning. (check-in: fe952c12 user: drh tags: trunk)
2023-12-28
14:01
Merge the latest trunk changes into the bedrock branch. (check-in: 5a17b972 user: drh tags: bedrock)
13:44
Merge the latest trunk enhancements into the wal2 branch. (check-in: 1f592dd3 user: drh tags: wal2)
2023-12-27
16:24
Fix a problem in the shell tool (not library) causing an out-of-bounds write if an ".open" command failed, then the user pressed ctrl-c to interrupt a query running on the substitute in-memory database. (check-in: 026618b9 user: dan tags: trunk)
2023-12-06
21:18
Merge the latest trunk changes into the bedrock branch. (check-in: c2e53000 user: drh tags: bedrock)