I’m running N1QL query on Couchbase Enterprise Edition 6.5.1 build 6299 and it doesn’t return a result. Issues is caused by the adSecUntCd
field. If I exclude this field from a query, it works and returns a result. In the document itself, field is set as "adSecUntCd": "#",
SELECT r.*
FROM B234 r
WHERE r.docType=‘UmBus’
AND SEARCH(r, {“must”: {“conjuncts”:[
{“field”:“adSecUntCd”, “match”: “#”},
{“field”:“adP2DNa”, “match”: “New York”},
{“field”:“bpyCoNa”,“Fuzziness”:1, “match”: “Alex”}]}},
{“index”:“FTSIDX”})
In FTS index, adSecUntCd
is defined as:
“adSecUntCd”: {
“enabled”: true,
“dynamic”: false,
“fields”: [
{
“include_in_all”: true,
“include_term_vectors”: true,
“index”: true,
“name”: “adSecUntCd”,
“type”: “text”
}
Thank you !