Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
31 check-ins using file src/sqlite.h.in version 02be315fea
|
2019-03-19
| ||
| 06:40 | Ensure that all the new window-function keywords can still be used as SQL identifiers. (check-in: a6d61dfd47 user: dan tags: window-functions) | |
|
2019-03-18
| ||
| 21:19 | Add further tests for new window function functionality. (check-in: 1fbddf01b1 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: 2879a691ac user: dan tags: window-functions) | |
| 16:51 | Fixes for RANGE windows and NULL values. (check-in: 723c84be3e user: dan tags: window-functions) | |
|
2019-03-16
| ||
| 20:29 | Fix problems with RANGE windows and string, blob and NULL values. (check-in: cebe09e11c 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: f2d5f7a24c user: dan tags: window-functions) | |
|
2019-03-15
| ||
| 20:46 | Implement the EXCLUDE clause for window frames. (check-in: 9b43c3ee2e user: dan tags: window-functions) | |
|
2019-03-14
| ||
| 20:53 | Parse EXCLUDE clauses in window frames. They do not yet work. (check-in: d03c7533a1 user: dan tags: window-functions) | |
| 16:36 | Add things to this branch that will be required to support the EXCLUDE clause. (check-in: 7d66cd2013 user: dan tags: window-functions) | |
|
2019-03-13
| ||
| 17:31 | Merge latest trunk changes into this branch. (check-in: 0b904517bd user: dan tags: window-functions) | |
| 17:20 | Avoid allocating excessive registers for the PARTITION BY expressions when processing window functions. (check-in: 180be26623 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: 6ad5531920 user: dan tags: window-functions) | |
| 13:19 | New test cases added to test/fuzzdata8.db (check-in: 049e992620 user: drh tags: trunk) | |
| 11:40 | When deserializing a database (sqlite3_deserialize()), do not attempt to parse the schema before the data is loaded. (check-in: 4e1b005e8b user: dan tags: trunk) | |
| 10:29 | Detect zero-length free slots on btree pages and report that as corruption. (check-in: c4f0568fde user: drh tags: trunk) | |
| 08:28 | Minor optimization in sqlite3WindowCodeStep(). (check-in: b1322ffb6e 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: 25ff7091cb user: dan tags: window-functions) | |
| 15:21 | Expand on header comment for sqlite3WindowCodeStep(). Further simplify the implementation of the same. (check-in: 5129bcc996 user: dan tags: window-functions) | |
| 09:49 | Fix a crash that could occur if the RHS of an IN expression is a correlated sub-query that refers to the outer query from within a window frame definition only. (check-in: 0524aaaf45 user: dan tags: trunk) | |
|
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: 0812635383 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: 6bd1a07949 user: dan tags: window-functions) | |
| 11:12 | Fix problems with "RANGE ... ORDER BY <expr> DESC" window frames. (check-in: e7bced731a user: dan tags: window-functions) | |
|
2019-03-09
| ||
| 20:49 | Add support for RANGE window frames. Some cases still do not work. (check-in: ffc32b246d user: dan tags: window-functions) | |
| 07:38 | Merge latest trunk changes into this branch. (check-in: 53ea550ce7 user: dan tags: window-functions) | |
|
2019-03-08
| ||
| 20:26 | Fix a harmless bug in the Makefile. (check-in: 62ac9cb07f user: drh tags: trunk) | |
| 15:57 | Merge the latest enhancements and fixes from trunk. (check-in: bf20d4ffcb user: drh tags: wal2) | |
| 14:07 | Add new test cases in test/fuzzdata8.db (check-in: 97bdc090f3 user: drh tags: trunk) | |
| 14:02 | Patch makes balance_nonroot() slightly smaller and faster and more robust against corrupt databases. (check-in: 174da3c32c user: drh tags: trunk) | |
| 13:27 | Fix another segfault in fts3 that could occur with corrupt records. (check-in: fcc24edde4 user: dan tags: trunk) | |
| 01:52 | Detect an attempt to drop a btree that is not within the bounds of the database file and abort early with an SQLITE_CORRUPT error, to avoid problems later on in the process. (check-in: 235a9698f5 user: drh tags: trunk) | |
|
2019-03-06
| ||
| 14:53 | Add the sqlite3_stmt_isexplain() interface. (check-in: ee642d3e27 user: drh tags: trunk) | |