db-derby-dev mailing list archives

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

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

Mamta A. Satoor commented on DERBY-6109:
----------------------------------------

DB2 syntax for CREATE SYNONYM can be found at http://pic.dhe.ibm.com/infocenter/dzichelp/v2r2/index.jsp?topic=%2Fcom.ibm.db2z10.doc.sqlref%2Fsrc%2Ftpc%2Fdb2z_sql_createsynonym.htm
                
> 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