Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
History of test/window4.tcl
|
2019-08-10
| ||
| 14:35 | Add extra test cases related to the previous commit. file: [d732df0e] check-in: [3c690b2b] user: dan branch: trunk, size: 9616 | |
|
2019-03-06
| ||
| 17:12 | Improvements to the way built-in window functions are handled. file: [5fbaab48] check-in: [e8eee566] user: dan branch: window-functions, size: 9240 | |
|
2018-09-24
| ||
| 14:51 | Fix a problem with views that use window functions as part of complex expressions. file: [511425f6] check-in: [507d892c] user: dan branch: trunk, size: 9239 | |
|
2018-07-09
| ||
| 13:31 | Throw an error if the second argument passed to nth_value() is not a positive integer. file: [87136405] check-in: [1a06e57a] user: dan branch: trunk, size: 8695 | |
|
2018-07-07
| ||
| 17:30 | Fix a problem with the handling of NULL values in the min() window function. file: [9491accc] check-in: [b76f35b0] user: dan branch: trunk, size: 8514 | |
|
2018-07-06
| ||
| 13:25 | Remove some bad assert() statements from the implementations of window functions percent_rank() and cume_dist(). file: [a7f0e514] check-in: [443f0c28] user: dan branch: trunk, size: 8199 | |
|
2018-06-25
| ||
| 11:42 | Fix another problem that could cause a crash when a window function was used in a view. file: [7cec7e57] check-in: [e954145a] user: dan branch: exp-window-functions, size: 8066 | |
|
2018-06-22
| ||
| 20:51 | Omit all window-function related code when building with SQLITE_OMIT_WINDOWFUNC. file: [e52914d7] check-in: [5f04b016] user: dan branch: exp-window-functions, size: 7897 | |
|
2018-06-21
| ||
| 19:20 | Fix a problem with handling single row partitions in the percent_rank() window function. file: [1ac3c81a] check-in: [b84fbf16] user: dan branch: exp-window-functions, size: 7875 | |
|
2018-06-15
| ||
| 19:01 | Fix another problem in lead()/lag(). And some errors that could occur following OOM faults. file: [ce0c1418] check-in: [fadd4dc1] user: dan branch: exp-window-functions, size: 7504 | |
| 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: [edacba69] check-in: [3839fb18] user: dan branch: exp-window-functions, size: 6704 | |
|
2018-06-14
| ||
| 20:52 | Fix a problem with handling of statements containing two or more different windows. file: [9a04d146] check-in: [567e09ef] user: dan branch: exp-window-functions, size: 5923 | |
| 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: [3388b296] check-in: [43eb1e75] user: dan branch: exp-window-functions, size: 5558 | |
|
2018-06-13
| ||
| 20:29 | Fix problems with "RANGE BETWEEN CURRENT ROW AND UNBOUNDED FOLLOWING" window frames. file: [09167855] check-in: [c34f31db] user: dan branch: exp-window-functions, size: 4296 | |
|
2018-06-12
| ||
| 20:53 | Fix another issue to do with window-functions in aggregate queries. file: [a77a7ab3] check-in: [6413e38a] user: dan branch: exp-window-functions, size: 4172 | |
| 18:40 | Fix some problems with using window-functions in aggregate queries. file: [e64db87b] check-in: [fe7081e0] user: dan branch: exp-window-functions, size: 4008 | |
|
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: [bfea0c4f] check-in: [b6d9c7ed] user: dan branch: exp-window-functions, size: 3416 | |
|
2018-06-09
| ||
| 17:43 | Add support for FILTER clause on aggregate window functions. file: [e459eb2f] check-in: [ceaf798e] user: dan branch: exp-window-functions, size: 2748 | |
|
2018-06-08
| ||
| 20:58 | Add support for the WINDOW clause. file: [2da10ad7] check-in: [19c983b5] user: dan branch: exp-window-functions, size: 2640 | |
| 11:45 | Fixes to allow group_concat() to be used as a window function. file: [9e5698ff] check-in: [89bbc9ba] user: dan branch: exp-window-functions, size: 2482 | |
|
2018-06-07
| ||
| 20:08 | Add window functions lag() and lead(). file: [46f5d6ad] check-in: [ef342070] user: dan branch: exp-window-functions, size: 2347 | |
|
2018-06-06
| ||
| 20:51 | Add implementation of nth_value() window function. file: [23918c0c] check-in: [eb1fb420] user: dan branch: exp-window-functions, size: 1908 | |
|
2018-06-04
| ||
| 18:55 | Add implementation of window function ntile(). file: [3f81bec5] check-in: [3f093f60] user: dan branch: exp-window-functions, size: 848 Added | |