aboutsummaryrefslogtreecommitdiff
path: root/src/window.c
Commit message (Expand)AuthorAge
* Detect when a UNIQUE or PRIMARY KEY on a WITHOUT ROWID table would needdrh2025-02-21
* Increase the maximum number of arguments on an SQL function to 1000 with thedrh2024-12-12
* Fix a problem with window functions min() and max() when used with a FILTER c...dan2024-11-14
* Refactor the SrcItem object so that information about subqueries is storeddrh2024-08-19
* Give unique names to fields in the SrcItem object, to facilitate analysis ofdrh2024-08-17
* Better optimize queries that use parameters in the LIMIT clause.drh2024-06-06
* Enhance the sqlite3ExprIsConstant() function so that it recognizesdrh2024-03-16
* Omit the new SQLITE_VALUE_SUBTYPE name. Stay with legacy SQLTIE_SUBTYPE.drh2023-11-09
* Make a distinction between functions that consume subtypes and functionsdrh2023-11-08
* Simplify the Expr compression logic slightly by adding the new EP_FullSizedrh2023-10-19
* Fix straggler misspellings and tidy the custom dictionary. Also include picku...larrybr2023-06-07
|\
* | Add a C-source spell-checking facility. make misspell (on Nix)larrybr2023-06-07
|/
* Fix a code-generator issue associated with very unusual use of windowdrh2023-04-13
* Do not assume that sub-queries that contain window functions are uncorrelated.dan2023-01-28
* If OP_Rewind has P2 of zero, that is an assertion that the table is neverdrh2023-01-11
* Rename the SELECTTRACE macro to TREETRACE, so that is corresponds to the newdrh2022-11-22
* Restore a VDBE coverage macro that is mistakenly deleted fordrh2022-07-26
* Small performance increase and size reduction by splitting out thedrh2022-07-25
* Omit the EP_MemToken flag that was made obsolete by [e1f1cfe7f4387b60], fordrh2022-07-22
* Organize the various flag bits of the ExprList_item object into a substructuredrh2022-05-02
* Fix a problem with using multiple SQLITE_SUBTYPE function as window functions...dan2022-04-20
* Stronger defenses against corrupt schemas in the ALTER TABLE logic.drh2022-03-10
* Prevent a NULL-pointer dereference when trying to parse a illegaldrh2022-03-10
* Refactor Window.pFunc into Window.pWFunc to disambiguate from other uses ofdrh2022-03-10
* Add ALWAYS() macros. Change some existing ALWAYS() into assert(). Otherdrh2022-01-24
* Ensure that the window function rewrite does not leave the parse treedrh2021-11-07
* Protect all accesses to the Expr.x union using nearby assert()s and branches.drh2021-10-07
* Protect all accesses to the FuncDef.u and Expr.u unions using nearbydrh2021-10-07
* Add const to parameters on various internal interfaces.drh2021-09-25
* Add assert() statements to refute drh2021-09-13
* Attempt to omit ORDER BY clauses from FROM-clause subqueries if those ORDER BYdrh2021-07-15
* Fix a problem handling ORDER BY terms of the form "ORDER BY likely(<integer>)...dan2021-06-23
* Take care that the code is not generated for the same Select object moredrh2021-05-26
* Allow aggregate sub-selects within ORDER BY and PARTITION BY clauses of windo...dan2021-05-19
* Detect misuse of aggregate functions in the ORDER BY clause of a querydrh2021-05-07
* Adjust a VDBE coverage macros due to the enhancement at [506333742103c1f4].drh2021-04-28
* Make window range queries more robust against corrupt database files.drh2021-04-24
* Restructure a loop in window.c to avoid hitting an assert() following an OOM....dan2021-04-06
* Earlier detection of OOM errors during window function processing.drh2021-04-06
* Earlier detection and handling of OOM problems.drh2021-04-06
* Do not allow floating point rounding errors to cause a window function xInver...dan2021-04-05
* Improved robustness to OOM conditions in the window function logic.drh2021-04-03
* Ensure that negative numbers may not be used in frame offset clauses even if ...dan2021-03-31
* Ensure the correct collation sequence is used for comparisons when delimiting...dan2021-03-06
* Allow WHERE terms to be pushed down into sub-queries that contain window func...dan2021-02-22
* Fix harmless compiler warnings that surface in newer versions of GCC.drh2020-08-10
* Fix a problem causing queries containing window functions to ignore collation...dan2020-07-13
* Remove unnecessary code from the window functions implementation.drh2020-07-10
* Extend the refactoring into extensions. Clean up stray newlines.drh2020-06-19
* Provide the ability to use the SELECTTRACE() debugging macro outside of thedrh2020-06-11