SQLite

Check-in [142b048ac7]
Login

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

Overview
Comment:Avoid generating hints using constraints that are also used to initialize the cursor, since presumably the cursor already knows about those constraints.
Downloads: Tarball | ZIP archive
Timelines: family | ancestors | descendants | both | cursor-hints
Files: files | file ages | folders
SHA1: 142b048ac778620dd4e448c2e969982eb8188501
User & Date: drh 2015-08-17 17:19:28.483
Context
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)
Changes
Unified Diff Side-by-Side Diff Patch
Changes to src/wherecode.c.
Changes to test/cursorhint.test.