[teiid-issues] [JBoss JIRA] (TEIID-3386) Mixed resutl with (double) full outer join and where clause

[RH Bugzilla Integration (JIRA)]

    [ https://issues.jboss.org/browse/TEIID-3386?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13104826#comment-13104826 ] 

RH Bugzilla Integration commented on TEIID-3386:
------------------------------------------------

David Le Sage <dlesage at redhat.com> changed the Status of [bug 1202847|https://bugzilla.redhat.com/show_bug.cgi?id=1202847] from ASSIGNED to MODIFIED

> Mixed resutl with (double) full outer join and where clause
> -----------------------------------------------------------
>
>                 Key: TEIID-3386
>                 URL: https://issues.jboss.org/browse/TEIID-3386
>             Project: Teiid
>          Issue Type: Bug
>    Affects Versions: 8.7.1
>            Reporter: Juraj Duráni
>            Assignee: Steven Hawkins
>         Attachments: server.log
>
>
> If a query contains double FULL OUTER JOIN and WHERE clause that contains condition on column from last table, teiid returns mixed result (underlying oracle10).
> Query:
> SELECT BQT1.SmallA.IntKey AS SmallA_IntKey, BQT2.MediumB.IntKey AS MediumB_IntKey, BQT2.LargeB.IntKey AS LargeB_IntKey
> FROM (BQT1.SmallA FULL OUTER JOIN BQT2.MediumB ON BQT1.SmallA.IntKey = BQT2.MediumB.IntKey) FULL OUTER JOIN BQT2.LargeB ON BQT2.MediumB.IntKey = BQT2.LargeB.IntKey
> WHERE BQT2.LargeB.IntKey < 1500 ORDER BY LargeB_IntKey, MediumB_IntKey, SmallA_IntKey;
> Actual result:
> 0	0	0
> 1	1	1
> 2	2	2
> 3	3	3
> ...    ...      ...
> 49	49	49
> 50	50	50
> ...    ...      ...
> 999	999	999
> <null>	<null>	1000
> ...    ...      ...
> <null>	<null>	1499
> Expected result:
> 0	0	0
> 1	1	1
> 2	2	2
> 3	3	3
> ...    ...      ...
> 49	49	49
> <null>	50	50
> ...    ...      ...
> 999	999	999
> <null>	<null>	1000
> ...    ...      ...
> <null>	<null>	1499



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)