Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
History for test/window9.test
2024-11-14
| ||
14:38 | [7b98a7916d] 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: 7704) | |
2021-03-31
| ||
11:31 | [349c71eab4] part of check-in [8b681b274d] Ensure that negative numbers may not be used in frame offset clauses even if they are initially text value. e.g. (RANGE BETWEEN '-1' PRECEDING ...). (check-in: [8b681b274d] user: dan branch: trunk, size: 6569) | |
2020-06-09
| ||
17:45 | [4d8c875b73] part of check-in [16a41fa8c4] Ensure that aggregate functions that (a) are part of SELECT statements with no FROM clause and (b) have one or more scalar sub-selects as arguments are assigned to the correct aggregate context. (check-in: [16a41fa8c4] user: dan branch: agg-context-fix, size: 6090) | |
2020-03-16
| ||
18:52 | [c22c25377c] 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: 6113) | |
2019-10-29
| ||
16:18 | [b63f6f74d7] part of check-in [4d424f3047] Remove the legacy_file_format PRAGMA. In its place, provide the SQLITE_DBCONFIG_LEGACY_FILE_FORMAT option to sqlite3_db_config(). Fix for ticket [6484e6ce678fffab] (check-in: [4d424f3047] user: drh branch: trunk, size: 5436) | |
2019-09-26
| ||
15:53 | [ae8be07be0] part of check-in [1cc6cf6407] Fix a window-functions problem that could occur if an ORDER BY clause contains an alias for a window-function that is not a top-level expression. (check-in: [1cc6cf6407] user: dan branch: trunk, size: 5437) | |
2019-08-15
| ||
13:53 | [20a6b590be] part of check-in [4f5b2d9381] Ensure that SQLite does not attempt to process incompatible window functions in a single scan. Fix for [256741a1]. (check-in: [4f5b2d9381] user: dan branch: trunk, size: 4649) | |
2019-08-08
| ||
15:24 | [1fd3ff4911] part of check-in [1e17ea2fd1] Remove support for STAT3. The sqlite_stat3 tables are ignored, if they exist. STAT4 continues to work as it always has, and as it is a superset of STAT3 is the recommended replacement. (check-in: [1e17ea2fd1] user: drh branch: omit-stat3, size: 4131) | |
2019-08-07
| ||
17:45 | [7ba6c69d30] part of check-in [8158d2aca6] Eliminate some more cases of redundant sorting in window-function queries. (check-in: [8158d2aca6] user: dan branch: trunk, size: 4132) | |
2019-08-05
| ||
20:45 | [2bc9f311a9] part of check-in [f37317d81c] Add test cases to this branch. (check-in: [f37317d81c] user: dan branch: tkt-61c853-A, size: 3530) | |
2019-07-22
| ||
17:28 | [7bbefbb188] part of check-in [05080344dc] Fix a bug in the linked-list handling code added by commit [fd7316cd]. (check-in: [05080344dc] user: dan branch: trunk, size: 3102) | |
16:20 | [4329f463a1] part of check-in [d23f331682] Remove Window objects from the corresponding Select.pWin list when they are deleted. (check-in: [d23f331682] user: dan branch: winfunc-in-orderby, size: 2844) | |
2019-07-08
| ||
12:01 | Added: [06495ac733] part of check-in [28196d894a] Ensure collation sequences and affinities work in window function queries. Fix for [9ece23d2]. (check-in: [28196d894a] user: dan branch: trunk, size: 2269) | |