/ File History
Login

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

History of test/window6.test

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