db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Daniel John Debrunner <...@debrunners.com>
Subject Re: [jira] Commented: (DERBY-347) Document SYNONYM support
Date Tue, 14 Jun 2005 14:26:32 GMT
Satheesh Bandaram (JIRA) wrote:

>     [ 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.
[snip]
>   *  A synonym can't be defined on a temporary table. (SQLSTATE XCL51)

Is the temp table restriction a DDL time (CREATE SYNONYM) failure or a
runtime (when the SYNONYM is used in a statement)?

Because error XCL51 doesn't exactly match what you describe. XCL51
indicates the operation cannot reference a table in the SESSION schema,
which is where temp tables are defined but that schema can also support
normal tables.

Dan.




Mime
View raw message