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

COMMITS

/ test/window8.test
autosetup
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
September 4, 2019
D
Fix handling of NULL, text and blob values in window queries that use "RANGE BETWEEN A FOLLOWING AND B FOLLOWING", or "B PRECEDING AND A PRECEDING", where A>B.
dan committed
1a97c41
August 30, 2019
D
Add test case to window8.test. Also fix an error in a comment in window.c.
dan committed
9889ede
D
Fix a bug in RANGE window functions that use "ORDER BY <expr> DESC NULLS FIRST" as the window-frame ORDER BY clause.
dan committed
8b47f52
August 19, 2019
D
Fix problems with window frames that use ORDER BY ... NULLS LAST etc.
dan committed
ae8e45c
April 3, 2019
D
Fix a couple of problems with "RANGE BETWEEN <expr> PRECEDING AND <expr> PRECEDING" frames.
dan committed
3f49c32
March 19, 2019
D
Add further tests to window8.test.
dan committed
78694ea
D
Fix a problem with EXCLUDE clauses on window frames with no ORDER BY.
dan committed
6603342
D
Add tests to ensure that the window functions implementation is not generating code for unnecessary sorts.
dan committed
8eff0cc
D
Update this branch with latest trunk changes.
dan committed
d430c2e
March 18, 2019
D
Fixes for RANGE windows and NULL values.
dan committed
bdabe74
March 16, 2019
D
Fix problems with RANGE windows and string, blob and NULL values.
dan committed
1e7cb19
March 15, 2019
D
Implement the EXCLUDE clause for window frames.
dan committed
c782a81
March 14, 2019
D
Add things to this branch that will be required to support the EXCLUDE clause.
dan committed
a0f6b83
March 12, 2019
D
Allow real values to be used in PRECEDING and FOLLOWING expressions for RANGE window frames.
dan committed
bb40727
March 11, 2019
D
Fix problems with "RANGE ... ORDER BY <expr> DESC" window frames.
dan committed
71fddaf
March 9, 2019
D
Add support for RANGE window frames. Some cases still do not work.
dan committed
72b9fdc
March 8, 2019
D
Add simple tests for GROUPS window frames.
dan committed
0d86a9b