Allow for specifying a <derived column list> when referencing tables, not only
when referencing derived tables
--------------------------------------------------------------------------------------------------------------
Key: CORE-4025
URL: http://tracker.firebirdsql.org/browse/CORE-4025
Project: Firebird Core
Issue Type: New Feature
Components: Engine
Affects Versions: 2.5.2
Reporter: Lukas Eder
Priority: Minor
The SQL:2008 Standard specifies:
7.6 <table reference>
<table reference> ::=
<table factor>
| <joined table>
<table factor> ::=
<table primary> [ <sample clause> ]
<table primary> ::=
<table or query name> [ [ AS ] <correlation name>
[ <left paren> <derived column list> <right paren> ] ]
| <derived table> [ AS ] <correlation name>
[ <left paren> <derived column list> <right paren> ]
| [...]
In other words, not only derived tables can have their columns renamed, but
also regular table references. I.e. the following two SQL statements should
have an equivalent behaviour:
SELECT x.a, x.b FROM my_table x(a, b)
SELECT x.a, x.b FROM (SELECT * FROM my_table) x(a, b)
However, Firebird only supports the latter. This is documented here:
http://www.firebirdsql.org/refdocs/langrefupd21-select.html#langrefupd21-derived-tables
It would be nice for firebird to allow for derived-column-lists also for simple
table references
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
------------------------------------------------------------------------------
Master Java SE, Java EE, Eclipse, Spring, Hibernate, JavaScript, jQuery
and much more. Keep your Java skills current with LearnJavaNow -
200+ hours of step-by-step video tutorials by Java experts.
SALE $49.99 this month only -- learn more at:
http://p.sf.net/sfu/learnmore_122612
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
