Details
-
Bug
-
Status: Resolved
-
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.
AFAIK, there is no plan for a RC3.
Wayne Siu Raju Suravarjjala - are we accepting more defects into 7.0.4?