/ Timeline
Login

100 ancestors of [e4d220a3]

2013-11-16
20:45
The one-pass optimization is now working for DELETE on WITHOUT ROWID tables. check-in: e4d220a3 user: drh tags: optimize-delete
20:13
Enhance the DELETE logic so that it can make use of WHERE_ONEPASS_DESIRED for rowid tables. check-in: 8f479a72 user: drh tags: optimize-delete
15:35
Fully constraint the ORDER BY on the top-10 line of the --summary output from the wordcount test program. Add the run-wordcount.bash script for running wordcount in various configurations. check-in: 7edf39eb user: drh tags: trunk
14:03
Avoid unnecessary OP_IfNull checks when doing a range query where there is a constraint on the lower bound of the range. check-in: de08a7e7 user: drh tags: trunk
13:55
Simplification and performance improvement to the logic that factors constant expressions ouf of inner loops. check-in: ee9353fd user: drh tags: trunk
12:56
Fix testcase misc7-16 so that it works with the new UNIQUE constraint error message format. check-in: c7f2ed9f user: drh tags: trunk
2013-11-15
20:06
Add ALWAYS and NEVER macros to currently unreachable but important branches in sqlite3ExprCompare(). Closed-Leaf check-in: cee835fe user: drh tags: expr-codegen-enhancement
19:00
Merge the operator comment fixes from trunk. check-in: 9f14f55c user: drh tags: expr-codegen-enhancement
18:58
Fix comments on the OP_Divide and OP_Remainder operators, especially the "Synopsis:" comment, so that they agree with the actual implementation. check-in: cc17f1f0 user: drh tags: trunk
18:15
Changes to make the new constant expression factoring logic more general and more testable. check-in: d10fb49a user: drh tags: expr-codegen-enhancement
16:48
Add test cases for INSERT INTO ... DEFAULT VALUES on tables with numeric constants in CHECK constraints. check-in: 79ec485b user: drh tags: expr-codegen-enhancement
15:52
Improvements to the Expr comparison routine to make it more general. Improvements to unary-minus code generation so that it can make use of a global constant register with a zero value. check-in: 835be656 user: drh tags: expr-codegen-enhancement
13:12
Add the --query option to the wordcount test program. check-in: 5960d11e user: drh tags: trunk
12:41
Simplify the range scan code generate while also avoiding an unnecessary OP_Affinity opcode. check-in: 372686bf user: drh tags: expr-codegen-enhancement
03:30
Merge EXPLAIN fixes from trunk. check-in: cd579727 user: drh tags: expr-codegen-enhancement
03:21
Fix a typo in the "synopsis" for the OP_Lt opcode that causes an incorrect comment to be added to EXPLAIN output. check-in: d99a30a2 user: drh tags: trunk
03:16
Another adjustment to the EXPLAIN indentation logic, in order to deal with the sorter loop on a CREATE INDEX statement. check-in: cbe85cc2 user: drh tags: trunk
01:10
Rework the logic that factors constant expressions out of inner loops, making it both simpler and faster. check-in: 8dc5c76c user: drh tags: expr-codegen-enhancement
2013-11-14
23:59
Adjust the command-line shell EXPLAIN indentation logic to handle the second loop of an UPDATE that reads out a RowSet. check-in: ea141a9b user: drh tags: trunk
19:34
Remove an unused local variable. check-in: 10d59226 user: drh tags: trunk
00:09
Simplification to the progress callback check. One branch removed. check-in: 24ef1654 user: drh tags: trunk
2013-11-13
23:48
Make sure the progress callback is invoked prior to an SQLITE_ROW return if it is overdue to be called. check-in: 21f59b04 user: drh tags: trunk
20:46
Merge the skip-scan enhancement into trunk. check-in: b0bb975c user: drh tags: trunk
19:01
Import the "PRAGMA vdbe_eqp" enhancement and the enhanced EXPLAIN formatting the shell from trunk. Fix a bug in skip-scan and add a test case to prevent a regression. Closed-Leaf check-in: f668616a user: drh tags: skip-scan
18:35
In the shell tool, if an "EXPLAIN" command is executed in ".explain on" mode, attempt to automatically indent the bodies of loops in the output VDBE program. check-in: e7d34ec6 user: dan tags: trunk
17:58
Add the "PRAGMA vdbe_eqp" command, only available with SQLITE_DEBUG. Simplify some of the other debugging logic. check-in: 8ce33f4c user: drh tags: trunk
17:24
Add VDBE comments to the beginning and end of skip-scan loops. check-in: 0c85d93b user: drh tags: skip-scan
16:58
Improve the way that skip-scan loops are constructued. Add test cases. Improved the scoring of skip-scan loops. check-in: 5e75ab93 user: drh tags: skip-scan
15:32
Add test cases for skip-scan. Enhance "do_test" so that if the expected result is of the form "/*..*/" or "~/*..*/" it treats the expected result as a glob pattern rather than as a regular expression. Fix a bug in ANALYZE result loading associated with WITHOUT ROWID tables. check-in: d3e6e9b2 user: drh tags: skip-scan
12:27
Add the ability to use an index even if the left-most columns of the index are unconstrainted, provided that the left-most columns have few distinct values. check-in: 27dd5993 user: drh tags: skip-scan
08:55
Avoid an unnecessary OP_IfNull while doing an indexed search. check-in: 51960009 user: drh tags: trunk
2013-11-12
21:37
Adjust the SQLITE_MALLOCSIZE defines, primarily to make sure _msize gets used with MSVC when appropriate. check-in: 4e7e805e user: mistachkin tags: trunk
21:10
Fix harmless compiler warning. check-in: ddacd101 user: mistachkin tags: trunk
20:18
Minor enhancements to the auxiliary information added to EXPLAIN output with SQLITE_EXPLAIN_ENABLE_COMMENTS. check-in: 0d1328e3 user: drh tags: trunk
18:37
Break out the structure and macro definitions of where.c into a separate header file whereInt.h for easier editing and debugging. check-in: c4446712 user: drh tags: trunk
17:46
When possible, have FTS use 32-bit operations to read varints from the database. check-in: aa7ba302 user: dan tags: trunk
15:33
A better (simpler) fix to the count(*) problem addressed in the previous check-in. check-in: 0f924c6e user: drh tags: trunk
14:55
Make sure the count(*) optimization works correctly on WITHOUT ROWID tables. check-in: 91174779 user: drh tags: trunk
12:30
Update test command [explain_i] to handle the opcodes used by virtual tables (VNext, VFilter etc.). check-in: 1b215ee3 user: dan tags: trunk
12:17
Fix for [4065ac8595]: Do not order CROSS or LEFT joins, even if the right-hand-side is a virtual table. check-in: e2684ece user: dan tags: trunk
01:11
Fix an error message in the spellfix extension so that it conforms to the style of error messages in the core. check-in: b896ae3d user: drh tags: trunk
2013-11-11
23:26
Add a comment to the sqlite3_index_info structure indicating that the new field is only available in SQLite 3.8.2 or later. check-in: 239648f8 user: drh tags: trunk
19:56
Fix typos in compile and run-time tests of the sqlite library version number in rtree.c. check-in: f58d5701 user: dan tags: trunk
19:01
Add a way for virtual tables to return the expected number of rows for a scan (not just the overall cost) to SQLite. Have the rtree module make use of this. check-in: 5a3cfd74 user: dan tags: trunk
16:55
Remove unreachable code, replacing it in most cases with assert() or NEVER() macros. check-in: 924d63b2 user: drh tags: trunk
03:37
Fix issue with several memory allocation tests due to KeyInfo allocations now being shared. check-in: 569fedd6 user: mistachkin tags: trunk
03:24
Convert several ALWAYS() macros in vdbe.c into assert() statements. check-in: acc40ff6 user: drh tags: trunk
02:46
Fix several harmless compiler warnings. check-in: e6ff492f user: mistachkin tags: trunk
01:42
Modify a HeapValidate assert in the Win32 native allocator. check-in: aaed7d1d user: mistachkin tags: trunk
00:43
Fix a problem in OP_IdxDelete as used by REPLACE conflict resolution that comes up due to recent enhancements that reduce the work required for UNIQUE NOT NULL indices. check-in: 61d7d475 user: drh tags: trunk
2013-11-10
00:03
Fix typo in comment and remove superfluous blank line. No changes to code. check-in: 023233f1 user: mistachkin tags: trunk
2013-11-09
23:55
Fix compilation errors with some compilers that do not reference recent Windows SDK header files. check-in: a5805976 user: mistachkin tags: trunk
23:44
Fix memory type mismatch when compiled with MEMDEBUG. check-in: 2c32bd6d user: mistachkin tags: trunk
22:08
Add the sqlite3_win32_compact_heap() function for cleaning up memory allocations on Win32 system. Also cleanup the winGetTempname() function. Changes to the Win32 VFS only. check-in: d06d9fdb user: drh tags: trunk
21:19
Updates to documentation on sqlite3_last_insert_rowid(). No changes to code. check-in: a4c5804e user: drh tags: trunk
21:11
Use the UNICODE_STRING_MAX_CHARS constant from WinNT.h. Closed-Leaf check-in: 3fefe4dd user: mistachkin tags: win32heap
21:10
Furhter cleanup of the winGetTempname function. check-in: 674de36b user: mistachkin tags: win32heap
19:47
Updates to requirements marks. No changes to code. check-in: 8a036628 user: drh tags: trunk
18:15
Throw an error if AUTOINCREMENT appears in a WITHOUT ROWID table. Updates to API documentation to discuss WITHOUT ROWID. check-in: b1abb2b0 user: drh tags: trunk
2013-11-08
20:10
Add more assert() statements and fix compilation issues when the Win32 native heap is not enabled. check-in: fbf8c382 user: mistachkin tags: win32heap
19:51
Disable use of HeapCompact on Windows CE as it is not available on all versions. check-in: e9694b87 user: mistachkin tags: win32heap
18:52
Adjust the winMemInit return code handling used when resetting the Win32 native heap. check-in: 37853665 user: mistachkin tags: win32heap
18:37
Minor corrections to logging for sqlite3_win32_compact_heap(). check-in: 71347d02 user: mistachkin tags: win32heap
18:13
Enhancements to the Win32 native heap integration. check-in: c54dc967 user: mistachkin tags: win32heap
17:13
Fix harmless compiler warnings. check-in: 0077c077 user: drh tags: trunk
17:03
Merge the Cygwin directory separator fix. Also fix a C++-ism in the multiplexor code so that it will compile on MSVC. check-in: 830629d3 user: drh tags: trunk
16:54
Performance improvement: Avoid unnecessary seeks on REPLACE INTO for a WITHOUT ROWID table. check-in: fd11afa5 user: drh tags: trunk
15:19
Performance improvements: Avoid unnecessary seeks when doing a single-row UPDATE on a WITHOUT ROWID table. check-in: 6f187a0f user: drh tags: trunk
12:14
Merge change to drop the mutex on the multiplexor before entering the xRead VFS call, in order to enhance parallelizability. check-in: 3c566e41 user: drh tags: trunk
01:09
Optimize out a NotExists/NotFound opcode that occurs in UPDATE processing after constraint checks if there is no possiblity that the constraint checking code might have moved the cursor. check-in: 74e3ee2e user: drh tags: trunk
00:16
On the --summary output of wordcount, add the a PRAGMA integrity_check and a 64-bit checksum of the entire table. check-in: 1d1d13b8 user: drh tags: trunk
2013-11-07
23:23
Add many new options to the wordcount test program: --delete, --pagesize, --cachesize, --commit, --nosync, and --journal. check-in: e938112d user: drh tags: trunk
22:11
Fix temporary directory separator handling for Cygwin. Closed-Leaf check-in: 9d870d5f user: mistachkin tags: cygDirSep
21:32
Fix a compiler warning introduced by the previous check-in. check-in: 404bd98f user: drh tags: trunk
21:25
Enable the WHERE_ONEPASS_DESIRED optimization for UPDATE operations on WITHOUT ROWID tables. check-in: 21530798 user: drh tags: trunk
19:43
Add the --stats and --summary options to the wordcount.c test program. check-in: 8aa21e67 user: drh tags: trunk
18:40
Increase the version number to 3.8.2. check-in: 9ad5b74c user: drh tags: trunk
18:37
Add the "wordcount.c" test program. check-in: f02ee546 user: drh tags: trunk
16:08
Add support for WITHOUT ROWID tables. This change also includes (1) standardization of the error message returned from run-time constraint errors, (2) improved EXPLAIN comments, (3) the SQLITE_ENABLE_EXPLAIN_COMMENTS option, (4) the SQLITE_ENABLE_MODULE_COMMENTS option, and (5) a bug fix (see [573cc27427]) in the handling of REPLACE on the rowid when secondary indices use FAIL or IGNORE. check-in: c80e229d user: drh tags: trunk
14:09
Make sure cached KeyInfo objects are only valid for a single database connection. Clear all cached KeyInfo objects on any collating sequence change. Closed-Leaf check-in: 55eea178 user: drh tags: omit-rowid
2013-11-06
19:59
Reference count the KeyInfo object. Cache a copy of an appropriate KeyInfo for each index in the Index object, and reuse that one copy as much as possible. check-in: defd5205 user: drh tags: omit-rowid
16:28
Have the OP_NoConflict opcode set the VdbeCursor.seekResult variable. This speeds up subsequent OP_Insert and OP_IdxInsert opcodes. check-in: 47455500 user: dan tags: omit-rowid
14:52
Use ansi escape codes to use different colored text for opcode names in the output of [explain_i]: Red for opcodes that insert or delete b-tree elements, blue for opcodes that move cursors and green for the ResultRow opcode. check-in: 4be2b64b user: dan tags: omit-rowid
14:36
Allocate extra stack space for UnpackedRecord objects, reducing the need to malloc for them as often, and thereby get a performance improvement. check-in: a725a75f user: drh tags: omit-rowid
14:05
Minor optimization to the OP_Halt opcode. check-in: d70c7881 user: drh tags: omit-rowid
12:56
Improved ORDER BY optimization for WITHOUT ROWID tables. check-in: 8f1709ff user: drh tags: omit-rowid
12:05
Disable the OR optimization for WITHOUT ROWID tables, since it relies on the use of rowids. check-in: 6055dad2 user: drh tags: omit-rowid
11:46
Remove an incorrect test case from conflict2.test. check-in: 427612ef user: drh tags: omit-rowid
02:36
Remove an unused variable. check-in: e9c1e419 user: drh tags: omit-rowid
2013-11-05
22:39
Make sure the query planner knows that the PRIMARY KEY index of a WITHOUT ROWID table is always a covering index. check-in: 03e7019e user: drh tags: omit-rowid
19:41
Fix conflict handling for the case when the rowid uses REPLACE but other unique constraints use FAIL or IGNORE. check-in: 573cc274 user: drh tags: omit-rowid
17:30
Fix a bug in secondary index initialization when the secondary index is a superset of the PRIMARY KEY for a WITHOUT ROWID table. check-in: 52a3d885 user: drh tags: omit-rowid
16:56
Remove an "explain" command from test script without_rowid1.test that was accidentally committed. check-in: 4b41d989 user: dan tags: omit-rowid
16:39
Unless the destination table is completely empty, disable the xfer optimization for WITHOUT ROWID tables. check-in: 3877c9f5 user: dan tags: omit-rowid
15:02
Updates to the backcompat.test test script so that it works with really old (3.6.*) versions. check-in: ace7e7b6 user: dan tags: omit-rowid
14:19
Add tests for updates of without-rowid tables that use non-BINARY collation sequences for the primary key columns. And a minor bugfix to the same. check-in: 99b1fa4b user: dan tags: omit-rowid
13:33
Standardize the error messages generated by constraint failures to a format of "$TYPE constraint failed: $DETAIL". This involves many changes to the expected output of test cases. check-in: 54b22192 user: drh tags: omit-rowid
01:59
Add the conflict2.test script. Fix issues discovered by this script. check-in: 294ed337 user: drh tags: omit-rowid
2013-11-04
22:04
Add the index7.test script for testing partial indices with WITHOUT ROWID tables. Fix bugs in ANALYZE located by that script. check-in: 79befe3a user: drh tags: omit-rowid
21:44
Bug fixes in the INSERT constraint checker. Refactor the Rowid handling logic for ANALYZE with STAT3/4. check-in: 1ea43c0f user: drh tags: omit-rowid
18:34
Add another test case file for WITHOUT ROWID and fix the bugs that the new test file uncovered. check-in: bc2a06eb user: drh tags: omit-rowid