/ Timeline
Login

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

50 check-ins occurring around 954bf369935083c1.

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
14:08
Add an "|| CORRUPT_DB" term to an assert() that might be false if the database is corrupt. Also add a branch to have sqlite3PagerMovepage() return SQLITE_CORRUPT in that case. check-in: b0d5cf40bb user: drh tags: trunk
2019-03-05
23:49
Fix a potential 32-bit integer overflow in the "showdb" utility program when it is trying to interpret a corrupt database file. check-in: 3803e75038 user: drh tags: trunk
19:29
Extend windowCodeStep() to handle any ROWS PRECEDING/FOLLOWING frame specification. check-in: af0ea13635 user: dan tags: window-functions
16:53
Add a script to tool/ that will extract the sqlite3.h header file from an sqlite3.c amalgamation. check-in: 38d2e510cd user: drh tags: trunk
14:47
New dbfuzz2 test cases added to test/fuzzdata7.db check-in: 25975e1fb2 user: drh tags: trunk
14:39
If the initial byte of a record is a large value, then always used the generalized record comparison routine sqlite3VdbeRecordCompare() rather than one of the specialized versions that are optimized for shorter records. check-in: c1ac00706b user: drh tags: trunk
2019-03-04
21:08
Merge trunk changes into this branch. check-in: 9b4d561f68 user: dan tags: window-functions
21:07
Support some "ROWS BETWEEN N PRECEDING AND M FOLLOWING" window functions without caching entire partitions. check-in: e7a91f1228 user: dan tags: window-functions
07:25
Merge latest trunk changes into this branch. check-in: 97a9604d85 user: dan tags: reuse-schema
07:15
Fix a problem preventing compilation with SQLITE_OMIT_UTF16. check-in: 906d1fd865 user: dan tags: trunk
2019-03-02
20:09
Improved comments on the fossildelta.c extension. check-in: d7d23f0450 user: drh tags: trunk