Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
About branch window-functions
This branch is to experiment with bringing SQLite WINDOW function support up to speed with Postgres 11. https://modern-sql.com/blog/2019-02/postgresql-11
44 check-ins related to "window-functions"
2019-03-26
| ||
13:08 | Add support for new window functions related features - GROUPS frames, RANGE frames with logical start and end points, the EXCLUDE clause and window chaining. (check-in: c6da3911 user: dan tags: trunk) | |
2019-03-22
| ||
13:56 | Fix a problem with a window function in a correlated sub-query where at least one reference to the outer SELECT appears in a FROM clause sub-select. (Closed-Leaf check-in: 9aca86f9 user: dan tags: window-functions) | |
2019-03-21
| ||
13:51 | Remove assert() statements based on the counter-factual proposition that 0 is not a valid cursor number. (check-in: c7b33618 user: dan tags: window-functions) | |
2019-03-19
| ||
19:39 | Add further tests to window8.test. (check-in: ec7e224f user: dan tags: window-functions) | |
19:19 | Fix a problem with EXCLUDE clauses on window frames with no ORDER BY. (check-in: e0255063 user: dan tags: window-functions) | |
17:45 | Add tests to ensure that the window functions implementation is not generating code for unnecessary sorts. (check-in: e195948a user: dan tags: window-functions) | |
16:49 | Add missing VdbeCoverage() macros to new code in window.c. (check-in: 4f9b93e6 user: dan tags: window-functions) | |
11:56 | Revert the OP_MustBeInt opcode implementation on this branch so that it again matches trunk. The extra functionality is no longer required. (check-in: c02f77b1 user: dan tags: window-functions) | |
11:17 | Update this branch with latest trunk changes. (check-in: 98cc2659 user: dan tags: window-functions) | |
09:57 | Add a LICENSE.md, containing the text of the blessing. (check-in: cbb7e602 user: drh tags: trunk) | |
06:40 | Ensure that all the new window-function keywords can still be used as SQL identifiers. (check-in: a6d61dfd user: dan tags: window-functions) | |
2019-03-18
| ||
21:19 | Add further tests for new window function functionality. (check-in: 1fbddf01 user: dan tags: window-functions) | |
18:55 | Always evaluate window functions using the alternative path usually only used by EXCLUDE frames if the SQLITE_QueryFlattener test flag is set. (check-in: 2879a691 user: dan tags: window-functions) | |
16:51 | Fixes for RANGE windows and NULL values. (check-in: 723c84be user: dan tags: window-functions) | |
2019-03-16
| ||
20:29 | Fix problems with RANGE windows and string, blob and NULL values. (check-in: cebe09e1 user: dan tags: window-functions) | |
10:15 | In order to identify the first row of each partition, check if the rowid in the ephemeral table is 1 instead of using a dedicated flag register. (check-in: f2d5f7a2 user: dan tags: window-functions) | |
2019-03-15
| ||
20:46 | Implement the EXCLUDE clause for window frames. (check-in: 9b43c3ee user: dan tags: window-functions) | |
2019-03-14
| ||
20:53 | Parse EXCLUDE clauses in window frames. They do not yet work. (check-in: d03c7533 user: dan tags: window-functions) | |
16:36 | Add things to this branch that will be required to support the EXCLUDE clause. (check-in: 7d66cd20 user: dan tags: window-functions) | |
2019-03-13
| ||
17:31 | Merge latest trunk changes into this branch. (check-in: 0b904517 user: dan tags: window-functions) | |
17:20 | Avoid allocating excessive registers for the PARTITION BY expressions when processing window functions. (check-in: 180be266 user: dan tags: window-functions) | |
15:29 | Remove rows from the ephemeral table used by window functions once they are no longer required. (check-in: 6ad55319 user: dan tags: window-functions) | |
13:19 | New test cases added to test/fuzzdata8.db (check-in: 049e9926 user: drh tags: trunk) | |
08:28 | Minor optimization in sqlite3WindowCodeStep(). (check-in: b1322ffb user: dan tags: window-functions) | |
2019-03-12
| ||
18:28 | Allow real values to be used in PRECEDING and FOLLOWING expressions for RANGE window frames. (check-in: 25ff7091 user: dan tags: window-functions) | |
15:21 | Expand on header comment for sqlite3WindowCodeStep(). Further simplify the implementation of the same. (check-in: 5129bcc9 user: dan tags: window-functions) | |
2019-03-11
| ||
19:50 | Remove "cache mode" from the window frame code generator. Handle the same cases by editing the window frame specification itself. (check-in: 08126353 user: dan tags: window-functions) | |
18:17 | Simplify the windows frame code some. Add a comment explaining some of the VM code generated by sqlite3WindowCodeStep(). (check-in: 6bd1a079 user: dan tags: window-functions) | |
11:12 | Fix problems with "RANGE ... ORDER BY <expr> DESC" window frames. (check-in: e7bced73 user: dan tags: window-functions) | |
2019-03-09
| ||
20:49 | Add support for RANGE window frames. Some cases still do not work. (check-in: ffc32b24 user: dan tags: window-functions) | |
07:38 | Merge latest trunk changes into this branch. (check-in: 53ea550c user: dan tags: window-functions) | |
2019-03-08
| ||
20:57 | Add simple tests for GROUPS window frames. (check-in: 2872702d user: dan tags: window-functions) | |
20:26 | Fix a harmless bug in the Makefile. (check-in: 62ac9cb0 user: drh tags: trunk) | |
20:02 | Finish consolidation of window frame code. Add untested support for GROUPS frames. (check-in: 954bf369 user: dan tags: window-functions) | |
2019-03-07
| ||
20:47 | Fix other "ROWS BETWEEN" cases on this branch. (check-in: a5f68f66 user: dan tags: window-functions) | |
19:26 | Modify new window functions function so that cursors are stepped immediately after each operation, instead of immediately before. (check-in: 093d2b25 user: dan tags: window-functions) | |
2019-03-06
| ||
21:04 | Simplify the window function code generator some more. (check-in: 45cbd3b4 user: dan tags: window-functions) | |
17:12 | Improvements to the way built-in window functions are handled. (check-in: e8eee566 user: dan tags: window-functions) | |
2019-03-05
| ||
19:29 | Extend windowCodeStep() to handle any ROWS PRECEDING/FOLLOWING frame specification. (check-in: af0ea136 user: dan tags: window-functions) | |
2019-03-04
| ||
21:08 | Merge trunk changes into this branch. (check-in: 9b4d561f user: dan tags: window-functions) | |
21:07 | Support some "ROWS BETWEEN N PRECEDING AND M FOLLOWING" window functions without caching entire partitions. (check-in: e7a91f12 user: dan tags: window-functions) | |
07:15 | Fix a problem preventing compilation with SQLITE_OMIT_UTF16. (check-in: 906d1fd8 user: dan tags: trunk) | |
2019-02-16
| ||
17:27 | Add support for chaining of WINDOW definitions. (check-in: c155125f user: dan tags: window-functions) | |
2019-02-14
| ||
15:27 | Improved oversized cell detection when updating ptrmap pages in balance_nonroot(). (check-in: aa61435a user: drh tags: trunk) | |