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.7.7.6_2, 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.