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

enable SEARCH() on expression

    XMLWordPrintable

    Details

    • Type: Improvement
    • Status: Open
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: Neo
    • Fix Version/s: Morpheus
    • Component/s: fts, query
    • Labels:
      None
    • Story Points:
      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

          Hide
          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.

          Show
          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

            Assignee:
            keshav Keshav Murthy
            Reporter:
            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