Loading...

XML

Word

Printable

Type: Bug
Resolution: Fixed
Priority: Major
Fix Version/s: 7.0.4, 7.1.1
Affects Version/s: 6.6.2, 6.6.3, Morpheus, 6.6.4, 6.6.5, 7.0.0, 7.0.1, 7.0.2, 7.0.3, 7.0.4, 7.1.0, 7.1.1
Component/s: query
Labels:
- approved-for-7.0.4
- approved-for-7.1.1

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.

is a backport of

MB-52090 adhoc query index selection issue with LIKE as index condition and query parameters

is caused by

MB-33009 N1QL plans different while using Named Parameters with Array Indexes

[BP to 7.0.4,7.1.1] - adhoc query index selection issue with LIKE as index condition and query parameters