/ All files named "test/window4.test"
Login

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

History for test/window4.test

2020-03-16
18:52
[fbead87f] part of check-in [38e3dd38] Fix handling of window functions in aggregate queries that have no GROUP BY clause. Also remove a faulty assert causing the error reported in [618156e3]. (check-in: [38e3dd38] user: dan branch: trunk, size: 58226)
2019-08-10
14:35
[807f3e6b] part of check-in [3c690b2b] Add extra test cases related to the previous commit. (check-in: [3c690b2b] user: dan branch: trunk, size: 57905)
2019-03-18
18:55
[bf8f8658] part of check-in [2879a691] Always evaluate window functions using the alternative path usually only used by EXCLUDE frames if the SQLITE_QueryFlattener test flag is set. (check-in: [2879a691] user: dan branch: window-functions, size: 56841)
2019-03-08
20:02
[0e3d5957] 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: 56841)
2018-09-24
14:51
[c5d6bf34] part of check-in [507d892c] Fix a problem with views that use window functions as part of complex expressions. (check-in: [507d892c] user: dan branch: trunk, size: 56778)
2018-07-09
13:31
[323b118e] part of check-in [1a06e57a] Throw an error if the second argument passed to nth_value() is not a positive integer. (check-in: [1a06e57a] user: dan branch: trunk, size: 55500)
2018-07-07
17:30
[b43a22ad] part of check-in [b76f35b0] Fix a problem with the handling of NULL values in the min() window function. (check-in: [b76f35b0] user: dan branch: trunk, size: 55234)
2018-07-06
13:25
[048b4760] part of check-in [443f0c28] Remove some bad assert() statements from the implementations of window functions percent_rank() and cume_dist(). (check-in: [443f0c28] user: dan branch: trunk, size: 54873)
2018-06-25
11:42
[dcd87678] part of check-in [e954145a] Fix another problem that could cause a crash when a window function was used in a view. (check-in: [e954145a] user: dan branch: exp-window-functions, size: 54538)
2018-06-22
20:51
[1acdae59] 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: 54297)
2018-06-21
19:20
[c07c80aa] part of check-in [b84fbf16] Fix a problem with handling single row partitions in the percent_rank() window function. (check-in: [b84fbf16] user: dan branch: exp-window-functions, size: 54250)
2018-06-15
19:01
[13b8cac1] part of check-in [fadd4dc1] Fix another problem in lead()/lag(). And some errors that could occur following OOM faults. (check-in: [fadd4dc1] user: dan branch: exp-window-functions, size: 53588)
16:10
[c3e7e53d] part of check-in [3839fb18] Fix a bug in the lead() and lag() window functions causing them to fail when used in queries featuring multiple window functions. (check-in: [3839fb18] user: dan branch: exp-window-functions, size: 52607)
2018-06-14
20:52
[2959afeb] part of check-in [567e09ef] Fix a problem with handling of statements containing two or more different windows. (check-in: [567e09ef] user: dan branch: exp-window-functions, size: 51588)
19:06
[f14ecc20] part of check-in [43eb1e75] Fix problem with window functions min() and max() when used with a PARTITION clause and a frame starting point other than "UNBOUNDED PRECEDING". (check-in: [43eb1e75] user: dan branch: exp-window-functions, size: 42837)
2018-06-13
20:29
[eb0cf574] part of check-in [c34f31db] Fix problems with "RANGE BETWEEN CURRENT ROW AND UNBOUNDED FOLLOWING" window frames. (check-in: [c34f31db] user: dan branch: exp-window-functions, size: 7946)
2018-06-12
20:53
[0fb98450] part of check-in [6413e38a] Fix another issue to do with window-functions in aggregate queries. (check-in: [6413e38a] user: dan branch: exp-window-functions, size: 7778)
18:40
[36df9adf] part of check-in [fe7081e0] Fix some problems with using window-functions in aggregate queries. (check-in: [fe7081e0] user: dan branch: exp-window-functions, size: 7584)
2018-06-11
18:16
[ca7c63f2] part of check-in [b6d9c7ed] Fix handling of window frames containing negative number of rows. e.g. "ROWS x PRECEDING AND y PRECEDING" where (x<y). (check-in: [b6d9c7ed] user: dan branch: exp-window-functions, size: 7040)
2018-06-09
17:43
[207ab5e5] part of check-in [ceaf798e] Add support for FILTER clause on aggregate window functions. (check-in: [ceaf798e] user: dan branch: exp-window-functions, size: 6221)
2018-06-08
20:58
[bef29a26] part of check-in [19c983b5] Add support for the WINDOW clause. (check-in: [19c983b5] user: dan branch: exp-window-functions, size: 5966)
11:45
[316bf084] 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: 5765)
2018-06-07
20:08
[aab06a0a] part of check-in [ef342070] Add window functions lag() and lead(). (check-in: [ef342070] user: dan branch: exp-window-functions, size: 5495)
2018-06-06
20:51
[0d89f694] part of check-in [eb1fb420] Add implementation of nth_value() window function. (check-in: [eb1fb420] user: dan branch: exp-window-functions, size: 4735)
2018-06-04
18:55
Added: [41754c45] part of check-in [3f093f60] Add implementation of window function ntile(). (check-in: [3f093f60] user: dan branch: exp-window-functions, size: 3425)