[DERBY-5168] Wrong syntax in identifier chain returned by SynonymAliasInfo.toString()

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 10.7.1.1
• Fix Version/s: 10.8.1.2
• Component/s: SQL
• Assignee: Knut Anders Hatlen
• Reporter: Knut Anders Hatlen
• Created: 31/Mar/11 15:23
• Updated: 19/Apr/11 12:39
• Resolved: 01/Apr/11 10:45

Description

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.