Morph MORPH
SIGN IN SIGN UP
dhruvhead / sqlite UNCLAIMED
0 0 244 C

COMMITS

/ test/window1.test
autosetup
May 23, 2024
D
Fix the window-function group_concat() so that it returns an empty string
drh committed
e6d3c57
November 2, 2023
D
Fix a spurious "misuse of aggregate function" error that could occur when an aggregate function was used within the FROM clause of a sub-select of the select that owns the aggregate. e.g. "SELECT (SELECT x FROM (SELECT sum(t1.a) AS x)) FROM t1". [forum:/forumpost/c9970a37ed | Forum post c9970a37ed].
dan committed
5e4233a
October 20, 2023
D
Add string_agg(X,Y) as an alias for group_concat(X,Y), for compatibility
drh committed
d5e040b
May 23, 2023
D
When converting an aggregate expression to AGG_COLUMN, be sure to remove
drh committed
ddf6b27
April 13, 2023
D
Add extra test cases to window1.test.
dan committed
8efa288
D
Fix a code-generator issue associated with very unusual use of window
drh committed
017bdf7
April 11, 2023
D
Remove an ALWAYS() that can sometimes be false. Add a test case that makes
drh committed
82aacda
March 28, 2023
D
Fix a weird corner case in aggregate function processing that results from the
drh committed
e1be2b7
D
Fix multiple problems with RETURNING on a DML statement against a view,
drh committed
3cbf38c
March 3, 2023
D
When it is known when preparing a statement that X cannot be NULL, transform 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".
dan committed
0433789
September 1, 2022
D
In the query planner, add a heuristic that will reduce the cost of a full
drh committed
a3fc683
June 21, 2022
D
Allow a HAVING clause on any aggregate query, even if there is no GROUP BY
drh committed
b9294de
November 7, 2021
D
Ensure that the window function rewrite does not leave the parse tree
drh committed
6d64b4a
October 1, 2021
D
Change things so that SQLITE_OMIT_VIRTUALTABLE implies SQLITE_OMIT_ALTER_TABLE.
dan committed
37f3ac8
June 23, 2021
D
Fix a problem handling ORDER BY terms of the form "ORDER BY likely(<integer>)" within window frames.
dan committed
a261c02
May 24, 2021
D
Additional defenses (above and beyond [b986600520696b0c]) to prevent an
drh committed
0542812
May 22, 2021
D
Do not invoke sqlite3ExprAffinity() after a syntax error that might have
drh committed
5e1a7de
May 19, 2021
D
Allow aggregate sub-selects within ORDER BY and PARTITION BY clauses of window frame definitions.
dan committed
3d691fd
May 17, 2021
D
Fix problems with refering to CTEs from within sub-selects in PARTITION BY or ORDER BY clauses of window frame definitions. Also a problem with renaming a column when the schema contains a trigger containing a correlated sub-select within a window frames PARTITION BY or ORDER BY clause.
dan committed
be12083
May 7, 2021
D
Detect misuse of aggregate functions in the ORDER BY clause of a query
drh committed
4752bbd
April 17, 2021
D
Remove a couple of NEVER() macros from the code for walking window lists.
dan committed
3c6fbd6
D
Ensure that variables are not used in the WINDOW clause of a query inside
drh committed
7b0d34f
April 12, 2021
D
Fix a segfault that could occur if the ORDER BY clause of a compound SELECT contains a sub-select that uses one or more window functions.
dan committed
d487e37
April 5, 2021
D
Do not allow floating point rounding errors to cause a window function xInverse() function to be invoked before the corresponding xStep() call.
dan committed
6b6ec40
July 13, 2020
D
Fix a problem causing queries containing window functions to ignore collation sequences under some circumstances.
dan committed
27da907
June 11, 2020
D
Avoid rewriting compound SELECT statements that use a different collation sequence for ORDER BY and record processing a second time if they contain window functions. Fix for [b706351c].
dan committed
46daa99
June 10, 2020
D
Ensure that the "push-down" optimization does not push constraints down into compound queries if any of the component queries uses window functions.
dan committed
f65e379
June 7, 2020
D
AggInfo objects might be referenced even after the sqlite3Select() function
drh committed
bf79097
D
Alternative fix to ticket [c8d3b9f0a750a529]: Prior to deleting or modifying
drh committed
8963662
May 24, 2020
D
When rewriting a query for window functions, if the rewrite changes the
drh committed
c37577b
May 11, 2020
D
Fix a problem handling constant integer expressions with collation sequences in PARTITION BY clauses.
dan committed
efa7888
April 3, 2020
D
In the event of a semantic error in an aggregate query, early-out the
drh committed
c415d91
February 29, 2020
D
Fix a problem with window functions occuring within sub-selects that are part of an OR term in a WHERE clause of the outer SELECT.
dan committed
0a21ea9
January 9, 2020
D
Fix an assert() in window.c that could fail with some obscure SELECT statements that use window functions.
dan committed
fbb6e9f
January 3, 2020
D
Ensure that when a Select object is reset a new, empty, SrcList is allocated.
dan committed
aa328b6
January 1, 2020
D
Ensure that when code for a scalar SELECT featuring window functions is generated more than once by the planner, separate ephemeral tables are opened for each instance.
dan committed
4ea562e
December 28, 2019
D
Do not attempt to flatten compound sub-queries in a FROM clause into the parent if any component of the sub-query uses a window function.
dan committed
997d743
December 27, 2019
D
Remove a NEVER() that is no longer true. Fix for [36ffedcb9].
dan committed
b4b3630
D
Fix a problem involving window function aliases being referenced from sub-selects.
dan committed
e3735bf
D
Add a missing "ifcapable rtree {...}" line to the window1.test test module.
drh committed
6473ba9
D
Fix a problem with window functions in aggregate queries that do not have GROUP BY clauses.
dan committed
4317043
D
Do not mistake constant integers in a PARTITION BY expression for references to ORDER BY style references to values returned by the SELECT statement.
dan committed
d8d2fb9
D
When determining if an aggregate within a sub-query should be processed as part of the sub-query or an outer query, consider any FILTER clause in the same way as the arguments to the aggregate.
dan committed
5e484cb
December 25, 2019
D
When the sqlite3WindowRewrite() routine detects and error, have it convert
drh committed
a9ebfe2
December 23, 2019
D
Fix a case in which SQLite could fail to identify "x BETWEEN ? AND ?" being true as implying that x is not null. Ticket [dfd66334].
dan committed
1d24a53
D
For expressions like (x, y) IN (SELECT ...) where the SELECT uses window-functions, require that all columns on the LHS be indexed before an index can be used. Fix for [d9ed4ebe].
dan committed
2811ea6
December 20, 2019
D
When computing dependencies on WHERE-clause terms, be sure to take into
drh committed
8cc8fea
December 18, 2019
D
Add a test case for fix in check-in [1ca0bd982ab1183b]
drh committed
8c72afa
December 7, 2019
D
Correctly deal with multi-row VALUES clauses that contain window functions.
drh committed
29cdbad
December 4, 2019
D
Fix a double-free that could occur when a component of a compound SELECT with an ORDER BY clause uses named window definitions.
dan committed
fcc057d