aboutsummaryrefslogtreecommitdiff
path: root/src
Commit message (Collapse)AuthorAge
...
| | * More frequently send the complete SELECT statement into sqlite3WhereBegin()drh2022-10-22
| | | | | | | | | | | | | | | so that it can more accurately determine index coverage. FossilOrigin-Name: f6d09c5a0df940dbaa716df70df28218985b83540b34c468989729a3421ef38c
| | * Enhance the query planner with the ability to discern when an index isdrh2022-10-22
| | | | | | | | | | | | | | | covering even when it indexes columns well beyond the 63rd column. FossilOrigin-Name: 1390417be45dd84e9118f6e761f23b8ff7476d26411e165bbaab678881e4eadd
| | * This branch attempts to improve the detection of covering indexes. Thisdrh2022-10-22
| | | | | | | | | | | | | | | | | | | | | first check-in merely improves a parameter name to sqlite3WhereBegin() to be more descriptive of what it contains, and ensures that a subroutine is not inlines so that sqlite3WhereBegin() runs slightly faster. FossilOrigin-Name: cadf5f6bb1ce0492ef858ada476288e8057afd3609caa18b09c818d3845d7244
| * | Fix built-in documentation for the ".mode qbox" command in the CLI.drh2022-10-24
| |/ | | | | FossilOrigin-Name: 3d7ea33be1076fd21681bdcff0c489646c017594b42b4a21a74e9e2d3947890b
| * Clarification on the meaning of SrcList and SrcItem and especially thedrh2022-10-22
| | | | | | | | | | | | SrcItem.colUsed and Index.colNotIdxed fields. Comment changes only - no changes to code. FossilOrigin-Name: d96f6cc8475ae5509b8bff2db75e3c6f69a214d58d8979fbc0162ae488a040dc
| * Add SQLITE_DQS to the compileoptions_used list, per request in [forum post ↵stephan2022-10-21
| | | | | | | | | | 8b1060122b|forum:8b1060122b]. Force DQS=0 in sqlite3-wasm.c. FossilOrigin-Name: fcd9e0dbe3226f3f7ccc15b11fc3aa3b8058571bef274c25a33e9753e22f7551
| * Macro name typo fix in OS_KV builds.stephan2022-10-21
| | | | | | FossilOrigin-Name: 9cf1142b0cdb13347e3f551c862cb4714cadfe5ad637f049cf0a4b8bb6125b32
| * Add a bit to the optimization disabling mask for the indexed expressiondrh2022-10-20
| | | | | | | | | | optimization. FossilOrigin-Name: 56df1482ab45d4d41f937b27c5a877b52fa082bfc6809ea682b62b47a51333de
| * Only enable the bMaybeNullRow flag on IndexedExpr for an index on andrh2022-10-20
| | | | | | | | | | | | expression, not on a virtual column. But do enable it for the right operand of a right join. FossilOrigin-Name: a9657c87c53c19228a42559c82c54b504a5ad729e407e9e2c7dabcc0c949b261
| * The generalized indexed expression optimization of [2435112867fbd7b6] makesdrh2022-10-20
| | | | | | | | | | | | the prior [a47efb7c8520a011] enhancement from 2017 obsolete. This check-in removes the older optimization. FossilOrigin-Name: 56442c9bdd7844454c79acf83323380ea3509cb2e0b9a3d538a6b51726ae6d07
| * Fix minor problems in test1.c test code.dan2022-10-20
| | | | | | FossilOrigin-Name: 6e545e2b846795fc67f8a90c04de284861a8a429ac686a7476b41c8ed7aabf75
| * Rework sqlite3_wasm_vfs_unlink(), add sqlite3_wasm_db_vfs(), update some docs.stephan2022-10-20
| | | | | | FossilOrigin-Name: cdd46858f0e63bc7bfce8e339b3db9efdec43b6443ee76563a847f53d0176831
| * In the CLI, never use strcmp() or strncmp() directly. Instead usedrh2022-10-19
| | | | | | | | | | | | | | wrapper functions cli_strcmp() and cli_strncmp() that work correctly even if the input is a NULL pointer. [forum:/forumpost/142b868da7560d0b|Forum post 142b868da7560d0b]. FossilOrigin-Name: 7450a561f8577c3ee41f84074c6ef39e29e56876cab4fd763e6489c66f603223
| * Fix references to "SrcList_item" in comments as that object has sincedrh2022-10-19
| | | | | | | | | | | | [bfd5bf2c73110fcb] (2021-02-21) been called "SrcItem". Comment changes only. No changes to code. FossilOrigin-Name: e3648a07f5607dbd4d6ad5b6e5a62a4a1d0b173d3f22aa36c74b768281fc86d8
| * If a virtual column whose value is constant gets indexed, do not includedrh2022-10-18
| | | | | | | | | | | | that column in the IndexedExpr list. dbsqlfuzz 59ac17a99b9a5c4930ee71cc153c9428a0c0e794 FossilOrigin-Name: c21eb903f06a16d4fafa5f895be08414fa58e6a91c148030aec8676b40c2d66d
| * Improved byte-code comments for the OP_Column opcodes used by thedrh2022-10-18
| | | | | | | | | | indexed expression optimization. FossilOrigin-Name: bf6d837fddbf74d5b3f40ad01ea4564edfac00b651d6f3f0e996cc5dc18bb06c
| * Fix the indexed expression resolver for generated columns so that it picksdrh2022-10-18
| | | | | | | | | | the correct table in a self-join. FossilOrigin-Name: 54c3eb085aca92da2b819f3532ee4750b377265f7e1e914600ea3c3d535efe51
| * Merge recent trunk fixes into the index-expr-opt branch.drh2022-10-18
| |\ | | | | | | FossilOrigin-Name: 6198ab4b871c464448ae303072bde0a810cac566a516cc29b1bf806fbd0a6c7b
| | * Correct sort order for serial-type 10 entries in the database file. Thisdrh2022-10-18
| | | | | | | | | | | | | | | is a continuation of [4fb77e96fa89a23a]. FossilOrigin-Name: 904b54625d985e742888e06ba792cab316b9ec9d6669d9cf509bac48030373ca
| * | Merge trunk fixes into the index-expr-opt branch.drh2022-10-18
| |\| | | | | | | FossilOrigin-Name: c7b9cc645b394a1b638a9a13ca83d321215aaa78d69ca70c6baa0ee692ed21bf
| | * Fix sqlite3VdbeRecordCompareWithSkip() so that it sorts the internal-usedrh2022-10-18
| | | | | | | | | | | | | | | | | | serial-type of 10 together with NULLs. dbsqlfuzz 5ff35e9d49a5fcca5051e23960ff2f483a538bab FossilOrigin-Name: 4fb77e96fa89a23a9365320c4190834edd6c09cfaf1ca30b34ce19b747ebbec0
| * | Merge trunk changes into the index-expr-opt branch.drh2022-10-17
| |\| | | | | | | FossilOrigin-Name: a1485ce6c8374135290eb0a1e4eb4e225497ad7096847a4e2377c9c054946ca7
| | * Fix a potential call to strlen() with a null argument in the command-line shelldrh2022-10-17
| | | | | | | | | | | | | | | following an OOM error. [forum:/forumpost/9c4f2ebe22|forum post 9c4f2ebe22]. FossilOrigin-Name: b6413a6dff8ac9b7088b1381afbbbf799e376455d11786530cc5fc825747ab53
| * | Improved comments and function names. No logic changes.drh2022-10-17
| | | | | | | | | FossilOrigin-Name: 8f460b3b15bf4b88a224907d2f83e4ed6bf84d6b3f480008a1b187ea49c6ce1d
| * | Get the indexed expression optimization working for virtual generated columns.drh2022-10-17
| | | | | | | | | FossilOrigin-Name: 8a510cb0880349370ad19b0852f270ca072bff7871f0dc272964af31c32a7c37
| * | Merge trunk enhancements into index-expr-opt branch.drh2022-10-17
| |\| | | | | | | FossilOrigin-Name: 56ef97e64efb84176df570819474901d492209ff80ce4355ff896dea9d2b8a51
| | * Make use of alloca() in wherePathSolver() when SQLITE_USE_ALLOCA is defined.drh2022-10-17
| | | | | | | | | FossilOrigin-Name: 45752471521f8d4a6cad4bce40f907018acd403ffd3b8170020c34e4e0b6b91b
| | * Remove a use of alloca() that does more harm than good.drh2022-10-17
| | | | | | | | | FossilOrigin-Name: 2ab3cf4d71b23a4c0b69f977828d82df7bbc080c29ae189e0d78d38efee50c96
| * | Enable the index-on-expression optimization even when the expression isdrh2022-10-15
| | | | | | | | | | | | | | | used as an argument to an aggregate function. FossilOrigin-Name: 462b3c7f39724dc814f55e7a225e7d0c48f81c524cdda797a66e9e198c35ce58
| * | Only extract an expression from an index when the index is not a null rowdrh2022-10-15
| | | | | | | | | | | | | | | in an outer join. FossilOrigin-Name: 08b033c737d1a84859291f50e2985c9dad8d660a50185d55d3171165a8e08d4c
| * | Merge fixes from trunk.drh2022-10-14
| |\| | | | | | | FossilOrigin-Name: 1cb65f36c3539302767f551ed53082f054666a7cb2696cef0990ab6747edbc52
| * | Cancel IndexExpr objects when they go out of scope.drh2022-10-14
| | | | | | | | | FossilOrigin-Name: 0963519371bb7ac02adb323430855760fb9b82a23745e47c504aaf393d22ac34
| * | This experimental branch attempts to use columns for an index-on-expressiondrh2022-10-13
| | | | | | | | | | | | | | | | | | in place of the expression that is being indexed. This particular check-in mostly works, but there are still issues. FossilOrigin-Name: 2e8d4fd4cfd9e82f33c707ba246fe2bb3ca01762cf5ac5905058fbc7adf0abe7
* | | Move file /ext/misc/dbdata.c to the /ext/recover/ directory.dan2022-10-19
| | | | | | | | | FossilOrigin-Name: f6d5ac807efcf6140016a8b8f0c74566c0bfc98ad92bd8fca03c5cc80ebf3dec
* | | Merge latest trunk changes.dan2022-10-15
|\ \ \ | | |/ | |/| FossilOrigin-Name: 42255ead8e44b24a8abc04aca49f170c55f3b52f42366a0d8ef248ee65fcc7ce
| * | Fix a problem with using the push-down optimization on compound SELECTs ↵dan2022-10-14
| | | | | | | | | | | | | | | where component SELECTs use different collation sequences. dbsqlfuzz 11516f050100243e5a845f5a2b48a90ed2efaf2e. FossilOrigin-Name: ed14863dd72e35fa3a23320c3d5a8166515faea39a555c28a27b2d35e701eac4
| * | Add missing initializer from the extension loader. Fix for drh2022-10-14
| | | | | | | | | | | | | | | check-in [d6d449978245b4fa]. FossilOrigin-Name: 565d74c36f2dd4612860c7ee561682c50db28cfa5384346528292019dbfdf86c
| * | Fix a problem in the LIKE and GLOB operators that may occur when the ↵dan2022-10-14
| |/ | | | | | | | | character immediately following a "%" or "*" wildcard is U+80. Reported by [forum:61bf7ccbdf]. FossilOrigin-Name: 2da677c45b643482eec39e4db7079c772760bc966dc71bf6c01658cc468f5823
| * Optimize the IS NULL and IS NOT NULL operators so that they avoid loadingdrh2022-10-13
| |\ | | | | | | | | | | | | | | | large strings or blobs off of disk if all it needs to know is whether or not the string or blob is NULL. FossilOrigin-Name: cb94350185f555c333b628ee846c47bcc9df5f76bb82de569b8322f30dbbe1bc
| | * Improvements to the description of the OPFLAG_TYPEOFARG option to OP_Column.drh2022-10-13
| | | | | | | | | FossilOrigin-Name: 5e9c67ba18b701aabbb0546acdfc532c9e8f0d27fb0a2c899415a5c47096c90b
| | * Adjust the implementation of sqlite3VdbeTypeofColumn() to make it easierdrh2022-10-13
| | | | | | | | | | | | | | | to test (and slightly smaller). FossilOrigin-Name: 79fdd021df256c6a2b9973fd6bf8e52ffaaf4d369d40489b8395ac97880b1325
| | * Proposed optimization to the IS NULL and NOT NULL operators that avoidsdrh2022-10-13
| | | | | | | | | | | | | | | | | | loading the entire content of larges strings and BLOBs. Response to [forum:/info/3c08d4715dc05b00|forum post 3c08d4715dc05b00]. FossilOrigin-Name: 45f171565442f9fd6574fb93ae7abe83c168b20be68af42531bc55571450d3ab
| * | Fix a typo in the documentation of the OP_Column opcode.drh2022-10-13
| |/ | | | | | | | | [forum:/forumpost/a2b5bd6d43|Forum post a2b5bd6d43]. FossilOrigin-Name: 043e76e6166da5cf8e213cce46aaccb1f910e1fdbdb5556576eafb81b3bc5faa
| * Merge trunk into fiddle-opfs as a preliminary step for a clean merge in the ↵stephan2022-10-12
| |\ | | | | | | | | | | | | other direction. FossilOrigin-Name: 5e1848ce384a78fe5dfa1b5c1b2acb9c2fac34a8f0ba6c652e0541dcf24e9027
| | * Add the sqlite3_value_encoding() interface.drh2022-10-12
| | | | | | | | | FossilOrigin-Name: d6d449978245b4fa66c152132da468eea7977eab4d1fe53bb2fe3ef543d8030f
| | * Enhance the OP_IsType opcode so that it is slightly smaller and faster anddrh2022-10-11
| | | | | | | | | | | | | | | so that it works correctly with invalid serial-type codes 10 and 11. FossilOrigin-Name: 846f863e0d55eb7e78c8d355bbbcd73e1946d0ba566c2cb31683cde5f4353d1b
| | * Improved the ability of the CLI to handle very long input lines.drh2022-10-11
| | | | | | | | | | | | | | | | | | Potentially a fix for the bug reported by [forum:/forumpost/fa4bb2941a|forum post fa4bb2941a]. FossilOrigin-Name: d0e107ee00101f42b4c9bf372625311d04b83c96a4a9caacac866ea03d8e7fa4
| | * Code clean-up for the integrity_check enhancement.drh2022-10-10
| | | | | | | | | FossilOrigin-Name: a140173102febe9ef8064ee9b95bee489db54caba149e577d69e4d75161bf390
| | * Fix corner-case bugs in the new integrity_check logic. All tests pass now.drh2022-10-10
| | | | | | | | | FossilOrigin-Name: dbab9d52a842085da67f5d0b8e96c665adc16331accf380b4c234e9b05bdb7fb
| | * An attempt to enhance PRAGMA integrity check so that it does data typedrh2022-10-10
| | | | | | | | | | | | | | | | | | | | | checking on non-STRICT tables. Specifically: (1) Columns with TEXT affinity should not contain numeric values, and (2) columns with numeric affinity should not contain text values that can be converted to numeric. FossilOrigin-Name: 8b1e7f0524637728cebe81c7d3ff8ad8a5a55782eac6409b425dad538024f596
generated by cgit v1.2.3 (git 2.25.1) at 2025-07-19 09:28:02 +0000