Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
19 check-ins using file test/window4.test version 0e3d5957
|
2019-03-18
| ||
| 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) | |
| 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) | |