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

COMMITS

/ test/window4.test
autosetup
March 16, 2020
D
Fix handling of window functions in aggregate queries that have no GROUP BY clause. Also remove a faulty assert causing the error reported in [618156e3].
dan committed
553948e
August 10, 2019
D
Add extra test cases related to the previous commit.
dan committed
b629968
March 18, 2019
D
Always evaluate window functions using the alternative path usually only used by EXCLUDE frames if the SQLITE_QueryFlattener test flag is set.
dan committed
108e6b2
March 8, 2019
D
Finish consolidation of window frame code. Add untested support for GROUPS frames.
dan committed
6c75b39
September 24, 2018
D
Fix a problem with views that use window functions as part of complex expressions.
dan committed
2fae150
July 9, 2018
D
Throw an error if the second argument passed to nth_value() is not a positive
dan committed
a1a7e11
July 7, 2018
D
Fix a problem with the handling of NULL values in the min() window function.
dan committed
d4fc49f
July 6, 2018
D
Remove some bad assert() statements from the implementations of window
dan committed
cf0343b
June 25, 2018
D
Fix another problem that could cause a crash when a window function was used
dan committed
867be21
June 22, 2018
D
Omit all window-function related code when building with SQLITE_OMIT_WINDOWFUNC.
dan committed
67a9b8e
June 21, 2018
D
Fix a problem with handling single row partitions in the percent_rank() window
dan committed
b7306f6
June 15, 2018
D
Fix another problem in lead()/lag(). And some errors that could occur
dan committed
6fde179
D
Fix a bug in the lead() and lag() window functions causing them to fail when
dan committed
e0a5e20
June 14, 2018
D
Fix a problem with handling of statements containing two or more different
dan committed
303451a
D
Fix problem with window functions min() and max() when used with a PARTITION
dan committed
9a94722
June 13, 2018
D
Fix problems with "RANGE BETWEEN CURRENT ROW AND UNBOUNDED FOLLOWING" window
dan committed
13078ca
June 12, 2018
D
Fix another issue to do with window-functions in aggregate queries.
dan committed
c0bb445
D
Fix some problems with using window-functions in aggregate queries.
dan committed
7392569
June 11, 2018
D
Fix handling of window frames containing negative number of rows. e.g. "ROWS x
dan committed
26522d1
June 9, 2018
D
Add support for FILTER clause on aggregate window functions.
dan committed
8b98560
June 8, 2018
D
Add support for the WINDOW clause.
dan committed
e3bf632
D
Fixes to allow group_concat() to be used as a window function.
dan committed
03854d2
June 7, 2018
D
Add window functions lag() and lead().
dan committed
fe4e25a
June 6, 2018
D
Add implementation of nth_value() window function.
dan committed
ec891fd
June 4, 2018
D
Add implementation of window function ntile().
dan committed
6bc5c9e