aboutsummaryrefslogtreecommitdiff
path: root/src
Commit message (Collapse)AuthorAge
...
* | Fix a harmless typo in a comment.drh2025-02-06
| | | | | | FossilOrigin-Name: ed82272904deb37640286448e03153316f828c629547a615a504af1d7ec5a278
* | Attempted improvements to the SQLITE_DBCONFIG_... documentation.drh2025-02-05
| | | | | | FossilOrigin-Name: baac853871ad307b67b4d624b9ee47fc1313f1aa62c9f8072fb49e97aa33db94
* | Detect and report signed integer overflow in the sumInverse() routine,drh2025-02-04
| | | | | | | | | | used by window functions. FossilOrigin-Name: 317e9a470fba2a4b717b9cb66488b8fccb44810a80f3a7deaf1ea81906e2b8d2
* | The Parse.addrExplain field is never even if SQLITE_OMIT_EXPLAIN is defined.drh2025-02-03
| | | | | | FossilOrigin-Name: 5d81a984c6aabb9fa9180efde8ca942b40f1ec18ff5a89f2fbb1252734f051d3
* | Fix a comment typo - in a comment used to generate documentation.drh2025-02-01
| | | | | | FossilOrigin-Name: b8de75eeded79a8312218d7a543e7c7d11181c9f4004e875495608d11a81ff38
* | Remove an ALWAYS() added by [2567298f4b0fdfeb] because dbsqlfuzz found a waydrh2025-02-01
| | | | | | | | | | to reach it. The test case was added to TH3. FossilOrigin-Name: d08a7aa8987458a91fcb861d58289e622ba8722936c7874a284f9f2fd782e269
* | Fix an issue with sqlite3_normalized_sql() caused by changes needed todrh2025-02-01
| | | | | | | | | | support SQLITE_DBCONFIG_ENABLE_COMMENT. FossilOrigin-Name: 79d287a39443f2d098fcc24199627555a656b34aa5bf5d484f91cb513d83e143
* | Tweaks to [4b4f33d791fe4318] to make it easier to test.drh2025-01-31
| | | | | | FossilOrigin-Name: 2567298f4b0fdfeb42aa6bba7e0bec3bc8d0b89bf644a79b41893dd6a6c5774c
* | Remove an assert() that is not true if a trace-callback is deregistered ↵dan2025-01-31
| | | | | | | | | | while there are active statements. FossilOrigin-Name: 0ecfc4d0ebdb272a69f8f98ddb069c7e0735fb899804027eb16f241d83b3d046
* | Fix a problem with LIKE and GLOB processing in utf-16be databases in cases ↵dan2025-01-31
| | | | | | | | | | where the utf-8 encoding of a character ends with the byte 0xBF. FossilOrigin-Name: 4b4f33d791fe4318c4597bee7d2f9e486ed223e731982af470f5cc0dbdc600fc
* | If any errors occur while processing sqlite_dbpage changes, canceldrh2025-01-31
| | | | | | | | | | pending truncate operations. FossilOrigin-Name: 6138e0dc4e0e4e19cb048fe0cd969156151fdc427eee21188d2a822642aad043
* | Improvements to the SQLITE_DBCONFIG option documentation.drh2025-01-31
| | | | | | FossilOrigin-Name: 59f0ba10062a6ccfd56061a16af3436b9e1b9d23378bff3302bcf33bb3137cb9
* | Add the SQLITE_DBCONFIG_ENABLE_COMMENTS setting (default on) to enable ordrh2025-01-31
| | | | | | | | | | disable the ability to include comments in SQL input text. FossilOrigin-Name: 393749a2e22d5c8eba36e2106a35909420aa6316652d1ab4f18ef699247b6fba
* | Merge all the latest trunk changes into the extra-security branch.drh2025-01-31
|\ \ | | | | | | FossilOrigin-Name: 86ba57561a8d8c14e401c06b2345a9417053aa3a5f0c84e52460f23f5e6aa8d0
| * | The reuse-subroutine optimization [c9a3498113074bbc] might have generateddrh2025-01-30
| | | | | | | | | | | | | | | byte-code that loops forever. This check-in fixes the problem. FossilOrigin-Name: 0cc4ed8c6e53aca1f5e94c132bedbc7f561c04a77f1a30b965ffe7560634bfeb
| * | Remove an unused parameter from an internal-use subroutine in the TCL interface.drh2025-01-30
| | | | | | | | | FossilOrigin-Name: a700692b39e24f5ca9ea6f879d413e20c2ad2b85f62c867407dafe111f13d931
| * | Improvements to the TCL interface for Tcl9 as suggested by Jan Nijtmans.drh2025-01-30
| | | | | | | | | FossilOrigin-Name: d76c5db866de2732b68401a4c3e39acddc7a99bed965160c1796477c062b478a
| * | Enhance the if() and iif() SQL functions so that they support anydrh2025-01-28
| | | | | | | | | | | | | | | | | | number of arguments greater than or equal to two. Suggested by [forum:/forumpost/40f7867f75f80|forum post 40f7867f75f80]. FossilOrigin-Name: fb76d184ee5afc41009c4023bb68b3ddd42c9235a79ec9695c26f5bbe9a1aa25
| * | Fix sessions module handling of tables with generated columns.dan2025-01-28
| | | | | | | | | FossilOrigin-Name: 437fb316389bc3c24c5cdb4d01edfc81e2c2e9f2b399fc2a95b05d279361d8ec
| * | Simplifh the IdList object to remove unnecessary fields. Performancedrh2025-01-28
| | | | | | | | | | | | | | | increases by about 0.8%. FossilOrigin-Name: a4625bb995dd5582d1f3cf0c2e54eb3f01f1cc1405811dda86ebd38b2b858994
| * | Remove an ALWAYS() in the star-query heuristic that is sometimes false if youdrh2025-01-28
| | | | | | | | | | | | | | | | | | have a corrupt database. dbsqlfuzz c37ba7728d79859b79c8341b59297e88fba017d3. Test case in TH3. FossilOrigin-Name: 6b9a339628eb8bfb6dfbee02000a6ac91cc8a9ae16bd990e62c4142b9f912c36
| * | Use hashing to accelerate column matching on INSERT statements. Code isdrh2025-01-27
| | | | | | | | | | | | | | | smaller and about 1.8% faster overall according to test/speedtest.tcl. FossilOrigin-Name: 8be956383e0344fb613ec2e56fce7b518f439ae34bf9ddb424de2bd9b31c9889
| * | Avoid splitting a hyperlink across lines in the documentation comment fordrh2025-01-27
| | | | | | | | | | | | | | | sqlite3_serialize(). FossilOrigin-Name: 74b770bd445d98ff883000ab2e31603d729e415e4e4f640646eef30825634f48
| * | Further comment improvements in the star-query heuristic. Add an ALWAYS()drh2025-01-26
| | | | | | | | | | | | | | | on an unreachable branch to achieve MC/DC. FossilOrigin-Name: 5e18ce68fbc5e73e6694936f3ba71f5b5e3758cf380951805ca6ea6a3f0943aa
| * | Small size and complexity reduction on the star-query heuristic. Improveddrh2025-01-26
| | | | | | | | | | | | | | | comments for the star-query heuristic. FossilOrigin-Name: a7ecb2f4b7eee78b88f1b2e026dffed2007ca4ffeb152632624ab2582839b250
| * | Revise the strategy used by the star-query heuristic: Instead of decreasingdrh2025-01-25
| | | | | | | | | | | | | | | | | | the cost of all fact-table WhereLoops, increase the run-cost of WhereLoops that are SCANs of dimension tables. FossilOrigin-Name: 1bc09c9e8bd77ac41ecbe510c7e003757fc11d0f586da6cdf3584315aa9d6407
| * | Improvments to debug output on the star-query heuristic.drh2025-01-25
| | | | | | | | | FossilOrigin-Name: b3ebeb0682a2c837987acf4ed92f06cf91aea235830c5a0f9dd1ce64afe16e84
| * | Avoid calling computeMxChoice() after an OOM as some assert()s can faildrh2025-01-25
| | | | | | | | | | | | | | | in that routine if a prior OOM occurred while building the WhereLoop array. FossilOrigin-Name: 8b9e621dbf599d7e75e07d75d4c400247d693ea76e00eba0919f4e33e3e10bdd
| * | Remove an incorrect ALWAYS() added in check-in [7cfbe14d199bb631].drh2025-01-24
| | | | | | | | | FossilOrigin-Name: 431a1a29f93dc642779dc21c3a0edad5fcda1d175e9d1e3b216fa02c234fe774
| * | Clarify handling of a NULL for the 2nd argument to sqlite3_serialize(), as ↵stephan2025-01-24
| | | | | | | | | | | | | | | pointed out in [forum:3df7168b90|forum post 3df7168b90]. FossilOrigin-Name: 340edbe5540762656b648c18a359ab7039b4a0af15db199fc86317a415e2bafa
| * | The debugging output for WhereLoop objects now shows costdrh2025-01-24
| | | | | | | | | | | | | | | estimate changes due to the star-query heuristic. FossilOrigin-Name: a280f5f5480e560fc2b80e8947d8062e8b3487d930e71cb60fc9ba90d87977c1
| * | Minor tweaks to the star-query detection and processing.drh2025-01-24
| | | | | | | | | FossilOrigin-Name: 61f76a45ac7aa454419fd7539a3d8e60f0733fb5a2abd034d795328f3c1b6e9b
| * | When looking for star-queries, do not count a table as a dimension tabledrh2025-01-24
| | | | | | | | | | | | | | | | | | if that table is separated from the fact table by an OUTER or CROSS join or if the table is a self-join. FossilOrigin-Name: 5aebd7df0d577e98b3affd22b84b42dfe84a9f37fa29187505cc245b95460ba4
| * | Fix a possible infinity loop in debugging-printf logic in the query planner.drh2025-01-23
| | | | | | | | | | | | | | | No changes to production code. FossilOrigin-Name: 9a20b94080f5379867530772e081b737ae4cf6b416469dcabb85b8dd819f491f
* | | Add two new sqlite3_db_config() options that enable the ATTACH commanddrh2025-01-22
|/ / | | | | | | | | | | to create new database files and to open databases read/write. Both default to on for backwards compatibility. FossilOrigin-Name: fe0c58d00b491d1af7c0894f5c32542954aeea2e6510853b3bcbf13ac0bf5ce0
* | Fix date/time computations to deal with the sub-millisecond roundingdrh2025-01-21
| | | | | | | | | | problem identified in [forum:/forumpost/766a2c9231|forum post 766a2c9231]. FossilOrigin-Name: afb0a5923a6db4045fab5226198aab970d746d4866294ebba943c6986e97ecde
* | Performance improvements to the (debug-use only) Mem.pScopyFrom logic, resultingdrh2025-01-21
| | | | | | | | | | | | | | in about 8x faster performance under -DSQLITE_DEBUG for the query in from [forum:/forumpost/0025389d0860af82|forum post 0025389d0860af82]. This change only affects builds that use -DSQLITE_DEBUG. FossilOrigin-Name: 7fb1ae25d1572dd7709a0f850c148a5f745a524f01ea231e29a1ebc37c173fb9
* | The FuncDev.nArg field values -3 and -4 now have special meansing of 1 or moredrh2025-01-21
| | | | | | | | | | | | | | or 2 or more arguments, respectively. This saves space in the built-in function table, resulting in slightly faster performance and a reduced binary size. FossilOrigin-Name: 753fd747f24c5e9a019eb00b8a4f66e65c6733ba10a7adbd1b55786867c32ca6
* | Use Tcl_GetString() instead of Tcl_GetCharLength() to test for a zero-lengthdrh2025-01-21
| | | | | | | | | | string in the TCL interface, since that is much more efficient. FossilOrigin-Name: a8d9dcfd23fbfcd887e451382836c1e88215984cc01e00be11387dbf4ab26fd8
* | Remove an assert() in the unix file locking logic that is not truedrh2025-01-20
| | | | | | | | | | if alternative VFS "unix-excl" is used for a read-only connection. FossilOrigin-Name: bd5dc92368e41231a07bb59dd3db8942e238129ec7a3c8d785459d9b62bfcba3
* | Fix an assert() that could fail if a virtual table called sqlite3_step() ↵dan2025-01-20
| | | | | | | | | | from within the xSync() method while committing a "PRAGMA defer_foreign_keys=1" transaction. FossilOrigin-Name: 39bdbb3f6dd1d30d180526d35c11f789f5e9d45b99ead72fd4a3b136afab66b1
* | Add an SQLITE_TESTCTRL_OPTIMIZATION mask that can disable the query plannerdrh2025-01-19
| | | | | | | | | | heuristics that are designed to help with star queries. FossilOrigin-Name: fec4ff185a2f3f1bee8f27432206276636cf27365d2d41cd7282f8c0425f2e96
* | Add a simple test case (many more are coming soon to TH3). Fix an obsoletedrh2025-01-18
| | | | | | | | | | assert(). FossilOrigin-Name: aa829a131a3431791083cf60d9cf00e7b3c0fafdd39a23e761b629a2287ab875
* | Add support for automatic query-time indexes on WITHOUT ROWID tables.drh2025-01-18
| | | | | | FossilOrigin-Name: 89c4cbd9529081941d7283a401c4a8d71b241f4577ebf6d3eb2ebe5a1cf92f2e
* | For the purpose of the query planner heuristic added by [38db9b5c83], a querydrh2025-01-17
| | | | | | | | | | | | | | | | | | | | should only count as a star query if the fact tables are connected to the dimension table by an INNER JOIN. If a LEFT JOIN is used, then the fact tables are constrained to be in inner loops anyhow and so the heuristic does not make any sense. But it does interfere with AUTOMATIC index creation, which causes the performance regression reported by [forum:/forumpost/d87570a145599033|forum post d87570a1455]. FossilOrigin-Name: 0852c57ee2768224af79910e6f26e70a4962651dae0f8b45cbfc847e6707d7bb
* | When two indexes have the same cost, use the narrower one (the one with thedrh2025-01-16
|\ \ | | | | | | | | | | | | smaller average on-disk row width). FossilOrigin-Name: 398559678f2b9a65b245ed73b4d512c4fccc69d42b5a6a1c1b7755a80b69d073
| * | When choosing between two indexes with the same cost, pick the one with thedrh2025-01-15
| | | | | | | | | | | | | | | smaller predicted number of bytes per row. FossilOrigin-Name: d4bd0d4214551f88f248698fefc821575b722ce5c194d0b3796f572e4704f641
* | | Check-in [da9124fee28c155c] broken the new SQLITE_IOCAP_SUBPAGE_READ mechanismdrh2025-01-15
|/ / | | | | | | | | for inhibiting direct-overflow-read. This check-in fixes the problem. FossilOrigin-Name: 113078d555eaf740666680562ebbb04f7d823b72e8b2d553627e54ab3d7bf653
* | Variable names and conditional logic simplified in where.c. Thesedrh2025-01-15
| | | | | | | | | | changes are cosmetic only and do not affect the resuling machine code. FossilOrigin-Name: dbc2d6a244fdafd208239894dbdd8f139db6ca20dd8f1ed00d87028e0cb60570
* | Remove a stray tab character from a comment.drh2025-01-13
| | | | | | FossilOrigin-Name: 315079b150b47e013e2cde4985bc39d24e0f6f6c6e60f9383fb8ea4ea897c67a
generated by cgit v1.2.3 (git 2.25.1) at 2025-06-02 02:55:10 +0000