[teiid-issues] [JBoss JIRA] Updated: (TEIID-939) MySQL nested set query pushdown failure

Tue Jan 26 11:00:19 EST 2010

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

Steven Hawkins updated TEIID-939:
---------------------------------

    Description: By default our translator is adding parens around nested set queries, this is not supported by MySQL.  The parens can safely be dropped as long as both the parent and the child are the same set operation (union, or union all).  This generic solution still leaves the problem for MySQL that you cannot left nest a union under a union all.  That case should be rare and can be worked around on mysql 5.  (was: By default our translator is adding parens around nested set queries, this is not supported by MySQL.  The parens can safely be dropped as long as both the parent and the child are the same set operation (union, or union all).  The only problem for MySQL is that you cannot left nest a union all under a union.)


> MySQL nested set query pushdown failure
> ---------------------------------------
>
>                 Key: TEIID-939
>                 URL: https://jira.jboss.org/jira/browse/TEIID-939
>             Project: Teiid
>          Issue Type: Bug
>          Components: JDBC Connector
>    Affects Versions: 6.0.0
>            Reporter: Steven Hawkins
>            Assignee: Steven Hawkins
>             Fix For: 7.0
>
>
> By default our translator is adding parens around nested set queries, this is not supported by MySQL.  The parens can safely be dropped as long as both the parent and the child are the same set operation (union, or union all).  This generic solution still leaves the problem for MySQL that you cannot left nest a union under a union all.  That case should be rare and can be worked around on mysql 5.

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