[ https://issues.jboss.org/browse/TEIID-4237?page=com.atlassian.jira.plugin... ] dalex dalex updated TEIID-4237: ------------------------------- Steps to Reproduce: Run the following query on teiid and mysql: {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} and compare gotten results. was: Run 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 and mysql and compare gotten results. -- This message was sent by Atlassian JIRA (v6.4.11#64026)