๐ŸŒ AIๆœ็ดข & ไปฃ็† ไธป้กต
  1. 61f2ee6 Back out the assert() fixes from [a9443dbfbe25e588] and by drh ยท 1 year, 7 months ago alter-table-fix
  2. 1550771 Fix a case where an error in the ORDER BY clause of an aggregate function that is part of a trigger body might cause an assert() to fail in an ALTER TABLE command. by dan ยท 1 year, 7 months ago
  3. 9a1a482 If there is no data available for a field in a corrupted record, but the type is available, have the recovery extension substitute 0, 0.0, '' or X'' instead of a NULL value. by dan ยท 1 year, 7 months ago
  4. f722d91 Add tests to bestindexC.test. No changes to code. by dan ยท 1 year, 7 months ago
  5. 5d783d5 Fix aggregate function processing to correctly deal with OOMs inside of by drh ยท 1 year, 7 months ago
  6. e09e451 Add a test for the fixes on this branch. by dan ยท 1 year, 7 months ago cleanup-testing
  7. 3254206 The sqlite3FaultSim(300) error from [1e8863909ac369e5] must be treated as by drh ยท 1 year, 7 months ago
  8. 0e4afdd Improvements to the ".testctrl fault_install" command in the CLI. by drh ยท 1 year, 7 months ago
  9. 7e60106 Add an sqlite3FaultSim(300) call to the sqlite3ParserAddCleanup() routine by drh ยท 1 year, 7 months ago
  10. 8292aa7 Squelch two OMIT-flag-related warnings reported in [forum:388243d9882067a9|forum post 388243d9882067a9]. No functional changes. by stephan ยท 1 year, 7 months ago
  11. a8c4383 Add a maintenance-reminder comment explaining [dc58ed65492857]. by stephan ยท 1 year, 7 months ago
  12. 0e93237 Reformulate a for-in loop to a for loop in wasm.xWrap() to work around a downstream framework-level misbehavior, as reported in [forum:b549992634b55104|forum post b549992634b55104]. by stephan ยท 1 year, 7 months ago
  13. f0c9bc5 Rename a shadowed local var, as reported in [forum:2ba65af3148585cf|forum post 2ba65af31]. No functional changes. by stephan ยท 1 year, 7 months ago
  14. 538ad6c Fix a hyperlink typo in session documentation. by drh ยท 1 year, 7 months ago
  15. d1122a4 Fix bug in test script sessionconflict.test. by dan ยท 1 year, 7 months ago
  16. a40cae7 Ensure successive scans of pragma virtual tables return consistent rowids. by dan ยท 1 year, 7 months ago
  17. e871779 Fix a compilation error in test/lemon-test01.y, reported in [forum:f0ad095705|forum post f0ad095705]. by stephan ยท 1 year, 7 months ago
  18. 11a088b When extracting links from sqlar archives, clobber any existing file or link, and do not call utimes() to set the timestamp - it looks through the link and operates on the target. by dan ยท 1 year, 7 months ago
  19. 07305e3 Omit redundant unary + operators from the AST. by drh ยท 1 year, 7 months ago
  20. ebf9702 Avoid unnecessary recursion in sqlite3ExprDeleteNN(). This complicates the by drh ยท 1 year, 7 months ago
  21. f4744ff Add new sessions API sqlite3changegroup_add_change(). by dan ยท 1 year, 7 months ago
  22. cbea8d5 Edit comments in sqlite3session.h. by dan ยท 1 year, 7 months ago changegroup-add-change
  23. 0f78aaf Add tests for sqlite3changegroup_add_change(). by dan ยท 1 year, 7 months ago
  24. 1002bcf Fix problem in sqlar_uncompress() when being used to extract symbolic links. by dan ยท 1 year, 7 months ago
  25. 1aa94b5 Add comment to the test/lemon-test01.y file indicating that it does not work by drh ยท 1 year, 7 months ago
  26. 5b80dbe Add new sessions API sqlite3changegroup_add_change(). by dan ยท 1 year, 7 months ago
  27. c52c00f Add test cases to test/in7.test. No code changes. by dan ยท 1 year, 7 months ago
  28. e8ba446 Assume that an SQL function is able to return a subtype if any of its by drh ยท 1 year, 7 months ago
  29. 2eb9adb Assume that a function is able to return a subtype if either (1) it is itself by drh ยท 1 year, 7 months ago func-rw-subtype
  30. 5b9b7cb Functions that pass through the sqlite3_value of one of their arguments must by drh ยท 1 year, 7 months ago
  31. 0901571 The coalesce(), ifnull(), and iif() functions pass through subtype values by drh ยท 1 year, 7 months ago
  32. 9c0d777 Fix a problem with queries that use "IN(...) ORDER BY ... NULLS LAST" or similar introduced by [d7648e21605a0b38]. by dan ยท 1 year, 7 months ago
  33. 7281493 Avoid an assert failure accessible only when internal testing features are enabled. dbsqlfuzz crash-66abacda6bca6bd531e25595e8c8068e2c710326.txt. by dan ยท 1 year, 7 months ago
  34. 01508c8 Fix a case where the recovery extension might write uninitialized data to the recovered database. by dan ยท 1 year, 7 months ago
  35. aeb6288 Avoid an OP_Next in cases where an IN(...) query against a UNIQUE index may return at most 1 row. by dan ยท 1 year, 7 months ago
  36. d059774 Fix the CREATE TABLE performance issue described by by drh ยท 1 year, 7 months ago
  37. 9b4e789 Add a test case to the fix to PRAGMA integrity_check in the previous check-in. by drh ยท 1 year, 7 months ago faster-create
  38. 78bc133 Do not accept a string that looks like a number used as an argument to by drh ยท 1 year, 7 months ago
  39. 2ae4531 Omit the OP_SqlExec to "PRAGMA integrity_check" added by [348fa7aaf7958b3f] by drh ยท 1 year, 7 months ago
  40. f3ea92c Avoid an OP_Next in cases where an IN(...) query against a UNIQUE index may return at most 1 row. by dan ยท 1 year, 7 months ago unique-in-opt
  41. 2ad1e92 Fix another problem in the recovery extension where a corrupt sqlite_schema table could lead to excessive memory consumption. by dan ยท 1 year, 8 months ago
  42. 19ca99e Fix a problem causing the recovery extension to use excessive memory and CPU time in some cases. by dan ยท 1 year, 8 months ago
  43. 8d5fe07 Avoid 32-bit overflow when calculating ncycle for ".scanstats vm". by dan ยท 1 year, 8 months ago
  44. b11daa5 Fix issues in [/info/1e227ad9f413227f|LIMIT/OFFSET support for virtual tables]. by drh ยท 1 year, 8 months ago
  45. b95c1d0 Internal JS doc touchups. No functional changes. by stephan ยท 1 year, 8 months ago
  46. 6c290cc Additional internal docs in the wasm utilities. by stephan ยท 1 year, 8 months ago
  47. 4c3ab54 Allow virtual table implementations to handle OFFSET but not LIMIT, but not LIMIT but not OFFSET. by dan ยท 1 year, 8 months ago vtab-limit-fix
  48. 297472a Have where.c ignore any plan from a virtual table that tries to use LIMIT/OFFSET without also using all WHERE constraints. by dan ยท 1 year, 8 months ago
  49. d3a4dbe Further fixes and improvements to the generate_series() enhancements on by drh ยท 1 year, 8 months ago
  50. 84a231e Use hex flag masks rather than decimals in ext/misc/series.c. by drh ยท 1 year, 8 months ago
  51. 3afd5b6 Fix a problem allowing a LIMIT constraint to be passed to a virtual table in cases where there exist WHERE terms that cannot also be passed. by dan ยท 1 year, 8 months ago
  52. 99ac232 Fix handling of LIMIT and OFFSET in virtual tables that are part of by drh ยท 1 year, 8 months ago
  53. 317b741 Enhance the generated_series() table-valued-function to respond to by drh ยท 1 year, 8 months ago
  54. d591a5b Add test demonstrating the problem at [forum:/forumpost/c243b8f856|forum post c243b8f856]. No fix yet. by dan ยท 1 year, 8 months ago
  55. fed13d5 Fix the TreeView display of a LIMIT clause on a compound query. Debugging by drh ยท 1 year, 8 months ago
  56. ec14ef8 Improvement to the way that affinity is determined for columns of a by drh ยท 1 year, 8 months ago
  57. ddc6bd9 Further improvements to the computation of affinity for compound subqueries: by drh ยท 1 year, 8 months ago compound-subquery-affinity
  58. 23afc2c Back out the previous change on this branch. In its place: Determine the by drh ยท 1 year, 8 months ago
  59. c859f02 wasm: add a makefile comment about the static sqlite3.h/c version info injected into the JS files possibly differing from the runtime-emited version info when a user provides their own sqlite3.c. by stephan ยท 1 year, 8 months ago
  60. f8e1951 An experimental minor tweak to the way affinities are computed for compound by drh ยท 1 year, 8 months ago
  61. 0868d58 If a RETURNING clause contains a subquery that references the table that is by drh ยท 1 year, 8 months ago
  62. dfa6289 Fix a case where a corrupt stat4 record could go unrecognized due to integer overflow. by dan ยท 1 year, 8 months ago
  63. 35b771e Add comments linking the assert() added in [cef4d9e3ba586735] to the places by drh ยท 1 year, 8 months ago
  64. 5b27eca Avoid slowdown when exprNodeIsConstant() is called on deeply nested SQL functions. by dan ยท 1 year, 8 months ago
  65. b065ece Ensure that temporary SrcItem objects created by trigger processing have by drh ยท 1 year, 8 months ago
  66. 99200b2 Remove an undocumented feature from the JS Worker1.open API because it relies on broken behavior which has no VFS-agnostic workaround. by stephan ยท 1 year, 8 months ago
  67. 14602ea Fix a problem with vector IN operators used with an index where the affinities by drh ยท 1 year, 8 months ago
  68. 0309fb9 Fix an uninitialized variable problem in the new code on this branch. by dan ยท 1 year, 8 months ago vector-in-fix
  69. 3ac612d Remove some dead WASM-side code. by stephan ยท 1 year, 8 months ago
  70. 642e950 Minor touchups in JS docs and exception messages. by stephan ยท 1 year, 8 months ago
  71. 6e6dfd6 When running the 'dist' target in ext/wasm for an SEE-capable build, ensure that the resulting zip file and directory name include '-see'. by stephan ยท 1 year, 8 months ago
  72. 46435a0 Add extra tests for aborting conflicts in the sessions module. by dan ยท 1 year, 8 months ago
  73. 5d8daf1 Minor cleanups to [8fbda563d2f5]. by stephan ยท 1 year, 8 months ago
  74. 0a42e99 Extend the JS/WASM SEE build support by (A) filtering SEE-related bits out of the JS when not building with SEE and (B) accepting an optional key/textkey/hexkey option to the sqlite3.oo1.DB and subclass constructors to create/open SEE-encrypted databases with. Demonstrate SEE in the test app using the kvvfs. This obviates the changes made in [5c505ee8a7]. by stephan ยท 1 year, 8 months ago
  75. 4f2f6c7 Extra robustness in the code that causes cursors to return NULL when they by drh ยท 1 year, 8 months ago
  76. 2469350 For sqlite3.oo1.DB JavaScript classes, bypass execution of any on-open() SQL in SEE-capable builds because it would necessarily run before the client has an opportunity to provide their decryption key, which would leave the db handle in an unusable state and cause the ctor to throw. This currently affects only the OPFS VFSes. We may want to consider extending the ctor options object to optionally accept an SEE key and apply it when opening the db. by stephan ยท 1 year, 8 months ago
  77. 2c26adb Continuation of the fix at [8c0f69e0e4ae0a44]: If a viaCoroutine FROM clause by drh ยท 1 year, 8 months ago
  78. db2a33a Fix an indentation problem in debugging routine sqlite3ShowSrcList(). No by drh ยท 1 year, 8 months ago
  79. 5749e1e Slight performance improvement for the new code on this branch. by dan ยท 1 year, 8 months ago
  80. d737fee Fix a problem where an expression like (a, b) IN (SELECT ...) might not use an index on (a, b) if the affinities and collation sequences of "a" and "b" are not identical. by dan ยท 1 year, 8 months ago
  81. 0526db3 Correct handling of OUTER JOIN when on or the other operand is a subquery by drh ยท 1 year, 8 months ago
  82. 06915d0 The first assert() added in [0ebc65481f4a3e79] is not necessarily true in a by drh ยท 1 year, 8 months ago
  83. 0221cac If a build fails in testrunner.tcl, do not attempt to run the jobs that by drh ยท 1 year, 8 months ago
  84. 6f4e5ee Fixes and new tests logic to ensure that the btree overflow page cache is by drh ยท 1 year, 8 months ago
  85. 1d40237 Add assert() statements to help verify the overflow page cache. by drh ยท 1 year, 8 months ago btree-ovfl-cache
  86. ae7ede4 New assert() statements to verify the correctness of the BTCF_AtLast flag by drh ยท 1 year, 8 months ago
  87. 366b419 Test case for the fix in the previous check-in. by drh ยท 1 year, 8 months ago
  88. c494fdb Mark the BTree cell overflow cache as invalid whenever the rowid goes invalid. by drh ยท 1 year, 8 months ago
  89. b6d108f Fix handling of the SQLITE_OMIT_WAL check in one place. Resolves [forum:87cc13302de160eb|forum post 87cc13302de160eb]. by stephan ยท 1 year, 8 months ago
  90. 495ce22 Fix a "shift exponent is too large" usan error that could occur in the fts3 snippet() function when a query phrase contains more than 64 tokens. by dan ยท 1 year, 8 months ago
  91. 73a50fa Avoid some performance problems in the recover extension when recovering strategically corrupted databases. by dan ยท 1 year, 8 months ago
  92. d21d5b2 The read-only CHECK-constraint optimization of [34ddf02d3d21151b] inhibits the by drh ยท 1 year, 8 months ago
  93. 1278ac4 Update tests in returning1.test to account for [c7896e88]. by dan ยท 1 year, 8 months ago
  94. d59afcf Enhance the WHERE-clause push-down optimization so that it is able to by drh ยท 1 year, 8 months ago
  95. 0389d5f Fix a harmless compiler warning in the ICU extension due to [acddbc489d5231da]. by drh ยท 1 year, 8 months ago
  96. ac94cf3 Enhancements to the fuzzer invariant checker to turn optimizations on and off. by drh ยท 1 year, 8 months ago pushdown-subquery
  97. 5b613ed Merge trunk testing enhancements into the pushdown-subquery branch. by drh ยท 1 year, 8 months ago
  98. fa4c424 Omit all rowid-in-view restrictions from the fuzzinvariant.c test module by drh ยท 1 year, 8 months ago
  99. 1152def If SQLITE_ALLOW_ROWID_IN_VIEW is set to 2, then all rowids for views return by drh ยท 1 year, 8 months ago
  100. 660322f Merge trunk enhancements into the pushdown-subquery branch. by drh ยท 1 year, 8 months ago