Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
18 check-ins using file test/window1.test version 5d9b3cfc
2019-03-13
| ||
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) | |
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: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) | |