/ Check-in [6611b76b]
Login

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

Overview
Comment:Change the EXPLAIN QUERY PLAN output to use "USING INDEX" instead of "BY INDEX", and to use "SEARCH" instead of "SCAN" for loops that are not full-table scans.
Downloads: Tarball | ZIP archive | SQL archive
Timelines: family | ancestors | descendants | both | experimental
Files: files | file ages | folders
SHA1: 6611b76b0296875fb9903b25dfaa783a9c12eaa1
User & Date: dan 2010-11-13 16:42:27
Context
2010-11-15
14:44
Merge the EXPLAIN QUERY PLAN changes from experimental into trunk. check-in: ce27bf38 user: drh tags: trunk
2010-11-13
16:42
Change the EXPLAIN QUERY PLAN output to use "USING INDEX" instead of "BY INDEX", and to use "SEARCH" instead of "SCAN" for loops that are not full-table scans. Closed-Leaf check-in: 6611b76b user: dan tags: experimental
2010-11-12
17:41
Add EXPLAIN QUERY PLAN test cases to check that the examples in the documentation work. check-in: 85fdad85 user: dan tags: experimental
Changes
Unified Diffs Side-by-Side Diffs Patch

Changes to src/where.c.

Changes to test/autoindex1.test.

Changes to test/e_createtable.test.

Changes to test/e_fkey.test.

Changes to test/eqp.test.

Changes to test/indexedby.test.

Changes to test/tkt-78e04e52ea.test.

Changes to test/tkt3442.test.

Changes to test/where3.test.

Changes to test/where7.test.

Changes to test/where9.test.