Details
-
Bug
-
Resolution: Fixed
-
Major
-
6.6.0
-
Untriaged
-
1
-
Unknown
Description
Non-covering queries when the field name isn't specified - needs the query to look into the _all field (if available).
As part of verification - in this situation we will need to set the analyzer for the default mapping correctly so non-analytic queries work correctly (keyword analyzer).
Example index definition:
{
|
"type": "fulltext-index", |
"name": "default", |
"uuid": "558d7e033dff989e", |
"sourceType": "couchbase", |
"sourceName": "default", |
"sourceUUID": "37ad8b8f5d53e38f4fff0bbbc9175671", |
"planParams": { |
"maxPartitionsPerPIndex": 171, |
"indexPartitions": 6 |
},
|
"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": { |
"hotel": { |
"default_analyzer": "keyword", |
"dynamic": true, |
"enabled": true |
}
|
}
|
},
|
"store": { |
"indexType": "scorch" |
}
|
},
|
"sourceParams": {} |
}
|
Example query:
SELECT *
|
FROM default AS d |
WHERE d.type='hotel' |
and search (d, {"query":{"wildcard":"*garden*"}}) |
limit 1; |
The workaround without a fix is to use the field setting within the query.
Attachments
Issue Links
- relates to
-
MB-57657 [Trinity Reverify] N1QL+FTS SEARCH queries to be allowed over indexes with non-overlapping analyzer definitions
-
- Closed
-
-
-
- Closed
-
-
-
- Closed
-