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.
Build couchbase-server-7.1.1-3063 contains query commit b2ed5c7 with commit message:
MB-52161Compare with original index condition for index eligibility