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

Query with like predicate to search special characters doesn't return results

    XMLWordPrintable

Details

    • Bug
    • Resolution: User Error
    • Major
    • 6.0.3, 6.5.0
    • 6.0.3, 6.5.0
    • query
    • None
    • Untriaged
    • No

    Description

      Build : 6.0.3-2872

      Steps:
      1. Create a bucket and load 1 doc like the following :
      {
      "test": "abc ()/\\[]{}.,<>~!@#$%&*-_+=|;:'\"?"
      }
      2. Create index :
      create index idx1 on test(test);
      3. Run query :
      select * from test where test like "%?%";
      No documents are returned, while the doc created in step 1 should have been returned.

      Similarly queries with any special characters do not return any result.

      The same queries return results with Analytics.

      Attachments

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

        Activity

          People

            keshav Keshav Murthy
            mihir.kamdar Mihir Kamdar (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Gerrit Reviews

                There are no open Gerrit changes

                PagerDuty