Details
-
Bug
-
Resolution: Fixed
-
Major
-
6.5.0
-
Untriaged
-
Centos 64-bit
-
Unknown
Description
Running query:
select * from `beer-sample` where search(`beer-sample`, {"field": "state", "match":"California"}, {"size": 10}) |
And it gives 127 results.
Same fts request:
curl -XPOST -H "Content-Type: application/json" -u Administrator:password http://192.168.10.10:8094/api/index/idx_beer_sample_fts/query -d '{"query":{"field": "state", "match":"California"}, "size":10}' |
Gives 10 results as expected:
{
|
"status": { |
"total": 6, |
"failed": 0, |
"successful": 6 |
},
|
"request": { |
"query": { |
"match": "California", |
"field": "state", |
"prefix_length": 0, |
"fuzziness": 0, |
"operator": "or" |
},
|
"size": 10, |
"from": 0, |
"highlight": null, |
"fields": null, |
"facets": null, |
"explain": false, |
"sort": [ |
"-_score" |
],
|
"includeLocations": false |
},
|
"hits": [ |
{
|
"index": "idx_beer_sample_fts_9d9f21abbf3cc8a6_aa574717", |
"id": "the_bruery", |
"score": 5.234958656331826, |
"sort": [ |
"_score" |
]
|
},
|
{
|
"index": "idx_beer_sample_fts_9d9f21abbf3cc8a6_aa574717", |
"id": "american_river_brewing", |
"score": 5.234958656331826, |
"sort": [ |
"_score" |
]
|
},
|
{
|
"index": "idx_beer_sample_fts_9d9f21abbf3cc8a6_aa574717", |
"id": "21st_amendment_brewery_cafe", |
"score": 5.234958656331826, |
"sort": [ |
"_score" |
]
|
},
|
{
|
"index": "idx_beer_sample_fts_9d9f21abbf3cc8a6_aa574717", |
"id": "taylor_s_restaurant_and_brewery", |
"score": 5.234958656331826, |
"sort": [ |
"_score" |
]
|
},
|
{
|
"index": "idx_beer_sample_fts_9d9f21abbf3cc8a6_aa574717", |
"id": "iron_springs_pub_brewery", |
"score": 5.234958656331826, |
"sort": [ |
"_score" |
]
|
},
|
{
|
"index": "idx_beer_sample_fts_9d9f21abbf3cc8a6_aa574717", |
"id": "hoppy_brewing_company", |
"score": 5.234958656331826, |
"sort": [ |
"_score" |
]
|
},
|
{
|
"index": "idx_beer_sample_fts_9d9f21abbf3cc8a6_aa574717", |
"id": "stone_brewing_co", |
"score": 5.234958656331826, |
"sort": [ |
"_score" |
]
|
},
|
{
|
"index": "idx_beer_sample_fts_9d9f21abbf3cc8a6_aa574717", |
"id": "speakeasy_ales_and_lagers", |
"score": 5.234958656331826, |
"sort": [ |
"_score" |
]
|
},
|
{
|
"index": "idx_beer_sample_fts_9d9f21abbf3cc8a6_aa574717", |
"id": "carmel_brewing", |
"score": 5.234958656331826, |
"sort": [ |
"_score" |
]
|
},
|
{
|
"index": "idx_beer_sample_fts_9d9f21abbf3cc8a6_aa574717", |
"id": "mammoth_brewing", |
"score": 5.234958656331826, |
"sort": [ |
"_score" |
]
|
}
|
],
|
"total_hits": 127, |
"max_score": 5.234958656331826, |
"took": 413888, |
"facets": null |
}
|
FTS index definition:
{
|
"name": "idx_beer_sample_fts", |
"type": "fulltext-index", |
"params": { |
"doc_config": { |
"docid_prefix_delim": "", |
"docid_regexp": "", |
"mode": "type_field", |
"type_field": "type" |
},
|
"mapping": { |
"default_analyzer": "standard", |
"default_datetime_parser": "dateTimeOptional", |
"default_field": "_all", |
"default_mapping": { |
"dynamic": true, |
"enabled": true |
},
|
"default_type": "_default", |
"docvalues_dynamic": true, |
"index_dynamic": true, |
"store_dynamic": false, |
"type_field": "_type" |
},
|
"store": { |
"indexType": "scorch", |
"kvStoreName": "" |
}
|
},
|
"sourceType": "couchbase", |
"sourceName": "beer-sample", |
"sourceUUID": "001a88b693dfbc7d9894a6d62eadb0c1", |
"sourceParams": {}, |
"planParams": { |
"maxPartitionsPerPIndex": 171, |
"numReplicas": 0 |
},
|
"uuid": "9d9f21abbf3cc8a6" |
}
|