[DERBY-5862] There is no way to escape the special _ and % characters in DatabaseMetaData search strings

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 10.10.1.1
• Component/s: JDBC
• Labels: derby_triage10_10
• Urgency: Normal
• Issue & fix info: Release Note Needed
• Bug behavior facts: Seen in production
• Assignee: Unassigned
• Reporter: Richard N. Hillegas
• Created: 18/Jul/12 13:28
• Updated: 28/Dec/12 08:56

Description

And DatabaseMetaData.getSearchStringEscape() returns an empty string. We should add a way to configure a search string escape character. See the discussion on this email thread: http://old.nabble.com/derby-getProcedureColumns-td34176144.html#a34176144

Issue Links

• is related to: DERBY-5875 Derby returns wrong results when you set the ESCAPE character to NULL in a LIKE clause.
• is related to: DERBY-5869 getProcedureColumns doesn't handle escaping in patterns correctly