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

N1QL: search() query execution failed

    XMLWordPrintable

Details

    • Untriaged
    • Centos 64-bit
    • 1
    • Unknown

    Description

      Build: 7.0.0-4960

      Cluster is: {kv, fts} {kv, fts} {kv, index, n1ql, fts}

      Create a bucket `default`, load attached dump.

      Create the following FTS index:

       

      {
       "name": "default_index",
       "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": false,
          "enabled": true,
          "properties": {
           "manages": {
            "dynamic": false,
            "enabled": true,
            "properties": {
             "reports": {
              "enabled": true,
              "dynamic": false,
              "fields": [
               {
                "include_in_all": true,
                "include_term_vectors": true,
                "index": true,
                "name": "reports",
                "store": true,
                "type": "text"
               }
              ]
             }
            }
           },
           "name": {
            "enabled": true,
            "dynamic": false,
            "fields": [
             {
              "include_in_all": true,
              "include_term_vectors": true,
              "index": true,
              "name": "name",
              "store": true,
              "type": "text"
             }
            ]
           }
          }
         },
         "default_type": "_default",
         "docvalues_dynamic": true,
         "index_dynamic": true,
         "store_dynamic": false,
         "type_field": "_type"
        },
        "store": {
         "indexType": "scorch",
         "mossStoreOptions": {},
         "segmentVersion": 15
        }
       },
       "sourceType": "gocbcore",
       "sourceName": "default",
       "sourceUUID": "83ca9675423d6a207df443bd20229915",
       "sourceParams": {},
       "planParams": {
        "maxPartitionsPerPIndex": 1024,
        "indexPartitions": 1,
        "numReplicas": 0
       },
       "uuid": "53ba20504fa89230"
      }
      

       

       

      Try to run the following query:

       

      select b, search_meta(b.oouutt) as meta from default b where search(b, {"query": {"query": "Palmer"}, "explain": true, "highlight": {}},{"out": "oouutt"})

       

      The following error will appear:

       

      [
        {
          "code": 5000,
          "msg": "n1fty: failed to parse query to search request - cause: invalid character ',' looking for beginning of value",
          "query": "select b, search_meta(b.oouutt) as meta from default b where search(b, {\"query\": {\"query\": \"Palmer\"}, \"explain\": true, \"highlight\": {}},{\"out\": \"oouutt\"})"
        }
      ]
      

      The following query executes successfully:

       

       

      select b, search_meta(b.oouutt) as meta from default b where search(b, {"query": {"query": "Palmer"}},{"out": "oouutt"})
      

      Last good build is: 7.0.0-4947

       

       

      Attachments

        Issue Links

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

          Activity

            People

              evgeny.makarenko Evgeny Makarenko (Inactive)
              evgeny.makarenko Evgeny Makarenko (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Gerrit Reviews

                  There are no open Gerrit changes

                  PagerDuty