Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
History for test/window8.test
2024-11-14
| ||
14:38 | [3d931e5880] part of check-in [d15fb0f75e] Fix a problem with window functions min() and max() when used with a FILTER clause. Forum post e9126d554a. (check-in: [d15fb0f75e] user: dan branch: trunk, size: 391624) | |
2021-05-19
| ||
14:49 | [4ab1681741] part of check-in [3daab94977] Allow aggregate sub-selects within ORDER BY and PARTITION BY clauses of window frame definitions. (check-in: [3daab94977] user: dan branch: trunk, size: 389818) | |
2021-05-17
| ||
16:20 | [2cdfaa1fd9] part of check-in [4c6cd54a8d] Fix problems with refering to CTEs from within sub-selects in PARTITION BY or ORDER BY clauses of window frame definitions. Also a problem with renaming a column when the schema contains a trigger containing a correlated sub-select within a window frames PARTITION BY or ORDER BY clause. (check-in: [4c6cd54a8d] user: dan branch: trunk, size: 389471) | |
2019-09-04
| ||
06:56 | [c4331b27a6] part of check-in [cb3e2be674] Fix handling of NULL, text and blob values in window queries that use "RANGE BETWEEN A FOLLOWING AND B FOLLOWING", or "B PRECEDING AND A PRECEDING", where A>B. (check-in: [cb3e2be674] user: dan branch: trunk, size: 388292) | |
2019-08-30
| ||
19:45 | [85ad3bd556] part of check-in [2925bfa597] Add test case to window8.test. Also fix an error in a comment in window.c. (check-in: [2925bfa597] user: dan branch: trunk, size: 381771) | |
16:14 | [4531204bfb] part of check-in [39b4cad4a5] Fix a bug in RANGE window functions that use "ORDER BY <expr> DESC NULLS FIRST" as the window-frame ORDER BY clause. (check-in: [39b4cad4a5] user: dan branch: trunk, size: 381365) | |
2019-08-19
| ||
19:59 | [48590f3737] part of check-in [75d665a494] Fix problems with window frames that use ORDER BY ... NULLS LAST etc. (check-in: [75d665a494] user: dan branch: nulls-last, size: 380903) | |
2019-04-03
| ||
16:27 | [df187dc199] part of check-in [39225cc775] Fix a couple of problems with "RANGE BETWEEN <expr> PRECEDING AND <expr> PRECEDING" frames. (check-in: [39225cc775] user: dan branch: trunk, size: 300159) | |
2019-03-19
| ||
19:39 | [0dd7e2d326] part of check-in [ec7e224f50] Add further tests to window8.test. (check-in: [ec7e224f50] user: dan branch: window-functions, size: 299569) | |
19:19 | [8d191c46d0] part of check-in [e025506379] Fix a problem with EXCLUDE clauses on window frames with no ORDER BY. (check-in: [e025506379] user: dan branch: window-functions, size: 267876) | |
17:45 | [ade3404ddd] part of check-in [e195948a68] Add tests to ensure that the window functions implementation is not generating code for unnecessary sorts. (check-in: [e195948a68] user: dan branch: window-functions, size: 224501) | |
11:17 | [cccb819319] part of check-in [98cc265987] Update this branch with latest trunk changes. (check-in: [98cc265987] user: dan branch: window-functions, size: 224308) | |
2019-03-18
| ||
16:51 | [daacb65e98] part of check-in [723c84be3e] Fixes for RANGE windows and NULL values. (check-in: [723c84be3e] user: dan branch: window-functions, size: 171432) | |
2019-03-16
| ||
20:29 | [118243072b] part of check-in [cebe09e11c] Fix problems with RANGE windows and string, blob and NULL values. (check-in: [cebe09e11c] user: dan branch: window-functions, size: 170483) | |
2019-03-15
| ||
20:46 | [1b8de9067b] part of check-in [9b43c3ee2e] Implement the EXCLUDE clause for window frames. (check-in: [9b43c3ee2e] user: dan branch: window-functions, size: 164198) | |
2019-03-14
| ||
16:36 | [03e2467392] part of check-in [7d66cd2013] Add things to this branch that will be required to support the EXCLUDE clause. (check-in: [7d66cd2013] user: dan branch: window-functions, size: 117221) | |
2019-03-12
| ||
18:28 | [e33941d2b3] part of check-in [25ff7091cb] Allow real values to be used in PRECEDING and FOLLOWING expressions for RANGE window frames. (check-in: [25ff7091cb] user: dan branch: window-functions, size: 112411) | |
2019-03-11
| ||
11:12 | [5bf663c76a] part of check-in [e7bced731a] Fix problems with "RANGE ... ORDER BY <expr> DESC" window frames. (check-in: [e7bced731a] user: dan branch: window-functions, size: 110964) | |
2019-03-09
| ||
20:49 | [54a2c5baa3] part of check-in [ffc32b246d] Add support for RANGE window frames. Some cases still do not work. (check-in: [ffc32b246d] user: dan branch: window-functions, size: 110139) | |
2019-03-08
| ||
20:57 | Added: [e7f8169b4f] part of check-in [2872702dac] Add simple tests for GROUPS window frames. (check-in: [2872702dac] user: dan branch: window-functions, size: 109471) | |