/ Check-in [f489b5bb]
Login

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

Overview
Comment:When doing a DISTINCT query using an index, try to use the index to skip ahead to the next distinct element, rather than doing a full scan of the index. (This is the "skip-ahead-distinct" optimization.)
Downloads: Tarball | ZIP archive | SQL archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA3-256: f489b5bb6b35665befdd411c2c55df5258e83cba265d8c4427ba22529cf882a4
User & Date: drh 2017-04-14 17:30:43
References
2017-11-21
15:19 New ticket [ef931875] Incorrect result due to the skip-ahead-distinct optimization. artifact: 00f210e1 user: drh
Context
2017-04-14
19:44
Fix some left-over K&R-C constructs in lemon.c. No changes to the core. check-in: a5379905 user: drh tags: trunk
17:30
When doing a DISTINCT query using an index, try to use the index to skip ahead to the next distinct element, rather than doing a full scan of the index. (This is the "skip-ahead-distinct" optimization.) check-in: f489b5bb user: drh tags: trunk
14:50
Make USE_FULLWARN=1 the default for MSVC and fix harmless compiler warnings. check-in: 6bf67376 user: mistachkin tags: trunk
00:45
Fix a couple of unreachable branches. check-in: 1aa0ea8d user: drh tags: skip-ahead-distinct
Changes
Unified Diffs Side-by-Side Diffs Patch

Changes to src/where.c.

Changes to src/whereInt.h.

Added test/distinct2.test.