[teiid-issues] [JBoss JIRA] (TEIID-4237) INNER JOIN returns incorrect results
dalex dalex (JIRA)
issues at jboss.org
Wed Jun 1 12:33:00 EDT 2016
[ https://issues.jboss.org/browse/TEIID-4237?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
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.
> 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)
More information about the teiid-issues
mailing list