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: [PATCH] Synonym support in Derby.
Date Fri, 03 Jun 2005 22:59:55 GMT
Satheesh Bandaram wrote:

>    2. While I am providing implementation that allows creating synonyms
>       for tables and views, it is possible to extend this mechanism to
>       other database objects as well, like procedures or functions. Some
>       of the database vendors already support this.

How does that work? If I create


Does this synonym work for tables, views procedures, functions etc?

CALL B -> really is CALL A;
SELECT B() * FROM B -> really is SELECT A() * FROM A

Ie. with the same single synonym?

Thus if in in the future Derby extended SYNONYM support to procedures
and functions, then creating a synonym B would have to ensure all of
the following:
   - no tables called B
   - no views called B
   - no procedures called B
   - no functions called B

Thus the synonym namespace is really a union of the namespaces it can
map to?


View raw message