Uploaded image for project: 'Derby'
  1. Derby
  2. DERBY-20

LIKE handles strings with control characters incorrectly.

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Minor
    • Resolution: Duplicate
    • 10.0.2.0
    • 10.1.3.1, 10.2.1.6
    • SQL
    • None

    Description

      Reporting for Daniel John Debrunner.

      If a string contains control characters in the regions matched
      by wild card characters then in some situations a LIKE will
      return false instead of true and the row will not be returned.

      Caused by the dynamic like optimization using >= with a prefix
      which is is equivalent to >= on the prefeix appended with
      blanks and not null (\u0000) characters.

      Attachments

        1. server.log
          395 kB
          David Van Couvering

        Activity

          People

            Unassigned Unassigned
            tulika Tulika Agrawal
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: