db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Satheesh Bandaram <sathe...@Sourcery.Org>
Subject Re: [PATCH] Synonym support in Derby.
Date Sat, 04 Jun 2005 00:31:15 GMT
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
  <meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
  <title></title>
</head>
<body bgcolor="#ffffff" text="#000000">
Take a look at Oracle approach:
<a class="moz-txt-link-freetext" href="http://download-west.oracle.com/docs/cd/B14117_01/server.101/b10759/statements_7001.htm#CJAJCDDF">http://download-west.oracle.com/docs/cd/B14117_01/server.101/b10759/statements_7001.htm#CJAJCDDF</a><br>
<br>
I sure can't fully understand how they resolve synonyms, without
confusion. They even have public and private synonyms. I don't have
access to an installation to try it out.<br>
<br>
I tried to make just the catalog design extendable for future. May be
not a good idea. I can rewrite the catalog mechanism if that is
preferred.<br>
<br>
Satheesh<br>
<br>
Daniel John Debrunner wrote:<br>
<blockquote cite="mid42A0E0EB.5090409@debrunners.com" type="cite">
  <pre wrap="">Satheesh Bandaram wrote:


  </pre>
  <blockquote type="cite">
    <pre wrap="">   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.
    </pre>
  </blockquote>
  <pre wrap=""><!---->
How does that work? If I create

CREATE SYNONYM B FOR A


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

CALL B -&gt; really is CALL A;
SELECT B() * FROM B -&gt; 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?

Dan.




  </pre>
</blockquote>
</body>
</html>


Mime
View raw message