SQLite

All files named ”test/window9.test”
Login

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)