Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
History for test/window4.test
2020-03-16
| ||
18:52 | [fbead87f68] part of check-in [38e3dd389d] 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: [38e3dd389d] user: dan branch: trunk, size: 58226) | |
2019-08-10
| ||
14:35 | [807f3e6b15] part of check-in [3c690b2b05] Add extra test cases related to the previous commit. (check-in: [3c690b2b05] user: dan branch: trunk, size: 57905) | |
2019-03-18
| ||
18:55 | [bf8f86586c] part of check-in [2879a691ac] Always evaluate window functions using the alternative path usually only used by EXCLUDE frames if the SQLITE_QueryFlattener test flag is set. (check-in: [2879a691ac] user: dan branch: window-functions, size: 56841) | |
2019-03-08
| ||
20:02 | [0e3d595705] 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: 56841) | |
2018-09-24
| ||
14:51 | [c5d6bf3403] part of check-in [507d892c3a] Fix a problem with views that use window functions as part of complex expressions. (check-in: [507d892c3a] user: dan branch: trunk, size: 56778) | |
2018-07-09
| ||
13:31 | [323b118eb5] part of check-in [1a06e57a0b] Throw an error if the second argument passed to nth_value() is not a positive integer. (check-in: [1a06e57a0b] user: dan branch: trunk, size: 55500) | |
2018-07-07
| ||
17:30 | [b43a22ad5b] part of check-in [b76f35b092] Fix a problem with the handling of NULL values in the min() window function. (check-in: [b76f35b092] user: dan branch: trunk, size: 55234) | |
2018-07-06
| ||
13:25 | [048b4760d0] part of check-in [443f0c286f] Remove some bad assert() statements from the implementations of window functions percent_rank() and cume_dist(). (check-in: [443f0c286f] user: dan branch: trunk, size: 54873) | |
2018-06-25
| ||
11:42 | [dcd8767869] part of check-in [e954145a3a] Fix another problem that could cause a crash when a window function was used in a view. (check-in: [e954145a3a] user: dan branch: exp-window-functions, size: 54538) | |
2018-06-22
| ||
20:51 | [1acdae592d] 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: 54297) | |
2018-06-21
| ||
19:20 | [c07c80aa04] part of check-in [b84fbf16ea] Fix a problem with handling single row partitions in the percent_rank() window function. (check-in: [b84fbf16ea] user: dan branch: exp-window-functions, size: 54250) | |
2018-06-15
| ||
19:01 | [13b8cac12e] part of check-in [fadd4dc119] Fix another problem in lead()/lag(). And some errors that could occur following OOM faults. (check-in: [fadd4dc119] user: dan branch: exp-window-functions, size: 53588) | |
16:10 | [c3e7e53d54] part of check-in [3839fb18f9] Fix a bug in the lead() and lag() window functions causing them to fail when used in queries featuring multiple window functions. (check-in: [3839fb18f9] user: dan branch: exp-window-functions, size: 52607) | |
2018-06-14
| ||
20:52 | [2959afeb5d] part of check-in [567e09ef2a] Fix a problem with handling of statements containing two or more different windows. (check-in: [567e09ef2a] user: dan branch: exp-window-functions, size: 51588) | |
19:06 | [f14ecc20c0] part of check-in [43eb1e75a4] 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: [43eb1e75a4] user: dan branch: exp-window-functions, size: 42837) | |
2018-06-13
| ||
20:29 | [eb0cf5740d] part of check-in [c34f31dbd7] Fix problems with "RANGE BETWEEN CURRENT ROW AND UNBOUNDED FOLLOWING" window frames. (check-in: [c34f31dbd7] user: dan branch: exp-window-functions, size: 7946) | |
2018-06-12
| ||
20:53 | [0fb98450ff] part of check-in [6413e38a17] Fix another issue to do with window-functions in aggregate queries. (check-in: [6413e38a17] user: dan branch: exp-window-functions, size: 7778) | |
18:40 | [36df9adf8b] part of check-in [fe7081e095] Fix some problems with using window-functions in aggregate queries. (check-in: [fe7081e095] user: dan branch: exp-window-functions, size: 7584) | |
2018-06-11
| ||
18:16 | [ca7c63f276] part of check-in [b6d9c7eda8] Fix handling of window frames containing negative number of rows. e.g. "ROWS x PRECEDING AND y PRECEDING" where (x<y). (check-in: [b6d9c7eda8] user: dan branch: exp-window-functions, size: 7040) | |
2018-06-09
| ||
17:43 | [207ab5e54b] part of check-in [ceaf798ea0] Add support for FILTER clause on aggregate window functions. (check-in: [ceaf798ea0] user: dan branch: exp-window-functions, size: 6221) | |
2018-06-08
| ||
20:58 | [bef29a267e] part of check-in [19c983b511] Add support for the WINDOW clause. (check-in: [19c983b511] user: dan branch: exp-window-functions, size: 5966) | |
11:45 | [316bf0844f] 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: 5765) | |
2018-06-07
| ||
20:08 | [aab06a0a1b] part of check-in [ef34207073] Add window functions lag() and lead(). (check-in: [ef34207073] user: dan branch: exp-window-functions, size: 5495) | |
2018-06-06
| ||
20:51 | [0d89f694ff] part of check-in [eb1fb420ac] Add implementation of nth_value() window function. (check-in: [eb1fb420ac] user: dan branch: exp-window-functions, size: 4735) | |
2018-06-04
| ||
18:55 | Added: [41754c4531] part of check-in [3f093f608c] Add implementation of window function ntile(). (check-in: [3f093f608c] user: dan branch: exp-window-functions, size: 3425) | |