aboutsummaryrefslogtreecommitdiff
path: root/src/window.c
Commit message (Collapse)AuthorAge
...
* Add support for window functions row_number(), rank(), dense_rank() anddan2018-06-02
| | | | | percent_rank(). FossilOrigin-Name: 91c1cb7a217d0991a08256269f6c55ef185c25362d57b36bfbd2d85dab38e58f
* Allow an entire partition to be cached in a temp table for all types of windowdan2018-06-01
| | | | | frames. This is required by nth_value() and others. FossilOrigin-Name: b5b18f661341d8d450147e62d321791c706f16c0550bcd98eec3e0220c039189
* Allow min() and max() to be used as window functions.dan2018-05-30
| | | FossilOrigin-Name: c16125a884a9131b707ac20033968c4c3177ea79625a15efb64d754568c6c7a0
* Further window frame tests and fixes.dan2018-05-28
| | | FossilOrigin-Name: e74c6e91859ec395c12ba2742542ff176a1d8364dcfb66b862240746bef54efc
* More fixes for different window frame types.dan2018-05-26
| | | FossilOrigin-Name: 2c85668a0f86bcfd3de4c65847ac252e136ce97409a2249c5f4f58e3756e9a69
* Fix "RANGE BETWEEN CURRENT ROW AND UNBOUNDED FOLLOWING" window framedan2018-05-25
| | | | | processing. FossilOrigin-Name: b4e9c686697a5211a3bfa47e63f0684e3d4241d8c292cffe1a967bc39ad7cd8f
* Fixes for "ROWS BETWEEN <expr> FOLLOWING AND <expr> FOLLOWING" and "ROWSdan2018-05-25
| | | | | BETWEEN <expr> FOLLOWING AND UNBOUNDED FOLLOWING" FossilOrigin-Name: 5ac44872fd5c4f92851e7bf57d7207bb4d67de88ea2b5c746ff97f20bd6352e1
* Allow "<expr> PRECEDING" to be used to specify the end of a window frame.dan2018-05-24
| | | FossilOrigin-Name: 7b709a989c188dbcf429989a0785294b36c8a7e89b5de8cefc25decf1f5b7f5a
* Support other frame types that use "<expr> PRECEDING" or "<expr> FOLLOWING" asdan2018-05-24
| | | | | start or end conditions. FossilOrigin-Name: ec7b648c7f0ee266653561bbb9daa45b9be0d8a1a14f11dc93bce467c35154e6
* Add support for "ROWS BETWEEN <expr> PRECEDING AND <expr> FOLLOWING" windowdan2018-05-23
| | | | | frames. FossilOrigin-Name: 3a203660f1e4da3b8d2d605c494f4843f6e00752f28042b49e11d7d6550dd406
* Add comments to window.c describing how other window frames will be implemented.dan2018-05-22
| | | FossilOrigin-Name: 16168146b202915252f9375aef38e65ca20c5d4aa906e851d4d3a484db57562d
* Begin adding support for more esoteric window frames.dan2018-05-21
| | | FossilOrigin-Name: bc4b81d60d40583de0f929730159011c1a7696802532ebd02220de3ace94a60d
* Evaluate multiple window functions in a single pass if they use the samedan2018-05-17
| | | | | | window definition. Add xValue callbacks for other built-in aggregate functions. FossilOrigin-Name: c9f0f140941660ff368e5bb5752d54feb1964b7a9eac986d4bfb8f24a1c20d86
* Start of experimental implementation of SQL window functions. Does not yetdan2018-05-16
work. FossilOrigin-Name: 3781e520854808fe02ad3fe77dd11fc917448c58ff1fd79123289dd91937decd