Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
History for test/window3.test
2023-10-20
| ||
20:19 | [330733bcca] part of check-in [b91c19bf26] Add string_agg(X,Y) as an alias for group_concat(X,Y), for compatibility with SQLServer and PG. (check-in: [b91c19bf26] user: drh branch: string_agg, size: 5163177) | |
2019-03-18
| ||
21:19 | [e9959a993c] part of check-in [1fbddf01b1] Add further tests for new window function functionality. (check-in: [1fbddf01b1] user: dan branch: window-functions, size: 5163185) | |
2019-03-15
| ||
20:46 | [f58f92026a] part of check-in [9b43c3ee2e] Implement the EXCLUDE clause for window frames. (check-in: [9b43c3ee2e] user: dan branch: window-functions, size: 5163185) | |
2019-03-08
| ||
20:02 | [ab76dbaeeb] part of check-in [954bf36993] Finish consolidation of window frame code. Add untested support for GROUPS frames. (check-in: [954bf36993] user: dan branch: window-functions, size: 4215198) | |
2019-02-16
| ||
17:27 | [ee56c741e9] part of check-in [c155125fd5] Add support for chaining of WINDOW definitions. (check-in: [c155125fd5] user: dan branch: window-functions, size: 4208415) | |
2018-07-10
| ||
18:50 | [e274b7f895] part of check-in [7c26c443e7] Modify tests in window3.test to be tolerant of rounding errors when comparing floating point values. (check-in: [7c26c443e7] user: dan branch: trunk, size: 4468058) | |
2018-07-02
| ||
12:07 | [87fb180219] part of check-in [4f3c8a82fd] 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: [4f3c8a82fd] user: dan branch: trunk, size: 4242148) | |
2018-06-22
| ||
20:51 | [47884c240d] part of check-in [5f04b01646] Omit all window-function related code when building with SQLITE_OMIT_WINDOWFUNC. (check-in: [5f04b01646] user: dan branch: exp-window-functions, size: 4203328) | |
2018-06-20
| ||
09:23 | [3c2c768e05] part of check-in [f41b6b7317] Add tests to improve coverage of code in window.c. Fix a problem with "SELECT row_number() OVER ()". (check-in: [f41b6b7317] user: dan branch: exp-window-functions, size: 4203281) | |
2018-06-09
| ||
17:43 | [41727668ee] part of check-in [ceaf798ea0] Add support for FILTER clause on aggregate window functions. (check-in: [ceaf798ea0] user: dan branch: exp-window-functions, size: 4159004) | |
2018-06-08
| ||
11:45 | [e43a143131] part of check-in [89bbc9ba8f] Fixes to allow group_concat() to be used as a window function. (check-in: [89bbc9ba8f] user: dan branch: exp-window-functions, size: 3696908) | |
2018-06-07
| ||
20:08 | [30da147abf] part of check-in [ef34207073] Add window functions lag() and lead(). (check-in: [ef34207073] user: dan branch: exp-window-functions, size: 1318369) | |
17:45 | [4962a83e7f] part of check-in [060b264028] Add support for window function first_value(). (check-in: [060b264028] user: dan branch: exp-window-functions, size: 1088815) | |
15:54 | [82e43e194e] part of check-in [63002b9a09] Fix problems with the nth_value() function. (check-in: [63002b9a09] user: dan branch: exp-window-functions, size: 978666) | |
2018-06-06
| ||
20:51 | [dcd30a2a35] part of check-in [eb1fb420ac] Add implementation of nth_value() window function. (check-in: [eb1fb420ac] user: dan branch: exp-window-functions, size: 978581) | |
2018-06-05
| ||
16:16 | [9c18697bb0] part of check-in [2493ce1a40] Add implementation of last_value() window function. (check-in: [2493ce1a40] user: dan branch: exp-window-functions, size: 862690) | |
2018-06-04
| ||
18:55 | [26697e9236] part of check-in [3f093f608c] Add implementation of window function ntile(). (check-in: [3f093f608c] user: dan branch: exp-window-functions, size: 729445) | |
08:22 | [25340bf9b6] part of check-in [76543f7dd3] Add support for window function cume_dist(). Improve tests for percent_rank(). (check-in: [76543f7dd3] user: dan branch: exp-window-functions, size: 506636) | |
2018-06-02
| ||
21:04 | [d8975dfd7a] part of check-in [91c1cb7a21] Add support for window functions row_number(), rank(), dense_rank() and percent_rank(). (check-in: [91c1cb7a21] user: dan branch: exp-window-functions, size: 418605) | |
2018-05-30
| ||
20:44 | Added: [ce345cb0b9] part of check-in [c16125a884] Allow min() and max() to be used as window functions. (check-in: [c16125a884] user: dan branch: exp-window-functions, size: 39520) | |