/ All files named "test/window3.tcl"
Login

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

History for test/window3.tcl

2020-07-29
16:18
[ba5e9395] part of check-in [a80ae2c9] Dozens and dozens of typo fixes in comments. This change adds no value to the end product and is disruptive, so it is questionable whether or not it will ever land on trunk. (check-in: [a80ae2c9] user: drh branch: typos, size: 12842)
2019-03-15
20:46
[acea6e86] part of check-in [9b43c3ee] Implement the EXCLUDE clause for window frames. (check-in: [9b43c3ee] user: dan branch: window-functions, size: 12843)
2019-02-16
17:27
[3bf7fc5b] part of check-in [c155125f] Add support for chaining of WINDOW definitions. (check-in: [c155125f] user: dan branch: window-functions, size: 12617)
2018-07-02
12:07
[577a3b1f] 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: 12128)
2018-06-22
20:51
[9b82055c] 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: 11963)
2018-06-20
09:23
[c770a8a8] 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: 11941)
2018-06-09
17:43
[654d61d7] part of check-in [ceaf798e] Add support for FILTER clause on aggregate window functions. (check-in: [ceaf798e] user: dan branch: exp-window-functions, size: 11777)
2018-06-08
11:45
[f2596e9d] 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: 11194)
2018-06-07
20:08
[8fdcd16a] part of check-in [ef342070] Add window functions lag() and lead(). (check-in: [ef342070] user: dan branch: exp-window-functions, size: 10459)
17:45
[4941d89c] part of check-in [060b2640] Add support for window function first_value(). (check-in: [060b2640] user: dan branch: exp-window-functions, size: 9273)
15:54
[81e74f14] part of check-in [63002b9a] Fix problems with the nth_value() function. (check-in: [63002b9a] user: dan branch: exp-window-functions, size: 8647)
2018-06-06
20:51
[e3053bb5] part of check-in [eb1fb420] Add implementation of nth_value() window function. (check-in: [eb1fb420] user: dan branch: exp-window-functions, size: 8642)
2018-06-05
16:16
[84bf567e] part of check-in [2493ce1a] Add implementation of last_value() window function. (check-in: [2493ce1a] user: dan branch: exp-window-functions, size: 8012)
2018-06-04
18:55
[3efd83d3] part of check-in [3f093f60] Add implementation of window function ntile(). (check-in: [3f093f60] user: dan branch: exp-window-functions, size: 7382)
08:22
[1c8da1cf] 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: 6747)
2018-06-02
21:04
[27a34216] 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: 6311)
2018-05-30
20:44
Added: [d17eda13] 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: 3825)