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
Activity
Link | This issue is triggered by CBSE-11939 [ CBSE-11939 ] |
Assignee | Pierre Regazzoni [ JIRAUSER25157 ] | Bingjie Miao [ bingjie.miao ] |
Fix Version/s | Morpheus [ 17651 ] | |
Fix Version/s | 7.0.4 [ 18322 ] | |
Fix Version/s | 7.1.1 [ 18320 ] |
Labels | candidate-for-7.1.1 |
Summary | [BP to 7.0.4] - adhoc query index selection issue with LIKE as index condition and query parameters | [BP to 7.0.4,7.1.1] - adhoc query index selection issue with LIKE as index condition and query parameters |
Labels | approved-for-7.0.4 approved-for-7.1.1 |
Link | This issue blocks MB-48997 [ MB-48997 ] |
Link | This issue blocks MB-51648 [ MB-51648 ] |
Assignee | Bingjie Miao [ bingjie.miao ] | Pierre Regazzoni [ JIRAUSER25157 ] |
Resolution | Fixed [ 1 ] | |
Status | Open [ 1 ] | Resolved [ 5 ] |
Assignee | Pierre Regazzoni [ JIRAUSER25157 ] | Ajay Bhullar [ ajay.bhullar ] |
Affects Version/s | 7.1.0.x [ 18356 ] |
Status | Resolved [ 5 ] | Closed [ 6 ] |
Link | This issue blocks MB-52510 [ MB-52510 ] |
Link | This issue blocks MB-51648 [ MB-51648 ] |