[teiid-issues] [JBoss JIRA] (TEIID-1622) Optional JOIN hints don't get optimized out for UNION ALL view
[
https://issues.jboss.org/browse/TEIID-1622?page=com.atlassian.jira.plugin...
]
Warren Gibson closed TEIID-1622.
--------------------------------
1/5/2012 - Covered by unit test "TestOptimizer.testOptionalJoinWithUnion" with
the following query:
select pm1.g2.e4 from /* optional */ pm1.g1 inner join pm1.g2 on pm1.g1.e1 = pm1.g2.e1
union all
select convert(pm1.g2.e2, double) from /* optional */ pm1.g1 inner join pm1.g2 on
pm1.g1.e1 = pm1.g2.e1
Optional JOIN hints don't get optimized out for UNION ALL view
--------------------------------------------------------------
Key: TEIID-1622
URL: https://issues.jboss.org/browse/TEIID-1622
Project: Teiid
Issue Type: Bug
Components: Server
Affects Versions: 7.1.1
Reporter: Mark Drilling
Assignee: Steven Hawkins
Fix For: 7.1.1
Attachments: 1622.patch
When we create a view with Optional JOIN hint on it, and execute a query against this
view, the hint is properly honored. But if we create a view with UNION ALL on two such
views and query the UNION ALL view the optional hint is not honored
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira