Rick Hillegas created DERBY-6109:
------------------------------------

             Summary: 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.0.0
            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

Reply via email to