Details
-
Improvement
-
Resolution: Won't Fix
-
Major
-
None
-
None
-
1
Description
Please add to CREATE INDEX docs the following limitations:
- When using clause IN, queries must use the same IN terms in the same order than Index.
The following index:
CREATE INDEX indexIn on bucket(field1) WHERE field1 IN ["A","B","C"]; |
Will only works if the query has the exact in clause or single equal value:
SELECT * from bucket WHERE field1 IN ["A","B","C"]; |
SELECT * from bucket WHERE field = "A"; -- OR B OR C |
Attachments
Issue Links
- relates to
-
MB-32306 Issues on Index Selection using IN clause
- Closed