[
https://issues.apache.org/jira/browse/DERBY-5168?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Knut Anders Hatlen closed DERBY-5168.
-------------------------------------
Resolution: Fixed
Fix Version/s: 10.8.0.0
Issue & fix info: (was: [Patch Available])
Committed revision 1087641.
> Wrong syntax in identifier chain returned by SynonymAliasInfo.toString()
> ------------------------------------------------------------------------
>
> Key: DERBY-5168
> URL: https://issues.apache.org/jira/browse/DERBY-5168
> Project: Derby
> Issue Type: Bug
> Components: SQL
> Affects Versions: 10.7.1.1
> Reporter: Knut Anders Hatlen
> Assignee: Knut Anders Hatlen
> Fix For: 10.8.0.0
>
> Attachments: derby-5168-1a.diff
>
>
> SynonymAliasInfo.toString() doesn't quote identifiers correctly. Example:
> ij> create table """"(x int);
> 0 rows inserted/updated/deleted
> ij> create synonym s1 for """";
> 0 rows inserted/updated/deleted
> ij> select aliasinfo from sys.sysaliases where alias = 'S1';
> ALIASINFO
> ---------------
> "APP"."""
> 1 row selected
> The returned value should say:
> "APP".""""
> That is, there should be one more double quote character.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira