Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: <derby-dev@db.apache.org>
Date: Fri, 22 Mar 2013 06:57:16 +0000 (UTC)
From: "Dag H. Wanvik (JIRA)" <jira@apache.org>
To: derby-dev@db.apache.org
Message-ID: <JIRA.12636820.1363197460700.33426.1363935436577@arcas>
In-Reply-To: <JIRA.12636820.1363197460700@arcas>
References: <JIRA.12636820.1363197460700@arcas>
Subject: [jira] [Commented] (DERBY-6109) Allow CREATE SYNONYM for table
 function invocations.
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit


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

Dag H. Wanvik commented on DERBY-6109:
--------------------------------------

Trying to grok that rationale for this, what would be the difference between a "wrapper view" and this new mechanism? And how would it facilitate projection pushing?
                
> 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