SQLite

Timeline
Login

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

31 check-ins using file main.mk version e829e6dc

2018-06-09
17:43
Add support for FILTER clause on aggregate window functions. (check-in: ceaf798e user: dan tags: exp-window-functions)
2018-06-08
20:58
Add support for the WINDOW clause. (check-in: 19c983b5 user: dan tags: exp-window-functions)
16:11
Do not flatten sub-queries that contain window functions. (check-in: 236cb75b user: dan tags: exp-window-functions)
11:45
Fixes to allow group_concat() to be used as a window function. (check-in: 89bbc9ba user: dan tags: exp-window-functions)
2018-06-07
20:35
Merge latest trunk changes with this branch. (check-in: 25102203 user: dan tags: exp-window-functions)
20:08
Add window functions lag() and lead(). (check-in: ef342070 user: dan tags: exp-window-functions)
17:45
Add support for window function first_value(). (check-in: 060b2640 user: dan tags: exp-window-functions)
15:54
Fix problems with the nth_value() function. (check-in: 63002b9a user: dan tags: exp-window-functions)
2018-06-06
20:51
Add implementation of nth_value() window function. (check-in: eb1fb420 user: dan tags: exp-window-functions)
2018-06-05
16:16
Add implementation of last_value() window function. (check-in: 2493ce1a user: dan tags: exp-window-functions)
2018-06-04
18:55
Add implementation of window function ntile(). (check-in: 3f093f60 user: dan tags: exp-window-functions)
08:28
Merge latest trunk changes into this branch. (check-in: 83d6416a user: dan tags: exp-window-functions)
08:22
Add support for window function cume_dist(). Improve tests for percent_rank(). (check-in: 76543f7d user: dan tags: exp-window-functions)
2018-06-02
21:04
Add support for window functions row_number(), rank(), dense_rank() and percent_rank(). (check-in: 91c1cb7a user: dan tags: exp-window-functions)
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)
2018-05-22
20:36
Merge latest trunk changes into this branch. (check-in: cdb68d2c user: dan tags: exp-window-functions)
20:35
Add comments to window.c describing how other window frames will be implemented. (check-in: 16168146 user: dan tags: exp-window-functions)
2018-05-21
19:45
Begin adding support for more esoteric window frames. (check-in: bc4b81d6 user: dan tags: exp-window-functions)
2018-05-19
14:15
Fix minor problems on this branch. (check-in: 19c2e4b2 user: dan tags: exp-window-functions)
2018-05-17
19:24
Evaluate multiple window functions in a single pass if they use the same window definition. Add xValue callbacks for other built-in aggregate functions. (check-in: c9f0f140 user: dan tags: exp-window-functions)
14:26
Handle multiple window-functions in a single query. (check-in: 35af0b75 user: dan tags: exp-window-functions)
2018-05-16
20:58
Start of experimental implementation of SQL window functions. Does not yet work. (check-in: 3781e520 user: dan tags: exp-window-functions)