/ Timeline
Login

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

2014-05-09
17:17
Merge recent trunk changes into the orderby-planning branch. Leaf check-in: 8d8609d6c6 user: drh tags: orderby-planning
2014-05-07
21:16
Include sqlite3rtree.h in the tsrc/ pile of source files during target_source in the main.mk makefile. check-in: 116bed5af6 user: drh tags: trunk
2014-05-02
18:05
Merge orderby-planning with this branch. check-in: d9549de317 user: dan tags: threads
17:33
Simplify assert() statements used to verify correct operation of record comparison routines. check-in: 3300d62dcb user: drh tags: orderby-planning
16:22
Failure to extend a temp file for use with mmap() in vdbesort.c is benign. check-in: d4d396387d user: drh tags: orderby-planning
15:25
Fix a faulty assert() statement. check-in: 9196ce4073 user: drh tags: orderby-planning
13:09
Merge latest trunk enhancements and fixes into the orderby-planning branch. check-in: 84862d3a09 user: drh tags: orderby-planning
00:09
Add a comment explaining why WhereLoop cost adjustments are omitted for skip-scan loops. check-in: 3bc43594aa user: drh tags: trunk
2014-04-24
16:25
Improved header comment on the vdbesort.c module. No changes to code. check-in: bf09ce24d0 user: drh tags: orderby-planning
15:06
Reopen the orderby-planning branch and merge in the latest trunk enhancements and fixes. check-in: 6077ddcd93 user: drh tags: orderby-planning
2014-04-21
13:36
Comment tweaks on the test case for the [b75a9ca6b0] bug fix. check-in: 65d2544af9 user: drh tags: trunk
2014-03-28
19:47
Fix a compiler warning and an after-OOM memory leak. check-in: 58f7ca2930 user: drh tags: orderby-planning
19:18
Merge latest changes from orderby-planning branch. check-in: 4c7fb54234 user: dan tags: threads
18:35
Merge the latest changes from trunk. check-in: 3047a25f1c user: drh tags: orderby-planning
14:41
Disable the wal64k.test script for non-unix systems since it depends on unix-only features. check-in: 27deb6e49b user: drh tags: trunk
2014-03-27
19:25
Instead of allocating a single large buffer at the beginning of each sort operation, start with a small buffer and extend it using realloc() as required. check-in: 81987c8ceb user: dan tags: orderby-planning
17:23
Use xFetch() to access temporary files in vdbesort.c. Use a single large allocation instead of many small allocations when accumulating records in vdbesort.c. This is an interim commit - it allocates a buffer the size of the page-cache every time data is sorted. check-in: f4ac1bf28c user: dan tags: orderby-planning
00:09
Merge the latest trunk changes and the fix for the crash on a corrupt database. check-in: 0b35346c32 user: drh tags: orderby-planning
2014-03-26
15:14
Add an extra test case for the potential buffer overread patched by [28ddecff04]. check-in: f585f5d7a0 user: dan tags: trunk
2014-03-25
18:29
Merge enhancements and fixes from trunk. check-in: e005f2d6dd user: drh tags: orderby-planning
17:45
Add another performance test case to speedtest1. This case is another ORDER BY test but this time without LIMIT. check-in: 9ab7ffd592 user: drh tags: trunk
17:07
Fix a problem in the code added by [707ea170b3] causing vdbesort.c to sort unstably. check-in: d3e640afe6 user: dan tags: orderby-planning
15:04
Remove the sequence values from sorter records used by ORDER BY as well. check-in: c3ae369783 user: dan tags: orderby-planning
2014-03-24
20:19
Omit the sequence value from sorter records used by GROUP BY queries that cannot use an index. check-in: 3f90abddc3 user: dan tags: orderby-planning
18:08
Avoid unnecessary moving of content between registers during an ORDER BY. check-in: 4f472accf0 user: drh tags: orderby-planning
09:34
Remove an unnecessary temporary register allocation. check-in: 5d506743f5 user: dan tags: orderby-planning
02:20
Remove a pointless OP_Once operation in ORDER BY clauses with LIMIT. check-in: e6c59d2331 user: drh tags: orderby-planning
01:43
Further enhancements to generated VDBE code for ORDER BY. check-in: e7188fad87 user: drh tags: orderby-planning
2014-03-23
18:47
merge fixes from trunk check-in: faf7f9caf5 user: drh tags: orderby-planning
17:45
Use only a single OP_MakeRecord instead of two when constructing entries to go onto a sorter. check-in: d696cdedac user: drh tags: orderby-planning
16:29
Avoid a possible use of an uninitialized variable following an I/O or OOM error. check-in: 641408a139 user: drh tags: trunk
2014-03-21
20:58
Add the ability to use indices for the first few terms of an ORDER BY clause, then sort in batches to handle the later terms. check-in: fa06a6fed9 user: drh tags: trunk
18:45
Merge the OFFSET-on-query-without-FROM fix from trunk. check-in: 71e9ae72c2 user: drh tags: orderby-planning
18:16
Fix the OFFSET clause so that it works correctly on queries that lack a FROM clause. Ticket [07d6a0453d4ed8]. check-in: 179ef81648 user: drh tags: trunk
15:24
New test case for block-sorting. check-in: e70cfa28aa user: drh tags: orderby-planning
2014-03-20
20:56
Merge trunk fixes for "x IN (?)" handling. check-in: eca35871c3 user: drh tags: orderby-planning
19:04
Remove a testcase() that is now always true due to the "x IN (?)" optimization. Add an ALWAYS() around a conditional in the parser that cannot be false. check-in: d5a1530bdc user: drh tags: trunk
2014-03-19
23:42
Merge the vdbesort.c optimization from trunk. check-in: e4bfffb988 user: drh tags: orderby-planning
23:24
Fix query planner weights associated with choosing block-sorting. Fix block sorting of tables with collating functions. Fix various test cases. All "veryquick" tests are now passing, though more tests need to be added. check-in: 01afbf97c0 user: drh tags: orderby-planning
20:01
Avoid some unnecessary calls to sqlite3VdbeRecordUnpack() that were being made when merging data from two or more temp files together in vdbesort.c check-in: 707ea170b3 user: dan tags: trunk
17:41
Make it possible for block-sort to use the OP_SorterOpen sorter in addition to a generic OP_OpenEphemeral. check-in: 7ce2daafd3 user: drh tags: orderby-planning
16:56
Fix a problem in the block-sort logic that can arise if the VDBE opcode array is resized while the block-sort logic is being coded. "make test" now runs to completion, though there are still 17 failures. check-in: 62f3a22050 user: drh tags: orderby-planning
15:17
Avoid reusing temporary registers in co-routines when doing block-sorting. check-in: 463d921b51 user: drh tags: orderby-planning
14:30
Make sure the where.c query planner never reports that the number of ORDER BY terms that are satisfied by indices is negative. check-in: b186d8d15a user: drh tags: orderby-planning
14:10
First attempt at getting block-sort to work. This is an incremental check-in. There are many problems still to be worked out. check-in: 59742dd4c5 user: drh tags: orderby-planning
2014-03-18
20:33
Make the partial-ORDER-BY information in the query planner available to the SELECT code generator. Still doesn't make a difference in the generated code. check-in: e258df236b user: drh tags: orderby-planning
18:59
Adjust the query planner to keep track of the number of ORDER BY terms satisfied. Still doesn't do anything with this information. Some tests fail after this check-in, but all failures are believed to be benign. The failures will be addressed at a later stage. check-in: 59d49b7fc4 user: drh tags: orderby-planning
15:30
Experiments with the optimization of ORDER BY and GROUP BY clauses. check-in: b150902579 user: drh tags: orderby-planning
2014-03-17
15:06
Clean up some obsolete "register" declarations in printf.c. check-in: ecd9d3f945 user: drh tags: trunk