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

[N1QL+FTS] Query string syntax failing in verification phase

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • Critical
    • 7.0.0
    • 6.6.1, Cheshire-Cat
    • fts
    • None
    • Untriaged
    • 1
    • Unknown

    Description

      It seems like verification is failing when you provide a query string as ..

      SELECT * FROM xyz as x
      WHERE SEARCH(x, {"query": "field_name:..."}, {"index": "fts_index_name"}) 

      or

      SELECT * FROM xyz as x
      WHERE SEARCH(x, {"query": {"query": "field_name:..."}}, {"index": "fts_index_name"})

      This syntax however does work ..

      SELECT * FROM xyz as x
      WHERE SEARCH(x, "field_name:...", {"index": "fts_index_name"}); 

      See more here .. https://forums.couchbase.com/t/how-to-configure-the-fts-scoring/29513/15

      Attachments

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

        Activity

          People

            abhinav Abhi Dangeti
            abhinav Abhi Dangeti
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Gerrit Reviews

                There are no open Gerrit changes

                PagerDuty