/ Timeline
Login

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

50 check-ins occurring around 0f2129f59f7df929.

2019-03-19
20:13
Fix a compiler warning in FTS5. check-in: d5acf3af65 user: drh tags: trunk
19:39
Add further tests to window8.test. check-in: ec7e224f50 user: dan tags: window-functions
19:19
Fix a problem with EXCLUDE clauses on window frames with no ORDER BY. check-in: e025506379 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: e195948a68 user: dan tags: window-functions
16:49
Add missing VdbeCoverage() macros to new code in window.c. check-in: 4f9b93e6cf user: dan tags: window-functions
15:36
When computing the amount of scratch memory needed during a rebalance operation, assume the worst case for the number of cells per page, rather than relying on the BtPage.nCell value, which might be incorrect for a corrupt database. check-in: a420ebd08f user: drh tags: trunk
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: c02f77b1b4 user: dan tags: window-functions
11:35
Tweak the tool/cg_anno.tcl script so that it can run on systems without /usr/bin/tclsh. check-in: a026189aa4 user: dan tags: trunk
11:17
Update this branch with latest trunk changes. check-in: 98cc265987 user: dan tags: window-functions
09:57
Add a LICENSE.md, containing the text of the blessing. check-in: cbb7e60272 user: drh tags: trunk
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