Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
History of test/window6.test
|
2019-08-08
| ||
| 15:24 | 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. file: [f8d67425] check-in: [1e17ea2f] user: drh branch: omit-stat3, size: 10536 | |
|
2019-03-26
| ||
| 16:47 | Fix a problem with window frames that use "BETWEEN <start> AND 0 PRECEDING". file: [465e608c] check-in: [7927b6b0] user: dan branch: trunk, size: 10537 | |
|
2019-03-09
| ||
| 20:49 | Add support for RANGE window frames. Some cases still do not work. file: [604890f2] check-in: [ffc32b24] user: dan branch: window-functions, size: 9699 | |
|
2018-09-28
| ||
| 23:53 | Fix test cases so that they work with ICU. file: [5eae4ae7] check-in: [d04b2013] user: drh branch: trunk, size: 9693 | |
|
2018-07-10
| ||
| 17:26 | Fix a problem with using scalar sub-selects in window function queries. file: [7574778c] check-in: [687fe532] user: dan branch: trunk, size: 9634 | |
|
2018-07-09
| ||
| 13:31 | Throw an error if the second argument passed to nth_value() is not a positive integer. file: [63a7176e] check-in: [1a06e57a] user: dan branch: trunk, size: 8932 | |
| 06:51 | Fix a bad assert() in window.c. file: [8370c027] check-in: [fe8aaf0c] user: dan branch: trunk, size: 7896 | |
|
2018-07-06
| ||
| 17:19 | Try to improve the error messages for misformed frame specifications in window definitions. file: [d2a243f0] check-in: [927b95a0] user: drh branch: trunk, size: 7717 | |
| 14:31 | Also disallow non-constant expressions in "<expr> PRECEDING" or "<expr> FOLLOWING" clauses. file: [9b7d99eb] check-in: [a6dffecc] user: dan branch: trunk, size: 7255 | |
| 14:15 | Ensure an error is returned if the user specifies an unsupported frame type. file: [117bf6d1] check-in: [0f3f8fcd] user: dan branch: trunk, size: 7171 | |
| 13:48 | Prevent "UNBOUNDED FOLLOWING" from being used as the starting boundary of a window-frame. And "UNBOUNDED PRECEDING" from being used as the ending boundary. file: [5509d5f1] check-in: [e51fdf66] user: dan branch: trunk, size: 6819 | |
| 07:42 | Return an error if DISTINCT is used with a window-function (e.g. "count(DISTINCT <expr>) OVER (...)"). file: [b3a17d3c] check-in: [d59bcc8e] user: dan branch: trunk, size: 6134 | |
|
2018-07-05
| ||
| 18:34 | Return an error if a "RANGE" window-frame uses "<expr> PRECEDING" or "<expr> FOLLOWING". file: [601baeb4] check-in: [786c87ba] user: dan branch: trunk, size: 5926 | |
| 18:19 | Fix a problem in the xInverse method of window-function group_concat(1). file: [378d6acd] check-in: [73391283] user: dan branch: trunk, size: 5435 | |
|
2018-07-02
| ||
| 17:45 | Fix a problem in the xInverse callback for the built-in sum() window function. file: [e8100090] check-in: [b6563647] user: dan branch: trunk, size: 5218 | |
| 17:14 | Fix a segfault caused by having identical window functions in the select-list and ORDER BY clause of a SELECT statement. file: [6a7df4ab] check-in: [693b4350] user: dan branch: trunk, size: 4812 | |
| 15:03 | Fix a crash caused by a LIKE pattern that consists of a single escape character. Problem found by OSSFuzz. file: [6e817df5] check-in: [bb9bfc3a] user: dan branch: trunk, size: 4212 | |
| 12:07 | Fix a segfault caused by invoking a regular aggregate as a window-function. And some problems with count(*) when used as a window-function. file: [28e9126e] check-in: [4f3c8a82] user: dan branch: trunk, size: 3925 | |
|
2018-06-30
| ||
| 18:54 | Have the tokenizer handle fallback for tokens "OVER" and "FILTER" in the same way as it does for "WINDOW". file: [fb4e4649] check-in: [12d819e1] user: dan branch: weak-fallback, size: 3545 | |
|
2018-06-29
| ||
| 17:44 | 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. file: [97bd18d5] check-in: [022079cb] user: dan branch: weak-fallback, size: 2795 Added | |