aboutsummaryrefslogtreecommitdiff
path: root/src
Commit message (Collapse)AuthorAge
* Ensure pointer map entries are always added when a row that does use overflowdrh2017-06-08
| | | | | | pages replaces one that does not in an auto-vacuum database. Fix for [fda22108]. FossilOrigin-Name: 9478106ca963e3ae5cfe59da40301c5a0a07494d03e656b5eb10ab45e441b870
* The SQLITE_EXTRA_IFNULLROW compile-time option causes OP_IfNullRow opcodesdrh2017-05-25
| | | | | | | to be issued for references to the right-hand side table of *any* flattened join, not just LEFT JOINs. This puts extra stress on the OP_IfNUllRow opcodes for testing purposes. FossilOrigin-Name: 1a074c8a2bc0b28918ef905339d11a21d30101b4ea8c06c8b3faca7d17237538
* The TK_IF_NULL_ROW expression node must be treated as a variable thatdrh2017-05-25
| | | | | | references the table Expr.iTable. Proposed fix for ticket [7fde638e94287d2c]. FossilOrigin-Name: b30a364a12d9865242b1444984cd25ee126dc69108d5c6a2d4b35df184437fe9
* Disable the LEFT JOIN flattening optimization for aggregate queries, as itdrh2017-05-23
| | | | | does not currently work. Further fix for ticket [cad1ab4cb7b0fc344]. FossilOrigin-Name: 05ada741554b9fd00befcf7b4083637f53de68699ae5210ac18e0773ad1a9910
* Ensure that the expression rewriter inside the query flattener decends intodrh2017-05-23
| | | | | | the substructure of the TK_IF_NULL_ROW operator. This is a continuation of the fix for ticket [cad1ab4cb7b0fc344]. FossilOrigin-Name: 28d2902d8f4dfbbfc610f271e00d353b0baae386b56b482f96b88836410be129
* Remove a surplus semicolon, which was harmless on gcc and clang but causeddrh2017-05-23
| | | | | compile-time errors on msvc. This only comes up using the encryption extension. FossilOrigin-Name: 4510d55d1e2e23d4a4470dbd414161beec2ceefb7537fd66ea3c347e11624dfc
* When flattening a query, make sure iTable attribute of TK_IF_NULL_ROWdrh2017-05-23
| | | | | | operators (that result from a prior flattening of a LEFT JOIN) are updated correctly. Fix for ticket [cad1ab4cb7b0fc344]. FossilOrigin-Name: 919d36e6ea112c8c94f01e02611c48e78c441657e6898a466cfc39f1e0001403
* Prevent a possible NULL pointer dereference in the OP_Found opcode thatdrh2017-05-19
| | | | | can follow an OOM error. Problem found by OSS-Fuzz. FossilOrigin-Name: 50ad60ded54aa22dfdf519ed5da6451de790e22a972ff299f7976fbdce7a0579
* Fix the build so that it works again with SQLITE_OMIT_SUBQUERY.drh2017-05-15
| | | FossilOrigin-Name: bb0d9281588b8cc24bf2f1f10d0c56277004226adaa2ce5037782503b283b45d
* Negative N values in sqlite3_get_auxdata() and sqlite3_set_auxdata() can bedrh2017-05-11
| | | | | | used to access an auxiliary data cache over all functions in a single prepared statement. FossilOrigin-Name: ff5306752e83e760255a10f20168c0f090929a4fee2a5f720dfab36f0ee72fae
* New requirements marks and documentation for the authorizer.drh2017-05-11
| | | FossilOrigin-Name: 3980ea0911b3ad3f86d7a7bdc6503f233315c274f473e18831e13eda2c238eeb
* Improvements to the sqlite3_set_authorizer() documentation.drh2017-05-11
| | | FossilOrigin-Name: 47629b1911e52445aad8ea969137bddf0019c55b4a4f0de8e77decb6a434c8a2
* Change the SQLITE_READ authorization call for unreferenced tables to usedrh2017-05-11
| | | | | | an empty string for the column name, as this is less likely to impact legacy authorization callbacks that assume column names are always non-NULL. FossilOrigin-Name: 4139953ab528f20fa346409810edcb22adb6c1edc9d22f40b1b077ef842a2441
* Rename fields of the internal AuxData object to make them unique and easierdrh2017-05-10
| | | | | to search for. FossilOrigin-Name: 2be9850cef6492e168243807c34af72119ffbe414027a12c4eda6c421b5b950d
* Improved documentation for the SQLITE_READ authorizer callback. No code changes.drh2017-05-10
| | | FossilOrigin-Name: 92c5ea7047323d10f762877c5f56d20a3e609e8b55efcfe4880ef3048821ac1f
* Invoke the SQLITE_READ authorizer callback with a NULL column name for anydrh2017-05-10
| | | | | table referenced by a query but from when no columns are extracted. FossilOrigin-Name: 92ab1f7257d2866c69eaaf4cf85990677b911ef425e9c5a36a96978cccfb551c
* Do not invoke codec macros for in-memory subjournals.drh2017-05-10
| | | FossilOrigin-Name: d2bb0066f7c8413ef9992e6b07641cdf40ad260778074bd83cc22dcaba87860b
* Do not invoke codec macros when reading or writing an in-memory sub-journal.dan2017-05-08
| | | FossilOrigin-Name: 2c145ee6c9e7916f022331453384cbe61ee3654c08a1b88467f85235b5bc18c4
* Fix an obscure assertion fault that can follow an OOM. The problemdrh2017-05-06
| | | | | was introduced by check-in [a1cf44763277b6c7]. FossilOrigin-Name: 04e7e5650efffdce759b46999beb67c250af6cf394a7779ab861f210a84c134d
* Fix requirements marks and harmless compiler warnings.drh2017-05-06
| | | FossilOrigin-Name: 198ff4c01d86d193a54745764d69376cab8e94747a4daa444690f7e1ec87800b
* Fix a collision of the "B0" identifier name between the termios.h headerdrh2017-05-04
| | | | | file and the SHA3 implementation in the shell. FossilOrigin-Name: b9a58daca80a815e87e541cb5fff9bc8b93f131d223f322c5b83dd5a5f0c0312
* Remove the unused "sqlite3_stack_used" TCL command from the test harness.drh2017-05-03
| | | FossilOrigin-Name: e24b73820cdca07eee87853fe6dd9f60d76e039eeb4aebef03654db3c7c94f14
* Fix the sqlite3GetInt32() function so that it correctly returns 0 on adrh2017-05-03
| | | | | zero-length input string. FossilOrigin-Name: 05eba9e3a5f9bb2a40af1dacd885e1915fbcd20b9af4cf0eed79ac16dbeba31b
* Always enable URI filenames when compiling with SQLITE_HAS_CODEC. Also allowdrh2017-05-03
| | | | | plaintext keys using the key= query parameter. FossilOrigin-Name: 31a51b4d168065fa59cc0e52ba798bd87ac82160c675bd531442b65133edb401
* Reuse the same materialization of a view when that view appears in a querydrh2017-05-02
|\ | | | | | | | | more than once, such as in a self-join. FossilOrigin-Name: 9e35c89dbe744312f612e507b51ff9a5bb656def75392d25bc19fc638548cd1e
| * Futher bug fixes to the function that determines when a materialized viewdrh2017-05-01
| | | | | | | | | | can be reused. FossilOrigin-Name: c64fe3a1695925693385d313e9ad2a1d8cb37ddaa8cc19920ae0978c91bc4c2c
| * Minor bug fixes and performance enhancement.drh2017-05-01
| | | | | | FossilOrigin-Name: b2aae559581d05e4e8caaddfbd137cb275d582e82d58872c6f42e462dc859b1c
| * Initial implementation of an optimization that attempts to reuse the samedrh2017-05-01
| | | | | | | | | | materialization of a view on a self-join of the view. FossilOrigin-Name: 478c34b9a8b5127d13024e10307aa832f160b89720c46424dd17555bd36f590d
* | Move terms of the HAVING clause that reference only columns in the GROUP BYdrh2017-05-02
|\ \ | | | | | | | | | | | | clause over to the WHERE clause, resulting in a faster query plan. FossilOrigin-Name: 47cbb471d056c8e1834a5ca72491404a3bfb273b5ff7bdd84b98d263938ea874
| * | Additional comments on the sqlite3ExprIsConstantOrGroupBy() routine. Nodrh2017-05-02
| | | | | | | | | | | | | | | code changes. FossilOrigin-Name: 8424492eac506866d2918e5fe03c8f65fef960215d56012a3b52ed42789ed35a
| * | Remove an unnecessary branch.drh2017-05-01
| | | | | | | | | FossilOrigin-Name: a33179596f534067a58d68b77160f11ab13272b29f912d7cbe15ea00bbf03ade
| * | Automatically transfer terms from the HAVING clause to the WHERE clause of andan2017-04-29
| | | | | | | | | | | | | | | | | | aggregate query in cases where the result of evaluating the term depends only one one or more of the GROUP BY expressions (and on no other inputs). FossilOrigin-Name: 5375a3ce56f1d993b13b469fe33ec7679948f53940f62a15ddbaeb8aaa26a22c
* | | Fix typo in comment. No changes to code.mistachkin2017-05-02
| | | | | | | | | FossilOrigin-Name: 6674814afb9e763e7f7060776586e26da28040b3208ce06c8a285dd647e5a53d
* | | Enhance "PRAGMA integrity_check" to detect duplicate rowids within a leafdan2017-05-01
| | | | | | | | | | | | | | | page. FossilOrigin-Name: adcad37b001d255299be716b16003b56ec1fba349ef73261ee0e543186c4f311
* | | Clear the BTCF_ValidNKey flag set if a cursor is moved bydan2017-05-01
| |/ |/| | | | | | | sqlite3BtreeInsert(). Fix for [f68dc596c4]. FossilOrigin-Name: a6727eef6d757a39ad23e5c8cbe960f5d909e5d37cb4e90bc3bdbb8bf58cd6f8
* | Add a single testcase() macro to the subquery processing logic.drh2017-04-29
| | | | | | FossilOrigin-Name: 4e1df76e3d85922648e0e1cce73a266c3b1ed4511ace259ec0a01d7693af9e6f
* | Improvements to opcode documentation in the bytecode engine.drh2017-04-29
|/ | | | | No changes to code. FossilOrigin-Name: e54c9f8db5b2fa8ea82c6eab7482255431af16901f7992c9667b56a0e50a9f4f
* Minor size and performance improvements to the push-down optimization.drh2017-04-29
| | | FossilOrigin-Name: 91dfb61a1a25763bb0b5c1e353a9d584bc6de3f6eb445f54202ffe7f6fee6e8d
* Within a loop that uses a non-covering index test, test non-indexed terms thatdan2017-04-28
| | | | | can be tested without seeking the main table cursor before those that cannot. FossilOrigin-Name: afe68f0a8060dc5c92cb1fb32a9f22bd36140cd2c0bb5b6cea853e169c5ed444
* When building an ephemeral table of integers, do not assume that the tabledan2017-04-24
| | | | | | does not already contain N if the insert cursor points to N-1. Fix for ticket [61fe9745]. FossilOrigin-Name: 1c1b0862236f564283be08338790d6494e705f1198547a59499e3f8c07f2cd99
* Fix an assertion fault found by OSSFuzz.drh2017-04-22
| | | FossilOrigin-Name: e39769f442ea86273f8fb7bd2f249b7d760b2fe4bf9ec191ff91def8231f3f35
* Remove a NEVER macro for a condition that may be true as of [a47efb7c].dan2017-04-21
| | | | | Problem reported by OSSFuzz. FossilOrigin-Name: bdc50d8d127266d02b291f6bfcd4e35eb07994ce23987d6e3921124cd881929a
* Improved optimizations of views as the right operand of a LEFT JOIN.drh2017-04-18
|\ | | | | FossilOrigin-Name: 41c27bc0ff1d3135cdb6273ede4595f5bb0c0e1e1d470ea1633cb525674cf431
| * Add the TK_IF_NULL_ROW opcode to deal with non-NULL result columns in thedrh2017-04-14
| | | | | | | | | | result set of a view or subquery on the RHS of a LEFT JOIN that gets flattened. FossilOrigin-Name: 3a5860d86fadcf924316707918bf283d26c53b1473e5e67f5cff59d18c2a7742
| * An initial attempt to optimize VIEWs that occur as the right operand of adrh2017-04-14
| | | | | | | | | | | | | | LEFT JOIN. This particular check-in does not work correctly because it does not deal with the case of columns in the VIEW that return non-NULL even when all columns in the table of the VIEW are NULL because of the LEFT JOIN. FossilOrigin-Name: 1838a59c8a1c151bd6fc822b0ffef661803cf0e4704c917e74a04567b81740b9
* | Defer checking for null in the comparison operators, since that is andrh2017-04-17
| | | | | | | | | | uncommon case. FossilOrigin-Name: 5684525613961fed9db6a4d10dbe25521201b24f08e011df3a20ac895316957d
* | Do not allow a Mem object to be both NULL and some other type at the same time.drh2017-04-17
| | | | | | FossilOrigin-Name: e698db1956bb3aba32cd3ec633ec20f5d19b1a10bc68d3772903bca3c87ee158
* | Consolidate two branches of code in the "PRAGMA foreign_key_check"dan2017-04-17
| | | | | | | | | | implementation. FossilOrigin-Name: 69f51f838abcf57b35e41f7a10fbb45f56536f93825aac865debc3c8315930be
* | Fix a problem in "PRAGMA foreign_key_check" in handling a WITHOUT ROWID childdan2017-04-17
| | | | | | | | | | | | | | | | table with an INTEGER PRIMARY KEY parent key. Also, if an FK violation is detected in a WITHOUT ROWID child table, do not try to read and return the rowid. The third column returned by "PRAGMA foreign_key_check" in this case (WITHOUT ROWID child table) is now always set to NULL. FossilOrigin-Name: 690870bd7b2e607b7992c4496c9f08c29eb72a36af002c606fd7aa3dcf94a2a4
* | Fix the ".column" output mode in the command-line shell so that it correctlydrh2017-04-17
| | | | | | | | | | counts and formats multi-byte UTF characters. FossilOrigin-Name: f508aff8d1782abdff4d03726ae098607a0ee6cfd2e35b130097ee5043e98960
generated by cgit v1.2.3 (git 2.25.1) at 2025-07-20 21:08:15 +0000