/ Check-in [62678be3]
Login

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

Overview
Comment:When the same index is used for all OR-terms in a WHERE clause, then try to use that index as a covering index.
Downloads: Tarball | ZIP archive | SQL archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1: 62678be3df35cdcb09172ba8c860f7b73517f1ea
User & Date: drh 2012-08-24 23:56:19
References
2012-10-04
15:26 New ticket [d02e1406] LEFT JOIN with an OR in the ON clause causes segfault. artifact: 28fef2d3 user: drh
2012-08-25
00:49
Backport check-in [62678be3df35cd]: When the same index is used for all OR-terms in a WHERE clause, then try to use that index as a covering index. Leaf check-in: 865dfcba user: drh tags: branch-3.7.2
Context
2012-08-25
02:11
Fix a harmless compiler warning. check-in: 929b5184 user: drh tags: trunk
01:38
Merge all the latest trunk changes into the apple-osx branch. check-in: 6723add4 user: drh tags: apple-osx
01:21
Merge the latest trunk changes into the sessions branch. check-in: aa62d688 user: drh tags: sessions
2012-08-24
23:56
When the same index is used for all OR-terms in a WHERE clause, then try to use that index as a covering index. check-in: 62678be3 user: drh tags: trunk
23:24
Move field WhereLevel.pCovidx inside the union to WhereLevel.u.pCovidx. Closed-Leaf check-in: b722143d user: drh tags: multi-or-covering-index
01:07
Merge the nested aggregate query enhancements into trunk. check-in: d4cd6017 user: drh tags: trunk
Changes
Unified Diffs Side-by-Side Diffs Patch

Changes to src/delete.c.

Changes to src/fkey.c.

Changes to src/select.c.

Changes to src/sqliteInt.h.

Changes to src/update.c.

Changes to src/where.c.

Added test/whereD.test.