[teiid-issues] [JBoss JIRA] (TEIID-4637) join of aliased views with partitioned unions not handled correctly.

[Steven Hawkins (JIRA)]

     [ https://issues.jboss.org/browse/TEIID-4637?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Steven Hawkins resolved TEIID-4637.
-----------------------------------
    Resolution: Done


With the fix a query such as:

select * from v as t1 inner join v as t2 on t1.part = t2.part and t1.intkey = t2.intkey

which alias the partitioned union view v will still be converted into a union of joins.

where v is defined as:

create view v as SELECT 1 as part, IntKey FROM SmallA as t1 UNION ALL SELECT 2 as part, intkey FROM SmallB as t2

> join of aliased views with partitioned unions not handled correctly.
> --------------------------------------------------------------------
>
>                 Key: TEIID-4637
>                 URL: https://issues.jboss.org/browse/TEIID-4637
>             Project: Teiid
>          Issue Type: Bug
>          Components: Query Engine
>            Reporter: Steven Hawkins
>            Assignee: Steven Hawkins
>             Fix For: 9.2, 9.1.2
>
>
> The partitioning logic uses the same partition info key regardless of what the alias name and then can't find the partition sets with the alias name, the the plan is not converted to a union of joins.



--
This message was sent by Atlassian JIRA
(v7.2.3#72005)