Details
-
Bug
-
Resolution: Won't Fix
-
Major
-
6.6.0
-
Untriaged
-
1
-
Unknown
Description
Build - 5.5.6-4733 --> 6.6.0 build 7781
- Install 5.5.6-4733
- Load travel-sample
- Create default index with default typemapping with keyword analyzer
{
"type": "fulltext-index",
"name": "default_index",
"uuid": "38eb503bf4b582b7",
"sourceType": "couchbase",
"sourceName": "travel-sample",
"sourceUUID": "58899145280249698e7345a0844a2011",
"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": {
"default_analyzer": "keyword",
"dynamic": true,
"enabled": true
},
"default_type": "_default",
"docvalues_dynamic": true,
"index_dynamic": true,
"store_dynamic": false,
"type_field": "_type"
},
"store": {
"indexType": "scorch",
"kvStoreName": "mossStore"
}
},
"sourceParams": {}
}
- FTS query with state:California returns 2261 results
curl -XPOST -H "Content-Type: application/json" \
http://172.23.121.65:8094/api/index/default_index/query \
-d '{
"explain": true,
"fields": [
"*"
],
"highlight": {},
"query": {
"query": "state:\"California\""
}
}'
2261 resultsĀ (4ms server-side)
- Upgrade to 6.6.0 build 7781
- Above FTS query returns 2261 results but Flex query returns 0 results
select meta().id from `travel-sample` USE INDEX (USING FTS, USING GSI) where state = 'California'
Explain plan:
{
"#operator": "Sequence",
"~children": [
{
"#operator": "IndexFtsSearch",
"covers": [
"cover (((`travel-sample`.`state`) = \"California\"))",
"cover ((meta(`travel-sample`).`id`))"
],
"index": "default_index",
"index_id": "38eb503bf4b582b7",
"keyspace": "travel-sample",
"namespace": "default",
"search_info": {
"field": "\"\"",
"options": "{\"index\": \"default_index\"}",
"outname": "out",
"query": "{\"query\": {\"field\": \"state\", \"term\": \"California\"}, \"score\": \"none\"}"
},
"using": "fts"
},
{
"#operator": "Parallel",
"~child": {
"#operator": "Sequence",
"~children": [
{
"#operator": "Filter",
"condition": "cover (((`travel-sample`.`state`) = \"California\"))"
},
{
"#operator": "InitialProject",
"result_terms": [
{
"expr": "cover ((meta(`travel-sample`).`id`))"
}
]
},
{
"#operator": "FinalProject"
}
]
}
}
]
}
Attachments
Issue Links
- duplicates
-
MB-38957 [FTS] Document mapping's analyzer not inherited by child fields
- Closed