SQLite

All files named ”test/window8.test”
Login

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)