/ File History
Login

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

History of test/window4.test

2018-09-24
14:51
Fix a problem with views that use window functions as part of complex expressions. file: [c5d6bf34] check-in: [507d892c] user: dan branch: trunk, size: 56778
2018-07-09
13:31
Throw an error if the second argument passed to nth_value() is not a positive integer. file: [323b118e] check-in: [1a06e57a] user: dan branch: trunk, size: 55500
2018-07-07
17:30
Fix a problem with the handling of NULL values in the min() window function. file: [b43a22ad] check-in: [b76f35b0] user: dan branch: trunk, size: 55234
2018-07-06
13:25
Remove some bad assert() statements from the implementations of window functions percent_rank() and cume_dist(). file: [048b4760] check-in: [443f0c28] user: dan branch: trunk, size: 54873
2018-06-25
11:42
Fix another problem that could cause a crash when a window function was used in a view. file: [dcd87678] check-in: [e954145a] user: dan branch: exp-window-functions, size: 54538
2018-06-22
20:51
Omit all window-function related code when building with SQLITE_OMIT_WINDOWFUNC. file: [1acdae59] check-in: [5f04b016] user: dan branch: exp-window-functions, size: 54297
2018-06-21
19:20
Fix a problem with handling single row partitions in the percent_rank() window function. file: [c07c80aa] check-in: [b84fbf16] user: dan branch: exp-window-functions, size: 54250
2018-06-15
19:01
Fix another problem in lead()/lag(). And some errors that could occur following OOM faults. file: [13b8cac1] check-in: [fadd4dc1] user: dan branch: exp-window-functions, size: 53588
16:10
Fix a bug in the lead() and lag() window functions causing them to fail when used in queries featuring multiple window functions. file: [c3e7e53d] check-in: [3839fb18] user: dan branch: exp-window-functions, size: 52607
2018-06-14
20:52
Fix a problem with handling of statements containing two or more different windows. file: [2959afeb] check-in: [567e09ef] user: dan branch: exp-window-functions, size: 51588
19:06
Fix problem with window functions min() and max() when used with a PARTITION clause and a frame starting point other than "UNBOUNDED PRECEDING". file: [f14ecc20] check-in: [43eb1e75] user: dan branch: exp-window-functions, size: 42837
2018-06-13
20:29
Fix problems with "RANGE BETWEEN CURRENT ROW AND UNBOUNDED FOLLOWING" window frames. file: [eb0cf574] check-in: [c34f31db] user: dan branch: exp-window-functions, size: 7946
2018-06-12
20:53
Fix another issue to do with window-functions in aggregate queries. file: [0fb98450] check-in: [6413e38a] user: dan branch: exp-window-functions, size: 7778
18:40
Fix some problems with using window-functions in aggregate queries. file: [36df9adf] check-in: [fe7081e0] user: dan branch: exp-window-functions, size: 7584
2018-06-11
18:16
Fix handling of window frames containing negative number of rows. e.g. "ROWS x PRECEDING AND y PRECEDING" where (x<y). file: [ca7c63f2] check-in: [b6d9c7ed] user: dan branch: exp-window-functions, size: 7040
2018-06-09
17:43
Add support for FILTER clause on aggregate window functions. file: [207ab5e5] check-in: [ceaf798e] user: dan branch: exp-window-functions, size: 6221
2018-06-08
20:58
Add support for the WINDOW clause. file: [bef29a26] check-in: [19c983b5] user: dan branch: exp-window-functions, size: 5966
11:45
Fixes to allow group_concat() to be used as a window function. file: [316bf084] check-in: [89bbc9ba] user: dan branch: exp-window-functions, size: 5765
2018-06-07
20:08
Add window functions lag() and lead(). file: [aab06a0a] check-in: [ef342070] user: dan branch: exp-window-functions, size: 5495
2018-06-06
20:51
Add implementation of nth_value() window function. file: [0d89f694] check-in: [eb1fb420] user: dan branch: exp-window-functions, size: 4735
2018-06-04
18:55
Add implementation of window function ntile(). file: [41754c45] check-in: [3f093f60] user: dan branch: exp-window-functions, size: 3425 Added