Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
8 descendants and 50 ancestors of 9e14aa14cff7ebf7
|
2016-04-21
| ||
| 15:44 | Merge the latest changes from trunk. (Closed-Leaf check-in: 8183fa6829 user: drh tags: skip-ahead-distinct) | |
|
2016-04-15
| ||
| 22:03 | Add the SQLITE_SkipAhead optimization setting (check-in: 87703b7661 user: drh tags: skip-ahead-distinct) | |
| 16:27 | Skip-ahead is now just an optimization. If it gets confused, it falls back to an incremental scan with redundancy elimination. (check-in: 6fac0b9212 user: drh tags: skip-ahead-distinct) | |
| 16:17 | Skip-ahead does not always work. So we still have to check for redundancy. (check-in: db5a2364eb user: drh tags: skip-ahead-distinct) | |
| 15:54 | Fixes to the skip-ahead distinct logic. More issues remain. (check-in: 45a70b2bb8 user: drh tags: skip-ahead-distinct) | |
| 15:06 | Merge enhancements from trunk, especially the ".eqp full" enhancement to the command-line shell. (check-in: 491f0dbd63 user: drh tags: skip-ahead-distinct) | |
| 14:13 | Several new test cases that cause failures. (check-in: 0379f2cff6 user: drh tags: skip-ahead-distinct) | |
| 13:24 | Fixed crash bugs. Still sometimes gets the wrong answers. (check-in: 2afcb2c752 user: drh tags: skip-ahead-distinct) | |
| 01:55 | Progress toward getting DISTINCT to use a seek to advance to the next distinct row, when driven by an appropriate index. (check-in: 9e14aa14cf user: drh tags: skip-ahead-distinct) | |
|
2016-04-14
| ||
| 19:29 | Work toward improving analysis and code generation for DISTINCT and aggregate queries. (Leaf check-in: 129083bd5e user: drh tags: better-distinct-agg) | |
| 16:40 | Add the SF_HasAgg constant (currently unused). Also enhance the comments on many other constant definitions to detail constraints on their values. (check-in: 7b7a69d098 user: drh tags: trunk) | |
| 15:44 | Correctly interpret negative "PRAGMA cache_size" values when determining the cache-size used for sorting large amounts of data (i.e. the functionality in vdbesort.c). (check-in: 79147dca87 user: dan tags: trunk) | |
| 15:38 | Add some missing testcase() macros to the pushDownWhereTerms() routine. (check-in: 67d7f79c5e user: drh tags: trunk) | |
| 13:35 | Rename WhereInfo.pResultSet to pDistinctSet to more accurately reflect what it represents. (check-in: 5317961411 user: drh tags: trunk) | |
| 13:16 | Since the return value of sqlite3OsClose() is always ignored, we might as well make it "void" instead of "int", and thereby save 50 bytes in the compiled binary. (check-in: 7ee570e7a9 user: drh tags: trunk) | |
| 13:06 | Additional ".selecttrace" debugging output when the query is transformed from a DISTINCT into a GROUP BY. (check-in: 5a46914510 user: drh tags: trunk) | |
|
2016-04-13
| ||
| 21:00 | Fix compiler warnings by removing surplus local variables in the schema pretty-printer logic of the command-line shell. (check-in: 55a62483b9 user: drh tags: trunk) | |
| 15:52 | Fixes for harmless compiler warnings. (check-in: 68142dc541 user: drh tags: trunk) | |
| 15:33 | Add the --indent option to the .schema and .fullschema commands in the shell, to enable simple but effective pretty-printing. (check-in: 83cfe82cd6 user: drh tags: trunk) | |
|
2016-04-12
| ||
| 20:26 | A couple more compiler warning fixes. (Closed-Leaf check-in: 929fa4c31e user: mistachkin tags: warnings) | |
| 20:15 | Even more compiler warning fixes. (check-in: 7faec9ea33 user: mistachkin tags: warnings) | |
| 20:05 | More harmless compiler warning fixes. (check-in: ab69527c16 user: mistachkin tags: warnings) | |
| 19:30 | Compilation fix for a C99-ism in the 'fts3view' tool. (check-in: bedb88a4b9 user: mistachkin tags: trunk) | |
| 19:20 | Fix harmless compiler warnings in the 'session' module. (check-in: a18a6ce227 user: mistachkin tags: trunk) | |
| 17:13 | Fix speedtest1 so that it automatically unlinks its test database prior to startup. (check-in: b65b69f6b6 user: drh tags: trunk) | |
| 16:59 | Add the --temp option to the speedtest1.c performance test program. (check-in: 8053a6e2bf user: drh tags: trunk) | |
| 16:23 | Improved localtime() support for WindowsCE (check-in: 662c32af02 user: drh tags: trunk) | |
| 16:11 | Add and adjust comments. (Closed-Leaf check-in: 541c6da238 user: mistachkin tags: winCeLocalTime) | |
| 16:04 | Add the sqlite3_snapshot_cmp() interface (available only with SQLITE_ENABLE_SNAPSHOT). (check-in: 7e72896551 user: drh tags: trunk) | |
| 15:14 | Update the documentation for sqlite3_snapshot_cmp() to make the circumstances under which the comparison is valid clearer. Add tests for the same. (Closed-Leaf check-in: 8fc834741b user: dan tags: snapshot-cmp) | |
| 11:58 | Update the header comment on the memjournal.c file. No code changes. (check-in: 07f10deabb user: drh tags: trunk) | |
| 00:26 | Performance optimization the Vdbe allocator. (check-in: e2c4995bf1 user: drh tags: trunk) | |
| 00:16 | Avoid unnecessary calls to object destructors for a small performance gain. (check-in: aec94b6ee6 user: drh tags: trunk) | |
| 00:00 | Performance improvements in sqlite3WhereExprUsage(). (check-in: fdf752394b user: drh tags: trunk) | |
|
2016-04-11
| ||
| 22:45 | Further refinements. (check-in: b35bb928b2 user: mistachkin tags: winCeLocalTime) | |
| 22:24 | Merge updates from trunk. (check-in: b8094166b3 user: mistachkin tags: winCeLocalTime) | |
| 22:23 | Fix typo in the MSVC makefile. (check-in: 3189a7f185 user: mistachkin tags: trunk) | |
| 22:10 | Fix some compilation issues. (check-in: 016481b39f user: mistachkin tags: winCeLocalTime) | |
| 19:59 | Add the sqlite3_snapshot_cmp() API. (check-in: c698a21af7 user: dan tags: snapshot-cmp) | |
| 19:01 | Performance optimization to sqlite3Dequote() and its callers. (check-in: 9efe2265b1 user: drh tags: trunk) | |
| 18:25 | Performance optimization for the sqlite3ExprListDelete() routine. (check-in: 2764aeaa11 user: drh tags: trunk) | |
| 18:15 | Performance optimizations in the column cache of the code generator, and especially the sqlite3ExprCacheRemove() routine. (check-in: e35b345cf8 user: drh tags: trunk) | |
| 16:43 | Simplification and performance improvements in sqlite3ExprDup() and its subroutines. More work is possible in this area. (check-in: 476cc28388 user: drh tags: trunk) | |
| 16:35 | Rename the OP_MX_JUMP macro to SQLITE_MX_JUMP_OPCODE to avoid confusing the opcode name generator. (check-in: e554a4c38b user: drh tags: trunk) | |
| 14:49 | Performance improvement in sqlite3ExprDelete(). (check-in: 60ad80e3af user: drh tags: trunk) | |
| 13:36 | Remove the VdbeOp.opflags field and its associated initialization overhead. Update mkopcodeh.tcl to reorder opcode numbers to help the resolveP2Values() routine run faster. (check-in: 099478fa75 user: drh tags: trunk) | |
| 01:43 | Back off of the parser optimization in the previous check-in, slightly, to preserve some backwards compatibility regarding some undocumented behavior in the '#AAA' style query parameter. (check-in: ef1966c246 user: drh tags: trunk) | |
| 01:26 | Small size reduction and performance improvement in the parser. (check-in: 16df71284b user: drh tags: trunk) | |
| 01:06 | Factor out the common operation of setting the Expr.x.pSelect field of an Expr object into a subroutine. (check-in: 6a5cceee48 user: drh tags: trunk) | |
|
2016-04-09
| ||
| 18:04 | Fix a problem in the code generator for joins on virtual tables where the outer loop of the join uses the IN operator. (check-in: 6c56b3a047 user: drh tags: trunk) | |
| 17:04 | Fix the sqlite3BtreeDelete() routine so that it preserves the correct key even when the row being deleted is not on a leaf page. Fix for ticket [a306e56ff68b8fa56] (check-in: ca2ef8a86c user: drh tags: trunk) | |
| 14:36 | Limit the number of digits shown in the "prereq" mask for ".wheretrace" debugging output. (check-in: 3686ed7413 user: drh tags: trunk) | |
|
2016-04-08
| ||
| 19:44 | Update documentation for sqlite3_snapshot_open(). No code changes. (check-in: 1dfa5234d3 user: drh tags: trunk) | |
|
2016-04-07
| ||
| 21:14 | Add test cases for ticket [7f7f8026eda387d544]. (check-in: 87aa9357fb user: drh tags: trunk) | |
| 18:42 | Prevent the in-memory journal read cursor from entering an inconsistent state when it reads the last few bytes out of the journal file. Fix for ticket [7f7f8026eda38]. (check-in: c4b9c611bd user: drh tags: trunk) | |
| 14:16 | Avoid decrementing a pointer off the front end of the buffer in OP_MakeRecord. (check-in: 153135bfb3 user: drh tags: trunk) | |
| 14:05 | Instead of just commenting out the unneeded code in the previous check-in, remove it completely. (check-in: 8415d4848a user: drh tags: trunk) | |
| 14:01 | Remove an unnecessary test for a NULL pointer in freeP4(). (check-in: e84e88e31b user: drh tags: trunk) | |
| 13:45 | Update comments on the unix file locking protocol. No changes to code. (check-in: 716b20de43 user: drh tags: trunk) | |