SQLite

All files named ”test/window3.test”
Login

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)