aboutsummaryrefslogtreecommitdiff
path: root/src
Commit message (Collapse)AuthorAge
...
| * Remove an ALWAYS() from a condition that can be true.drh2024-03-25
| | | | | | FossilOrigin-Name: 715fcf033a6c0c64fa3076d58be8c39246aebef922c1a44a31831b40e165015e
| * Fix an inaccuracy in automatic indexes that was exposed by the fixdrh2024-03-25
| | | | | | | | | | at [80c4223098c1827f]. FossilOrigin-Name: fdc9406f1c8ba4a7341c1e408f6042ddc788cf65f98e1de2ee101390bfb0abae
| * Use the SQLITE_CONSTRAINT return value from xBestIndex to prohibit baddrh2024-03-25
| | | | | | | | | | query plans in the pragma virtual table. FossilOrigin-Name: b1259d4448f744861e416f42328c1450854370e5c77102d2a5abe5cf6c7f12bd
| * Flag sqlite3_trace() and sqlite3_profile() as deprecated so that the doc ↵stephan2024-03-25
| | | | | | | | | | generator for funclist.html sees them as such, and add 'Deprecated' to their page's title for consistency with other deprecated APIs. Comment changes only. Addresses [forum:0901025836|forum post 0901025836]. FossilOrigin-Name: 87c54f93f5711739741ed0ff3c1a6fe24ffc8a025b43523bf78c1f6be8c1b4cd
| * Fix the xBestIndex method of the pragma virtual table so that it correctlydrh2024-03-24
| | | | | | | | | | | | | | gives a higher cost to plans where the schema hidden parameter is unconstrained. Fix for the problem reported by [forum:/forumpost/85b6a8b6705fb77a|forum post 85b6a8b6705fb77a]. FossilOrigin-Name: bc516ff5202ee6e9834266bf755fe26e30ac557dcc7975ca7a06dfe33874fcd2
| * Improved "wheretrace" debugging output for calls to xBestIndex. No changesdrh2024-03-24
| | | | | | | | | | to release code. FossilOrigin-Name: 33966bb06ce9a8e90734de59a8d43c523f60870d20be64789638da4c84a8b81b
| * Do not automatically assume that ROWID is NOT NULL when compiled withdrh2024-03-24
| | | | | | | | | | | | SQLITE_ALLOW_ROWID_IN_VIEW. dbsqlfuzz 31b38eeb63a4e1562de665078f52b7b47a7543cf FossilOrigin-Name: 80c4223098c1827ff3a564f1f9a4203164a943e9a83eef99df68378fa3c4764b
| * Fix an adverse interaction between CREATE TABLE AS and the newdrh2024-03-23
| | | | | | | | | | | | [/info/a120c9235f125e05|VALUES-as-coroutine] optimization. dbsqlfuzz c2c5e7e08b7e489d270a26d895077a03f678c33b FossilOrigin-Name: 84b6fdea0bf07c73df0ca8ef110db066164a5f34606e6c069a060476e04ef44e
| * Fix incorrect boundary assert()s on the new OP_IfSizeBetween opcode.drh2024-03-22
| | | | | | FossilOrigin-Name: 8eda4797c573382cbb989a4ab4b1f19d8fd538dbc9818d86a9aa6189cfa90f37
| * Have os_unix.c reuse cached file-descriptors in the case when a read-write ↵dan2024-03-21
| | | | | | | | | | fd is requested on a read-only file and a read-only fd returned. FossilOrigin-Name: a678e85402af08c1e387bf30ff2205f84dd7da749755da565d70f831c007a3d9
| * Fix all test cases so that they work with SQLITE_ALLOW_ROWID_IN_VIEW.drh2024-03-21
| | | | | | FossilOrigin-Name: 66c69e2f20f7692e0f34743ae97b09c4d8d11b874cdc5381795f2d1e0410f724
| * Change EXPLAIN QUERY PLAN output to say "USE TEMP B-TREE FOR LAST TERM OF ↵dan2024-03-20
| | | | | | | | | | ORDER BY", or "LAST N TERMS OF ORDER BY", instead of "RIGHT PART OF ORDER BY". FossilOrigin-Name: cd547c500442f3f58c05d6da8a67c3238560c5204ea62ec14afa844cc8fb94f0
| * Fix the SQLITE_ALLOW_ROWID_IN_VIEW bug-compatibility option so that it worksdrh2024-03-20
| |\ | | | | | | | | | | | | | | | | | | again. Add the SQLITE_CONFIG_ROWID_IN_VIEW sqlite3_config() value to optionally disable the bug-compatibility mode at start-time. Enable testing of SQLITE_ALLOW_ROWID_IN_VIEW. FossilOrigin-Name: b6802565df0f63286a7ef26c92d3ed817895f244920a24909cd855090fdfa08c
| | * Fix a typo in a comment.drh2024-03-20
| | | | | | | | | FossilOrigin-Name: 54680d0fbec1f0575ac4be6dca866971795dab2c42b02a492d5cd485f46d153f
| | * Fix typos in the SQLITE_CONFIG_ROWID_IN_VIEW documentation.drh2024-03-20
| | | | | | | | | FossilOrigin-Name: 1ad1ca498296493c8e89cda911cc153baa51c90ae6c19961841e6b4e37302a23
| | * Change the SQLITE_CONFIG_NO_ROWID_IN_VIEW configuration option to bedrh2024-03-19
| | | | | | | | | | | | | | | | | | | | | just SQLITE_CONFIG_ROWID_IN_VIEW (without the "_NO_" in the middle) and give it the ability to turn the option on and off. Otherwise, it is difficult to test. FossilOrigin-Name: 5d412edc2e378999ad798d1d7d73c7f7a17ee4e3c751a0dd00b9d5ce32759550
| | * Return the error "ambiguous column name: rowid", instead of "no such column: ↵drh2024-03-19
| | |\ | | | | | | | | | | | | | | | | rowid", when a "rowid" reference is ambiguous. FossilOrigin-Name: 0615bdae2dfc70c7e0416a28e89ffde31fa44ed4b3dac46e5ef20eed0d89e58c
| | | * Return the error "ambiguous column name: rowid", instead of "no such column: ↵dan2024-03-19
| | | | | | | | | | | | | | | | | | | | rowid", when a "rowid" reference is ambiguous. FossilOrigin-Name: 021f34fcfed41b607be8169bbda59aef93f130108d944f4741b46e8e345b2bbb
| | * | Add the --no-rowid-in-view option to the --help output of the CLI.drh2024-03-19
| | | | | | | | | | | | FossilOrigin-Name: 134da9c348a5e3b5cef97b79f37d48257afd4fa958a84f6930ac9874284a14cd
| | * | In the name resolver when SQLITE_ALLOW_ROWID_IN_INDEX is enabled, if theredrh2024-03-19
| | | | | | | | | | | | | | | | | | | | | | | | are multiple views that might resolve to the "rowid" but only one real table, then use that one real table and ignore the views. FossilOrigin-Name: 8fcea4cdfc89dd78eca5e7f62aa31aff0e296f41e79349d3af1cc3a2bc4d77c6
| | * | Update tests to work with SQLITE_ALLOW_ROWID_IN_VIEW.dan2024-03-19
| | | | | | | | | | | | FossilOrigin-Name: 495b8c7b08b998ddfe2ad055703f058c768e7e94014952e5cd8a81c7c1515cb1
| | * | Improvements to the first check-in on this branch, causing less collateraldrh2024-03-19
| | | | | | | | | | | | | | | | | | | | damage. FossilOrigin-Name: 7bc882897b6910f93695ad372445df7791b096412089ccbcd4fde365c62fa074
| | * | On second thought, change SQLITE_TESTCTRL_ROWID_IN_VIEW into a start-timedrh2024-03-19
| | | | | | | | | | | | | | | | | | | | option SQLITE_CONFIG_NO_ROWID_IN_VIEW. FossilOrigin-Name: b8e045c9e1d098d116f8745704b10ed76569d4b063c0b81cce16bc136930755d
| | * | When compiled with SQLITE_ALLOW_ROWID_IN_VIEW, rowid-in-view is on by defaultdrh2024-03-19
| | | | | | | | | | | | | | | | | | | | | | | | but can now be turned off using SQLITE_TESTCTRL_ROWID_IN_VIEW. Without the compile-time option, rowid-in-view is always off. FossilOrigin-Name: 8a6196ab29052071be753c5c77ac945c2d62ecc8019c6160f954eafe34ab05a8
| | * | First steps toward getting -DSQLITE_ALLOW_ROWID_IN_VIEW to work again. Thatdrh2024-03-19
| | | | | | | | | | | | | | | | | | | | | | | | | | | | compile-time option is untested, undocumented, and unsupported. But it was mentioned in the release notes for version 3.36.0, so I think that means we need to support it forever. FossilOrigin-Name: 7c46ff640247584f1ea260c062de29a0e49f649d1894a526574c1a479006a1fc
| * | | Make sure the new u1.nRow value is copied when making a copy of a SrcItemdrh2024-03-19
| | |/ | |/| | | | | | | | | | object. This fixes a problem in [ac6f095e13e43d66] from yesterady. FossilOrigin-Name: 262f8f9d80d37160e4126634b99aa48fce2073e61f6365e8bdbe1cc4fa560a96
| * | Fix another problem from [c63e26e705f5e967] involving infinities and thedrh2024-03-19
| |/ | | | | | | | | | | Kahan-Babushka-Neumaier summation algorithm. Problem reported by [forum:/forumpost/23b8688ef4|forum post 23b8688ef4]. FossilOrigin-Name: 45d272ef38d5ee6189f81369aefb8e3ac35868a67687012d93c84f2bbc42520a
| * Fix harmless compiler (scan-build) warnings.drh2024-03-18
| | | | | | FossilOrigin-Name: c86f9f2a15ffc726b7f0d9bba5a8c4dfdaeea6a297e0b591c554fff3d1fe6e1c
| * Allow the VALUES-as-coroutine optimization to be applied to later rows ofdrh2024-03-18
| | | | | | | | | | a VALUES clause even if earlier rows do not qualify. FossilOrigin-Name: 9a47ea7f0f675f7bf4710901487ce34c7689e618cd1d8b9f94f0ff7ebc3f2841
| * Add assert() statements to validate access to the SrcItem.u1.nRow union member.drh2024-03-18
| | | | | | FossilOrigin-Name: 21f616d9b948efca441f8d45d0a95f4c052ce8b6daec7fa582ad9a00b82ca570
| * Fix the patch at [10ee6fcba08ab128] so that it works on reduced-size Exprdrh2024-03-18
| | | | | | | | | | nodes. FossilOrigin-Name: 260bd764c3f2d6d067adb9cd0045b7c24d5e00b02ab2735b1cba455a6143ff4c
| * Improvements to EXPLAIN QUERY PLAN output for multi-row VALUES claues.drh2024-03-18
| | | | | | FossilOrigin-Name: ac6f095e13e43d66c06552c8b01f6bec3407c9d41a34c4cdb0be57b0b828ad0d
| * Ensure the database schema has been loaded and the database encoding gleaned ↵dan2024-03-18
| | | | | | | | | | before beginning to code a multi-row VALUES clause. FossilOrigin-Name: 2ff476eb3d1f4a2146f4a48b57895a00a3ff5beb29afa679ae53ea58cac07c76
| * Fix a problem caused by a non-aggregate function with an OVER clause in a ↵dan2024-03-18
| | | | | | | | | | multi-row VALUES clause. FossilOrigin-Name: 10ee6fcba08ab1281235197602148fe062560e1d5034a477b8e7b574dd3e2907
| * Omit the "noop(X)" test SQL function. Accomplish the same thing usingdrh2024-03-17
| | | | | | | | | | the idiom: "coalesce(X,random())". FossilOrigin-Name: 0eb2fbb8910e7a372c50db3ae44238d7b161f0e45858b74061b5228aec5fcc7e
| * Add an ALWAYS on an unreachable branch.drh2024-03-17
| | | | | | FossilOrigin-Name: 0dce6211690210e802545cbca9b3375e07075e117fad3f8c921879da7671d981
| * A formerly impossible case has now become possible because of the newdrh2024-03-16
| | | | | | | | | | ExprIsConstant enhancements. So deal with that. FossilOrigin-Name: 9ba3cff9d48fe8fc8a0a51291169599209d464465e44bdfd60058fd1e314a2b1
| * Further expand the scope of usage for the enhacement to expr-is-constant.drh2024-03-16
| | | | | | FossilOrigin-Name: d7eadcf7dd089f0f4aa963c58f0df32edd951368c9906375fd62b0a61cd393b8
| * Assert that the eCode is always non-zero upon entry into exprNodeIsConstant().drh2024-03-16
| | | | | | FossilOrigin-Name: f71b28f6713126745bca53e098dfe3444d4235d6a2b87ced5b333a7f0ee79be8
| * Activate the enhanced constant-expression for thedrh2024-03-16
| | | | | | | | | | [constant propagation optimization](/info/f4229707ac08d66c). FossilOrigin-Name: 92afea38881a1a4f266c79ddc6e1027cf17c288dcc8f7e7d50466899ac0054c4
| * Extend the scope expr-is-constant for function to cover the IN-to-EQdrh2024-03-16
| | | | | | | | | | optimization. FossilOrigin-Name: dae669245c86021bcd28716aff6e316257cc8075d02081745d4b7de17f8ad553
| * Fix exprNodeIsConstantFunction() so that it returns WRC_Continue, not ↵dan2024-03-16
| | | | | | | | | | WRC_Abort, if the function really is constant. FossilOrigin-Name: d85dd4de2d0989127e0ae6a2eec9d83a577777f8d5ba40700084a0b498016634
| * Enhance the sqlite3ExprIsConstant() function so that it recognizesdrh2024-03-16
| | | | | | | | | | | | constant functions. So far the enhancement only applies to the multi-row VALUES clause, but it could possibly be applied in many other places. FossilOrigin-Name: c9e0488c6c0135932b6e76b0f3f3acd69ef65327e0a54daa59777f35da1aef26
| * Fix a problem with ALTER TABLE and correlated multi-row VALUES clauses.dan2024-03-14
| | | | | | FossilOrigin-Name: d543c829ef74dbd64105bd757ca660e4f02e9ce562be4f1688a701fa535351c4
| * Fix a problem handling "INSERT INTO ... SELECT ... UNION VALUES(...), (...)" ↵dan2024-03-14
| | | | | | | | | | and similar statements. FossilOrigin-Name: e8a2a8198a97046ff376bc5d38e4bc0a24fcac79f5a0dadb9d29d953a862a012
| * Avoid some OP_SCopy instructions in "INSERT INTO .. VALUES" statements that ↵dan2024-03-14
| | | | | | | | | | insert more than one row in cases where the VALUES clause contains a value for all columns of the table. FossilOrigin-Name: 988f0ea70cd21b3194011e0cd1ddd4990a07669e0fd9c37afa48f69698ab7212
| * Change the way parse.y handles multi-row VALUES clauses to save a few cycles.dan2024-03-13
| | | | | | FossilOrigin-Name: 88d5bc91a52675d2a83748b79ad50de0e9732b2afd23107627bdc604f744d275
| * Remove unreachable code from this branch.dan2024-03-13
| | | | | | FossilOrigin-Name: 657c7b4f9df53e041a33cfad00ee2f507ac09c97a2ae61164bd189d660d167da
| * Fix some OOM handling problems on this branch.dan2024-03-13
| | | | | | FossilOrigin-Name: 2085c7f12a3916ec883c31795e29f2e2b6641c30ecf748cce9bff7b13b061d1f
| * Ensure that if a multi-row VALUES cannot be coded while being parsed, the ↵dan2024-03-13
| | | | | | | | | | SF_MultiValue flag is correctly set. FossilOrigin-Name: 94791824a6f04782aac6bc16c182685e2d6ebf5c688dc9f8d59e479c6fd5a40e