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

N1QL SEARCH() failed with SORT search_score() & LIMIT

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • Major
    • 7.0.2
    • 6.6.2, Cheshire-Cat
    • fts
    • Untriaged
    • 1
    • Unknown

    Description

      This query failed:

      select meta().id, search_score() as score, h.reviews from hotel h
      where SEARCH(h,“travel”)
      ORDER BY score DESC
      LIMIT 10

      [

      { "code": 5000, "msg": "n1fty: search request parse err - cause: json: error calling MarshalJSON for type json.RawMessage: invalid character '_' in numeric literal", "query": "select meta().id, search_score() as score, h.reviews from hotel h\nwhere SEARCH(h,\"friend\")\nORDER BY search_score() DESC\nLIMIT 10" }

      ]

       

      Explain:

      {
      "#operator": "Sequence",
      "~children": [
      {
      "#operator": "Sequence",
      "~children": [
      {
      "#operator": "IndexFtsSearch",
      "as": "h",
      "bucket": "travel-sample",
      "index": "hotel_reviews",
      "index_id": "3db71d60db124221",
      "keyspace": "hotel",
      "namespace": "default",
      "scope": "inventory",
      "search_info":

      { "field": "\"\"", "limit": "10", "order": [ "score DESC" ], "outname": "out", "query": "\"friend\"" }

      ,
      "using": "fts"
      },

      { "#operator": "Fetch", "as": "h", "bucket": "travel-sample", "keyspace": "hotel", "namespace": "default", "scope": "inventory" }

      ,
      {
      "#operator": "Parallel",
      "maxParallelism": 1,
      "~child": {
      "#operator": "Sequence",
      "~children": [

      { "#operator": "Filter", "condition": "search(`h`, \"friend\")" }

      ,
      {
      "#operator": "InitialProject",
      "result_terms": [

      { "expr": "(meta(`h`).`id`)" }

      ,

      { "as": "score", "expr": "search_score((`h`.`out`))" }

      ,

      { "expr": "(`h`.`reviews`)" }

      ]
      }
      ]
      }
      }
      ]
      },

      { "#operator": "Limit", "expr": "10" }

      ]
      }

       

       

       

       

       

      Attachments

        For Gerrit Dashboard: MB-46927
        # Subject Branch Project Status CR V

        Activity

          People

            girish.benakappa Girish Benakappa
            binh.le Binh Le
            Votes:
            0 Vote for this issue
            Watchers:
            5 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Gerrit Reviews

                There are no open Gerrit changes

                PagerDuty