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

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

    XMLWordPrintable

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • 2.5.0
    • 2.7.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

            Build couchbase-lite-net-2.7.0-48 contains couchbase-lite-core commit 0749df2 with commit message:
            CBL-52 Make the LIKE and CONTAINS functions collation aware (#848)

            build-team Couchbase Build Team added a comment - Build couchbase-lite-net-2.7.0-48 contains couchbase-lite-core commit 0749df2 with commit message: CBL-52 Make the LIKE and CONTAINS functions collation aware (#848)

            Build couchbase-lite-cblite-2.6.0-170 contains couchbase-lite-core commit 0749df2 with commit message:
            CBL-52 Make the LIKE and CONTAINS functions collation aware (#848)

            build-team Couchbase Build Team added a comment - Build couchbase-lite-cblite-2.6.0-170 contains couchbase-lite-core commit 0749df2 with commit message: CBL-52 Make the LIKE and CONTAINS functions collation aware (#848)

            Build couchbase-lite-ios-2.7.0-46 contains couchbase-lite-core commit 0749df2 with commit message:
            CBL-52 Make the LIKE and CONTAINS functions collation aware (#848)

            build-team Couchbase Build Team added a comment - Build couchbase-lite-ios-2.7.0-46 contains couchbase-lite-core commit 0749df2 with commit message: CBL-52 Make the LIKE and CONTAINS functions collation aware (#848)

            Build couchbase-lite-log-2.7.0-79 contains couchbase-lite-core commit 0749df2 with commit message:
            CBL-52 Make the LIKE and CONTAINS functions collation aware (#848)

            build-team Couchbase Build Team added a comment - Build couchbase-lite-log-2.7.0-79 contains couchbase-lite-core commit 0749df2 with commit message: CBL-52 Make the LIKE and CONTAINS functions collation aware (#848)

            Build couchbase-lite-cblite-2.7.0-5 contains couchbase-lite-core commit 0749df2 with commit message:
            CBL-52 Make the LIKE and CONTAINS functions collation aware (#848)

            build-team Couchbase Build Team added a comment - Build couchbase-lite-cblite-2.7.0-5 contains couchbase-lite-core commit 0749df2 with commit message: CBL-52 Make the LIKE and CONTAINS functions collation aware (#848)

            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