/ Timeline
Login

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

50 check-ins occurring around b1322ffb6e63a110.

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
15:49
Fix a buffer overread that could occur when running fts5 prefix queries inside a transaction. check-in: b3fa58dd74 user: dan tags: trunk
15:23
Fix an fts5 problem with interleaving reads and writes in a single transaction. check-in: 45c73deb44 user: dan tags: trunk
10:30
Fix a typo in a comment. No changes to code. check-in: c2f50aa4e7 user: drh tags: trunk
2019-03-17
23:59
New hyperlink on the README.md file. check-in: cc5ab96715 user: drh tags: trunk
23:44
Update the README.md file at the top level to talk about how to deal with version names and how to verify the code in Git mirrors. check-in: e8c87a0ac1 user: drh tags: trunk
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
19:08
Back out the change to support Fuchsia, since it turns out fuchsia does not like dot-file locks. check-in: 1d801a3b2c user: drh tags: trunk
18:57
Remove a debugging printf() left in test/sessionfuzz.c. check-in: 73c4abc902 user: dan tags: trunk
16:17
Ensure that ALTER TABLE commands open statement transactions. Fix for [596d059a]. check-in: 0f2129f59f user: dan tags: trunk
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
00:01
Technical improvements to the documentation for sqlite3_bind_blob() and sqlite3_bind_text(). No changes to code. check-in: fb60150aee user: drh tags: trunk
2019-03-13
23:51
Improvements to the sqlite3_db_filename() API documentation. No code changes. check-in: 711f5ec4dc user: drh tags: trunk
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:57
Add simple tests for GROUPS window frames. check-in: 2872702dac user: dan tags: window-functions
20:26
Fix a harmless bug in the Makefile. check-in: 62ac9cb07f user: drh tags: trunk
20:02
Finish consolidation of window frame code. Add untested support for GROUPS frames. check-in: 954bf36993 user: dan tags: window-functions
16:06
Merge the latest enhancements and fixes from trunk. check-in: 543ecb30d6 user: drh tags: begin-concurrent-pnu-wal2
15:57
Merge the latest enhancements and fixes from trunk. check-in: bf20d4ffcb user: drh tags: wal2
15:39
Add the bgckpt.c extension to Makefile.in and Makefile.msc. check-in: 3712d625d6 user: drh tags: wal2
15:30
Merge all the latest enhancements from trunk. check-in: 667cce3dce user: drh tags: begin-concurrent-pnu
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-07
20:47
Fix other "ROWS BETWEEN" cases on this branch. check-in: a5f68f6647 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: 093d2b25f1 user: dan tags: window-functions
2019-03-06
21:04
Simplify the window function code generator some more. check-in: 45cbd3b449 user: dan tags: window-functions
17:12
Improvements to the way built-in window functions are handled. check-in: e8eee566df user: dan tags: window-functions
14:53
Add the sqlite3_stmt_isexplain() interface. check-in: ee642d3e27 user: drh tags: trunk