[teiid-issues] [JBoss JIRA] (TEIID-1622) Optional JOIN hints don't get optimized out for UNION ALL view
Warren Gibson (Closed) (JIRA)
jira-events at lists.jboss.org
Thu Jan 5 12:06:09 EST 2012
[ https://issues.jboss.org/browse/TEIID-1622?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
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
More information about the teiid-issues
mailing list