db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Rick Hillegas (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (DERBY-6109) Allow CREATE SYNONYM for table function invocations.
Date Tue, 19 Mar 2013 15:21:15 GMT

    [ https://issues.apache.org/jira/browse/DERBY-6109?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13606398#comment-13606398
] 

Rick Hillegas commented on DERBY-6109:
--------------------------------------

Note that the proposed syntax would be a significant departure from how other databases implement
synonyms. For other databases, the synonym is just a replacement name for the name of another
database object (table, view, function, procedure, sequence, another synonym). The syntax
for other databases is pretty much as follows:

  create [ or replace ] [ public | private ] synonym [ <schemaName> . ] <identifier>
for [ <schemaName> . ] <identifier>

Here are syntax examples for various other databases:

Oracle: http://www.techonthenet.com/oracle/synonyms.php

IBM Informix: http://publib.boulder.ibm.com/infocenter/idshelp/v10/index.jsp?topic=/com.ibm.sqls.doc/sqls272.htm

Microsoft SQL Server: http://msdn.microsoft.com/en-us/library/ms177544.aspx

EnterpriseDB: http://www.enterprisedb.com/docs/en/8.4/oracompat/Postgres_Plus_Advanced_Server_Oracle_Compatibility_Guide-33.htm

The broad agreement among other databases suggests that the proposed Derby syntax would not
conform if the SQL committee decided to standardize CREATE SYNONYM.
                
> Allow CREATE SYNONYM for table function invocations.
> ----------------------------------------------------
>
>                 Key: DERBY-6109
>                 URL: https://issues.apache.org/jira/browse/DERBY-6109
>             Project: Derby
>          Issue Type: Improvement
>          Components: SQL
>    Affects Versions: 10.10.1.1
>            Reporter: Rick Hillegas
>
> SYNONYMs are a non-standard extension supported by many databases. See DERBY-335. Right
now SYNONYMs are only allowed for tables and views. It would be useful (and should be easy)
to extend this feature to support SYNONYMs for table function invocations. E.g.:
> CREATE SYNONYM LT0 for TABLE( LT0() )
> CREATE SYNONYM LT0_P for TABLE( LT0('with_provenance') )
> See the discussion of this topic on this email thread: http://apache-database.10148.n7.nabble.com/Limitations-of-Table-Functions-vs-old-VTIs-td127988.html

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira

Mime
View raw message