FlexIndex:Flex Query returns 0 results after upgrade

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"

  }

  ]

  }

  }

  ]

  }