/ File History
Login
SQLite training in Houston TX on 2019-11-05 (details)
Part of the 2019 Tcl Conference

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

History of test/window3.test

2019-03-18
21:19
Add further tests for new window function functionality. file: [e9959a99] check-in: [1fbddf01] user: dan branch: window-functions, size: 5163185
2019-03-15
20:46
Implement the EXCLUDE clause for window frames. file: [f58f9202] check-in: [9b43c3ee] user: dan branch: window-functions, size: 5163185
2019-03-08
20:02
Finish consolidation of window frame code. Add untested support for GROUPS frames. file: [ab76dbae] check-in: [954bf369] user: dan branch: window-functions, size: 4215198
2019-02-16
17:27
Add support for chaining of WINDOW definitions. file: [ee56c741] check-in: [c155125f] user: dan branch: window-functions, size: 4208415
2018-07-10
18:50
Modify tests in window3.test to be tolerant of rounding errors when comparing floating point values. file: [e274b7f8] check-in: [7c26c443] user: dan branch: trunk, size: 4468058
2018-07-02
12:07
Fix a segfault caused by invoking a regular aggregate as a window-function. And some problems with count(*) when used as a window-function. file: [87fb1802] check-in: [4f3c8a82] user: dan branch: trunk, size: 4242148
2018-06-22
20:51
Omit all window-function related code when building with SQLITE_OMIT_WINDOWFUNC. file: [47884c24] check-in: [5f04b016] user: dan branch: exp-window-functions, size: 4203328
2018-06-20
09:23
Add tests to improve coverage of code in window.c. Fix a problem with "SELECT row_number() OVER ()". file: [3c2c768e] check-in: [f41b6b73] user: dan branch: exp-window-functions, size: 4203281
2018-06-09
17:43
Add support for FILTER clause on aggregate window functions. file: [41727668] check-in: [ceaf798e] user: dan branch: exp-window-functions, size: 4159004
2018-06-08
11:45
Fixes to allow group_concat() to be used as a window function. file: [e43a1431] check-in: [89bbc9ba] user: dan branch: exp-window-functions, size: 3696908
2018-06-07
20:08
Add window functions lag() and lead(). file: [30da147a] check-in: [ef342070] user: dan branch: exp-window-functions, size: 1318369
17:45
Add support for window function first_value(). file: [4962a83e] check-in: [060b2640] user: dan branch: exp-window-functions, size: 1088815
15:54
Fix problems with the nth_value() function. file: [82e43e19] check-in: [63002b9a] user: dan branch: exp-window-functions, size: 978666
2018-06-06
20:51
Add implementation of nth_value() window function. file: [dcd30a2a] check-in: [eb1fb420] user: dan branch: exp-window-functions, size: 978581
2018-06-05
16:16
Add implementation of last_value() window function. file: [9c18697b] check-in: [2493ce1a] user: dan branch: exp-window-functions, size: 862690
2018-06-04
18:55
Add implementation of window function ntile(). file: [26697e92] check-in: [3f093f60] user: dan branch: exp-window-functions, size: 729445
08:22
Add support for window function cume_dist(). Improve tests for percent_rank(). file: [25340bf9] check-in: [76543f7d] user: dan branch: exp-window-functions, size: 506636
2018-06-02
21:04
Add support for window functions row_number(), rank(), dense_rank() and percent_rank(). file: [d8975dfd] check-in: [91c1cb7a] user: dan branch: exp-window-functions, size: 418605
2018-05-30
20:44
Allow min() and max() to be used as window functions. file: [ce345cb0] check-in: [c16125a8] user: dan branch: exp-window-functions, size: 39520 Added