Details
-
Bug
-
Status: Closed
-
Major
-
Resolution: Fixed
-
6.6.2, 7.0.0, 6.6.3, Morpheus, 7.1.0, 7.0.3, 7.0.2, 7.0.1, 6.6.5, 6.6.4, 7.1.1, 7.0.4
-
Untriaged
-
1
-
Yes
Description
create index ix2 on default(c1) WHERE type LIKE "airport%";
|
\set -$type "airport%";
|
EXPLAIN SELECT 1 FROM default WHERE c1 = 10 AND type LIKE $type;
|
Above adhoc query does n't choose the index.
Following works.
EXPLAIN SELECT 1 FROM default WHERE c1 = 10 AND type LIKE "airport%"; |
DNF transformation might not happened LIKE before index selection.
Attachments
Issue Links
For Gerrit Dashboard: MB-52161 | ||||||
---|---|---|---|---|---|---|
# | Subject | Branch | Project | Status | CR | V |
174866,3 | MB-52161 Compare with original index condition for index eligibility | cheshire-cat | query | Status: MERGED | +2 | +1 |
174885,2 | MB-52161 Compare with original index condition for index eligibility | neo | query | Status: MERGED | +2 | +1 |
Build couchbase-server-7.1.1-3063 contains query commit b2ed5c7 with commit message:
MB-52161Compare with original index condition for index eligibility