/ File History
Login

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

History of test/window3.test

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