paulhorn/sqlite
1
0
Fork 0
Code Issues Pull Requests Packages Projects Releases Wiki Activity

Commit Graph

  • 7340b032d1 Clamp the nToken parameter to the fts5 snippet() function between 0 and 64. It has always been documented this way, but not previously implemented. Report [bugs:/info/2026-06-08T08:29:00Z | 2026-06-08T08:29:00Z]. dan 2026-06-08 11:24:05 +00:00
  • 2bc3763ec5 Add extra tests to check that non-deterministic functions may not be used in indexes. dan 2026-06-08 10:47:55 +00:00
  • a6812a4242 Improvements to the GCC compiler bug work-around of check-in [7fae321095ebec77]. drh 2026-06-06 18:32:53 +00:00
  • 6bf7825ac5 Minor performance enhancement and improved comments on the quicksort algorithm used by the median() implementation in func.c. drh 2026-06-06 17:20:35 +00:00
  • 192b3a539b A new approach to working around the GCC bug. gcc-bug-114659 drh 2026-06-05 00:11:56 +00:00
  • 9403250ef8 Disable the vector-IN-SELECT optimization if the number of columns is so large that it would cause the WhereTerm.nChild column to wrap. drh 2026-06-04 16:58:53 +00:00
  • 002d33d8c5 Disable the vector-IN-SELECT optimization if the number of columns is so large that it would cause the WhereTerm.nChild column to wrap. [bugs:/info/2026-06-04T10:00:49Z|Bug 2026-06-04T10:00:49Z]. drh 2026-06-04 16:56:11 +00:00
  • d9439caee6 Fix a crash that could be caused by configuring the pager-cache with a bulk allocation too small to fit even one page. drh 2026-06-04 12:27:17 +00:00
  • ee181f479a Fix a crash that could be caused by configuring the pager-cache with a bulk allocation too small to fit even one page. Bug [bugs:/info/2026-06-04T07:03:12Z | 2026-06-04T07:03:12Z]. dan 2026-06-04 11:48:18 +00:00
  • 076db92d85 Fix a possible NULL pointer derefence in the (experimental and untested) uuid.c extension. [bugs:/info/2026-06-04T09:50:59Z|Bug 2026-06-04T09:50:59Z]. drh 2026-06-04 11:42:23 +00:00
  • 2dacda40a6 Extra testcase() macros to ensure adequate testing of the previous check-in. drh 2026-06-04 11:39:13 +00:00
  • eaba46222c Remove the data type ANY added to the shell's CSV imports. drh 2026-06-04 11:35:15 +00:00
  • 244554d02f Increment the patch level to 3.53.3. drh 2026-06-04 11:29:09 +00:00
  • 1ba44fc5e0 Fix problems with expressions like "(?,?,?) IN (SELECT c,b,a FROM ...)" when there is an index on columns "c", "b" and "a", but not in that order. drh 2026-06-04 11:24:28 +00:00
  • 62a3734e78 Fix problems with expressions like "(?,?,?) IN (SELECT c,b,a FROM ...)" when there is an index on columns "c", "b" and "a", but not in that order. Bug [bugs:/info/2026-06-04T07:02:53Z | 2026-06-04T07:02:53Z]. dan 2026-06-04 11:19:43 +00:00
  • 95d072cc81 Clearly mark the ext/misc/wholenumber.c extension as "testing and debugging use only". Fix a potential integer overflow that can occur if the above warning is ignored. [bugs:/info/2026-06-04T09:40:28Z|Bug 2026-06-04T09:40:28Z]. drh 2026-06-04 11:18:11 +00:00
  • 1e1679194e Remove all references to GetNativeSystemInfo() on Windows, which is [forum:/info/f01dc61c5febbe19|reportedly] not available when compiling with MinGW. drh 2026-06-04 10:28:26 +00:00
  • 0ec8e406bd Merge the 3.53.2 patch release into the reuse-schema-3.53 branch reuse-schema-3.53 drh 2026-06-03 19:28:11 +00:00
  • ccc132c5be Version 3.53.2 version-3.53.2 release drh 2026-06-03 19:12:13 +00:00
  • 5e132e142f Fix harmless compiler warning. drh 2026-06-03 18:51:23 +00:00
  • 0120735de1 Update the utf-8 decoder in the ICU extension to treat invalid sequences as codepoint 0xFFFD, matching the core. Report [bugs:/info/2026-06-03T04:04:46Z | 2026-06-03T04:04:46Z]. dan 2026-06-03 17:21:12 +00:00
  • b9e656f6f7 Fix a faulty assert() in rtree that could fire when processing an unusually large record. drh 2026-06-03 16:58:01 +00:00
  • d80528ad4d Fix a faulty assert() in rtree that could fire when processing an unusually large record. Bug [bugs:/info/2026-06-03T14:44:46Z | 2026-06-03T14:44:46Z]. dan 2026-06-03 16:46:15 +00:00
  • c867ce4b89 Use tail recursion on the larger of the two partitions when doing a quicksort as part of the implementation of the median() function, to avoid excess stack usage on pathological inputs. drh 2026-06-03 16:23:45 +00:00
  • c2d29194a8 Use tail recursion on the larger of the two partitions when doing a quicksort as part of the implementation of the median() function, to avoid excess stack usage on pathological inputs. [bugs:/info/2026-06-03T07:26:42Z|Bug 2026-06-03T07:26:42Z]. drh 2026-06-03 16:21:17 +00:00
  • ceb66403bb Fix an integer overflow problem in fts3 that could lead to a buffer overwrite on platforms where size_t is 32-bits. drh 2026-06-03 15:54:58 +00:00
  • 61523e22f9 Fix an integer overflow problem in fts3 that could lead to a buffer overwrite on platforms where size_t is 32-bits. Bug [bugs:/info/2026-06-03T04:28:51Z | 2026-06-03T04:28:51Z]. dan 2026-06-03 15:29:59 +00:00
  • 6c1aa834f6 Fix another buffer overread in fts5 that could occur when processing corrupt records. drh 2026-06-03 15:02:29 +00:00
  • 51b2c3863b Fix another buffer overread in fts5 that could occur when processing corrupt records. Bug [bugs:/info/2026-06-03T03:54:40Z | 2026-06-03T03:54:40Z]. dan 2026-06-03 14:58:13 +00:00
  • e7d405200a Fix another potential buffer overrun that could occur in fts5 when processing corrupt records. drh 2026-06-03 14:24:19 +00:00
  • 6feeafc7de Fix another potential buffer overrun that could occur in fts5 when processing corrupt records. dan 2026-06-03 13:49:33 +00:00
  • c911dda3d3 Fix a potential UAF bug in the zipfile extension. drh 2026-06-03 13:16:20 +00:00
  • a735462db6 Fix a potential UAF bug in the zipfile extension. [bugs:/info/2026-06-03T10:58:51Z|Bug 2026-06-03T10:58:51Z]. drh 2026-06-03 13:12:20 +00:00
  • d2240cc988 Fix negative array index in "testing and debugging uses only" extension qpvtab.c. [bugs:/info/2026-06-03T07:26:26Z|Bug 2026-06-03T07:26:26Z]. drh 2026-06-03 12:43:50 +00:00
  • edec48cd40 Avoid excessive recursion and stack overflow in fts3 when processing a corrupt database. drh 2026-06-03 12:04:07 +00:00
  • 942b7c555a Avoid excessive recursion and stack overflow in fts3 when processing a corrupt database. dan 2026-06-03 11:37:45 +00:00
  • f7915390d5 The prefix_length() function should stop at the first NUL terminator. drh 2026-06-03 11:30:01 +00:00
  • 069e5acd63 The prefix_length() function should stop at the first NUL terminator. [bugs:/info/2026-06-03T07:42:00Z|Bug 2026-06-03T07:42:00Z]. drh 2026-06-03 11:07:47 +00:00
  • 42be6fdf22 Make the (unused, untested, and unsupported) ext/misc/compress.c routines responsive to OOM conditions. drh 2026-06-03 11:05:22 +00:00
  • 1c0a370472 Make the (unused, untested, and unsupported) ext/misc/compress.c routines responsive to OOM conditions. [bugs:/info/2026-06-03T08:28:36Z|Bug 2026-06-03T08:28:36Z]. drh 2026-06-03 10:55:08 +00:00
  • 31a9e5c5d9 Update the session module so that it can apply changesets containing two or more UPDATE changes that form a dependency loop - so that no single UPDATE can be applied independently without violating a constraint. dan 2026-06-02 18:23:55 +00:00
  • 15ea8253d6 Merge the latest branch-3.53 fixes into the reuse-schema-3.53 branch. drh 2026-06-02 17:22:20 +00:00
  • 2acb57c1be Fix a case where sqlite3expert could be tricked into executing arbitrary SQL by a corrupt database schema. dan 2026-06-02 15:20:37 +00:00
  • 0851e6a4fe Remove a NEVER() that is actually reachable. This same NEVER() was removed from trunk at check-in [0de3d95500b7ecd4]. drh 2026-06-02 13:44:21 +00:00
  • 2a28b15748 Add extra test case to zipfile.test. No code changes. dan 2026-06-02 11:11:02 +00:00
  • b1637e5408 Fix the CLI so that it works when compiled using STDCALL on Microsoft x86. Change should not affect other platforms. [forum:/info/2026-06-02T09:44:12Z|Forum 2026-06-02T09:44:12Z]. drh 2026-06-02 10:08:30 +00:00
  • b48ca02d64 Enhance PRAGMA integrity_check so that it better detects incorrect header sizes at the beginning of cells. drh 2026-06-01 20:02:17 +00:00
  • b2543d0098 Disable transitive WHERE constraints when there are explicit COLLATE operators. drh 2026-06-01 18:07:44 +00:00
  • c28f2d22b6 Disable transitive WHERE constraints when there are explicit COLLATE operators. Fix for report [bugs:/info/ffddcd3617 | 2026-05-31T08:33:10Z]. dan 2026-06-01 18:01:13 +00:00
  • 48a591fa6b Minor performance improvement for the patch on this branch. transitive-where-collate-bugs dan 2026-06-01 17:56:11 +00:00
  • 2c351bbf82 Fix minor problems surrounding transitive WHERE constraints and explicit COLLATE terms. dan 2026-06-01 17:40:23 +00:00
  • ddea119f82 Make sure the authenticator is called for columns that are part of a USING in a FULL JOIN. [bugs:/info/2026-05-31T02:00:37Z|Bug 2026-05-31T02:00:37Z]. drh 2026-06-01 16:49:39 +00:00
  • 4902f35e63 For expressions of the form "(x, y...) IN (SELECT a, b ...)" where the result is not true, consider the collation sequences of columns "a" and "b" when determinining if the result should be false or NULL. drh 2026-06-01 16:38:10 +00:00
  • 03aa9a7b50 For expressions of the form "(x, y...) IN (SELECT a, b ...)" where the result is not true, consider the collation sequences of columns "a" and "b" when determinining if the result should be false or NULL. Bug report [bugs:/info/0785f45e67 | 2026-05-31T02:10:44Z]. dan 2026-06-01 16:20:40 +00:00
  • 2a95fade33 Fix a minor problem with test case mjournal-3.3. drh 2026-06-01 15:47:23 +00:00
  • 62d17739bc Better handle a (possibly) potential buffer overrun in fts5. Based on the report in [bugs:/info/38e75aa4f9 | 2026-05-31T09:06:13Z]. dan 2026-06-01 15:03:53 +00:00
  • 193a8f3673 Do not allow the argument to a table-valued function to reference a table to its right, even if the SELECT is inside a common table expression. drh 2026-06-01 13:48:25 +00:00
  • 81ceb00b00 Fix an integer overflow that could lead to a buffer overrun in the zipfile extension. drh 2026-06-01 13:44:19 +00:00
  • 8626a528e1 Extra defenses against integer overflows in the untested, unused, and unsupported transliterate() SQL extension function found in the ext/misc/spellfix.c extension. drh 2026-06-01 13:39:15 +00:00
  • f55434ab30 Remove the data type ANY added to the shell's CSV exports in [aff74e71ea734e1a], as discussed in [forum:2ea4c50f69fc9829|forum post 2026-06-01T12:01:59Z]. stephan 2026-06-01 13:14:48 +00:00
  • 0a04687373 Do not allow the argument to a table-valued function to reference a table to its right, even if the SELECT is inside a common table expression. This is a replacement for the fix at [3c0a277e6741c722]. Fix for multiple dbsqlfuzz reports and probably also a fix for [bugs:/info/b6c6fad96c|Bug 2026-06-01T07:23:11Z]. drh 2026-06-01 12:36:28 +00:00
  • c079bd08a2 Test case to show that the change fixes the original carray problem. right-ref-cte drh 2026-06-01 12:30:13 +00:00
  • 5cae890219 Improvements to sqlite3SelectCheckOnClauses() to be more accurate in identifying table-valued functions that references tables to the right. drh 2026-06-01 12:19:30 +00:00
  • f3eea1efa4 Back out the recent change to carray. The intent is to fix this problem in a different way so that it works for all table-valued functions. drh 2026-06-01 12:07:21 +00:00
  • 3040da55a8 Fix an integer overflow that could lead to a buffer overrun in the zipfile extension. Bug [bugs:/info/2026-06-01T10:16:47Z | 2026-06-01T10:16:47Z]. dan 2026-06-01 11:52:23 +00:00
  • 1a760748a6 Update new test in zipfile.test so that it does not run if SQLITE_MAX_LENGTH is too small. zipfile-buffer-overrun dan 2026-06-01 11:50:55 +00:00
  • 5481274912 Fix an integer overflow that could lead to a buffer overrun in the zipfile extension. Bug [bugs:/info/2026-06-01T10:16:47Z | 2026-06-01T10:16:47Z]. dan 2026-06-01 10:56:11 +00:00
  • 6c218ba0ad Extra defenses against integer overflows in the untested, unused, and unsupported transliterate() SQL extension function found in the ext/misc/spellfix.c extension. [bugs:/info/2026-06-01T10:34:57Z|Bug 2026-06-01T10:34:57Z]. drh 2026-06-01 10:53:28 +00:00
  • ca8593ce68 Fix the carray virtual table so that it gives no solution if it cannot find a usable first parameter. dbsqlfuzz find. drh 2026-05-31 19:41:16 +00:00
  • af6fdd2673 Test case to cover the bug fix in the previous check-in. drh 2026-05-31 17:01:44 +00:00
  • b8c5fe2c19 Fix the zipfile extension so that ZIP archives containing files whose names contain embedded \000 bytes do not cause problems. drh 2026-05-31 15:52:29 +00:00
  • 1cd9eb3811 Fix the zipfile extension so that ZIP archives containing files whose names contain embedded \000 bytes do not cause problems. [bugs:/info/2026-05-31T11:43:05Z|Bug 2026-05-31T11:43:05Z]. drh 2026-05-31 15:49:57 +00:00
  • 7437c19a01 Fiddle should default to using NO_COLOR since the JS console does not support ANSI X3.64. drh 2026-05-31 09:38:28 +00:00
  • c3a422d794 Fix the format() SQL function so that it reports TOOBIG and NOMEM errors. Fix a possible integer overflow on %#Q formatting. drh 2026-05-31 09:23:09 +00:00
  • d076d98ec8 Fix the format() SQL function so that it reports TOOBIG and NOMEM errors. Fix a possible integer overflow on %#Q formatting. [bugs:/info/2026-05-31T02:00:07Z|Bug 2026-05-31T02:00:07Z]. drh 2026-05-31 09:18:31 +00:00
  • d542c33c9d Add a test to ensure an application does not try to create a geopoly virtual table with too many columns. drh 2026-05-30 13:25:49 +00:00
  • 72f0bd609c Add a test to ensure an application does not try to create a geopoly virtual table with too many columns. [bugs:/info/2026-05-30T12:47:27Z|Bug 2026-05-30T12:47:27Z]. drh 2026-05-30 13:23:25 +00:00
  • 7aad2942c2 Harden the diskused.c extension against NULL pointer deferences that might have previously occurred when given a corrupt database file. [bug:/info/2026-05-30T07:08:55Z|Bug 2026-05-30T07:08:55Z]. drh 2026-05-30 10:24:03 +00:00
  • fa5d2efbfc Remove the untested and undocumented "scrub" utility program. It was written in 2016, but made obsolete by the VACUUM INTO command in 2019. drh 2026-05-30 10:15:58 +00:00
  • 07ded24fbb Remove the untested and undocumented "scrub" utility program. It was written in 2016, but made obsolete by the [VACUUM INTO] command in 2019. drh 2026-05-30 10:09:33 +00:00
  • c22fe7a31c Be sure to do floating-point to text conversions in JSON to the full 17-digits. drh 2026-05-29 23:17:09 +00:00
  • 5b98467d28 Be sure to do floating-point to text conversions in JSON to the full 17-digits. drh 2026-05-29 23:14:22 +00:00
  • 1b66c8f2e9 Merge the latest trunk enhancements and fixes into the bedrock branch via wal2. bedrock drh 2026-05-29 18:18:03 +00:00
  • 87ed2e565e Merge the latest trunk enhancements and fixes into the wal2 branch. wal2 drh 2026-05-29 18:08:48 +00:00
  • 3d006d0d00 Rename the ext/misc/analyze.c extension to ext/misc/diskused.c, to avoid confusion with the src/analyze.c file. The function is now called "diskused(X)" instead of "analyze(X)". The CLI command is renamed from ".dbstat" to ".diskused". drh 2026-05-29 14:57:38 +00:00
  • 991cbd78b3 The -csv option to the CLI also sets "-limits off", for legacy compatibility, and because that seems to make sense. [forum:/info/2026-05-28T16:23:36Z|Forum thread 2026-05-28T16:23:36Z]. drh 2026-05-29 12:23:38 +00:00
  • 56363a8d07 Merge the latest trunk fixes and enhancements into the begin-concurrent branch. begin-concurrent drh 2026-05-28 20:11:47 +00:00
  • 6a8e887a64 Avoid a resource leak in an error path in the icu extension. dan 2026-05-28 11:29:05 +00:00
  • 43ab3c2a84 Fix an infinite loop that can occur in the unused, untested, and unsupported ext/misc/btreeinfo.c extension if it is presented with a corrupt database file. [bugs:/forumpost/b43c44cc1c|Bug 2026-05-28T05:41:01Z]. drh 2026-05-28 11:16:55 +00:00
  • 9b7ea5700b Fix a problem with shell tool function analyze() and schema objects with name containing "%" characters. dan 2026-05-28 11:12:29 +00:00
  • a15c394233 Fix potential integer overflow in btree overflow page cache computation. drh 2026-05-28 10:18:42 +00:00
  • 720d3afa7e Fix potential integer overflow in btree overflow page cache computation, reported by Project Fortify. Test cases in TH3. drh 2026-05-28 10:14:25 +00:00
  • 4cc2dbd54d Patch test/indexexpr1.test to work when built with SQLITE_DQS=0. Addresses [forum:2026-05-26T18:08:20Z|forum post 2026-05-26T18:08:20Z]. stephan 2026-05-26 19:25:36 +00:00
  • b79ffe60b6 Fix an OOM check in shell.c.in. Addresses [forum:2026-05-26T15:02:35Z|forum post 2026-05-26T15:02:35Z]. stephan 2026-05-26 17:15:54 +00:00
  • d38b6c0a19 Fix a potential 1-byte overread in sqlite3changeset_invert() when processing a corrupt buffer. drh 2026-05-26 15:09:07 +00:00
  • 6e3e557c81 Fix a potential 1-byte overread in sqlite3changeset_invert() when processing a corrupt buffer. dan 2026-05-26 15:03:30 +00:00
  • 600eb440c2 Fix a 32-bit integer overflow in sqlite3changegroup_change_blob() that could lead to a buffer overwrite. drh 2026-05-26 14:23:36 +00:00
  • 18bee1617f Fix a 32-bit integer overflow in sqlite3changegroup_change_blob() that could lead to a buffer overwrite. dan 2026-05-26 14:18:50 +00:00
  • e9b5658888 Fix QRF so that it works sensibly with "--wrap 1" drh 2026-05-26 13:57:36 +00:00
  • 2315f282be Fix QRF so that it works sensibly with "--wrap 1" drh 2026-05-26 13:54:57 +00:00