aboutsummaryrefslogtreecommitdiff
path: root/src
Commit message (Collapse)AuthorAge
...
* | The check-in at [198b3e33dcfd74c7] caused a performance regression for somedrh2023-03-11
| | | | | | | | | | | | queries, which is here fixed. Problem reported by [forum:/forumpost/b405033490fa56d9|forum post b405033490fa56d9]. FossilOrigin-Name: dc9f025dc43cb8008e7d8d644175d8b2d084e602a1513803c40c513d1e99fea4
* | CLI help to reflect no-more-options optionlarrybr2023-03-11
|/ | | FossilOrigin-Name: 30d95a12eb8b1cfc8ed11d3ed68cd713993ba34efa2fe623c18cfe41f14df1d9
* Fix a typo in a comment. No code changes.drh2023-03-10
| | | FossilOrigin-Name: 76acc075402aac2d14d8279b8095008a842522a0985fdf89200da4339757a40b
* Give CLI a no-more-options option. (--)larrybr2023-03-10
| | | FossilOrigin-Name: 0822788752621f6bf6af44b420b594ddd352634b3b0ed0eb835abea34b45817a
* Fix a possible NULL pointer dereference due to the sqlite3_interrupt()drh2023-03-08
| | | | | | enhancement at [bd8fa10e59f58886]. Reported by [forum:/forumpost/f5a2b1db87|forum post f5a2b1db87]. FossilOrigin-Name: 84417bbd144b2197c9930a520feb94b59053957c190be79f8deaaaebca68ecf1
* Backout the OP_MakeRecord optimization as it does not work.drh2023-03-08
| | | FossilOrigin-Name: 25017312d0d476d9cd5a39835748ee26c2ea482e163264ce2f9843ac627276d6
* Small performance improvement in the OP_MakeRecord opcode.drh2023-03-08
| | | FossilOrigin-Name: ca89daef0fcf6cb04aa6fa90dd333d6f2474bf3f458c833d9cd5bd8e59f2a04a
* Change to [44135d6ea84f7ba6] that retains the historical datatype ("INT", ↵drh2023-03-08
|\ | | | | | | | | not "NUM") for a table created as follows: "CREATE TABLE t1 AS SELECT CAST(123 AS INT) AS value;". The use of FLEXNUM only occurs on compound queries. FossilOrigin-Name: 6d5b5896261c62a7e130b47416ee8c25793859a2afcb1646c257600537a5b71b
| * A proposed change to [44135d6ea84f7ba6] that retains thedrh2023-03-07
| | | | | | | | | | | | historical datatype ("INT", not "NUM") for a table created as follows: "<tt>CREATE TABLE t1 AS SELECT CAST(123 AS INT) AS value;</tt>". FossilOrigin-Name: a0e54fe2058a4ac1e794b2491e424c60dfa42c6781b1cfd83c5db65c28c11c71
* | Fix a problem in the count-of-view optimization that can lead to incorrectdrh2023-03-08
| | | | | | | | | | bytecode. dbsqlfuzz 23d782160b71c3f8f535ccb2da313dfc8eb8c631. FossilOrigin-Name: f45009533a79a59b302598ee2545ef787c51d0128f4e1dca60dd83589f660619
* | Fix a bug introduced 4 days ago by [e95439119ac200cb]: do not set thedrh2023-03-07
|/ | | | | | | Expr.affExpr field of a generated column expression if the expression is a RAISE() function, as affExpr has a different meaning for RAISE. [forum:/forumpost/b312e075b5|Forum post b312e075b5]. FossilOrigin-Name: 1096b5a7cc8104db01f8820ace47020baad2f12e6711e3a7b4514ed1becc7b66
* Cause CLI to fail noisily when deserialize option used for non-seekable "file".larrybr2023-03-06
| | | FossilOrigin-Name: 24bd7e82471925987d924188ce0f80ed4f282b10ea1022e42881a7f529814eb9
* Add SQLITE_DBCONFIG_REVERSE_SCANORDER for direct C-language access to thedrh2023-03-06
| | | | | "PRAGMA reverse_unordered_selects" setting. FossilOrigin-Name: 83e84531b46814aea6dad1ce8283cb9f6b90ad52badb60b875ea8f66e4ac0925
* Fix to check-in [b9190d3da70c4171] - the agg-with-indexed-expr optimizationdrh2023-03-04
| | | | | | | | | requested by ticket [99378177930f87bd] - that can cause an incorrect answer if an aggregate subquery has a GROUP BY clause, and that GROUP BY contains a term that is not in the result set, and the outer query makes use of expression indexes. Problem reported by [forum:/forumpost/a68313d054|forum post a68313d054]. FossilOrigin-Name: e06973876993926fd56181281d04b8dd504c689abf883fa21a5721cc1d478ea8
* Show the output value from OP_AggFinal when doing byte-code tracing.drh2023-03-04
| | | FossilOrigin-Name: 35f10a06ba81b8a526249729828fff06214e9cf95de418a9081f19d8d69fd657
* Make the SQLITE_DBCONFIG_STMT_SCANSTATUS option on by default.dan2023-03-03
| | | FossilOrigin-Name: 5a09191186bc03b374e0c0d029e1a15208c6b845bc2f5f5f9f6a8a882809d9f3
* Fix a vdbe-coverage macro added by [f418bdd627e84e7d].drh2023-03-03
| | | FossilOrigin-Name: 77f559d2647615379fed55ced5d69ae90515273e59811b92171bdd3089c90a22
* Follow-up to [e95439119ac200cb] to fix a case where a pointer is NULL due todrh2023-03-03
| | | | | OOM. FossilOrigin-Name: 2535bc8c256a7642a6ac00ebfd3393beb93da94394c13b886c3ddd20d114aa3c
* Enhance PRAGMA integrity_check so that it can detect when there are extradrh2023-03-03
| | | | | | | bytes at the end of an index record, which might cause OP_IdxRowid to malfunction. dbsqlfuzz c1aa3986534d5feab8d21f28b3c1712df2ef358ba. Test case in TH3. FossilOrigin-Name: f418bdd627e84e7d494f730d7124d8f4846ebcde031f5b2498685c9aceebb3c8
* When it is known when preparing a statement that X cannot be NULL, transform ↵dan2023-03-03
| | | | | the expression (X IS NULL) to integer value 1 instead of 'true'. This is because under some circumstances, "Y IS TRUE" may not be equivalent to "Y IS 1". FossilOrigin-Name: cc4bb05b3653e9502b95ea6fe0bfb77feebc11285b66e1dde4c7b945928efbf1
* Do not use an expression index on a generated column if generated columndrh2023-03-03
| | | | | has the wrong affinity. dbsqlfuzz 65f5eb57f8859344d5f1f33e08c77ee12960ed83 FossilOrigin-Name: e95439119ac200cb47d0e277622f41ee7986b364487cd252b485ce5fa030d70f
* Remove unnecessary call to sqlite3_dbdata_init() from shell.c.in.dan2023-03-03
| | | FossilOrigin-Name: c4d083a3aeeee69342d41b93a1393855871b0e4e7bfdb5fcc2973138018f248b
* When flattening the right operand of a LEFT JOINdrh2023-03-02
| | | | | | | | (check-in [41c27bc0ff1d3135]), ensure that the OP_IfNullRow opcode does not NULL-out a subquery result that was computed within OP_Once. This fixes the problem problem reported by [forum:/forumpost/402f05296d|forum post 402f05296d]. FossilOrigin-Name: 8fe13f7a5e5eb798189acb25a608df7a94c2f5cc83463331a048b779c7890c82
* When flattening a view that is the right operand of a LEFT JOIN, usingdrh2023-03-01
| | | | | | | | | the optimization of check-in [41c27bc0ff1d3135], always insert the TK_IF_NULL_ROW expression nodes, even for TK_COLUMN expressions, as the TK_COLUMN might be a column from an outer query and hence still need to be NULLed out. This fixes the problem described by [forum:/forumpost/26387ea7ef|forum post 26387ea7ef]. FossilOrigin-Name: 198b3e33dcfd74c7ba6abcf789ee81dfed464a50ebf15c8edeff349d36789fca
* Follow-up to [bbaf1f2eb1e1637b]: Make sure subtypes do not cross a subquerydrh2023-03-01
| | | | | | | boundary even if the function that returned the value with a subtype is buried down inside a larger expression. This fixes a problem identified by [forum:/forumpost/37dd14a538|forum post 37dd14a538]. FossilOrigin-Name: e72661eb680ea707a839cb3d5cf6c7ef03706e7b40af1b84760147e59cd61a50
* Do not attempt to apply the count-of-view optimization to a CTE.drh2023-03-01
| | | | | dbsqlfuzz ef8623915d843b150c159166ee4548c78cc6895a FossilOrigin-Name: abc3a383636c0346053b5d09d96585f56c64cacb5751673ea3bf339e4955d1cd
* Change the name of SQLITE_DBCONFIG_STMT_SCANSTATS to ↵dan2023-02-28
| | | | | SQLITE_DBCONFIG_STMT_SCANSTATUS. FossilOrigin-Name: a63e4a150b505fc309fac847131009ee9965eb1b798ebcb202ec8b52f9189240
* Add an sqlite3_db_config() option - SQLITE_DBCONFIG_STMT_SCANSTATS - for ↵dan2023-02-28
| | | | | enabling and disabling the collection of sqlite3_stmt_scanstats() statistics in SQLITE_ENABLE_STMT_SCANSTATUS builds. Collection of statistics is disabled by default. FossilOrigin-Name: 0f5579bef27b84ee855065cfe87703c51e1f9773906a9e0d4e4dafc90bd0e553
* Only use a Bloom filter on an automatic index if one or more of the keydrh2023-02-28
| | | | | columns in the index can take on non-TEXT values. FossilOrigin-Name: 5916705c731604d2e6b51a307cc8d7b67f4c102062bfdfcbc716a2916e0b0d86
* In the Bloom filter optimization, hash all strings and blobs into the samedrh2023-02-28
| | | | | | | | | value, because we do not know if two different strings might compare equal even if they have different byte sequences, due to collating functions. Formerly, the hash of a string or blob was just its length. This could all be improved. Fix for the issue reported by [forum:/forumpost/0846211821|forum post 0846211821]. FossilOrigin-Name: 090304b870419acb5b05205a07fc75830b556928149f76a843cda526f77a6fc0
* When an automatic index creates a Bloom filter, show that in thedrh2023-02-28
| | | | | EXPLAIN QUERY PLAN output. FossilOrigin-Name: d7b2ac1c1a31fa4285cf6df0995db7e7705bb6a1bc94850c14c94cc4e3eb239a
* Performance optimization in the varint decoder for the cell parser.drh2023-02-28
| | | FossilOrigin-Name: b2b91c7cb40f1efe800059614e34823411016a3ece3f988e1574aecadd4c3114
* Improve the error message generated by the recovery extension if it is used ↵dan2023-02-28
| | | | | with a non-SQLITE_ENABLE_DBPAGE_VTAB build. FossilOrigin-Name: c1f2a1d55c180fb51a4e203befbbe529bdd23137b26190c50b8f85820450e7fa
* Minor performance optimization in the computation of an affinity stringdrh2023-02-27
| | | | | for an index. FossilOrigin-Name: 07334aa17b6ded27c5bd353998d96645a94cdcf32440abb59d127a002cd98ce9
* Further to [46639f682975dac6], the parameters of a table valued function thatdrh2023-02-27
| | | | | | is on the left side of a RIGHT JOIN do not need to be in the ON clause. Add new test cases and tags to associated test cases with the code. FossilOrigin-Name: 18ee689de3d1ae43b05ca52e0b62c49442ebf68a88814a7c679e8856250a4b0d
* When a table-valued function appears as the right table of a RIGHT JOIN,drh2023-02-26
| | | | | | | | the argument constraints on the table-valued function should be considered part of the ON clause of the RIGHT JOIN. Fix for the problem reported by [forum:/forumpost/422e635f3beafbf6|forum post 422e635f3beafbf6]. Test cases in TH3. Possibly related to the enhancement at [501609eddf2a46d5]. FossilOrigin-Name: 46639f682975dac6efec4e230aca2c9b127b4fc77e0b465fad38ef4caa9b7a4c
* In the [/info/7c2d3406000dc8ac|omit-unused-subquery-columns optimization], bedrh2023-02-26
| | | | | | sure to remove the EP_Skip and EP_Unlikely flags from the result set expressions that get nulled-out. dbsqlfuzz bf1d3ed6e0e0dd8766027797d43db40c776d2b15. FossilOrigin-Name: 21aec65e5e2a01e58dd0bb8c8b9b29b8414373b53353fc7ca80a152fdd27566b
* Split out a new variant of cellSizePtr() that applies only to leaf pages,drh2023-02-25
| | | | | for a small performance increase. FossilOrigin-Name: 22d32eef8741ae4f2aac3869465e5a7d2e33c6bc2425dd8e77f2a746e43687e8
* Remove an unnecessary and redundant corruption checks in defragmentPage().drh2023-02-25
| | | FossilOrigin-Name: 2dc7342e12e9dac2d8345d045a17caa29c26eaf6f417dd052c7c645eddd6c58c
* Revert (mostly) to earlier CLI response to -echo and SQL at the command line.larrybr2023-02-25
| | | FossilOrigin-Name: 1c6cfcf6ed5e084e5eb6874a261f3670ab5fb3e5dbcf150f37c58b2f16351ee3
* Performance optimization on sqlite3_vsnprintf().drh2023-02-25
| | | FossilOrigin-Name: 4430e6e96dbf3d0b464776c132838dd3e456716e0ae5972fc7e0ece13b56ea25
* Add the "on" option to the ".log" command in the CLI. Allow ".log on" anddrh2023-02-24
| | | | | ".log off" even in --safe mode. Enable the .log command for fiddle builds. FossilOrigin-Name: 6bba9100ae81466eeb49845c449cbfddf4f82f18b89f55e6ef575cbf66af63af
* In the CLI, do not emit warnings about the incorrect usage of sqlite3_config()drh2023-02-24
| | | | | in Fiddle. FossilOrigin-Name: 847021b402a3e624e22959a70e3e29a4f069c2005534485779cdc018722b5863
* Modify the sqlite3_config() interface so that the SQLITE_CONFIG_LOG anddrh2023-02-24
|\ | | | | | | | | | | SQLITE_CONFIG_PCACHE_HDRSZ opcodes can be called after sqlite3_initialize(). Enhancement request [0b75886e6d48f7c2]. FossilOrigin-Name: 7902fb806b33a27932f9ca347246f4ac43091caad0a1536009985b650fd720e2
| * Back out the SQLITE_CONFIG_URI option from anytime-config.drh2023-02-24
| | | | | | FossilOrigin-Name: 0de98b8e21e4cbf2438160651585ea23ebea952c5a4e7d88e5eabe5cc49517b2
| * Merge enhancements from trunk into the anytime-config branch.drh2023-02-24
| |\ | | | | | | FossilOrigin-Name: 04b2fdf3bc986cd402e8a6c060e1b3989e60770695e2f8a4bc12c43e380a694c
| * | Allow the sqlite3_config() interface to be invoked at any time for a fewdrh2023-02-23
| | | | | | | | | | | | | | | | | | choosen options: SQLITE_CONFIG_LOG, SQLITE_CONFIG_URI, and SQLITE_CONFIG_PCACHE_HDRSZ. This list will likely change before release. FossilOrigin-Name: e1702eb48d13c7c9b7605f1e77242672222c53059edcdc4e9cea59510715822a
* | | Add the "number_of_cores" TCL command to the testfixture.drh2023-02-24
| |/ |/| | | FossilOrigin-Name: 16ee5a7b5d02cad51a35d5675fcc5bb50a62d1f243bde107fc89fed44ffd6a43
* | Fix an incorrect optimization that was attempted as part ofdrh2023-02-24
| | | | | | | | | | check-in [18de3a8e6b431a07]. FossilOrigin-Name: f32055e8110a2eac6c9e26d1d1e620f0668bcb475d49d309dc549cea05e1e582
* | Omit unnecessary branches from the enhanced floating-point conversiondrh2023-02-23
| | | | | | | | | | logic. FossilOrigin-Name: 32b0ba0d27481d85a4b0037ec36befcbffecdec75891eba58569acb160045553
generated by cgit v1.2.3 (git 2.25.1) at 2025-07-21 08:56:24 +0000