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

[dalex dalex (JIRA)]

dalex dalex created TEIID-4237:
----------------------------------

             Summary: 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


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)