[teiid-issues] [JBoss JIRA] Created: (TEIID-939) MySQL nested set query pushdown failure
Steven Hawkins (JIRA)
jira-events at lists.jboss.org
Thu Jan 21 21:21:19 EST 2010
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). The only problem for MySQL is that you cannot left nest a union all under a union.
--
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
More information about the teiid-issues
mailing list