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

enable SEARCH() on expression

    XMLWordPrintable

Details

    • Improvement
    • Status: Open
    • Major
    • Resolution: Unresolved
    • Neo
    • Morpheus
    • fts, query
    • None
    • 1

    Description

      From Keshav Murthy

      SELECT *
      FROM [
      {"x":1, "y": "Hello, world"},
      {"x":2, "y": "New, world"},
      {"x":3, "y": "Modern, world"}
      ] r
       
       WHERE search(r.y, "world");
      

      Attachments

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

        Activity

          With latest verify improvements we should consider this.
          Query side and FTS side (use standard index) needs improvement. This enables more JOIN cases for nested loop.

          Sitaram.Vemulapalli Sitaram Vemulapalli added a comment - With latest verify improvements we should consider this. Query side and FTS side (use standard index) needs improvement. This enables more JOIN cases for nested loop.

          People

            keshav Keshav Murthy
            Sitaram.Vemulapalli Sitaram Vemulapalli
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:

              Gerrit Reviews

                There are no open Gerrit changes

                PagerDuty