SQLite
Timeline
Not logged in

All nodes on the path from [release] to [trunk]

2014-04-18
22:20
[9a5d38c79d] Leaf: Clean up the proper-subset cost adjustment logic to make it more compact and easier to read and so that full branch test coverage is more easily obtained. (user: drh, tags: trunk)
00:49
[2c5363873a] Add the SQLITE_RUNTIME_BYTEORDER compile-time option to force SQLite to check the processor byte-order at run-time. Add additional compile-time byte order checks for ARM, PPC, and SPARC. (user: drh, tags: trunk)
00:06
[9c6961967a] Add the SQLITE_TESTCTRL_BYTEORDER test control to interrogate SQLite's notion of the processor byte order and whether the byte order is known at compile-time or determined at run-time. (user: drh, tags: trunk)
2014-04-14
19:48
[c6fa8d0d82] Make sure the undocumented sqlite_rename_parent() function does not crash even if it is invoked with NULL arguments. Ticket [264b970c4379fd4b94] (user: drh, tags: trunk)
2014-04-13
19:28
[ab23abf392] Remove the unused second argument from sqlite3ExprCachePop(). Add an ALWAYS() on an always-true conditional in sqlite3VdbeResolveLabel(). (user: drh, tags: trunk)
19:15
[3122b83640] Make sure column cache elements are cleared correctly when jumping over code for key generation in a partial index. Fix for ticket [2ea3e9fe6379fc3f6]. (user: drh, tags: trunk)
2014-04-10
02:24
[a67b5312f6] Modify the OR-clause handling so that it can safely deal with OR-clause with 17 or more terms. Fix for ticket [10fb063b1179be53ea0b53bb]. (user: drh, tags: trunk)
2014-04-04
18:49
[2312eb6a9e] Performance improvements when reading large blobs, especially if SQLITE_DIRECT_OVERFLOW_READ is defined. (user: drh, tags: trunk)
18:20
[683dd379a2] Merge changes to the query planner that strive to ensure that any index usage that is a proper subset of some other index usage always has a slightly higher cost. (user: drh, tags: trunk)
14:12
[e54330b431] Ensure the "PRAGMA journal_mode=WAL" works coming from any other journal_mode with ATTACH-ed databases. (user: drh, tags: trunk)
2014-04-03
16:53
[a611fa96c4] Leaf: Version 3.8.4.3 (user: drh, tags: release, branch-3.8.4, version-3.8.4.3)
16:29
[d5513dfa23] Use OP_Copy instead of OP_SCopy when moving results out of a subquery, to prevent the subquery results from changing out from under the outer query. Fix for ticket 1e64dd782a126f48d78. (user: drh, tags: trunk)
16:18
[f05a49b6e0] Increase the version number to 3.8.4.3 (user: drh, tags: branch-3.8.4)
16:16
[ec6a06246e] Use OP_Copy instead of OP_SCopy when moving results out of a subquery, to prevent the subquery results from changing out from under the outer query. Fix for ticket 1e64dd782a126f48d78. (user: drh, tags: branch-3.8.4)
14:31
[48ecdd4aff] Fix a typo in the "Synopsis:" comment for the OP_VFilter opcode. (user: drh, tags: trunk)
00:32
[9d2ae6342c] In the command-line shell, run set writable_schema before running the ".clone" command. (user: drh, tags: trunk)
2014-03-31
13:42
[b3296267fb] Avoid a (harmless) buffer overread that is possible on an OOM when MEMSYS5 is engaged. (user: drh, tags: trunk)
2014-03-28
14:41
[27deb6e49b] Disable the wal64k.test script for non-unix systems since it depends on unix-only features. (user: drh, tags: trunk)
12:56
[a4e47150f3] Fix a harmless compiler warning. (user: drh, tags: trunk)
03:12
[7fa85eaaaf] 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. (user: drh, tags: trunk)
2014-03-27
18:36
[9b4d7226bc] 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. (user: drh, tags: trunk)
14:05
[b4bd2a062c] Enhance the logest.c utility with new operators: "dup", "inv", "log", and "nlogn". Provide help on an invalid input. (user: drh, tags: trunk)
2014-03-26
18:51
[02ea166372] Version 3.8.4.2 (user: drh, tags: release, branch-3.8.4, version-3.8.4.2)
16:25
[59978a2e42] Increase the version number to 3.8.4.2. (user: drh, tags: branch-3.8.4)
16:22
[db2935473e] Fix a potential buffer overread that could have occurred when searching a corrupt database file. (user: drh, tags: branch-3.8.4)
15:14
[f585f5d7a0] Add an extra test case for the potential buffer overread patched by 28ddecff04. (user: dan, tags: trunk)
15:05
[2b28e8d582] Add a test case to verify that the previous change avoids excess buffer overread in sqlite3VdbeRecordCompare(). (user: drh, tags: trunk)
14:51
[28ddecff04] Earlier detection of corruption in sqlite3VdbeRecordCompare() in order to avoid a potential buffer overread. (user: drh, tags: trunk)
12:02
[851abdb8fd] Add an assert() and a comment to clarify the operation of the vdbeRecordCompareInt() routine. (user: drh, tags: trunk)
2014-03-25
20:28
[7922809ee0] 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. (user: drh, tags: trunk)
17:45
[9ab7ffd592] Add another performance test case to speedtest1. This case is another ORDER BY test but this time without LIMIT. (user: drh, tags: trunk)
14:54
[588122641e] Add an ORDER BY test case to speedtest1.c (user: drh, tags: trunk)
11:00
[e6798871ce] 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. (user: drh, tags: trunk)
2014-03-24
16:30
[4d7551ce46] Remove unused variables Parse.nColCache and Parse.iColCache. (user: dan, tags: trunk)
15:00
[221f8f9447] Fix arithmetic operators so that they do not change the affinity of their input operands. Ticket [a8a0d2996a]. (user: drh, tags: trunk)
11:23
[db7d62c8d5] 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. (user: dan, tags: trunk)
2014-03-23
16:29
[641408a139] Avoid a possible use of an uninitialized variable following an I/O or OOM error. (user: drh, tags: trunk)
2014-03-22
02:19
[9b2838f23e] 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. (user: drh, tags: trunk)
01:52
[9760879d08] Increase the version number to 3.8.5. (user: drh, tags: trunk)
00:27
[c36f74611c] 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. (user: drh, tags: trunk)
2014-03-21
20:58
[fa06a6fed9] 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. (user: drh, tags: trunk)
19:56
[45d8cc678d] 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. (user: drh, tags: trunk)
19:27
[1f413aca00] Avoid leaking memory in an obscure case where the flattener adds an ORDER BY clause to the recursive part of a recursive query. (user: dan, tags: trunk)
18:16
[179ef81648] Fix the OFFSET clause so that it works correctly on queries that lack a FROM clause. Ticket [07d6a0453d4ed8]. (user: drh, tags: trunk)
2014-03-20
19:04
[d5a1530bdc] 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. (user: drh, tags: trunk)
18:45
[01944c53f5] Fix the EXPLAIN indenter in the command-line shell to correctly handle NextIfOpen and PrevIfOpen opcodes. (user: drh, tags: trunk)
17:03
[2ea4a9f75f] The "x IN (?)" optimization in check-ins 2ff3b25f40 and e68b427afb is incorrect, as demonstrated by the in4-5.1 test case in this check-in. The "COLLATE binary" that was being added to the RHS of IN was overriding the implicit collating sequence of the LHS. This change defines the EP_Generic expression node property that blocks all affinity or collating sequence information in the expression subtree and adds that property to the expression taken from RHS of the IN operator. (user: drh, tags: trunk)
15:14
[b1435f26b0] Fix harmless compiler warnings. (user: drh, tags: trunk)
14:56
[2ff3b25f40] Previous check-in is not quite correct. "x IN (?)" is not exactly the same as "x==?" do to collation and affinity issues. The correct converstion should be to "x==(+? COLLATE binary)". The current check-in fixes this problem and provides test cases. Ticket [e39d032577df69] (user: drh, tags: trunk)
13:26
[e68b427afb] Convert expressions of the form "X IN (?)" with exactly one value on the RHS of the IN into equality tests: "X=?". Add test cases to verify that statements work correctly on this corner case. Fix for ticket [e39d032577df6942]. (user: drh, tags: trunk)
12:17
[ca31408131] Fix an unnecessarily obtuse use of a bitmask flag. (user: drh, tags: trunk)
2014-03-19
20:01
[707ea170b3] Avoid some unnecessary calls to sqlite3VdbeRecordUnpack() that were being made when merging data from two or more temp files together in vdbesort.c (user: dan, tags: trunk)
2014-03-17
15:06
[ecd9d3f945] Clean up some obsolete "register" declarations in printf.c. (user: drh, tags: trunk)
14:24
[eb071eb58c] Performance enhancements and size reduction for sqlite3VXPrintf() (user: drh, tags: trunk)
2014-03-14
11:46
[1277932b7e] Fix a harmless compiler warning that crops up with SQLITE_MAX_MMAP_SIZE=0. (user: drh, tags: trunk)
2014-03-12
19:38
[6504aa47a8] Fix an obscure bug causing sqlite3_close() to fail if there are virtual tables on the disconnect list when it is called. (user: dan, tags: trunk)
19:20
[c67a52c356] Changes to FTS to ensure that it does not access the database from within the xConnect method. (user: dan, tags: trunk)
12:44
[7ce03c1b55] Prevent the rtree module from reading sqlite_stat1 data from the wrong database. (user: dan, tags: trunk)
2014-03-11
15:27
[018d317b12] Version 3.8.4.1 (user: drh, tags: trunk, release, version-3.8.4.1)