db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Satheesh Bandaram (JIRA)" <derby-...@db.apache.org>
Subject [jira] Commented: (DERBY-347) Document SYNONYM support
Date Mon, 13 Jun 2005 17:56:49 GMT
    [ 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


Mime
View raw message