[DERBY-6109] Allow CREATE SYNONYM for table function invocations.

• Type: Improvement
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 10.10.1.1
• Component/s: SQL
• Labels: derby_triage10_11
• Urgency: Normal
• Assignee: Unassigned
• Reporter: Richard N. Hillegas
• Created: 13/Mar/13 17:57
• Updated: 25/Jun/13 04:19

Description

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

Issue Links

• relates to: DERBY-6036 If you wrap a SELECT * view around a table, all of the columns are read from the base row even when you SELECT only a subset of the view columns.
• relates to: DERBY-335 Enhance Derby by adding SYNONYM support. A synonym is an alternate name for a view or a table.