[
https://issues.apache.org/jira/browse/DERBY-4654?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Knut Anders Hatlen updated DERBY-4654:
--------------------------------------
Issue & fix info: [Patch Available]
All the regression tests passed.
> Restriction.toSQL() doesn't escape special characters
> -----------------------------------------------------
>
> Key: DERBY-4654
> URL: https://issues.apache.org/jira/browse/DERBY-4654
> Project: Derby
> Issue Type: Bug
> Components: SQL
> Affects Versions: 10.6.1.0
> Reporter: Knut Anders Hatlen
> Assignee: Knut Anders Hatlen
> Priority: Minor
> Attachments: derby-4654.diff
>
>
> org.apache.derby.vti.Restriction.toSQL() adds double quotes around column
> names, but it does not escape the special characters (like double quotes) in
> the column names, so the returned string may not be valid SQL. This could
> cause problems when using the restriction to generate a query against an
> external database.
> Restriction.doubleQuote() should use IdUtil.normalToDelimited() to get proper
> quoting of the names.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
