Flex Index: "n1fty: SargableFlex Sargable - cause: parsing time

Build: 6.6.0 build 7661

• Load emp- wiki dataset
• Create FTS index with below:

  {

  "type": "fulltext-index",

  "name": "custom_index",

  "uuid": "6c6131cb3dffe4ef",

  "sourceType": "couchbase",

  "sourceName": "default",

  "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": {

  "dynamic": true,

  "enabled": false

  },

  "default_type": "_default",

  "docvalues_dynamic": true,

  "index_dynamic": true,

  "store_dynamic": false,

  "type_field": "type",

  "types": {

  "emp": {

  "dynamic": false,

  "enabled": true,

  "properties": {

  "dept": {

  "dynamic": false,

  "enabled": true,

  "fields": [

  {

  "analyzer": "keyword",

  "include_in_all": true,

  "include_term_vectors": true,

  "index": true,

  "name": "dept",

  "type": "text"

  }

  ]

  },

  "is_manager": {

  "dynamic": false,

  "enabled": true,

  "fields": [

  {

  "include_in_all": true,

  "include_term_vectors": true,

  "index": true,

  "name": "is_manager",

  "type": "boolean"

  }

  ]

  },

  "join_date": {

  "dynamic": false,

  "enabled": true,

  "fields": [

  {

  "include_in_all": true,

  "include_term_vectors": true,

  "index": true,

  "name": "join_date",

  "type": "datetime"

  }

  ]

  },

  "manages": {

  "dynamic": false,

  "enabled": true,

  "properties": {

  "team_size": {

  "dynamic": false,

  "enabled": true,

  "fields": [

  {

  "include_in_all": true,

  "include_term_vectors": true,

  "index": true,

  "name": "team_size",

  "type": "number"

  }

  ]

  }

  }

  },

  "salary": {

  "dynamic": false,

  "enabled": true,

  "fields": [

  {

  "include_in_all": true,

  "include_term_vectors": true,

  "index": true,

  "name": "salary",

  "type": "number"

  }

  ]

  }

  }

  },

  "wiki": {

  "dynamic": false,

  "enabled": true,

  "properties": {

  "mutated": {

  "dynamic": false,

  "enabled": true,

  "fields": [

  {

  "include_in_all": true,

  "include_term_vectors": true,

  "index": true,

  "name": "mutated",

  "type": "number"

  }

  ]

  },

  "revision": {

  "dynamic": false,

  "enabled": true,

  "properties": {

  "timestamp": {

  "dynamic": false,

  "enabled": true,

  "fields": [

  {

  "include_in_all": true,

  "include_term_vectors": true,

  "index": true,

  "name": "timestamp",

  "type": "datetime"

  }

  ]

  }

  }

  },

  "title": {

  "dynamic": false,

  "enabled": true,

  "fields": [

  {

  "analyzer": "keyword",

  "include_in_all": true,

  "include_term_vectors": true,

  "index": true,

  "name": "title",

  "type": "text"

  }

  ]

  },

  "type": {

  "dynamic": false,

  "enabled": true,

  "fields": [

  {

  "analyzer": "keyword",

  "include_in_all": true,

  "include_term_vectors": true,

  "index": true,

  "name": "type",

  "type": "text"

  }

  ]

  }

  }

  }

  }

  },

  "store": {

  "indexType": "scorch",

  "mossStoreOptions": {}

  }

  },

  "sourceParams": {}

  }

• Below query throws ""n1fty: SargableFlex Sargable - cause: parsing time \"adsdas\" as \"15:04:05\": cannot parse \"adsdas\" as \"15\"","

  select meta().id from default USE INDEX (USING FTS, USING GSI) where type = "emp" and ( ( manages.team_size between 6 and 1195) or (join_date between "adsdas" and "zadasd"))

  [

  {

  "code": 5000,

  "msg": "n1fty: SargableFlex Sargable - cause: parsing time \"adsdas\" as \"15:04:05\": cannot parse \"adsdas\" as \"15\"",

  "query": "select meta().id from default USE INDEX (USING FTS, USING GSI) where type = \"emp\" and ( ( manages.team_size between 6 and 1195) or (join_date between \"adsdas\" and \"zadasd\"))"

  }

  ]