aboutsummaryrefslogtreecommitdiff
Commit message (Collapse)AuthorAge
...
* | | Optimize allocation of large tombstone arrays in fts5.dan2025-07-15
| | | | | | | | | FossilOrigin-Name: 0fcc3cbdfa21adf97aed01fa76991cccf9380e2755b0182a9e2c94e3c8fb38d7
* | | Add the snapshot-zip makefile targets for both Windows and Posix.drh2025-07-14
| | | | | | | | | FossilOrigin-Name: 8c73c0c5935431556f687556bfdb459754609f07c6366c810a55bf7583ee303d
* | | Enhance the "mktoolzip.tcl" script (used by the "tool-zip" makefile target) ↵drh2025-07-14
| | | | | | | | | | | | | | | | | | | | | | | | so that it uses "fossil test-filezip" to build the ZIP archive if available, and so that it also generates windows-dll-*.zip on Windows platforms. FossilOrigin-Name: 63ddc215eb6106985c53d3c8d99f5445a92acf4359a6bb2681882c49583df871
* | | In rtree.c, ensure that the pReadAux statement is reset whenever the ↵dan2025-07-14
|\ \ \ | | | | | | | | | | | | | | | | bAuxValid flag is cleared. Fix for [forum:/forumpost/3e45ed31d8 | forum post 3e45ed31d8]. FossilOrigin-Name: 3c0afda372cd688e9aff7be1c0a41f557c8c8819f5f47420166ce8255cd806c8
| * | | In rtree.c, ensure that the pReadAux statement is reset whenever the ↵dan2025-07-14
|/ / / | | | | | | | | | | | | bAuxValid flag is cleared. Possible fix for [forum:/forumpost/3e45ed31d8 | forum post 3e45ed31d8]. FossilOrigin-Name: 1740f9a09850f6647fc1f6384353d89a1ac0b2b15c429b576b6014eada71937e
* | | Add new sessions function sqlite3changeset_apply_v3() and its streaming ↵dan2025-07-14
| | | | | | | | | | | | | | | equivalent. This allows changesets to be filtered on a per-change basis, not just per-table. FossilOrigin-Name: 10ebd7a119ef1985755ef143a941fbaed1b5ca1c8a71e011c8bbc70e383fd337
* | | Fix harmless compiler warnings in builds that use SQLITE_OMIT_DATETIME_FUNCS.drh2025-07-14
|/ / | | | | FossilOrigin-Name: e11fbf9fd630a7de2e0b0e4b67dded05b905b2a0ba04aa7e915ca9df2d9ebe21
* | wasm: introduce the sqlite3.oo1.DB.wrapHandle() and Stmt.wrapHandle() APIs, ↵stephan2025-07-11
|\ \ | | | | | | | | | | | | which enable clients to wrap (sqlite3*) resp. (sqlite3_stmt*) pointers in their oo1 API counterparts, optionally with or without taking over ownership of the pointer. FossilOrigin-Name: e5d079549594ca44852773b8919894866394e47ad725dadc7f65242413a219d3
| * | Clearer docs for the unowned db/stmt handle mechanism.stephan2025-07-11
| | | | | | | | | FossilOrigin-Name: 53401b5435e30c4b47b6e203976b714d616246d734b5876a34f53f6388f872f8
| * | Correct a one-too-many-exclamation-points bug which caused the opposite of ↵stephan2025-07-11
| | | | | | | | | | | | | | | intended semantics in oo1.Stmt.pointer ownership. FossilOrigin-Name: 91e709f36d36174534b4cf4ff548a558e66cca5e23a6c8c106bc43375fc3ce72
| * | Minor JS doc tweaks.stephan2025-07-10
| | | | | | | | | FossilOrigin-Name: 34d893b4837be8bb679e9809befd98201dd79c8d2054f41429b18793b77e840f
| * | wasm: DB.wrapHandle() no longer accepts a DB object as its first argument, ↵stephan2025-07-09
| | | | | | | | | | | | | | | as there's no apparent use case for proxying one DB object with another. Doc improvements for the new code. FossilOrigin-Name: 0ee19db02a9b9320681d4393d9ba52889d149eac8ee114fc7b7f52a57271c139
| * | wasm: add a few tests demonstrating that oo1.Stmt.paramaterCount's new impl ↵stephan2025-07-09
| | | | | | | | | | | | | | | does not change visible behaviors. Add the c-pp-filtered files to 'make clean'. FossilOrigin-Name: 3fe61545967f82190011edb90b1be6a448b590555c7ba5f8e96494aeea8f88ce
| * | Remove some dead JS code and some extraneous debug output from test code.stephan2025-07-06
| | | | | | | | | FossilOrigin-Name: 6e73770a7f3845055e0130012d844c32c4a1bfdb87e8379c161e1a266a808143
| * | JS doc additions.stephan2025-07-06
| | | | | | | | | FossilOrigin-Name: 7933505f0c1d25c6ee81ead8edc5ea649a84ec0582321bcf5ed4a17232750f90
| * | Experimentally add sqlite3.oo1.DB/Stmt.wrapHandle(), which allow DB/Stmt ↵stephan2025-07-06
| | | | | | | | | | | | | | | instances to wrap a (sqlite3*)/(sqlite3_stmt*) optionally with or without taking ownership of it. The intent is to enable mix-and-match use of the C API, the oo1 API, and any other hypothetical API which exposes those pointers. oo1.Stmt.parameterCount is now a property access interceptor like Stmt.columnCount is, but that doesn't change how it's used. FossilOrigin-Name: 1227543b87c3320d6b80e0f61b88ea53b68779966a0295c4d6a1db6369c48207
* | | Additional header comment documentation in the ext/misc/vtablog.c test ↵drh2025-07-11
| | | | | | | | | | | | | | | extension. FossilOrigin-Name: 3656acfaa3011321a6e17fb81e5bdedcfffeab6035f133ab89ae9589bf5bef72
* | | speedtest1: in WASM builds, disable the "app" test set by default because ↵stephan2025-07-11
| | | | | | | | | | | | | | | that one set is triggering file-not-found errors for the db file for reasons not yet understood. FossilOrigin-Name: 9d68971c58261bce72b49c574cf07ad31add62bee814c58840b927fed7eb87b1
* | | Do not export the numerous Emscripten HEAPxy symbols and remove the last ↵stephan2025-07-11
| | | | | | | | | | | | | | | remaining JS code which references them. They have long-since been replaced by internal equivalents and a specific feature check on one of them (which is also no longer needed) is triggering an exception from Emscripten. More details are in [https://github.com/emscripten-core/emscripten/issues/24656 | Emscripten ticket #24656], noting that this is not an Emscripten bug but an Emscripten behavior change brought it to light. FossilOrigin-Name: b9462dc1461c830466f4e1de4a4d3bf249e3f81aea363f13462ea915769878d9
* | | Improve the accuracy of the ETC on both devtest and releasetest.drh2025-07-10
| | | | | | | | | FossilOrigin-Name: a3f96cafdc0e1f2eeccc6509f1f9c26d2c48668953550f299cf2805a0a063014
* | | Add the estkey column to the jobs table of testrunner.db. The plan is todrh2025-07-10
| | | | | | | | | | | | | | | | | | use this to collect measurements that will help generate improved ETAs for a test run. FossilOrigin-Name: 9eccf5267c6423c9dd4da1d61b62bbb6fbba44fb8089da79f89c84e8b77ff0f0
* | | Minor internal doc correction in vdbeInt.h.stephan2025-07-10
| | | | | | | | | FossilOrigin-Name: c3a2ef639c22255a298cbccb7fd871ec9b24929f82bf95d6982b12daf5c963d6
* | | Fix the empty-table optimization on INTERSECT so that it does not try todrh2025-07-09
| | | | | | | | | | | | | | | use an uninitialized register for LIMIT processing. FossilOrigin-Name: 6918ada008507b4564ca0dc5f4f6818c49a42eb14a16285b2074e21dcc8f2c3f
* | | Fix a possible user-after free following OOM in the EXISTS-to-JOINdrh2025-07-08
| | | | | | | | | | | | | | | optimization. FossilOrigin-Name: 498ee8d514e64cdc93a8d68e1971b6326c6132daf25067936bec921c42494caa
* | | Adjustments to test/incrblob4.test so that it works on both Linux and Macdrh2025-07-08
| | | | | | | | | | | | | | | | | | in spite of error message differences between those platforms. Minor change to termIsEquivalent() to provide 100% MC/DC. FossilOrigin-Name: 720387f8604f7cd997f1850ed62ce6ab32608155d7f02a89c695041caafc4067
* | | New optimizations to detect early when queries return no rows due todrh2025-07-08
|\ \ \ | | | | | | | | | | | | | | | | | | | | | | | | tables being empty. This includes the EXISTS-to-JOIN optimization that tries to transform EXISTS constraints into additional terms of the FROM clause. FossilOrigin-Name: e33da6d5dc964db817d1bc63c9083aecd93d49ee14d5198600b47eaf7c5b9331
| * | | Enable the EXISTS-to-JOIN optimization if the outer query has nodrh2025-07-08
| | | | | | | | | | | | | | | | | | | | FROM clause. FossilOrigin-Name: 1b9b124f9a35ebd1ac4ea70ef1ee08a4c82c11da690d4164f6b785a6fd9730d9
| * | | Small performance optimization in the resolver.drh2025-07-07
| | | | | | | | | | | | FossilOrigin-Name: 840646df0696706bd4dd7a04dfc8b16ad80c24cbcbc57a22c9e65a93cc17af2b
| * | | Merge the latest trunk enhancements and fixes into the ↵drh2025-07-07
| |\ \ \ | | | | | | | | | | | | | | | | | | | | empty-table-optimizations branch. FossilOrigin-Name: f15cdf07573c05276a13885d74bae21a93544766344f19ef939b7a69edd1073b
| * | | | Improvements to the EXPLAIN QUERY PLAN output for EXISTS-to-JOIN.drh2025-07-06
| | | | | | | | | | | | | | | FossilOrigin-Name: 6b1ecbaa2ee405be040901dceac45d027d35c313622748ba4dbbd404e297a7fa
| * | | | Enhance the EXISTS-to-JOIN optimization so that it works on EXISTS subqueriesdrh2025-07-05
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | that do not have a WHERE clause, and so that it works on nested EXISTS subqueries. FossilOrigin-Name: c1d5295724f9cf7f49e0786d28016eff2d268a2b670f934d24c76787626089db
| * | | | Merge fixes from trunk into the empty-table-optimizations branchdrh2025-07-04
| |\ \ \ \ | | | | | | | | | | | | FossilOrigin-Name: 6f98b16d210a9f5b6ca4b4599e3dab3263eddbae7c70ddbcabf988f4a1014e8b
| * | | | | Do not allow the EXISTS-to-JOIN optimization if the EXISTS clause is baseddrh2025-07-04
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | on a view, since that view might expand into a join. FossilOrigin-Name: 872c41feddafcc21a02f1229ce017ceea9f8e309a4dd5b6e323477d67f975947
| * | | | | Improve the early-termination optimization so that it works in queriesdrh2025-07-04
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | which use the LIKE optimization in the outer loop. FossilOrigin-Name: b4e4d148243cfcb09aa0aaca30e83812b42e2780073e55c0e8c6e3da16243dfc
| * | | | | Merge the latest trunk fixes and enhancements into the ↵drh2025-07-03
| |\ \ \ \ \ | | | | | | | | | | | | | | | | | | | | | | | | | | | | empty-table-optimizations branch FossilOrigin-Name: d4f47e04f5880e99a53089e2dd5cde64a7ea44f059d9906b5d11324896546714
| * | | | | | Minor tweaks to the exists-to-join optimization.drh2025-07-03
| | | | | | | | | | | | | | | | | | | | | FossilOrigin-Name: 9cb600ad576c68647ed943a0773019312c5f01c9c1ca9ff0bf1214b03a531b48
| * | | | | | Merge in the exists-to-join optimization that has been modifieddrh2025-07-02
| |\ \ \ \ \ \ | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | to relax the requirement of having an indexed join constraint. FossilOrigin-Name: 1c1aef2b7feae29066d0330699ab634ef41f5b60cdcd479a60cb1a5409553138
| | * \ \ \ \ \ Merge all the latest trunk enhancements into the exists-to-join branch.drh2024-07-31
| | |\ \ \ \ \ \ | | | | | | | | | | | | | | | | | | FossilOrigin-Name: 9084a4c8726a2c7ba1c381886e29c7b86121d531282be0d63d5988d84f6f448d
| | * \ \ \ \ \ \ Merge the latest trunk enhancements into the exists-to-join branch.drh2024-06-27
| | |\ \ \ \ \ \ \ | | | | | | | | | | | | | | | | | | | | FossilOrigin-Name: fc643f8a12e9b7448136b281f798e18dfebe0a3df5115d930b965c8a33933e2d
| | * | | | | | | | Do not attempt the exists-to-join optimization if the FROM clause is full.drh2024-06-20
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | FossilOrigin-Name: 8e3a1d2850337a902ab36b1d6a0dad4ae35030b71d1e15547f6e7487c1f86d18
| | * | | | | | | | Add tests for the change on this branch.dan2024-06-14
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | FossilOrigin-Name: ae19ff9ba819439fd107e745b6e8e503e5b68bfdb9da58b74035413704ad3caf
| | * | | | | | | | Do not attempt the exists-to-join optimization for expressions from the ON ↵dan2024-06-12
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | clause of joins. FossilOrigin-Name: 4666433cbd9af21c2e0440b10bcb39878624a39485e2bb514553b276acb8a401
| | * | | | | | | | Provide the ability to disable the exists-to-join optimization usingdrh2024-06-11
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | SQLITE_TESTCTRL_OPTIMIZATIONS. Provide tree-trace output for the optimization. FossilOrigin-Name: 33a3f327855b427ae6ba0057218d043a1417bc9d780728f47f23acdd836e1686
| | * | | | | | | | Merge trunk enhancements into the exists-to-join branch.drh2024-06-11
| | |\ \ \ \ \ \ \ \ | | | | | | | | | | | | | | | | | | | | | | FossilOrigin-Name: 5f25a9518a675efbd0525cc2f5595ee7bc7122be7cfecdf6b20c909185dea370
| | * | | | | | | | | Add missing calls to sqlite3exprSkipCollateAndLikely() to the enchancement ↵dan2024-06-10
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | on this branch. FossilOrigin-Name: 078537d057d638389e3ab3bc04bcac53f342c7bf1d8d75222296ef42d09e9ee7
| | * | | | | | | | | Fix a crash that could occur when the SELECT in an EXISTS(SELECT ...) used ↵dan2024-06-10
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | an unknown collation sequence. FossilOrigin-Name: f3009a6d7facd1ead520d588c5ad089db76d8641cd3dae076f2405492d7defcd
| | * | | | | | | | | Add extra tests for the changes on this branch.dan2024-06-08
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | FossilOrigin-Name: a6365c778f2a6d6fa78e8520553373898f382ce73bf6496533e26291648ef5d1
| | * | | | | | | | | Experimental optimization to rewrite a SELECT with an EXISTS(...) expression ↵dan2024-06-07
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | in the WHERE clause as a join. FossilOrigin-Name: 972a33db0b0e924b78d5309d222d8ea298bd59c72da14ea2d14e8e2caaad1e0a
| * | | | | | | | | | Fix VDBE coveragedrh2025-07-02
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | FossilOrigin-Name: ff593a16d61cc5c588d1737deb822abb90b1759475a4cabfcf608978b1191487
| * | | | | | | | | | Early exit if one of the inner loops of a 3-way or larger join is andrh2025-07-02
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | empty table. FossilOrigin-Name: eaad6ac707a5960d9518d4049b7b1759e7512727ce87be3c402408144bda0a97