[teiid-issues] [JBoss JIRA] (TEIID-4237) INNER JOIN returns incorrect results

[Johnathon Lee (JIRA)]

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

Johnathon Lee updated TEIID-4237:
---------------------------------
    Fix Version/s: 8.7.6


> INNER JOIN returns incorrect results
> ------------------------------------
>
>                 Key: TEIID-4237
>                 URL: https://issues.jboss.org/browse/TEIID-4237
>             Project: Teiid
>          Issue Type: Bug
>          Components: Query Engine
>    Affects Versions: 8.12
>         Environment: teiid-8.12-Beta1 on Red Hat JBoss Enterprise Application Platform - Version 6.3.0.GA
>            Reporter: dalex dalex
>            Assignee: Steven Hawkins
>            Priority: Blocker
>             Fix For: 9.0, 8.7.6, 8.12.5, 8.13.5
>
>
> Running the following query:
> {code:sql}
> select avg(t1.a) from 
> 	(select 3 as a, 3 as b union all
> 	select 1 as a, 1 as b union all
> 	select 3 as a, 3 as b) as t1 
> join (select 1 as a, 1 as b union all
> 	select 1 as a, 1 as b union all
> 	select 2 as a, 2 as b union all
> 	select 2 as a, 2 as b union all
> 	select 3 as a, 3 as b union all
> 	select 3 as a, 3 as b) as t2 on t1.a=t2.a
> {code}
> on teiid causes incorrect result: 2 in comparing with mysql which returns 2.333.



--
This message was sent by Atlassian JIRA
(v6.4.11#64026)