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

[Steven Hawkins (JIRA)]

     [ https://issues.jboss.org/browse/TEIID-3386?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Steven Hawkins closed TEIID-3386.
---------------------------------


> 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.4.11#64026)