| Key: |
DERBY-20
|
| Type: |
Bug
|
| Status: |
Closed
|
| Resolution: |
Duplicate
|
| Priority: |
Minor
|
| Assignee: |
Unassigned
|
| Reporter: |
Tulika Agrawal
|
| Votes: |
0
|
| Watchers: |
2
|
|
If you were logged in you would be able to see more operations.
|
|
|
|
File Attachments:
|
| |
Size |
|
server.log |
2005-07-22 05:12 AM |
David Van Couvering |
395 kB |
|
|
| Resolution Date: |
31/Jul/06 06:33 AM
|
|
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.
|
|
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. |
Show » |
made changes - 22/Jul/05 05:12 AM
| Field |
Original Value |
New Value |
|
Attachment
|
|
server.log
[ 12311348
]
|
made changes - 31/Jul/06 06:33 AM
|
Fix Version/s
|
|
10.2.0.0
[ 11187
]
|
|
Fix Version/s
|
|
10.1.3.1
[ 12311953
]
|
|
Status
|
Open
[ 1
]
|
Closed
[ 6
]
|
|
Resolution
|
|
Duplicate
[ 3
]
|
|
LIKE handles strings with control characters incorrectly.
