SQLite

All files named ”test/window8.tcl”
Login

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

History for test/window8.tcl

2024-11-14
14:38
[c57364e64d] 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: 15747)
2021-05-19
14:49
[5e02e41d9d] 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: 14349)
2021-05-17
16:20
[3d3c206107] 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: 14069)
2020-07-29
16:18
[a20eb1d259] part of check-in [a80ae2c98b] Dozens and dozens of typo fixes in comments. This change adds no value to the end product and is disruptive, so it is questionable whether or not it will ever land on trunk. (check-in: [a80ae2c98b] user: drh branch: typos, size: 13082)
2019-09-04
06:56
[f2711aa357] 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: 13084)
2019-08-30
19:45
[112bdc96dd] 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: 11672)
16:14
[3b63931d60] 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: 11292)
2019-08-19
19:59
[5884cc884f] 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: 10948)
2019-04-03
16:27
[9e9a82ae9e] 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: 9639)
2019-03-19
19:39
[97de3829e0] part of check-in [ec7e224f50] Add further tests to window8.test. (check-in: [ec7e224f50] user: dan branch: window-functions, size: 9150)
19:19
[38eca1d367] 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: 8857)
17:45
[f319644bfb] 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: 7671)
11:17
[969c2fe8d8] part of check-in [98cc265987] Update this branch with latest trunk changes. (check-in: [98cc265987] user: dan branch: window-functions, size: 7630)
2019-03-18
16:51
[9755f960fb] part of check-in [723c84be3e] Fixes for RANGE windows and NULL values. (check-in: [723c84be3e] user: dan branch: window-functions, size: 7399)
2019-03-16
20:29
[3f973e4007] 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: 6511)
2019-03-15
20:46
[e4b794bdc0] part of check-in [9b43c3ee2e] Implement the EXCLUDE clause for window frames. (check-in: [9b43c3ee2e] user: dan branch: window-functions, size: 5979)
2019-03-14
16:36
[da939e7d69] 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: 5700)
2019-03-12
18:28
[2aa94709de] 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: 5221)
2019-03-11
11:12
[d296629022] part of check-in [e7bced731a] Fix problems with "RANGE ... ORDER BY <expr> DESC" window frames. (check-in: [e7bced731a] user: dan branch: window-functions, size: 4774)
2019-03-09
20:49
[ec44b7ae3a] 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: 4510)
2019-03-08
20:57
Added: [7b7da7cf72] part of check-in [2872702dac] Add simple tests for GROUPS window frames. (check-in: [2872702dac] user: dan branch: window-functions, size: 4065)