[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