/ Timeline
Login

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

50 check-ins occurring around b415dfb6cb0df0c6.

2014-03-28
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
12:56
Fix a harmless compiler warning. check-in: a4e47150f3 user: drh tags: trunk
03:12
Enhance the sqlite3VdbeRecordCompare() routines so that if they encounter database corruption, they will set the UnpackedRecord.isCorrupt field and return 0. The sqlite3BtreeMovetoUnpacked() routine detects this and returns SQLITE_CORRUPT, causing the corruption to be reported back to the top-level. check-in: 7fa85eaaaf 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
18:36
Minor cleanup of the code in the query planner that computes the costs estimates for the various plans. There are no changes to the costs at this time. But the code is slightly more readable now and that might facilitate future enhancements. check-in: 9b4d7226bc user: drh tags: trunk
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
14:05
Enhance the logest.c utility with new operators: "dup", "inv", "log", and "nlogn". Provide help on an invalid input. check-in: b4bd2a062c user: drh tags: trunk
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
19:45
Merge from trunk the fix for the crash on a corrupt database. check-in: 8cb2b02baa user: drh tags: threads
19:43
Merge in fixes (including the corrupt-database crash fix) and performance enhancements from trunk. check-in: fc8ca1a87e user: drh tags: sessions
18:51
Version 3.8.4.2 check-in: 02ea166372 user: drh tags: release, version-3.8.4.2, branch-3.8.4
16:25
Increase the version number to 3.8.4.2. check-in: 59978a2e42 user: drh tags: branch-3.8.4
16:22
Fix a potential buffer overread that could have occurred when searching a corrupt database file. check-in: db2935473e user: drh tags: branch-3.8.4
15:14
Add an extra test case for the potential buffer overread patched by [28ddecff04]. check-in: f585f5d7a0 user: dan tags: trunk
15:05
Add a test case to verify that the previous change avoids excess buffer overread in sqlite3VdbeRecordCompare(). check-in: 2b28e8d582 user: drh tags: trunk
14:51
Earlier detection of corruption in sqlite3VdbeRecordCompare() in order to avoid a potential buffer overread. check-in: 28ddecff04 user: drh tags: trunk
12:02
Add an assert() and a comment to clarify the operation of the vdbeRecordCompareInt() routine. check-in: 851abdb8fd user: drh tags: trunk
2014-03-25
20:28
Adjust the repeat counts on several tests in speedtest1 so that the relative time spent on the test is roughly the same regardless of --size. check-in: 7922809ee0 user: drh tags: trunk
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
14:54
Add an ORDER BY test case to speedtest1.c check-in: 588122641e user: drh tags: trunk
14:12
Enable four sorting threads by default in the command-line shell. check-in: 1cab83577c user: drh tags: threads
13:17
Merge all fixes and enhancements from trunk. check-in: b415dfb6cb user: drh tags: threads
11:00
Detect when a VdbeCursor is still pointing at a valid row but that row has moved, and invalidated the return from prior sqlite3BtreeDataFetch() or sqlite3BtreeKeyFetch() calls. check-in: e6798871ce user: drh tags: trunk
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
16:30
Remove unused variables Parse.nColCache and Parse.iColCache. check-in: 4d7551ce46 user: dan tags: trunk
15:00
Fix arithmetic operators so that they do not change the affinity of their input operands. Ticket [a8a0d2996a]. check-in: 221f8f9447 user: drh tags: trunk
12:33
Cancel column-cache entries that are involved in a comparison operator since the comparison might have forced an affinity change. Originally proposed as a fix for ticket [a8a0d2996a], but later determined to be incorrect. Closed-Leaf check-in: 0b95b7a874 user: drh tags: tkt-a8a0d2996a
11:23
Avoid attempting to mmap memory from an offset that is not a multiple of the system page size on systems with page sizes larger than 32KB. check-in: db7d62c8d5 user: dan tags: trunk
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-22
02:19
Clear the sort-order flags on the KeyInfo object associated with the OP_Compare/OP_Jump of the block-sort logic, in order to make the OP_Jump fully testable. check-in: 9b2838f23e user: drh tags: trunk
01:52
Increase the version number to 3.8.5. check-in: 9760879d08 user: drh tags: trunk
00:27
Fix the ORDER BY optimization logic so that it will do a block-sort on a partial DESC ORDER BY. This enhancement uncovered a memory leak in pushUntoSorter() which is also fixed. check-in: c36f74611c 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
19:56
Change the names of SRT_DistTable and SRT_Table used by CTE to more meaningful SRT_DistFifo and SRT_Fifo, respectively. Simplify the IgnorableOrderby() macro in the process. check-in: 45d8cc678d user: drh tags: trunk
19:27
Avoid leaking memory in an obscure case where the flattener adds an ORDER BY clause to the recursive part of a recursive query. check-in: 1f413aca00 user: dan 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
18:56
Only use the direct-overflow-read optimization if all data from the overflow page in question is being read. check-in: d8e1f75ddf user: dan tags: overflow-pgno-cache