SQLite

Timeline
Login

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

10 check-ins using file src/select.c version 8a7f842a

2018-06-01
21:00
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. (check-in: b5b18f66 user: dan tags: exp-window-functions)
2018-05-30
20:44
Allow min() and max() to be used as window functions. (check-in: c16125a8 user: dan tags: exp-window-functions)
2018-05-28
18:30
Further window frame tests and fixes. (check-in: e74c6e91 user: dan tags: exp-window-functions)
2018-05-26
21:17
More fixes for different window frame types. (check-in: 2c85668a user: dan tags: exp-window-functions)
2018-05-25
20:30
Fix "RANGE BETWEEN CURRENT ROW AND UNBOUNDED FOLLOWING" window frame processing. (check-in: b4e9c686 user: dan tags: exp-window-functions)
09:36
Merge latest trunk changes into this branch. (check-in: 62325198 user: dan tags: exp-window-functions)
09:29
Fixes for "ROWS BETWEEN <expr> FOLLOWING AND <expr> FOLLOWING" and "ROWS BETWEEN <expr> FOLLOWING AND UNBOUNDED FOLLOWING" (check-in: 5ac44872 user: dan tags: exp-window-functions)
2018-05-24
21:10
Allow "<expr> PRECEDING" to be used to specify the end of a window frame. (check-in: 7b709a98 user: dan tags: exp-window-functions)
17:49
Support other frame types that use "<expr> PRECEDING" or "<expr> FOLLOWING" as start or end conditions. (check-in: ec7b648c user: dan tags: exp-window-functions)
2018-05-23
20:55
Add support for "ROWS BETWEEN <expr> PRECEDING AND <expr> FOLLOWING" window frames. (check-in: 3a203660 user: dan tags: exp-window-functions)