/ All files named "test/window8.test"
Login

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

History for test/window8.test

2019-09-04
06:56
[c4331b27] part of check-in [cb3e2be6] 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: [cb3e2be6] user: dan branch: trunk, size: 388292)
2019-08-30
19:45
[85ad3bd5] part of check-in [2925bfa5] Add test case to window8.test. Also fix an error in a comment in window.c. (check-in: [2925bfa5] user: dan branch: trunk, size: 381771)
16:14
[4531204b] part of check-in [39b4cad4] Fix a bug in RANGE window functions that use "ORDER BY <expr> DESC NULLS FIRST" as the window-frame ORDER BY clause. (check-in: [39b4cad4] user: dan branch: trunk, size: 381365)
2019-08-19
19:59
[48590f37] part of check-in [75d665a4] Fix problems with window frames that use ORDER BY ... NULLS LAST etc. (check-in: [75d665a4] user: dan branch: nulls-last, size: 380903)
2019-04-03
16:27
[df187dc1] part of check-in [39225cc7] Fix a couple of problems with "RANGE BETWEEN <expr> PRECEDING AND <expr> PRECEDING" frames. (check-in: [39225cc7] user: dan branch: trunk, size: 300159)
2019-03-19
19:39
[0dd7e2d3] part of check-in [ec7e224f] Add further tests to window8.test. (check-in: [ec7e224f] user: dan branch: window-functions, size: 299569)
19:19
[8d191c46] part of check-in [e0255063] Fix a problem with EXCLUDE clauses on window frames with no ORDER BY. (check-in: [e0255063] user: dan branch: window-functions, size: 267876)
17:45
[ade3404d] part of check-in [e195948a] Add tests to ensure that the window functions implementation is not generating code for unnecessary sorts. (check-in: [e195948a] user: dan branch: window-functions, size: 224501)
11:17
[cccb8193] part of check-in [98cc2659] Update this branch with latest trunk changes. (check-in: [98cc2659] user: dan branch: window-functions, size: 224308)
2019-03-18
16:51
[daacb65e] part of check-in [723c84be] Fixes for RANGE windows and NULL values. (check-in: [723c84be] user: dan branch: window-functions, size: 171432)
2019-03-16
20:29
[11824307] part of check-in [cebe09e1] Fix problems with RANGE windows and string, blob and NULL values. (check-in: [cebe09e1] user: dan branch: window-functions, size: 170483)
2019-03-15
20:46
[1b8de906] part of check-in [9b43c3ee] Implement the EXCLUDE clause for window frames. (check-in: [9b43c3ee] user: dan branch: window-functions, size: 164198)
2019-03-14
16:36
[03e24673] part of check-in [7d66cd20] Add things to this branch that will be required to support the EXCLUDE clause. (check-in: [7d66cd20] user: dan branch: window-functions, size: 117221)
2019-03-12
18:28
[e33941d2] part of check-in [25ff7091] Allow real values to be used in PRECEDING and FOLLOWING expressions for RANGE window frames. (check-in: [25ff7091] user: dan branch: window-functions, size: 112411)
2019-03-11
11:12
[5bf663c7] part of check-in [e7bced73] Fix problems with "RANGE ... ORDER BY <expr> DESC" window frames. (check-in: [e7bced73] user: dan branch: window-functions, size: 110964)
2019-03-09
20:49
[54a2c5ba] part of check-in [ffc32b24] Add support for RANGE window frames. Some cases still do not work. (check-in: [ffc32b24] user: dan branch: window-functions, size: 110139)
2019-03-08
20:57
Added: [e7f8169b] part of check-in [2872702d] Add simple tests for GROUPS window frames. (check-in: [2872702d] user: dan branch: window-functions, size: 109471)