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

Fast pattern matching with LIKE and HAS_TOKEN

    XMLWordPrintable

Details

    • Improvement
    • Resolution: Fixed
    • Major
    • 4.6.2, 5.0.0
    • 4.6.2, 5.0.0
    • query
    • None

    Description

      cc Keshav Murthy Perry Krug

      Based on customer feedback, we should make

      some_expr LIKE '%pattern%'
      

      work faster. It should automatically use a SUFFIXES( some_expr ) index if one exists.

      LIKEwise, we need a function or keyword that uses a TOKENS( some_expr ) index.

      HAS_TOKEN( some_expr, 'token' )
      

      Attachments

        Issue Links

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

          Activity

            People

              ajay.bhullar Ajay Bhullar
              gerald Gerald Sangudi (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