Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
History for test/window6.test
2022-01-16
| ||
19:11 | [311de885bd] part of check-in [4883776669] Fix test cases so that they all still work even with -DSQLITE_DQS=0. (check-in: [4883776669] user: drh branch: trunk, size: 10585) | |
2019-08-08
| ||
15:24 | [f8d674254b] 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: 10536) | |
2019-03-26
| ||
16:47 | [465e608c02] part of check-in [7927b6b023] Fix a problem with window frames that use "BETWEEN <start> AND 0 PRECEDING". (check-in: [7927b6b023] user: dan branch: trunk, size: 10537) | |
2019-03-09
| ||
20:49 | [604890f2b0] 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: 9699) | |
2018-09-28
| ||
23:53 | [5eae4ae7a5] part of check-in [d04b2013b5] Fix test cases so that they work with ICU. (check-in: [d04b2013b5] user: drh branch: trunk, size: 9693) | |
2018-07-10
| ||
17:26 | [7574778c79] part of check-in [687fe532c2] Fix a problem with using scalar sub-selects in window function queries. (check-in: [687fe532c2] user: dan branch: trunk, size: 9634) | |
2018-07-09
| ||
13:31 | [63a7176e01] part of check-in [1a06e57a0b] Throw an error if the second argument passed to nth_value() is not a positive integer. (check-in: [1a06e57a0b] user: dan branch: trunk, size: 8932) | |
06:51 | [8370c02744] part of check-in [fe8aaf0c80] Fix a bad assert() in window.c. (check-in: [fe8aaf0c80] user: dan branch: trunk, size: 7896) | |
2018-07-06
| ||
17:19 | [d2a243f0bf] part of check-in [927b95a081] Try to improve the error messages for misformed frame specifications in window definitions. (check-in: [927b95a081] user: drh branch: trunk, size: 7717) | |
14:31 | [9b7d99ebe5] part of check-in [a6dffecc6b] Also disallow non-constant expressions in "<expr> PRECEDING" or "<expr> FOLLOWING" clauses. (check-in: [a6dffecc6b] user: dan branch: trunk, size: 7255) | |
14:15 | [117bf6d18f] part of check-in [0f3f8fcde1] Ensure an error is returned if the user specifies an unsupported frame type. (check-in: [0f3f8fcde1] user: dan branch: trunk, size: 7171) | |
13:48 | [5509d5f1bd] part of check-in [e51fdf66a2] Prevent "UNBOUNDED FOLLOWING" from being used as the starting boundary of a window-frame. And "UNBOUNDED PRECEDING" from being used as the ending boundary. (check-in: [e51fdf66a2] user: dan branch: trunk, size: 6819) | |
07:42 | [b3a17d3ca1] part of check-in [d59bcc8eea] Return an error if DISTINCT is used with a window-function (e.g. "count(DISTINCT <expr>) OVER (...)"). (check-in: [d59bcc8eea] user: dan branch: trunk, size: 6134) | |
2018-07-05
| ||
18:34 | [601baeb467] part of check-in [786c87ba41] Return an error if a "RANGE" window-frame uses "<expr> PRECEDING" or "<expr> FOLLOWING". (check-in: [786c87ba41] user: dan branch: trunk, size: 5926) | |
18:19 | [378d6acda7] part of check-in [7339128310] Fix a problem in the xInverse method of window-function group_concat(1). (check-in: [7339128310] user: dan branch: trunk, size: 5435) | |
2018-07-02
| ||
17:45 | [e8100090c9] part of check-in [b656364738] Fix a problem in the xInverse callback for the built-in sum() window function. (check-in: [b656364738] user: dan branch: trunk, size: 5218) | |
17:14 | [6a7df4ab43] part of check-in [693b4350d7] Fix a segfault caused by having identical window functions in the select-list and ORDER BY clause of a SELECT statement. (check-in: [693b4350d7] user: dan branch: trunk, size: 4812) | |
15:03 | [6e817df584] part of check-in [bb9bfc3a12] Fix a crash caused by a LIKE pattern that consists of a single escape character. Problem found by OSSFuzz. (check-in: [bb9bfc3a12] user: dan branch: trunk, size: 4212) | |
12:07 | [28e9126e1c] part of check-in [4f3c8a82fd] Fix a segfault caused by invoking a regular aggregate as a window-function. And some problems with count(*) when used as a window-function. (check-in: [4f3c8a82fd] user: dan branch: trunk, size: 3925) | |
2018-06-30
| ||
18:54 | [fb4e464993] part of check-in [12d819e1c1] Have the tokenizer handle fallback for tokens "OVER" and "FILTER" in the same way as it does for "WINDOW". (check-in: [12d819e1c1] user: dan branch: weak-fallback, size: 3545) | |
2018-06-29
| ||
17:44 | Added: [97bd18d5cc] part of check-in [022079cb0d] Instead of using a lemon %fallback directive, have the tokenizer try to figure out whether an instance of "WINDOW" should be TK_WINDOW or TK_ID. (check-in: [022079cb0d] user: dan branch: weak-fallback, size: 2795) | |