dan
|
dfa552f45b
|
Add support for window functions row_number(), rank(), dense_rank() and
percent_rank().
FossilOrigin-Name: 91c1cb7a217d0991a08256269f6c55ef185c25362d57b36bfbd2d85dab38e58f
|
2018-06-02 21:04:28 +00:00 |
|
dan
|
f690b57206
|
Allow an entire partition to be cached in a temp table for all types of window
frames. This is required by nth_value() and others.
FossilOrigin-Name: b5b18f661341d8d450147e62d321791c706f16c0550bcd98eec3e0220c039189
|
2018-06-01 21:00:08 +00:00 |
|
dan
|
c9a8668ac7
|
Allow min() and max() to be used as window functions.
FossilOrigin-Name: c16125a884a9131b707ac20033968c4c3177ea79625a15efb64d754568c6c7a0
|
2018-05-30 20:44:58 +00:00 |
|
dan
|
d6f784ef92
|
Further window frame tests and fixes.
FossilOrigin-Name: e74c6e91859ec395c12ba2742542ff176a1d8364dcfb66b862240746bef54efc
|
2018-05-28 18:30:45 +00:00 |
|
dan
|
79d4544d53
|
More fixes for different window frame types.
FossilOrigin-Name: 2c85668a0f86bcfd3de4c65847ac252e136ce97409a2249c5f4f58e3756e9a69
|
2018-05-26 21:17:29 +00:00 |
|
dan
|
09590aaa1b
|
Fix "RANGE BETWEEN CURRENT ROW AND UNBOUNDED FOLLOWING" window frame
processing.
FossilOrigin-Name: b4e9c686697a5211a3bfa47e63f0684e3d4241d8c292cffe1a967bc39ad7cd8f
|
2018-05-25 20:30:17 +00:00 |
|
dan
|
e105dd7622
|
Fixes for "ROWS BETWEEN <expr> FOLLOWING AND <expr> FOLLOWING" and "ROWS
BETWEEN <expr> FOLLOWING AND UNBOUNDED FOLLOWING"
FossilOrigin-Name: 5ac44872fd5c4f92851e7bf57d7207bb4d67de88ea2b5c746ff97f20bd6352e1
|
2018-05-25 09:29:11 +00:00 |
|
dan
|
31f5639fb7
|
Allow "<expr> PRECEDING" to be used to specify the end of a window frame.
FossilOrigin-Name: 7b709a989c188dbcf429989a0785294b36c8a7e89b5de8cefc25decf1f5b7f5a
|
2018-05-24 21:10:57 +00:00 |
|
dan
|
99652dda3c
|
Support other frame types that use "<expr> PRECEDING" or "<expr> FOLLOWING" as
start or end conditions.
FossilOrigin-Name: ec7b648c7f0ee266653561bbb9daa45b9be0d8a1a14f11dc93bce467c35154e6
|
2018-05-24 17:49:14 +00:00 |
|
dan
|
c3a20c19a8
|
Add support for "ROWS BETWEEN <expr> PRECEDING AND <expr> FOLLOWING" window
frames.
FossilOrigin-Name: 3a203660f1e4da3b8d2d605c494f4843f6e00752f28042b49e11d7d6550dd406
|
2018-05-23 20:55:37 +00:00 |
|
dan
|
8471be3311
|
Add comments to window.c describing how other window frames will be implemented.
FossilOrigin-Name: 16168146b202915252f9375aef38e65ca20c5d4aa906e851d4d3a484db57562d
|
2018-05-22 20:35:37 +00:00 |
|
dan
|
f9eae18b56
|
Begin adding support for more esoteric window frames.
FossilOrigin-Name: bc4b81d60d40583de0f929730159011c1a7696802532ebd02220de3ace94a60d
|
2018-05-21 19:45:11 +00:00 |
|
dan
|
e2f781b9d1
|
Evaluate multiple window functions in a single pass if they use the same
window definition. Add xValue callbacks for other built-in aggregate
functions.
FossilOrigin-Name: c9f0f140941660ff368e5bb5752d54feb1964b7a9eac986d4bfb8f24a1c20d86
|
2018-05-17 19:24:08 +00:00 |
|
dan
|
86fb6e1738
|
Start of experimental implementation of SQL window functions. Does not yet
work.
FossilOrigin-Name: 3781e520854808fe02ad3fe77dd11fc917448c58ff1fd79123289dd91937decd
|
2018-05-16 20:58:07 +00:00 |
|