Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
50 check-ins
|
2025-07-01
| ||
| 14:44 | Simplify the column_text/blob_v2() JS tests a bit and correct the text_v2() tests to call into both the column and value variants. (Leaf check-in: d5cb808043 user: stephan tags: column-text-blob-v2) | |
| 13:01 | Initial implementations of sqlite3_column_text_v2(), sqlite3_column_blob_v2(), and their JS/WASM bindings/tests. (check-in: 1d065231ab user: stephan tags: column-text-blob-v2) | |
| 12:56 | Increment the patch level to 3. (Leaf check-in: cf6d599ce9 user: drh tags: branch-3.50) | |
| 12:49 | When attempting to optimize "expr AND false" to "false" and "expr IN ()" to "false", take care not to delete aggregate functions in the "expr" as doing so can change the meaning of the query. (check-in: 355c7902de user: drh tags: branch-3.50) | |
| 12:43 | When attempting to optimize "expr AND false" to "false" and "expr IN ()" to "false", take care not to delete aggregate functions in the "expr" as doing so can change the meaning of the query. See forum thread f4878de3e7. (Leaf check-in: 77397bd67d user: drh tags: trunk) | |
| 09:02 | Add tests which demonstrate the difference in behavior for zero-length results in sqlite3_value_text_v2() (empty string) vs sqlite3_value_blob_v2() (NULL). (check-in: 2e7cf00d16 user: stephan tags: column-text-blob-v2) | |
| 00:34 | Add JS tests for SQLITE_ENABLE_API_ARMOR-shielded sqlite3_value_blob/text_v2() misuse. (check-in: 3c0de5b33c user: stephan tags: column-text-blob-v2) | |
| 00:17 | Add JS basic tests for sqlite3_value_blob_v2(). Simplify the sqlite3_value_text_v2() tests a bit. (check-in: c371f92d5b user: stephan tags: column-text-blob-v2) | |
|
2025-06-30
| ||
| 23:49 | Add JS bindings for sqlite3_value_text/blob_v2() and add basic JS tests for text_v2(). (check-in: 096c745f38 user: stephan tags: column-text-blob-v2) | |
| 23:17 | Restart this branch using a different take: add new "v2" routines instead of refactoring the old ones, which eliminates any performance impact or risk of behavior change for existing APIs. None of this code is actually called from anywhere yet. (check-in: b0b1b4ccb9 user: stephan tags: column-text-blob-v2) | |
| 22:15 | Initial experimental internal changes needed to support a hypothetical sqlite3_column_text/blob_v2(), as discussed in forum post 402a837960d9de45. This is just the first step: this change needs to cascade upwards a couple of levels, remove one level of porting-crutch API, and go through performance comparisons before we'll know whether it's really feasible. make devtest passes but there are corner error cases which require more precise testing to ensure that there are no visible changes in behavior. (Closed-Leaf check-in: 730c6a623e user: stephan tags: column-text-blob-v2) | |
| 21:07 | More aggressive optimization of addrHalt for RIGHT JOIN. (Leaf check-in: 5e51d1c0df user: drh tags: empty-table-optimizations) | |
| 20:19 | Compute WhereLevel.addrBrk and .addrHalt early so that those labels can be used to abort loops early. Use this to improve performance on two more of the cases described by forum post 52651713ac. (check-in: 6fc0b9ac23 user: drh tags: empty-table-optimizations) | |
| 16:41 | Strive to skip the evaluation of scalar subqueries that are part of a larger expression if the result from the scalar subquery does not change the result of the overall expression. (check-in: 0083d5169a user: drh tags: trunk) | |
| 15:56 | Correct ~/.local/config/... to ~/.config/... when looking for sqliterc when XDG_CONFIG_HOME is not set. Internal doc touchups. (Leaf check-in: ebb346c5aa user: stephan tags: shell-xdg-vars) | |
| 15:21 | Add support for using $XDG_STATE_HOME/sqlite_history or ~/.local/state/sqlite_history before fallback back to the historical default of ~/.sqlite_history. Update sqlite3.1 (man page) with the new semantics. (check-in: 6b780655cc user: stephan tags: shell-xdg-vars) | |
| 12:14 | For all binary operators, try to avoid computing subquery operands if the other operand is NULL. (Closed-Leaf check-in: d86eb16283 user: drh tags: optimize-null-values) | |
| 11:46 | Preliminary refactoring of the XDG_CONFIG_HOME support to support the pending addition of other XDG-configurable options. In response to forum post 31db1a23f9. (check-in: 69b9244e3a user: stephan tags: shell-xdg-vars) | |
| 11:04 | Slightly smaller and faster version of the previous check-in. (check-in: f6e6fd02f4 user: drh tags: optimize-null-values) | |
| 11:01 | Minor API doc typo fixes from brickviking. (check-in: 581a088df7 user: stephan tags: branch-3.50) | |
| 11:00 | Minor API doc typo fixes from brickviking. (check-in: b48d951916 user: stephan tags: trunk) | |
| 10:30 | Factor out the code that tries to avoid evaluating subquery operands if the other operand is NULL into a subroutine, so that it can be more easily reused by other parts of the code generator. (check-in: 3c6c71bcea user: drh tags: optimize-null-values) | |
|
2025-06-29
| ||
| 07:32 | Minor API doc typo fixes from brickviking. (check-in: 45acc26bb0 user: stephan tags: branch-3.50) | |
| 07:32 | Minor API doc typo fixes from brickviking. (check-in: c7cf9dcb69 user: stephan tags: trunk) | |
|
2025-06-28
| ||
| 17:59 | Improve the bytecode generated for comparisons so that if one operand is a subquery and the other operand evaluates to NULL, the subquery operand is not even computed. This fixes 5 of the 11 slow queries described in forum post 52651713ac. (check-in: f147bc0477 user: drh tags: optimize-null-values) | |
| 14:36 | Merge all the latest trunk fixes and enhancements into the reuse-schema branch. (Leaf check-in: 6e1f97d99b user: drh tags: reuse-schema) | |
| 14:35 | Merge the 3.50.2 changes into the reuse-schema-3.50 branch. (Leaf check-in: b66f853a24 user: drh tags: reuse-schema-3.50) | |
| 14:30 | Merge the latest trunk fixes and enhancements into the bedrock branch. (Leaf check-in: a6f6fbe617 user: drh tags: bedrock) | |
| 14:24 | Merge the latest trunk enhancements into the wal2 branch. (Leaf check-in: e7867c3992 user: drh tags: wal2) | |
| 14:16 | Merge the latest trunk enhancements into the begin-concurrent branch. (Leaf check-in: 1ae8d60237 user: drh tags: begin-concurrent) | |
| 14:00 | Version 3.50.2 (check-in: 2af157d77f user: drh tags: release, branch-3.50, version-3.50.2) | |
|
2025-06-27
| ||
| 19:56 | Raise an error right away if the number of aggregate terms in a query exceeds the maximum number of columns. (check-in: 4ae45291e6 user: drh tags: branch-3.50) | |
| 19:02 | Raise an error right away if the number of aggregate terms in a query exceeds the maximum number of columns. (check-in: 5508b56fd2 user: drh tags: trunk) | |
| 12:51 | API doc typo fixes and closing DD element tags from brickviking. (check-in: 6113572247 user: drh tags: branch-3.50) | |
| 12:46 | API doc typo fixes and closing DD element tags from brickviking. (check-in: c9ddd15b01 user: stephan tags: trunk) | |
|
2025-06-26
| ||
| 18:57 | Work around an apparent GCC UBSAN bug. See forum thread 1d7c25d4a2d for details. (check-in: 23056532e5 user: drh tags: trunk) | |
| 15:41 | Minor API doc fixes sent off-list from brickviking. (check-in: a9e9cefd05 user: drh tags: branch-3.50) | |
|
2025-06-25
| ||
| 20:42 | Minor API doc fixes sent off-list from brickviking. (check-in: cb4d05633a user: stephan tags: trunk) | |
|
2025-06-24
| ||
| 18:27 | Similar fix to the previous check-in, but this time for sqlite3_preupdate_new(). (check-in: 9aaff764d5 user: drh tags: trunk) | |
| 15:58 | Range check the column index on the sqlite3_preupdate_old() interface and return SQLITE_MISUSE if too large. Forum post b617e49728. (check-in: 6a5701e6c7 user: drh tags: trunk) | |
| 07:38 | API doc typo fixes and one rephrasing improvement from brickviking. (check-in: 85e8060c47 user: stephan tags: trunk) | |
|
2025-06-23
| ||
| 19:38 | Improve some of the error messages emitted by fts5 when it encounters corruption. (check-in: 48044a6b57 user: dan tags: trunk) | |
| 19:00 | Fix an SQL typo introduced by the previous check-in. (check-in: 72a81d247b user: drh tags: trunk) | |
| 16:51 | Escape the "_" character in LIKE patterns in the CLI. Forum post 6a89702f5d. (check-in: cf61cd359e user: drh tags: trunk) | |
| 13:42 | Fix a harmless compiler warning injected by [c978aed3b6f82b3d]. (check-in: f46500247b user: drh tags: trunk) | |
| 13:28 | Improved "statement aborts at ..." log-file messages that identify the trigger that caused the abort. (check-in: 7691264fe3 user: drh tags: trunk) | |
|
2025-06-22
| ||
| 22:48 | Add the --disable-rpath configure script flag to address forum post 13cac3b56516f849. (check-in: a59d9bb25e user: stephan tags: trunk) | |
| 12:04 | API doc typo fixes from brickviking. (check-in: 18e07f8f53 user: stephan tags: trunk) | |
|
2025-06-21
| ||
| 16:33 | Minor JS test cleanups prompted by a linter. (check-in: 764235a3d1 user: stephan tags: trunk) | |
| 16:18 | Remove some duplicated JS tests. (check-in: d1cb9ed79d user: stephan tags: trunk) | |