[
https://issues.apache.org/jira/browse/DERBY-5862?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13419601#comment-13419601
]
Knut Anders Hatlen commented on DERBY-5862:
-------------------------------------------
We might be able to do this without adding more internal syntax, as it looks
like we accept NULL in the escape clause if it's parameterized:
ij> prepare ps as 'select tablename from sys.systables where tablename like
''SYSD%'' escape ?';
ij> execute ps using 'values cast( null as char(1) )';
IJ WARNING: Autocommit may close using result set
TABLENAME
--------------------------------------------------------------------------------------------------------------------------------
SYSDEPENDS
SYSDUMMY1
2 rows selected
> There is no way to escape the special _ and % characters in DatabaseMetaData
> search strings
> -------------------------------------------------------------------------------------------
>
> Key: DERBY-5862
> URL: https://issues.apache.org/jira/browse/DERBY-5862
> Project: Derby
> Issue Type: Bug
> Components: JDBC
> Affects Versions: 10.10.0.0
> Reporter: Rick Hillegas
>
> 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
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
