[teiid-issues] [JBoss JIRA] (TEIID-2039) Virtual table mapping with large number of UNIONs is resulting in excessively long source query
[
https://issues.jboss.org/browse/TEIID-2039?page=com.atlassian.jira.plugin...
]
Steven Hawkins resolved TEIID-2039.
-----------------------------------
Resolution: Done
added the capability supportsOnlyCorrelatedSubqueries that can be overridden if needed to
prevent the pushdown of non-correlated scalar/exists subqueries that will just be
pre-evaluated. non-correlated in/quantified compare will typically be transformed into a
join or scalar subquery if possible.
Virtual table mapping with large number of UNIONs is resulting in
excessively long source query
-----------------------------------------------------------------------------------------------
Key: TEIID-2039
URL: https://issues.jboss.org/browse/TEIID-2039
Project: Teiid
Issue Type: Bug
Components: Query Engine
Affects Versions: 7.4.1, 7.7
Reporter: Marc Shirley
Assignee: Steven Hawkins
Fix For: 8.3
Queries against a virtual table built upon several layers of UNION transformations is
resulting in what appears to be a badly formed, excessively long source query (for
example, a SQL string over 1 million characters) that results in slow query execution.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira