Uploaded image for project: 'Couchbase Lite'
  1. Couchbase Lite
  2. CBL-52

“LIKE”, "CONTAINS", "REGEX_LIKE" operators ignore collations

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • Major
    • 2.7.0
    • 2.5.0
    • LiteCore
    • Security Level: Public
    • CBL Sprint 3, CBL Sprint 4
    • 5

    Description

      The query LIKE operator and family just translates into a SQL LIKE operator, etc, and SQLite's implementation of it ignores collations: it's always case-insensitive for ASCII but case-sensitive and diacritic-sensitive for non-ASCII (it just compares non-ASCII bytes bit-for-bit.)

      We will need to implement our own function that's aware of the collation applied to the LHS.

      Attachments

        Issue Links

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

          Activity

            People

              jimb Jim Borden
              jimb Jim Borden
              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