This Day In History For 2020-06-05
1 Year Ago (more context)
|
2019-06-05
| ||
| 14:29 | CLI enhancements: Add the ".filectrl" command. Make the ".testctrl" command visible to ".help". (check-in: 7b3a99fc user: drh tags: trunk) | |
| 13:14 | Add a test case for the unix SQLITE_FCNTL_CHUNK_SIZE file-control. (check-in: 3a477fd0 user: dan tags: trunk) | |
2 Years Ago (more context)
|
2018-06-05
| ||
| 23:51 | Update the version number to 3.25.0 for the next development cycle. (check-in: 7598236c user: drh tags: trunk) | |
| 23:21 | Avoid unnecessary loads of columns in an aggregate query that are not within an aggregate function and that are not part of the GROUP BY clause. (check-in: e15e1006 user: drh tags: trunk) | |
| 20:45 | Add the OP_IfNoHope and OP_SeekHit opcodes used to reduce the number of unnecessary sqlite3BtreeMovetoUnpacked() calls when checking for an early exit on IN-operator loops. Futher optimizations are likely possible here. (check-in: 6bf251af user: drh tags: multikey-opt-idea) | |
| 20:04 | Calculate non-aggregate expressions in the SELECT list of an aggregate query that does not use min() or max() once per group, instead of once per row visited. (Closed-Leaf check-in: dce2dfbe user: dan tags: exp-agg-opt) | |
| 16:16 | Add implementation of last_value() window function. (check-in: 2493ce1a user: dan tags: exp-window-functions) | |
| 15:16 | Use an OP_NotFound opcode to cancel futile IN operators early. The current implementation is suboptimal because it always runs teh OP_NotFound. This still needs to be enhanced to only do the OP_NotFound if no results have been seen on the current loop. (check-in: 87a9fc50 user: drh tags: multikey-opt-idea) | |
| 13:54 | Merge trunk changes. (check-in: 047295c5 user: drh tags: multikey-opt-idea) | |
| 13:43 | Update and correct the documentation on the OP_OpenRead, OP_OpenWrite, and OP_ReopenIdx opcodes. No code changes other than the addition of an assert(). (check-in: 8a0b730d user: drh tags: trunk) | |
3 Years Ago (more context)
|
2017-06-05
| ||
| 19:20 | Fix a subtle bug in the remember UDF of the kvtest.exe utility program. (check-in: 9eea3670 user: drh tags: trunk) | |
| 16:33 | Fix a bug in test_fs.c that occurs when the first component of a path contains a GLOB or LIKE escape character. (check-in: 73c70590 user: dan tags: trunk) | |
| 13:28 | For the kvtest utility, add the --vacuum option to "kvtest stat" and also run PRAGMA integrity_check with "kvtest stat". (check-in: f3c25df4 user: drh tags: trunk) | |
| 12:29 | Fix the column width deduction logic in the command-line shell to account for multi-byte utf8 characters. (check-in: ed0842c1 user: drh tags: trunk) | |
| 10:31 | Omit some of the fstree tests in vtabH if the PWD contains LIKE wildcards. (check-in: ead29f9c user: drh tags: trunk) | |
5 Years Ago (more context)
|
2015-06-05
| ||
| 22:33 | Split FROM-clause subquery flattening and code generation into separate loops. (check-in: be8e3fc7 user: drh tags: view-optimization) | |
| 20:27 | Provide one final Select tree dump prior to WHERE clause analysis when ".selecttrace 0x400" tracing bit is set with SELECTTRACE_ENABLED. Analysis and debug changes only - normal builds are unaffected. (check-in: 283bf0b6 user: drh tags: trunk) | |
| 19:05 | Make use of range constraints on the rowid field of an fts5 table in full-text queries. (check-in: 32cbc0ed user: dan tags: fts5) | |
| 15:59 | Add a new opcode to the VDBE that gives the b-tree a hint about the set of columns in a table or index that are actually used by the query. (Closed-Leaf check-in: f167bba4 user: drh tags: column-usage-hint) | |
10 Years Ago (more context)
|
2010-06-05
| ||
| 19:18 | Add further test cases for the logic in sqlite3WalBeginReadTransaction(). (check-in: a49713db user: dan tags: trunk) | |
| 18:34 | • Edit [c041c6a9786bc9eb|c041c6a9]: Edit check-in comment. Timestamp 2010-06-05 18:34:26. (artifact: 384ffb6e user: dan) | |
| 18:34 | Clarify the purpose of a test for a race-condition in sqlite3WalBeginReadTransaction(). (check-in: c041c6a9 user: dan tags: trunk) | |
| 18:12 | Remove a condition from sqlite3WalRead() that is unreachable as of the changes to clear entries out of the wal-index hash tables on transaction or savepoint rollback. (check-in: 39420473 user: dan tags: trunk) | |
| 14:42 | Mark a condition in wal.c as ALWAYS(). (check-in: 3fe0cc78 user: dan tags: trunk) | |
| 11:53 | Add extra coverage test cases for wal.c. No changes to production code. (check-in: f9d4ae0e user: dan tags: trunk) | |
20 Years Ago (more context)
|
2000-06-05
| ||
| 21:39 | added Agg opcodes to the vdbe (CVS 54) (check-in: e9ed5d2a user: drh tags: trunk) | |
| 18:56 | :-) (CVS 53) (check-in: 3dbfa558 user: drh tags: trunk) | |
| 18:54 | :-) (CVS 52) (check-in: c02268bd user: drh tags: trunk) | |
| 16:01 | separate Select structure (CVS 51) (check-in: ce45dea9 user: drh tags: trunk) | |
| 02:07 | :-) (CVS 50) (check-in: 1cf2873d user: drh tags: trunk) | |