Uploaded image for project: 'Couchbase Server'
  1. Couchbase Server
  2. MB-19191

[FTS] Bleve bool query on a nested field containing stringified numeral(using standard analyzer) returns 0 results

    XMLWordPrintable

Details

    • Bug
    • Resolution: Cannot Reproduce
    • Critical
    • 4.5.0
    • 4.5.0
    • cbft
    • None
    • Untriaged
    • No

    Description

      Build
      4.5.0-2047

      Testcase
      ./testrunner -i INI_FILE.ini -p skip-cleanup=True,compare_es=True,cluster=D+F,GROUP=P1 -t fts.stable_topology_fts.StableTopFTS.test_query_type,items=50000,num_queries=1000,query_types=bool,cluster=D,F,F,compare_es=True,dataset=all,GROUP=P1

      This test uses standard analyzer.

      [2016-04-10 07:40:38,201] - [task:1097] INFO - ------------------------------------Query # 4 -------------------------------------
      [2016-04-10 07:40:38,227] - [fts_base:1097] INFO - Running query {"from": 0, "indexName": "default_index", "fields": [], "explain": false, "ctl": {"timeout": 60000, "consistency": {"vectors": {}, "level": ""}}, "query": {"should": {"disjuncts": [{"field": "type", "match": "wiki"}, {"field": "dept", "match": "Pre-sales"}, {"field": "dept", "match": "Accounts"}]}, "must": {"conjuncts": [{"field": "revision.contributor.id", "match": "371"}]}}, "size": 10000000} on node: 172.23.107.125
      [2016-04-10 07:40:38,293] - [rest_client:2236] INFO - Status: {u'successful': 32, u'failed': 0, u'total': 32}
      [2016-04-10 07:40:38,294] - [task:1106] INFO - FTS hits for query: {"should": {"disjuncts": [{"field": "type", "match": "wiki"}, {"field": "dept", "match": "Pre-sales"}, {"field": "dept", "match": "Accounts"}]}, "must": {"conjuncts": [{"field": "revision.contributor.id", "match": "371"}]}} is 0 (took 41.835019ms)
      [2016-04-10 07:40:38,306] - [task:1116] INFO - ES hits for query: {"bool": {"should": [{"match": {"type": "wiki"}}, {"match": {"dept": "Pre-sales"}}, {"match": {"dept": "Accounts"}}], "must": {"match": {"revision.contributor.id": "371"}}}} on es_index is 5 (took 4ms)
      [2016-04-10 07:40:38,306] - [task:1121] ERROR - FAIL: FTS hits: 0, while ES hits: 5
      [2016-04-10 07:40:38,306] - [task:1136] ERROR - FAIL: Following 5 docs were not returned by FTS, but ES, printing 50: [u'wiki10000313', u'wiki10001328', u'wiki10000324', u'wiki10000686', u'wiki10000695']
      

      Clearly, when we see the sampled docs, revision.contributor.id is "371".

      {
      _index: "es_index",
      _type: "wiki",
      _id: "wiki10000313",
      _version: 3,
      found: true,
      _source: {
      redirect: null,
      title: "Models of our universe",
      mutated: 0,
      type: "wiki",
      id: "488",
      revision: {
      contributor: {
      username: "Listener",
      id: "371"
      },
      timestamp: "2004-05-21T09:33:53Z",
      id: "36774",
      comment: "syntax",
      text: {
      @xml:space: "preserve",
      #text: "#REDIRECT [[Shape of the universe]]"
      }
      }
      }
      }
      

      {
      _index: "es_index",
      _type: "wiki",
      _id: "wiki10000324",
      _version: 3,
      found: true,
      _source: {
      redirect: null,
      title: "Math",
      mutated: 0,
      type: "wiki",
      id: "507",
      revision: {
      contributor: {
      username: "Listener",
      id: "371"
      },
      timestamp: "2004-05-21T09:28:09Z",
      id: "36793",
      comment: "syntax, please",
      text: {
      @xml:space: "preserve",
      #text: "#REDIRECT [[Mathematics]]"
      }
      }
      }
      }
      

      Attachments

        No reviews matched the request. Check your Options in the drop-down menu of this sections header.

        Activity

          People

            apiravi Aruna Piravi (Inactive)
            apiravi Aruna Piravi (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Gerrit Reviews

                There are no open Gerrit changes

                PagerDuty