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

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

History for test/window9.test

2020-06-09
17:45
[4d8c875b] part of check-in [16a41fa8] 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: [16a41fa8] user: dan branch: agg-context-fix, size: 6090)
2020-03-16
18:52
[c22c2537] part of check-in [38e3dd38] 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: [38e3dd38] user: dan branch: trunk, size: 6113)
2019-10-29
16:18
[b63f6f74] part of check-in [4d424f30] 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: [4d424f30] user: drh branch: trunk, size: 5436)
2019-09-26
15:53
[ae8be07b] part of check-in [1cc6cf64] 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: [1cc6cf64] user: dan branch: trunk, size: 5437)
2019-08-15
13:53
[20a6b590] part of check-in [4f5b2d93] Ensure that SQLite does not attempt to process incompatible window functions in a single scan. Fix for [256741a1]. (check-in: [4f5b2d93] user: dan branch: trunk, size: 4649)
2019-08-08
15:24
[1fd3ff49] part of check-in [1e17ea2f] 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: [1e17ea2f] user: drh branch: omit-stat3, size: 4131)
2019-08-07
17:45
[7ba6c69d] part of check-in [8158d2ac] Eliminate some more cases of redundant sorting in window-function queries. (check-in: [8158d2ac] user: dan branch: trunk, size: 4132)
2019-08-05
20:45
[2bc9f311] part of check-in [f37317d8] Add test cases to this branch. (check-in: [f37317d8] user: dan branch: tkt-61c853-A, size: 3530)
2019-07-22
17:28
[7bbefbb1] part of check-in [05080344] Fix a bug in the linked-list handling code added by commit [fd7316cd]. (check-in: [05080344] user: dan branch: trunk, size: 3102)
16:20
[4329f463] part of check-in [d23f3316] Remove Window objects from the corresponding Select.pWin list when they are deleted. (check-in: [d23f3316] user: dan branch: winfunc-in-orderby, size: 2844)
2019-07-08
12:01
Added: [06495ac7] part of check-in [28196d89] Ensure collation sequences and affinities work in window function queries. Fix for [9ece23d2]. (check-in: [28196d89] user: dan branch: trunk, size: 2269)