SQLite
Timeline
Not logged in

200 most recent timeline items related to "trunk"

2014-04-23
12:57
[e2c9f71a45] Leaf: Merge all recent trunk changes into the threads branch. (user: drh, tags: threads)
12:00
[2029a396dc] Leaf: Enhancements to the date and time functions so that they optionally support a 5-digit year. Not sure we want to include this in trunk. Saved in a branch for future reference. (user: drh, tags: five-digit-year)
2014-04-22
19:30
[03e3c5a8b1] Add the win32-none VFS which omits rollback-journal locking. (user: drh, tags: win32-none)
2014-04-21
13:36
[65d2544af9] Leaf: Comment tweaks on the test case for the [b75a9ca6b0] bug fix. (user: drh, tags: trunk)
13:21
[de9a490f59] Avoid discarding an ORDER BY clause in the case where an identical GROUP BY clauses uses an index to group, but not sort, the rows. Fix for [b75a9ca6b0]. (user: dan, tags: trunk)
2014-04-18
22:20
[9a5d38c79d] 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)
12:38
[8729aa3e3e] Merge recent trunk changes into the threads branch. (user: drh, tags: threads)
01:10
[95e77efe07] Leaf: Merge recent trunk changes into sessions. (user: drh, tags: sessions)
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:08
[a1b2f28ba8] Preliminary changes to support building VSIX packages for Windows Phone 8.1. (user: mistachkin, tags: vsixWinPhone81)
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:37
[39ac79cffe] Merge the latest trunk changes into the threads branch. (user: drh, tags: threads)
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:42
[a0910079ad] Merge all recent changes from trunk. (user: drh, tags: threads)
16:35
[9515c8344a] Merge all recent changes from trunk, including the fix for the OP_SCopy-vs-OP_Copy problem. (user: drh, tags: sessions)
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)
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-04-01
01:24
[834bf1c367] Closed-Leaf: Remove an unnecessary conditional, replacing it with an assert(). Improvements to comments. (user: drh, tags: overflow-pgno-cache)
2014-03-31
22:03
[f6211540c9] Merge in the latest changes and fixes from trunk. (user: drh, tags: overflow-pgno-cache)
20:05
[7473c4dfc1] Closed-Leaf: Remove an unnecessary conditional. (user: drh, tags: query-plan-experiments)
13:42
[b3296267fb] Avoid a (harmless) buffer overread that is possible on an OOM when MEMSYS5 is engaged. (user: drh, tags: trunk)
2014-03-29
21:16
[8f869ca7a6] Experiments in picking better query plans, especially when the usage of one index is a subset of another. (user: drh, tags: query-plan-experiments)
2014-03-28
18:35
[3047a25f1c] Merge the latest changes from trunk. (user: drh, tags: orderby-planning)
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)
00:09
[0b35346c32] Merge the latest trunk changes and the fix for the crash on a corrupt database. (user: drh, tags: orderby-planning)
2014-03-26
19:45
[8cb2b02baa] Merge from trunk the fix for the crash on a corrupt database. (user: drh, tags: threads)
19:43
[fc8ca1a87e] Merge in fixes (including the corrupt-database crash fix) and performance enhancements from trunk. (user: drh, tags: sessions)
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)
18:29
[e005f2d6dd] Merge enhancements and fixes from trunk. (user: drh, tags: orderby-planning)
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)
13:17
[b415dfb6cb] Merge all fixes and enhancements from trunk. (user: drh, tags: threads)
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)
12:33
[0b95b7a874] Closed-Leaf: 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. (user: drh, tags: tkt-a8a0d2996a)
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
18:47
[faf7f9caf5] merge fixes from trunk (user: drh, tags: orderby-planning)
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:45
[71e9ae72c2] Merge the OFFSET-on-query-without-FROM fix from trunk. (user: drh, tags: orderby-planning)
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
20:56
[eca35871c3] Merge trunk fixes for "x IN (?)" handling. (user: drh, tags: orderby-planning)
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:36
[eae6dfbe55] Closed-Leaf: One possible fix for the [e39d032577d] problem it to replace the failing assert() with a testcase() as shown here. (user: drh, tags: tkt-e39d0325)
12:17
[ca31408131] Fix an unnecessarily obtuse use of a bitmask flag. (user: drh, tags: trunk)
09:42
[e3d2be3ba4] Closed-Leaf: Add a test to ensure os_unix.c works with 64KiB OS pages. (user: dan, tags: shm-mapping-fix)
08:59
[6f3a5c24d2] Add an experimental fix to 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: shm-mapping-fix)
2014-03-19
23:42
[e4bfffb988] Merge the vdbesort.c optimization from trunk. (user: drh, tags: orderby-planning)
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-18
15:30
[b150902579] Experiments with the optimization of ORDER BY and GROUP BY clauses. (user: drh, tags: orderby-planning)
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-13
15:41
[d17231b63d] Merge latest trunk changes into this branch. (user: dan, tags: threads)
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)
10:03
[42c9d8fc5f] Bump the version number to 3.8.4.1., to conform with trunk. (user: drh, tags: sessions)
2014-03-11
20:33
[da59198505] Enable the b-tree cursor object's overflow page-number cache, which is normally enabled only for incr-blob cursors, for all cursors. (user: dan, tags: overflow-pgno-cache)
15:27
[018d317b12] Version 3.8.4.1 (user: drh, tags: trunk, release, version-3.8.4.1)
15:25
[33f5694fa4] Update version number to 3.8.4.1 (user: drh, tags: trunk)
14:44
[04caffcef3] Closed-Leaf: Forgot to change the VERSION file. (user: drh, tags: mistake)
09:19
[5527e23636] Add a test to see what happens if an rtree constructor encounters an SQLITE_BUSY error. No changes to code. (user: dan, tags: trunk)
01:48
[917c410808] Version 3.8.4 for sessions (plus two minor fixes). (user: drh, tags: sessions)
2014-03-10
20:12
[0769eebd02] Adjustments to the cost computation for the skip-scan query plan, to take into account the fact that a seek has to occur on each skip. (user: drh, tags: trunk)
18:03
[0a5318bc27] Attempt to work around MSVC's treatment of __LINE__ as a non-constant value in "Edit and Continue" mode by avoiding the use of __LINE__ when SQLITE_VDBE_COVERAGE is not defined. (user: drh, tags: trunk)
12:20
[530a1ee7dc] Version 3.8.4 (user: drh, tags: trunk, release, version-3.8.4)
2014-03-08
19:07
[ba39df9d4f] Fix a bug causing "SELECT char()" to return SQLITE_NOMEM. (user: dan, tags: trunk)
2014-03-07
14:57
[e5b17a9d07] Improved comment on the pager.c PERSIST rollback journal delete logic inside of hasHotJournal(). No changes to code. (user: drh, tags: trunk)
14:36
[bb6a75f4bb] Merge the fix for the journal_mode=PERSIST error recovery delay bug. (user: drh, tags: sessions)
03:31
[1c318ef3b7] Revise change from the previous check-in to clarify the situation when handling open journal files, regardless of journal mode. (user: mistachkin, tags: trunk)
02:29
[fdc651e2ec] Avoid calling sqlite3OsDelete() on a file that is open, since this causes Windows to run *very* slowly. Comes up on error recovery in journal_mode=PERSIST. (user: mistachkin, tags: trunk)
2014-03-06
18:16
[c0d54b4e41] Do not run corruptH.test in mmap mode. (user: dan, tags: trunk)
13:48
[1ed463d918] Merge the latest 3.8.4 tweaks from trunk. (user: drh, tags: sessions)
13:38
[0a4200f95c] Improved EXPLAIN indentation of a loop in the ANALYZE logic for STAT4. Mark the not-found jump of a seek operation in that loop as never taken. (user: drh, tags: trunk)
12:36
[4a4997221f] Remove a branch that is never taken from where.c. (user: dan, tags: trunk)
02:15
[c87d8e07ec] Cosmetic change to the shell in-memory database warning to skip coloring the trailing period. (user: mistachkin, tags: trunk)
01:56
[b83cfe899d] Fix some incorrect comments and typos in comments. Add testcase() macros to some of the new record comparison code. (user: drh, tags: trunk)
00:30
[29b0a4f158] Better loadable extension handling in the Win32 VFS when compiled for Cygwin. (user: mistachkin, tags: trunk)
00:28
[170e058520] Better support for MinGW 4.x. (user: mistachkin, tags: trunk)
2014-03-05
23:12
[a1f2b04285] Merge compiler-warning fixes from trunk. (user: drh, tags: sessions)
19:36
[bfd75f471a] Always include the ctype.h header in the spellfix.c extension. (user: drh, tags: trunk)
19:13
[e406d4bb78] Avoid running a couple of test cases that use realloc() extensively if SQLITE_MEMDEBUG is defined. (user: dan, tags: trunk)
19:04
[0723effc9c] Fix a harmless compiler warning on MSVC. (user: drh, tags: trunk)
17:29
[f33f2b3f92] Add SQLITE_OMIT_CTE to the list of compile options that might be returned by "PRAGMA compile_options". (user: dan, tags: trunk)
16:15
[ef1a998625] Add tests to join.test to verify that it is not possible to use more than 64 tables in a join. (user: dan, tags: trunk)
15:52
[eee2a13f2c] Count the number of elements in a SrcList object using an "int" rather than a "u8", to avoid overflows and to work around an issue in the C compiler on AIX. (user: drh, tags: trunk)
15:04
[d4fbc05df9] Add a test case for the problem fixed by 1d134ba2ed. (user: dan, tags: trunk)
14:49
[0828975d58] Merge in various obscure bug fixes and the removal of Mem.memType from trunk. (user: drh, tags: sessions)
14:40
[1d134ba2ed] When converting a result type from TEXT to BLOB using the sqlite3_value_blob() interface, continue to report SQLITE_TEXT as the true type from sqlite3_value_text() as long as that text is still valid. The maintains legacy behavior from before the noMemType change. (user: drh, tags: trunk)
12:47
[12cbebb997] Separate the column NULL value constant into a separate routine for greater commonality with the sessions branch. (user: drh, tags: trunk)
11:48
[9e85285789] Remove the redundant memType field from struct Mem. (user: dan, tags: trunk)
11:22
[378b290da8] Do not run corruptI.test with the mmap permutation. (user: dan, tags: trunk)
01:29
[bac2820e13] Closed-Leaf: Experimental simplification of memory flags/type handling. (user: mistachkin, tags: noMemType)
2014-03-04
21:19
[554501f158] Avoid indexing off the front end of an array when creating a view with two or more blank column names in the SELECT statement that defines the view. (user: drh, tags: trunk)
21:00
[e072cb3ee2] Fix a problem with "DEFAULT (-(-9223372036854775808))" clauses in ALTER TABLE ... ADD COLUMN commands. (user: dan, tags: trunk)
18:06
[767ccb1fa1] Fix a potential memory use-after-free problem following an OOM error. (user: drh, tags: trunk)
16:21
[53f6ec792f] Fix an assert() so that it takes OOM errors into account. (user: drh, tags: trunk)
16:05
[2879234b7c] Ensure that BtreeMovetoUnpacked() does not try to invoke xRecordCompare when it is set to NULL. (user: dan, tags: trunk)
14:34
[7f51ad97f0] Merge the performance enhancements of trunk (and some obscure bug fixes) into the sessions branch. (user: drh, tags: sessions)
13:18
[9830c343bc] Improve clarity of presentation in the sqlite3VdbeMemFromBtree() routine. (user: drh, tags: trunk)
12:07
[1e57f67b20] Fix comment in test. (user: mistachkin, tags: trunk)
11:54
[3cbb9b1b4f] Fix minor typos in the new test file. (user: mistachkin, tags: trunk)
11:35
[62410bb8a7] Add tests to verify the fix for bug [4ef7e3cfca]. (user: dan, tags: trunk)
11:29
[5bcd0b1ca5] Fix name resolution problem in sub-selects within triggers, ticket [4ef7e3cfca]. (user: mistachkin, tags: trunk)
11:16
[8d18a803bd] Fix harmless compiler warning. (user: mistachkin, tags: trunk)
04:12
[3325ad5bdc] Refactor the sqlite3VdbeRecordCompare() routine used to compare btree records. Create fast-track special case routines to handle the common cases more quickly. This gives a significant performance boost. (user: drh, tags: trunk)
04:04
[f10130ede4] Closed-Leaf: Fix more instances of assuming 'char' is signed. And, make sure to never shift a signed integer. (user: drh, tags: broken-on-arm)
2014-03-03
21:59
[aec5473a75] Refactor the sqlite3VdbeRecordCompare() routine used to compare btree records. Create a couple of fast-track routines to handle the common cases of a string with BINARY collation or integer values as the left-most column. This gives a significant performance boost in common use. Oops: This build does not work on the Beaglebone where "char" defaults to unsigned. (user: drh, tags: broken-on-arm)
17:48
[1d60356462] Merge latest trunk changes. (user: dan, tags: experimental)
17:36
[c0fa0c0e2d] Change an OP_SCopy into an OP_Copy in a case where the destination might be used after the source has changed. (user: drh, tags: trunk)
16:48
[559835e54e] Change the "explain_i" tcl test command so that xterm color codes are only added if the output is actually a terminal. (user: dan, tags: trunk)
14:45
[e00ed717fb] Merge latest trunk changes. (user: dan, tags: experimental)
14:20
[7fdd378d54] Fix a segfault that can occur following an OOM error. (user: dan, tags: trunk)
00:12
[e3f6c61e03] Change the MEM_Dyn flag so that it means that Mem.xDel exists and must be used to free the string or blob. Add tighter invariant checks on Mem. (user: drh, tags: trunk)
2014-03-01
19:45
[9c1747b5de] Merge trunk changes. (user: dan, tags: experimental)
18:13
[44e1c33767] Closed-Leaf: Change the MEM_Dyn flag so that it means that Mem.xDel exists and must be used to free the string or blob. Add tighter invariant checks on Mem. (user: drh, tags: enhanced-mem-check)
14:45
[4aeb3ae435] Add extra assert() statements trying to catch a Mem object in an inconsistent state. (user: drh, tags: enhanced-mem-check)
2014-02-28
20:47
[e6ecf73376] In the command-line shell add the (undocumented and unsupported) ".eqp" command and -eqp command-line option, to cause EXPLAIN QUERY PLAN to be run on each SQL statement as it is evaluated. Intended use is for analysis of the query planner. (user: drh, tags: trunk)
19:37
[0a3579d9b9] Provide an #ifdef in shell.c to work around issues when cross-compiling from Ubuntu to windows. (user: drh, tags: trunk)
2014-02-27
20:52
[8f30b09518] Merge in latest trunk changes. (user: dan, tags: experimental)
15:11
[51ce713c6e] A better way of handling the USE_SYSTEM_SQLITE #define in shell.c. (user: drh, tags: trunk)
15:04
[a669040023] Add #defines to the command-line shell source code (shell.c) so that it can be imported directly into other projects (ex: Fossil) and used without editing. (user: drh, tags: trunk)
05:47
[ed0bfcfadc] Leaf: Merge updates from trunk. (user: mistachkin, tags: winIoRetry)
2014-02-26
21:35
[06c2db875e] More efficient removal of duplicates in recursive queries using the UNION compound operator. (user: drh, tags: trunk)
19:05
[3ad687b7aa] Leaf: Only run the OP_OpenRead opcodes for a correlated subquery once, on the initial iteration. Keep the cursor open for subsequent runs. This was suppose to be a performance enhancement, but it is difficult to come up with a query where is makes a significant difference. Hence, the change is getting parked in a branch. (user: drh, tags: open-only-once)
13:53
[9c2e7612cd] In the command-line shell for CSV import, if the lines are \r\n terminated and the last field is blank, make sure an empty string and not a "\r" string is imported. (user: drh, tags: trunk)
02:26
[dca1945aeb] Improved handling of constants and especially constant functions in the ORDER BY clause of a query. Do not optimize out "ORDER BY random()". Fix for ticket [65bdeb9739605cc2296]. (user: drh, tags: trunk)
2014-02-25
21:55
[97a8c9733c] Do not allow temporary registers to be in use across an OP_Yield within a co-routine. Fix for ticket [8c63ff0eca81a9132d8]. (user: drh, tags: trunk)
21:01
[85206e0bba] Attempt to speed up sqlite3VdbeRecordCompare() by various means. This code is in an interim state. (user: dan, tags: experimental)
19:38
[cc5eda5422] Closed-Leaf: Make sure temporary registers used within a co-routine are not also used outside of that co-routine, in order to prevent concurrent use of the same register for two different things. Ticket [8c63ff0eca81a9132d8] (user: drh, tags: tkt-8c63ff0eca)
18:12
[23001a85cd] Also adjust the order of files in the amalgamation to ensure that _FILE_OFFSET_BITS is defined before any #include, for QNX. (user: drh, tags: trunk)
14:52
[953cdd6ada] QNX requires that _FILE_OFFSET_BITS be set prior to any system #include. (user: drh, tags: trunk)
2014-02-24
21:42
[2477b3a294] Fix several small style/consistency issues with the previous check-in. (user: mistachkin, tags: trunk)
21:23
[854d410ad3] Closed-Leaf: Merge updates from trunk. (user: mistachkin, tags: cygDlOpen)
21:20
[53081e7202] Enhance testing support for the Win32 VFS dynamic extension loading facilities. (user: mistachkin, tags: trunk)
19:49
[d6746cabaa] Close some stray connections in walro.test. (user: dan, tags: trunk)
19:07
[ba5f0a5599] In memsys5, initialize new allocations to non-zero bytes. Change the content of freed allocations to prevent use after free. These changes in SQLITE_DEBUG only. (user: drh, tags: trunk)
14:24
[4df0ac9023] Remove an unused variable from the VDBE_PROFILE compile-time option. Keep the opcode count in an u32 instead of an int. (user: drh, tags: trunk)
2014-02-21
10:48
[09cf240a7f] Leaf: Merge updates from trunk. (user: mistachkin, tags: winHdr)
05:44
[6676475c47] Better loadable extension handling in the Win32 VFS when compiled for Cygwin. (user: mistachkin, tags: cygDlOpen)
2014-02-20
19:42
[b46d4e8923] Fix the text of a comment used to generate VDBE opcode documentation so that it omits symbols that can be mistaken for a hyperlink by the parser. (user: drh, tags: trunk)
19:32
[824029090d] Fix a harmless shadowed-variable warning. (user: drh, tags: trunk)
19:23
[d5d973fedc] Make sure that the difference between two string pointers is passed into sqlite3_mprintf() as type "int". (user: drh, tags: trunk)
2014-02-19
19:14
[c1e94169dd] Add the VdbeCoverageNeverTaken() macro, and comments that better describe how the VDBE branch coverage measurement works. Add some tags to provide 100% VDBE branch coverage. (user: drh, tags: trunk)
14:20
[d2c047f304] Add the SQLITE_NOTNULL P5 code for comparison operations - really a composite of SQLITE_NULLEQ and SQLITE_JUMPIFNULL. This flag indicates that NULL operands are not possible and raises and assert() if NULL operands are seen. Also omit an unnecessary scan of the sqlite_sequence table when writing into an AUTOINCREMENT table. (user: drh, tags: trunk)
01:31
[85b355cfb4] Make sure a multi-row VALUES clause works correctly in a compound SELECT. (user: drh, tags: trunk)
00:53
[b978256469] Tweaks in support of VDBE branch test coverage. (user: drh, tags: trunk)
2014-02-18
11:31
[b287520c92] Fix VDBE branch accounting on comparison operators. (user: drh, tags: trunk)
05:18
[adba783c70] Enhance the Win32 VFS I/O retry logic. (user: mistachkin, tags: winIoRetry)
03:07
[b92d31a97d] Add VdbeCoverage() and VdbeCoverageIf() macros for improved VDBE coverage testing. (user: drh, tags: trunk)
01:07
[915f6f1c7a] Improvements to "NOT IN (SELECT ...)" processing. Only test for NULL values on the RHS on the first iteration, then remember the result. There has been logic to do this for year, but it didn't work right and ended up repeating the NULL test on every iteration. This inefficiency was found using the VDBE coverage testing tools. (user: drh, tags: trunk)
2014-02-17
23:52
[a72687699b] Merge in performance enhancements for INSERT operations, especially INSERTs on tables that have no affinity columns or that have many indices or INSERTs with content coming from a SELECT. Add the SQLITE_TESTCTRL_VDBE_COVERAGE test control and the SQLITE_VDBE_COVERAGE compile-time option used for measure coverage of branches in VDBE programs. (user: drh, tags: trunk)
22:40
[ce184c7bb1] Leaf: Add logic to do test coverage measurements on the VDBE code. (user: drh, tags: insert-optimization)
15:36
[2914e41911] Merge the VDBE_PROFILE fixes from trunk. (user: drh, tags: insert-optimization)
01:13
[7adb3da235] Fix the VDBE_PROFILE logic. Add a script to process the output file. (user: drh, tags: trunk)
2014-02-16
19:20
[057c16ee97] Closed-Leaf: Use the modern MinGW major version macro, not the deprecated one. (user: mistachkin, tags: mingw4x)
01:55
[aa2d8b0e81] Enhance the code generator for INSERT INTO ... SELECT so that the SELECT generates output directly in the registers that INSERT INTO will be using, in many cases, and OP_SCopy operations can thus be avoided. (user: drh, tags: insert-optimization)
2014-02-14
23:49
[e07a32f308] Seek past NULLs in a top-constrained search. Avoid checking for NULLs in the body of the search. (user: drh, tags: trunk)
23:35
[e147230767] Better support for MinGW 4.x. (user: mistachkin, tags: mingw4x)
20:59
[3c1ae447de] Reduce the number of cases where it is necessary to check for NULL after the loop terminating condition. (user: drh, tags: trunk)
15:13
[b6bea903ac] Add OP_IdxGT and OP_IdxLE as distinct opcodes. Formerly these operations where done using OP_IdxGE and OP_IdxLT with the P5 flag set. But VDBE code is easier to read with distinct opcode names. Also change OP_SeekGe to OP_SeekGE, and so forth, so that the capitalization is consistent. The whole point of this change is to improve the readability of VDBE listings. (user: drh, tags: trunk)
00:25
[9e573198e1] Revise how the Tcl system encoding is handled by the test suite. (user: mistachkin, tags: trunk)
2014-02-13
21:57
[b22b614068] Improvements to the makefile and README for MSVC. (user: mistachkin, tags: trunk)
19:27
[48c821fd97] Ensure that if the "psow=0" URI option or FCNTL_POWERSAFE_OVERWRITE file-control is used to clear the power-safe overwrite flag, extra padding frames are added to the WAL file. (user: dan, tags: trunk)
19:10
[18d4e258c4] Change README to README.md and expand it. Remove unrelated and obsolete files. (user: drh, tags: trunk)
18:46
[e3b79e920c] Avoid passing a flags argument with the internal WAL_SYNC_TRANSACTIONS bit set when calling sqlite3OsSync(). (user: dan, tags: trunk)
13:42
[b81ba7a4bc] Update the tclconfig files to the latest from http://core.tcl.tk/tclconfig. (user: drh, tags: trunk)
2014-02-12
23:52
[cc8f10bcb2] Minor simplifications to the "zeroPage()" routine in btree.c. (user: drh, tags: trunk)
21:31
[56bc5ce895] Remove the "rowid cache" that sought to remember the largest rowid for a table and thereby speed up OP_NewRowid. That cache was ineffective. Removing it results in a performance increase of 0.4%, less memory usage, and a slightly smaller library size. (user: drh, tags: trunk)
15:05
[f352ef57e3] Leaf: Various fixes and test case updates so that veryquick.test passes again. (user: dan, tags: deferred-open)
14:43
[5d01426ddf] Make sure "rowid" columns are correctly resolved in joins between normal tables and WITHOUT ROWID tables. Fix for ticket [c34d0557f740c45070]. (user: drh, tags: trunk)
14:43
[4d7057c494] Merge latest trunk changes. (user: dan, tags: deferred-open)