[ http://issues.apache.org/jira/browse/DERBY-335?page=all ]
Satheesh Bandaram updated DERBY-335:
------------------------------------
Attachment: synonym.patch.jira
Second version of the patch. Still to implement include
* Dependency registration and checking. (will be submitted as another
patch)
* May make minor reorg of code to merge resolveTableToSynonym with
existing routines.
> Enhance Derby by adding SYNONYM support. A synonym is an alternate name for a
> view or a table.
> ----------------------------------------------------------------------------------------------
>
> Key: DERBY-335
> URL: http://issues.apache.org/jira/browse/DERBY-335
> Project: Derby
> Type: New Feature
> Components: SQL
> Versions: 10.1.0.0
> Environment: Generic
> Reporter: Satheesh Bandaram
> Assignee: Satheesh Bandaram
> Fix For: 10.1.0.0
> Attachments: synonym.patch.jira
>
> Synonym provides an alternate name for a table or a view that is present in
> the same schema or another schema. A synonym can also be created for another
> synonym, causing nesting of synonyms. A synonym can be used in SELECT,
> INSERT, UPDATE, DELETE or LOCK TABLE statements instead of the original
> qualified table or view name. Note that a synonym can be created for a table
> or a view that doesn't yet exists. But the target table/view must be present
> before the synonym can be used.
> Synonyms are supported by all major database vendors, including Oracle, DB2
> and mySQL. DB2 also allows CREATE ALIAS statement, which does exactly same as
> CREATE SYNONYM. Creating aliases instead of synonyms is not supported by
> Oracle or mySQL, so I propose that Derby not support creating aliases.
> Synonyms are not part of SQL-2003 spec, but is a common-SQL statement among
> major database vendors. SQL standard doesn't pay attention to DDLs as much,
> so I suspect they skipped synonyms.
> I will be adding two new DDL statements to Derby:
> CREATE SYNONYM <SynonymSchema>.<SynonymName> FOR <TargetSchema>.<TargetName>
> DROP SYNONYM <SynonymSchema>.<SynonymName>
> Synonyms share the same namespace as tables or views. It is not possible to
> create a synonym with same name as a table that already exists in the same
> schema. Similarly, a table/view can't be created that matches a synonym
> already present.
--
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
