aboutsummaryrefslogtreecommitdiff
path: root/src
Commit message (Collapse)AuthorAge
...
* Fix harmless compiler warnings.drh2024-09-06
| | | FossilOrigin-Name: 60fb8ee153ec293b6b3a4170dafa305e4c16af575aced72daef46116d8dc2bb6
* A testcase() macro added to help ensure that the fix to the omit-noop-joindrh2024-09-06
| | | | | optimization from yesterday does not regress. FossilOrigin-Name: 224628b1039b996499e0d806fc0215f175da6f1059eb1b9ac491ac11126971ab
* Ensure that the WhereInfo.revMask bitmap is adjusted when tables are removeddrh2024-09-05
| | | | | | | from the FROM clause by the Omit-Noop-Join optimization of [0cd82ee9a8413cf1]. Fix for the issue described by [forum:/forum/8a1e467e905b8d27|format post 8a1e467e905b8d27]. FossilOrigin-Name: 22ca5a2ffb89ccb5f337993b5a95e27c449c39014284156eabc33da012a8759c
* Fix a bug in the parsing of some corner-case JSON PATH strings that containdrh2024-09-04
| | | | | escaped double-quotes. FossilOrigin-Name: 60ac55c4b76355aaf7cbde38bf1f6082ff5612bf4ffc49ab69d00fd4e3d64e64
* Improved error messages on percentile functions. More tests cases fordrh2024-09-02
| | | | | percentile and for ordered-set aggregates. FossilOrigin-Name: e1bca168e70335fa2f9537632fd16e374c566a564fab4974c0b8f61cb63d08ce
* Change the name of the enabling compile-time macro todrh2024-09-02
| | | | | SQLITE_ENABLE_ORDERED_SET_AGGREGATES. FossilOrigin-Name: 3b1cdddf8339cc339ec74cd8be2bfa42e62b500048a444eb9e5d9817bc4702ae
* More internal documentation improvements.drh2024-09-01
| | | FossilOrigin-Name: 8b91b74931c36e1955ef933a07d8ec40c8b54c882efe7084d179168867c5244f
* The WITHIN GROUP (ORDER BY ...) syntax is now a compile-time option:drh2024-09-01
| | | | | | SQLITE_ENABLE_ORDERED_SET_FUNCS. There is no increment in the code size if the option is omitted. FossilOrigin-Name: c9367e2532d653738af27c4d92810eb648a9e12f72d7223017c87cb0dddc6804
* No prepare-time penality for ordered-set aggregates for applications thatdrh2024-09-01
| | | | | do not use them. FossilOrigin-Name: e070c16d2183312e416ff6af770346041e4d3836c4db2c9ea6049f63fb0eaa07
* Add error checking: Do not allow functions other than those in thedrh2024-08-31
| | | | | percentile extension to use the ordered-set aggregate notation. FossilOrigin-Name: 317d901429303340290334dbe7680a36339df0a50b586e3f71b6c5e5eba6d411
* Demonstration of how ordered-set aggregates might be parsed and integrateddrh2024-08-31
| | | | | into the existing parse tree, should we decide to support them. FossilOrigin-Name: ef9777890001ba0122d3add799795e118fd87243f42731ab84d4748b67605647
* Enhance the percentile() and median() extension functions so that they can bedrh2024-08-31
| | | | | window functions. FossilOrigin-Name: 4d0e3df4b9c609755977b8a462126242d2be1310c0122a8d4ba76d98d32a7230
* A couple of #defines so that the build work with SQLITE_OMIT_FLOATING_POINT.drh2024-08-30
| | | FossilOrigin-Name: be768f80c703ac1645251ccbac83e07b3ea4cc231c8ea7e66374a4f78361f10b
* Fix a case where the BTCF_AtLast flag was being left set incorrectly. This ↵dan2024-08-29
| | | | | was causing obscure window function queries to fail. FossilOrigin-Name: e042eb024738a83eed92cd2dfac3d2a50d2589715a3d81b1a494564dd7d8e7fa
* Do not allow sqlite3_blob_open() to work on a any table that containsdrh2024-08-28
| | | | | | | | generated columns, even columns of the table which are not generated themselves, because such columns might be part of the expression of a STORED column. This restriction could be relaxed some, but that would be a lot of code for something that nobody ever uses. FossilOrigin-Name: 6e84947123339f0ea2b7dabc6134a621eed09317f81647f15870ed50a0f7d1bc
* Merge all the latests trunk enhancements into the win-dupe-crt-fio branch.drh2024-08-27
|\ | | | | FossilOrigin-Name: 2d52db98f47fbcda0622c034b21c2fb19bf4345b88c5c565ae9e6f7128642e43
| * Randomize the name of the attached database used to do VACUUM.drh2024-08-26
| | | | | | FossilOrigin-Name: 0f4e65d73a2b95932f36768c0d9925a2d265d9b395b886d8e492d1d519b2093c
| * shell.c.in: use eputz/oputz() instead of eputf/oputf() where appropriate to ↵stephan2024-08-25
| | | | | | | | | | avoid compilation errors in -std=c99 mode (namely wasm builds). FossilOrigin-Name: 9ef8317faebc29d016bdf2e8c678fb21ca2cfa95272f1f18b461fcaf0e220ac5
| * Fix compiler warnings in the CLI detected by MSVC.drh2024-08-24
| | | | | | FossilOrigin-Name: 23ae505cbfde6dfd1dbb2216cf76c1e316b49f2ca84491a1aae28ad33f7777a9
| * Remove a term from an assert() that is no longer relevant.drh2024-08-24
| | | | | | FossilOrigin-Name: 8b4766252b80075354a6b1406c5430fe999a6490aa3e079893fcc682d88734f7
| * Avoid a stack overflow that could be caused by a recursively defined ↵dan2024-08-24
| | | | | | | | | | WINDOW() with a strategically embedded error. FossilOrigin-Name: bada54bd6bf54190e40aa721b77081015957d204c7b6a9fdbe8c67bcf20798f8
| * Ensure that the WhereLoop.u.btree.pOrderBy field added by thedrh2024-08-24
| | | | | | | | | | | | order-by-subquery optimization [7a0cdc7edb704a88] is correctly initialized. dbsqlfuzz 437be171a98687082a31ea6efc2fd5c5d64481c8. FossilOrigin-Name: b75f8b2252aefe7bb96fa237205a1a9dc88c46d9ec09bca7407e6c636b203e7e
| * Eliminate use of strcpy() in shell.c.in to squelch an unwarranted link-time ↵stephan2024-08-23
| | | | | | | | | | warning on OpenBSD. FossilOrigin-Name: 32e9bf7f972144eacbb2580151220bc4fc1cbcc8bcf586ffd8e10762abf75c7e
| * Add the SQLITE_INDEX_SCAN_HEX bit to the sqlite3_index_info.idxFlags bitmask.drh2024-08-22
| | | | | | | | | | | | When set, this bit causes the EXPLAIN QUERY PLAN output to show the idxNum value in hex rather than in decimal. This is purely a debugging aid. FossilOrigin-Name: 6c00e88ebdb41d6317bb8758825521614dedc2e6e6289ff415c5f0406eed815b
| * Add the new SQLITE_TESTCTRL_OPTGET that retrieves the current optimizationdrh2024-08-21
| | | | | | | | | | | | setting. Use this in the CLI to provide symbolic fine-grain control over optimization settings using the ".testctrl opt" dot-command. FossilOrigin-Name: 0ea4e1e8fc689cb1af3a8d21dd6af9d483115412b414e85e8a42480f50d65af2
| * Improved comments on byte-code subroutine calls to materialize subqueries.drh2024-08-21
| | | | | | | | | | Should not affect production builds. FossilOrigin-Name: 6b024c85ef856e26cddac8ad862e16909b5149c3e3efb4e73ba54c97291f1cc4
| * Add code comments for a "table-of-contents" and various milestone marks indrh2024-08-21
| | | | | | | | | | | | the 1300+ line long sqlite3Select() function, to help improve readiability and maintainability. Comment changes only - no functional changes. FossilOrigin-Name: 00cfbb9fa5136e6a7847da4e4ab30d320ca79c22acda9db2030e558d59b8c744
| * Fix a minor typo in a comment.drh2024-08-21
| | | | | | FossilOrigin-Name: 92c80af1129051c9eded8df170730ad6366b4f7715dead34c4364c8149d0dce9
| * Improvements to treetrace output for subqueries. Debug code only.drh2024-08-21
| | | | | | FossilOrigin-Name: 0a835d18d9063b17a1d506fd989ebcf7f0d76593978a3bd5981be59618335f21
| * De-duplicate some error-output code in shell.c.in as part of tracking down ↵stephan2024-08-21
| | | | | | | | | | the cause of [forum:5647ca2af1|forum post 5647ca2af1]. FossilOrigin-Name: fd5904495e0c775174f9380bc6877fb9def3d30dec1c9315979ad4503a18d70b
| * Remove incorrect assert() statements in the SrcItem invariant validator.drh2024-08-21
| | | | | | | | | | dbsqlfuzz 7f908865436ce531b0ace55c97a1c71d05c4e76c. FossilOrigin-Name: 81a1ede38823b8d50e221ecb6ce52a05d82a856099002a71d9f1ac561a587f05
| * Refactor the SrcItem object to move fields associated with subqueries outdrh2024-08-20
| |\ | | | | | | | | | | | | | | | into a separate object named Subquery. This reduces the size of the SrcItem object by about 1/3rd and provides improved performance. FossilOrigin-Name: 484bcd75bc95491d8540c791c1c4d40d996cb465839564662e14f98739699bf1
| | * Fix a name resolution issue with CTEs.drh2024-08-20
| | | | | | | | | FossilOrigin-Name: 4fa8235dd59cd683d6c6c97bfe181a9637be7c054d435323c903b9dbd74aff02
| | * Fix minor comment issues.drh2024-08-20
| | | | | | | | | FossilOrigin-Name: c1bbed19f4348ec31c3cb4723eaa8f1554bb58ef4de7feb3a0f39612785f13d5
| | * Remove unreachable code.drh2024-08-20
| | | | | | | | | FossilOrigin-Name: 17699329aa8e234c6793a38db5ca05def9395b287bcc8bc05493b824327edb59
| | * Tighter checking of access constraints on union members in SrcItem.drh2024-08-20
| | | | | | | | | | | | | | | Improved invariant checking. FossilOrigin-Name: fd72d3400a8fe5747f494eee81654698acee350bb95b9db269e87d857af03492
| | * Fix some stray SrcItem field name fixes.drh2024-08-20
| | | | | | | | | FossilOrigin-Name: bc5f5ce59e1e4323422bda7d002310923f927a03b4fd42749bf04f6c9853956b
| | * Fix a memory leak so that now all dev tests (including TH3) are passing.drh2024-08-20
| | | | | | | | | FossilOrigin-Name: 3995c45fff0e4bd10bcf49cc16eb1050216426723c63ba56d3ae5ba738c34019
| | * Memory issues fixes so that mdevtest now passes.drh2024-08-20
| | | | | | | | | FossilOrigin-Name: b249516f6a6650808e035ec219e762bf24dcb7c32a6235984b995d08d07d35d8
| | * Refactor the SrcItem object so that information about subqueries is storeddrh2024-08-19
| | | | | | | | | | | | | | | | | | | | | | | | | | | in a separately allocated Subquery object. This reduces the memory requirements for SrcItem and makes the code run faster. It also provides an expansion path for subquery processing that does not burden simple queries. The current checking mostly works, but there are still issues that need to be tracked down and fixed. FossilOrigin-Name: 8ff5dda8448d7e1a533d7f27db2573ce68fa9956b9d9847ced45e83c1f06bab0
| | * Give unique names to fields in the SrcItem object, to facilitate analysis ofdrh2024-08-17
| | | | | | | | | | | | | | | how those fields are used using "grep". FossilOrigin-Name: 9f5aeef3cbc2c95267c8f7bf60d5c66971a76789669fb0e8f853273ff6f616f2
| | * Reduce the size of the SrcItem object by combining fields into a union.drh2024-08-17
| | | | | | | | | FossilOrigin-Name: a4c59ac3c6ec979c25b544d29e47b8e39f6439c098eed8f84b3bd506c9adf047
| * | When the database encoding is UTF-16LE and the GLOB optimization is used,drh2024-08-20
| | | | | | | | | | | | | | | | | | it is ok to use the range search over an index, but it is not ok to disable the actual GLOB function call. FossilOrigin-Name: 3399698376761ab8c422f8ea02bfa2759afb606f08bedbd1cf7eee834229a9aa
| * | Fix for the UTF-16LE problem reporte bydrh2024-08-20
| | | | | | | | | | | | | | | | | | | | | | | | [forum:/forumpost/dc7e1b7527e84343|forum post dc7e1b7527e84343]. Because of the unexpected ordering of characters using the default collation (memcmp() order) in UTF-16LE, the LIKE/GLOB optimization restricts its attention to the pattern prefix that is all ASCII, which is the common case. FossilOrigin-Name: a5797ebdea423afc3d2d3bd8adaf1575d33a01f594c0c315afcb1499f1718e9b
| * | Earlier error detection while processing complex aggregatedrh2024-08-19
| | | | | | | | | | | | | | | queries. dbsqlfuzz 5242c2f07f4aa031aa3c80461f18e9b7619ede9b FossilOrigin-Name: 70f4973078ffc72f4ff247234e6f8e695b40803c3e7c9ed12050d97195728352
| * | Attempt to fix date/time calculations for days earlier than 0400-03-01.drh2024-08-19
| | | | | | | | | | | | | | | See [forum:/forumpost/eaa0a09786c6368b|forum thread eaa0a09786c6368b]. FossilOrigin-Name: 00cae11fffaf50e2133915e851d41098d00b6b1458e1438bcb6664e1411d8498
| * | Automatically disable directory fsync when compiling for AIX.drh2024-08-18
| |/ | | | | FossilOrigin-Name: 8d170e07e20c21a5bb97fdc8c2d01d92178f5fe740e60d203e4621747cfce33e
| * Fix a typo in an "ifdef" that broke SQLITE_OMIT_ANALYZE builds.dan2024-08-17
| | | | | | FossilOrigin-Name: c09da26cb6f772a18c595ff0eb55d8345a377c3ef5ed02a5e539ffdbe9d07f85
| * If a subquery has an ORDER BY clause and that ordering is helpfile indrh2024-08-16
| |\ | | | | | | | | | | | | | | | | | | satisfying the ORDER BY or GROUP BY of the outer query without doing an extra sort, then omit or reduce the sort in the outer query. Call this the "order-by-subquery optimization". FossilOrigin-Name: 7a0cdc7edb704a88a77b748cd28f6e00c49849cc2c1af838b95b34232ecc21f9
| | * Fix handling of COLLATE. Add test cases for the same. Code cleanup fordrh2024-08-16
| | | | | | | | | | | | | | | improved understandability and maintainability. FossilOrigin-Name: 41a41c173a9d15d94f23d73a5c04bfb1616cb9223bc81d41808f9b4d00817fbf
generated by cgit v1.2.3 (git 2.25.1) at 2025-05-24 18:58:49 +0000