[teiid-issues] [JBoss JIRA] Closed: (TEIID-1097) Add support for nested table references

Sat Jun 19 06:55:47 EDT 2010

     [ https://jira.jboss.org/browse/TEIID-1097?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Steve Hawkins closed TEIID-1097.
--------------------------------


> Add support for nested table references
> ---------------------------------------
>
>                 Key: TEIID-1097
>                 URL: https://jira.jboss.org/browse/TEIID-1097
>             Project: Teiid
>          Issue Type: Feature Request
>          Components: Query Engine
>    Affects Versions: 7.0
>            Reporter: Steve Hawkins
>            Assignee: Steve Hawkins
>             Fix For: 7.0
>
>
> Our current approach to procedural relational queries that relies upon criteria is difficult to use and causes numerous problems, such as TEIID-32 and unclear applicability of default values.  It would be easier to just add support nested table references. e.g.
> select * from t, table(... t.x) t1
> Where the join between the procedure or query contained in the table expression is implied.  See http://publib.boulder.ibm.com/infocenter/dzichelp/v2r2/index.jsp?topic=/com.ibm.db29.doc.sqlref/db2z_sql_tablereference.htm for more on the usage constraints.
> This functionality is also needed by the XMLTABLE function.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira