SQLite

Today In History
Login

This Day In History For 2020-06-09

2 Years Ago (more context)

2018-06-09
20:52
Fix a typo in the amalgamation autoconf file. (check-in: de0857f3 user: drh tags: trunk)
18:09
Merge recent trunk changes with this branch. (check-in: c71f2359 user: dan tags: exp-window-functions)
17:58
Update the amalgamation build script to include window.c. (check-in: 21d2f4a6 user: dan tags: exp-window-functions)
17:43
Add support for FILTER clause on aggregate window functions. (check-in: ceaf798e user: dan tags: exp-window-functions)
16:49
Slightly smaller and faster code by encapsulating wal-index hash table location information in a separate WalHashLoc object rather than passing around the various elements as separate variables. (check-in: 538a365b user: drh tags: trunk)
14:13
Improved comments an presentation for the recent IN operator decision improvement. (check-in: 31e480f6 user: drh tags: trunk)
02:49
Performance improvement to sqlite3WhereExprUsage(). (check-in: fd093413 user: drh tags: trunk)
01:12
Compute the bitmask of indexed columns for each index once when the Index objecct is constructed, instead of recomputing it every time it is needed. (check-in: d735872e user: drh tags: trunk)
00:09
Avoid invoking the whereLoopAddOr() routine in the query planner if there are no OR operators in the WHERE clause, thus speeding up query planning slightly. (check-in: 292724ff user: drh tags: trunk)

3 Years Ago (more context)

2017-06-09
15:14
Merge enhancements and fixes from trunk. (check-in: 3fd050c3 user: drh tags: prepare_v3)
11:43
Update the documentation to make it clear that the table name parameter to sqlite3_table_column_metadata() may not be NULL. (check-in: 2881ab1e user: drh tags: trunk)
02:27
Adjust the implementation of the ".selftest" feature of the shell to avoid using the deprecated sqlite3_get_table() interface. (check-in: 3168e2c9 user: drh tags: trunk)

5 Years Ago (more context)

2015-06-09
20:58
Add the "columnsize=" option to fts5, similar to fts4's "matchinfo=fts3". (check-in: aa12f9d9 user: dan tags: fts5)
15:58
Add the --output=$file and --verbose=(0|1|file) options to tester.tcl. (check-in: f7b2c703 user: dan tags: trunk)
10:58
Remove some repeated lines of source code. Probably introduced by careless cut'n'pasting. (Closed-Leaf check-in: a34cd71c user: dan tags: vtab-left-join)

10 Years Ago (more context)

2010-06-09
19:01
Fix test script problems causing errors in the "inmemory_journal" permutations. (check-in: ea05b7f9 user: dan tags: trunk)
18:46 Edit [0797b10c0cc08ae3|0797b10c]: Edit check-in comment. Timestamp 2010-06-09 16:58:50. (artifact: e55f0d38 user: drh)
16:58
When restarting (wrapping) a log file, set all unused aReadMark[] slots to READMARK_NOT_USED instead of 0. Setting them to 0 does not cause a problem, but may cause SQLite to obtain and release a few more file locks than would otherwise be necessary. (check-in: 0797b10c user: dan tags: trunk)
16:16 Fixed ticket [f973c7ac]: Incorrect affinity for indexed range constraint plus 2 other changes (artifact: 9b2cbacd user: drh)
15:47
Fix for ticket [f973c7ac31]. (check-in: 6eb058dd user: dan tags: trunk)
15:20 New ticket [f973c7ac] Incorrect affinity for indexed range constraint. (artifact: def6ef22 user: drh)
14:45
Shift the meaning of aReadMark[] back so that +1 offset from mxFrame is removed. Add the new READMARK_NOT_USED value (0xffffffff) instead of zero to signal an aReadMark[] that is not in use. (check-in: c576827d user: drh tags: trunk)
12:30 Edit [7c102c7b5f90717f|7c102c7b]: Change branch background color to "#ffc0d0". Move to branch mistake. Mark "Closed". Timestamp 2010-06-09 11:02:13. (artifact: 9e3e9ca2 user: drh)
11:30 Edit [7c102c7b5f90717f|7c102c7b]: Timestamp 2010-06-09 11:02:13. Cancel tag "trunk". (artifact: 4d073dc2 user: dan)
11:29 Edit [7c102c7b5f90717f|7c102c7b]: Timestamp 2010-06-09 11:02:13. Add tag "mistake". (artifact: 4ca4f62e user: dan)
11:28
Simpler fix for the race condition also fixed by [7c102c7b5f] (check-in: 3c2de820 user: dan tags: trunk)
11:02
Fix for race condition in WAL locking code. (Closed-Leaf check-in: 7c102c7b user: dan tags: mistake)

20 Years Ago (more context)

2000-06-09
14:14
:-) (CVS 91) (check-in: d573b431 user: drh tags: trunk)
03:52
:-) (CVS 90) (check-in: aba926bb user: drh tags: trunk)
03:51
:-) (CVS 89) (check-in: 8de283de user: drh tags: trunk)
03:47
:-) (CVS 88) (check-in: 3252269e user: drh tags: trunk)
01:58
:-) (CVS 87) (check-in: 3661b5ff user: drh tags: trunk)