/ Timeline
Login

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

2016-06-20
17:25
For a table on the rhs of a LEFT JOIN operator, do not include terms like "IS NULL" from the WHERE clause in the cursor-hint. These may be false for rows that the cursor would otherwise visit, but true for a row of all NULL values generated by the LEFT JOIN. check-in: 913e595615 user: dan tags: trunk
17:22
Allow LIKE operators that appear in a WHERE clause to be included in the cursor-hint for a cursor on the rhs of a LEFT JOIN. Closed-Leaf check-in: 7455d932f5 user: dan tags: cursor-hints
2016-06-17
19:27
Include WHERE terms in the cursor-hint passed to a cursor opened for the rhs of a LEFT JOIN iff we can be sure that those terms will not evaluate to true if the LEFT JOIN generates a row of NULLs. check-in: 998095aba0 user: dan tags: cursor-hints
14:59
Fix a duplicate test name in cursorhint2.test. check-in: fcd12b69ce user: dan tags: cursor-hints
14:47
Fix a typo in the cursorhint2.test script. check-in: c1a5a57cf1 user: dan tags: cursor-hints
14:33
If a table is on the rhs of a LEFT JOIN, include only terms from the joins ON(...) clause in the cursor-hint passed via OP_CursorHint. check-in: 2a2346b042 user: dan tags: cursor-hints
2016-06-16
17:14
Add a missing OP_ColumnsUsed opcode to code for expressions like "? IN (SELECT ...)" in cases where expression can use an index that may contain NULL values. check-in: 0b1579caf0 user: dan tags: trunk
2015-10-27
13:35
Provide hints to the storage engine using the sqlite3BtreeCursorHint() interface when compiling with SQLITE_ENABLE_CURSOR_HINTS. check-in: 45d3539e15 user: drh tags: trunk
13:24
Split out sqlite3BtreeCursorHintFlags() from sqlite3BtreeCursorHint() the interface for improved performance. Closed-Leaf check-in: b3ec9a0d62 user: drh tags: cursor-hints
2015-10-26
20:11
Merge the BTREE_FORDELETE enhancement with this branch. check-in: 20da0849ce user: dan tags: cursor-hints
18:51
Merge in all trunk changes prior to the BTREE_FORDELETE enhancement. check-in: 53d5a4add6 user: drh tags: cursor-hints
18:01
Capture BTREE_FORDELETE test cases that were mistakenly omitted from the previous merge. check-in: de6972515f user: drh tags: trunk
14:54
Fix a C99-ism and a harmless compiler warning. check-in: 138783b553 user: drh tags: trunk
2015-10-16
20:53
Merge recent enhancements from trunk. Version now 3.9.1. check-in: 26fa091d68 user: drh tags: cursor-hints
20:13
Enhancements to the MSVC makefile. check-in: 39e8a5d93f user: mistachkin tags: trunk
2015-10-14
20:09
Merge in all the 3.9.0 updates from trunk. check-in: 2944414934 user: drh tags: cursor-hints
20:03
Update makefiles to remove all uses of "awk" - to make building SQLite easier on Windows systems. The only requirements now are tclsh, a C compiler, and common file utilities. check-in: 4bd0d43db7 user: drh tags: trunk
2015-09-24
15:06
Merge trunk changes into the cursor-hints branch. check-in: fbe637620f user: drh tags: cursor-hints
12:40
Strengthen the implementations of xShmMemoryBarrier on both the unix and windows VFSes, so that they likely work even if SQLITE_THREADSAFE=0 is used. check-in: c6ab807b72 user: drh tags: trunk
2015-09-15
17:31
Merge enhancements from trunk. check-in: 66fe068326 user: drh tags: cursor-hints
14:39
Add test cases to cover fts5 integrity-check code. check-in: 1d018c35b9 user: dan tags: trunk
2015-09-03
14:39
Merge enhancements from trunk. check-in: 25ee3000e9 user: drh tags: cursor-hints
13:46
Add the sqlite3VdbeLoadString() and sqlite3VdbeMultiLoad() routines to help with code generation, especially on PRAGMAs. Rename sqlite3VdbeAddGoto() to just sqlite3VdbeGoto(). check-in: 847387ec8e user: drh tags: trunk
2015-09-01
18:31
Merge enhancements from trunk. check-in: 29570a6048 user: drh tags: cursor-hints
2015-08-29
19:41
Enhance the json_extract() function so that if given multiple PATH arguments it will return a JSON array with all of the answers. Also update comments within the json1 extension to reflect stricter interpretation of JSON and PATH arguments. check-in: 1da60c3dda user: drh tags: trunk
2015-08-20
23:45
Merge recent enhancements from trunk, including table-valued expressions. check-in: b9927c876c user: drh tags: cursor-hints
23:33
Compiler-warning fixes in the sqldiff.exe utility. check-in: 64d13339d4 user: drh tags: trunk
2015-08-18
15:58
Provide hints for all terms in a range constraint if there are any equality terms anywhere in the constraint. Range constraint terms are only omitted for a pure range constraint with no equality prefix. check-in: b5897bc0f0 user: drh tags: cursor-hints
2015-08-17
17:19
Avoid generating hints using constraints that are also used to initialize the cursor, since presumably the cursor already knows about those constraints. check-in: 142b048ac7 user: drh tags: cursor-hints
2015-08-15
00:51
Change the display of the P4 operand of CursorHint in EXPLAIN output to function notation. check-in: bee73d429c user: drh tags: cursor-hints
2015-08-14
23:57
Always provide the BTREE_BULKLOAD hint, even when SQLITE_ENABLE_CURSOR_HINTS is not defined, as that hint gives a 4% performance increase. check-in: 83a844357e user: drh tags: cursor-hints
20:08
Updated testing of cursor-hints. Remove the test_cursorhint.c file and associated logic in the core and do tests based purely on the newly enhanced EXPLAIN output. check-in: bf383e665a user: drh tags: cursor-hints
18:50
Fix the cursor hint mechanism so that it does the right thing for indexed lookups. check-in: 581e3d4988 user: drh tags: cursor-hints
15:05
Refactor the sqlite3BtreeCursorHint() interface for improved maintainability. check-in: fc3fb5cd0d user: drh tags: cursor-hints
01:03
Fix the CursorHint so that it includes the scan boundary constraints. On the expression text for the CursorHint opcode, show rowid correctly. check-in: f0d428d13a user: drh tags: cursor-hints
2015-08-13
21:43
Convert the hint expression of the CursorHint opcode into a string for display by EXPLAIN. Leaf check-in: 12640cb222 user: drh tags: cursor-hints-displayP4
21:38
Fix a harmless compiler warning. check-in: 608ab4ac19 user: drh tags: cursor-hints
21:32
Convert the hint expression of the CursorHint opcode into a string for display by EXPLAIN. check-in: 2068847187 user: drh tags: cursor-hints
20:34
Fix a bug in sqlite3ExprContainsSubquery(). check-in: be254715b5 user: drh tags: cursor-hints
20:07
Merge in all the trunk changes from the previous year. This breaks the cursor-hint mechanism, but provides a baseline for trouble-shooting. check-in: 82a7a61bc0 user: drh tags: cursor-hints
18:26
Add the sqlite3rbu_savestate() function to the rbu extension. To force rbu to save its state to disk without closing the sqlite3rbu* handle. check-in: 851a875ad6 user: dan tags: trunk
2014-07-15
11:59
Add simple tests for new sqlite3BtreeCursorHint() functionality. check-in: 1efa6ed584 user: dan tags: cursor-hints
2014-07-14
19:04
In the expression passed to sqlite3BtreeCursorHint() for the inner loops of joins, replace any TK_COLUMN references to columns in the outer loops with TK_REGISTER expressions (Expr.iTable indicates the specific register containing the value). There are no automated tests for this yet. check-in: f9dddd008c user: dan tags: cursor-hints
2013-12-07
23:35
Do not allow cursor hints to use expressions containing subqueries. This change fixes the problem seen in the previous check-in. check-in: bfefc57554 user: drh tags: cursor-hints
20:39
If the SQLITE_ENABLE_CURSOR_HINTS macro is defined, then invoke the sqlite3BtreeCursorHint() interface to provide hints to the storage engine about rows that need not be returned. Hints can be disabled using SQLITE_TESTCTRL_OPTIMIZATIONS with SQLITE_CursorHints (0x2000). Cursor hints are not used by the built-in storage engine of SQLite but might be useful to applications that provide their own storage engine. The current code is work-in-progrss and contains bugs. check-in: 3a9bec524e user: drh tags: cursor-hints
17:01
Increase the version number to 3.8.3. check-in: 23d00f2287 user: drh tags: trunk