Details
-
Bug
-
Resolution: Duplicate
-
Major
-
None
-
Cheshire-Cat
-
Untriaged
-
1
-
Unknown
Description
Build: 7.0.0-2005
Steps to reproduce:
have a type mapped index with 2 type mapping : emp and wiki
have "name" fileld indexed only in emp type mapping
for below flex query, fts index is not Sargable
select meta().id from default USE INDEX (USING FTS, USING GSI) where type = "emp" or type = "wiki" and name = "Kory Palmer"
if we have parentheses around "type" predicate like below, FTS index is sargable
select meta().id from default USE INDEX (USING FTS, USING GSI) where (type = "emp" or type = "wiki") and name = "Kory Palmer"
Attachments
Issue Links
- duplicates
-
MB-39252 Flex Index: Multi-typmapping: Flex query and GSI query returns different results
- Closed