Derby
  1. Derby
  2. DERBY-20

LIKE handles strings with control characters incorrectly.

    Details

    • Type: Bug Bug
    • Status: Closed
    • Priority: Minor Minor
    • Resolution: Duplicate
    • Affects Version/s: 10.0.2.0
    • Fix Version/s: 10.1.3.1, 10.2.1.6
    • Component/s: SQL
    • Labels:
      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.

      1. server.log
        395 kB
        David Van Couvering

        Activity

        Tulika Agrawal created issue -
        David Van Couvering made changes -
        Field Original Value New Value
        Attachment server.log [ 12311348 ]
        Øystein Grøvlen made changes -
        Resolution Duplicate [ 3 ]
        Status Open [ 1 ] Closed [ 6 ]
        Fix Version/s 10.2.0.0 [ 11187 ]
        Fix Version/s 10.1.3.1 [ 12311953 ]
        Gavin made changes -
        Workflow jira [ 37520 ] Default workflow, editable Closed status [ 12801242 ]

          People

          • Assignee:
            Unassigned
            Reporter:
            Tulika Agrawal
          • Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:

              Development