Message: A new issue has been created in JIRA.
--------------------------------------------------------------------- View the issue: http://issues.apache.org/jira/browse/DERBY-20 Here is an overview of the issue: --------------------------------------------------------------------- Key: DERBY-20 Summary: LIKE handles strings with control characters incorrectly. Type: Bug Status: Unassigned Priority: Minor Project: Derby Components: SQL Versions: 10.0.2.0 Assignee: Reporter: Tulika Agrawal Created: Wed, 29 Sep 2004 12:11 PM Updated: Wed, 29 Sep 2004 12:11 PM 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. --------------------------------------------------------------------- JIRA INFORMATION: This message is automatically generated by JIRA. If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa If you want more information on JIRA, or have a bug to report see: http://www.atlassian.com/software/jira
