Details
-
Bug
-
Resolution: Duplicate
-
Major
-
Cheshire-Cat
-
Untriaged
-
1
-
Unknown
Description
Build: 7.0.0-1834
- Load dataset attached
- Create fts index where languages_known is an array element with below:
{
"type": "fulltext-index",
"name": "custom_index",
"uuid": "6effc389824c52e1",
"sourceType": "gocbcore",
"sourceName": "default",
"sourceUUID": "76c5f0aa3ec25b1a9bd9c6c06cc31906",
"planParams": {
"maxPartitionsPerPIndex": 171
},
"params": {
"doc_config": {
"docid_prefix_delim": "",
"docid_regexp": "",
"mode": "type_field",
"type_field": "type"
},
"mapping": {
"analysis": {},
"default_analyzer": "standard",
"default_datetime_parser": "dateTimeOptional",
"default_field": "_all",
"default_mapping": {
"dynamic": true,
"enabled": false
},
"default_type": "_default",
"docvalues_dynamic": true,
"index_dynamic": true,
"store_dynamic": false,
"type_field": "type",
"types": {
"emp": {
"dynamic": false,
"enabled": true,
"properties": {
"is_manager": {
"dynamic": false,
"enabled": true,
"fields": [
{
"include_in_all": true,
"include_term_vectors": true,
"index": true,
"name": "is_manager",
"type": "boolean"
}
]
},
"join_date": {
"dynamic": false,
"enabled": true,
"fields": [
{
"include_in_all": true,
"include_term_vectors": true,
"index": true,
"name": "join_date",
"type": "datetime"
}
]
},
"manages": {
"dynamic": false,
"enabled": true,
"properties": {
"team_size": {
"dynamic": false,
"enabled": true,
"fields": [
{
"include_in_all": true,
"include_term_vectors": true,
"index": true,
"name": "team_size",
"type": "number"
}
]
}
}
},
"mutated": {
"dynamic": false,
"enabled": true,
"fields": [
{
"include_in_all": true,
"include_term_vectors": true,
"index": true,
"name": "mutated",
"type": "number"
}
]
},
"name": {
"dynamic": false,
"enabled": true,
"fields": [
{
"analyzer": "keyword",
"include_in_all": true,
"include_term_vectors": true,
"index": true,
"name": "name",
"type": "text"
}
]
}
}
}
}
},
"store": {
"indexType": "scorch",
"mossStoreOptions": {}
}
},
"sourceParams": {}
}
- Create GSI primary index
- For the below Flex query, fts index is not considered.
select meta().id from default USE INDEX (USING GSI) where type = "emp" and name = "Scott" OR name = "Baker III" AND join_date between "1978-01-27T18:40:00" and "2020-04-27T09:26:53.949274" OR join_date between "1970-03-11T16:16:00" and "2020-04-27T09:26:53.954405"
Attachments
Issue Links
- is duplicated by
-
MB-39068 FlexIndex: FlexQuery with OR is not using FTS index even though its sargable
- Closed