[ http://issues.apache.org/jira/browse/DERBY-347?page=comments#action_12313495 ]
Satheesh Bandaram commented on DERBY-347: ----------------------------------------- The patch looks good, though I would add more description to the CREATE SYNONYM section. Can we also add the following information? * A synonym can be defined for a table/view that doesn't exists at the synonym creation time. If it doesn't exists, a warning (SQLSTATE 01522) is raised. The referenced object must be present when a synonym is used in a DML statement. * A synonym can be created for another synonym. However, attempts to create a synonym that results in a circular references throws an error. (SQLSTATE 42916) * If a two part synonym name is specified, the schema name can't start with 'SYS' * A synonym can't be defined on a temporary table. (SQLSTATE XCL51) > Document SYNONYM support > ------------------------ > > Key: DERBY-347 > URL: http://issues.apache.org/jira/browse/DERBY-347 > Project: Derby > Type: Sub-task > Components: Documentation > Environment: all > Reporter: Jeff Levitt > Assignee: Jeff Levitt > Priority: Minor > Fix For: 10.1.0.0 > Attachments: derby335.zip > > Provide documentation for SYNONYM support....see parent issue (Derby 335) for > functionality. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira
