[teiid-issues] [JBoss JIRA] (TEIID-5930) FULL JOIN missing data when not using LIMIT clause

[Dmitrii Pogorelov (Jira)]

    [ https://issues.redhat.com/browse/TEIID-5930?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14029180#comment-14029180 ] 

Dmitrii Pogorelov commented on TEIID-5930:
------------------------------------------

[~shawkins] thx a lot for the quick fix, it worked!

> FULL JOIN missing data when not using LIMIT clause
> --------------------------------------------------
>
>                 Key: TEIID-5930
>                 URL: https://issues.redhat.com/browse/TEIID-5930
>             Project: Teiid
>          Issue Type: Bug
>          Components: Query Engine
>    Affects Versions: 13.1
>            Reporter: Dmitrii Pogorelov
>            Assignee: Steven Hawkins
>            Priority: Blocker
>             Fix For: 14.0, 13.0.3, 13.1.1
>
>   Original Estimate: 4 hours
>          Time Spent: 3 hours
>  Remaining Estimate: 1 hour
>
> When commenting out/uncommenting limit clause in the query:
> {code:sql}
> SELECT COUNT(*) 
> FROM 
>     (
>         SELECT 
>             date_value1 
>             , id
>         FROM views.view1_m 
>         Limit 1000000000
>     ) v1 
> full 
> JOIN  
>     (
>         SELECT 
>             date_value2 
>             , id
>         FROM views.view2_m 
>         LIMIT 1000000000
>     ) v2 
>     ON 
>         v1.date_value1 = v2.date_value2 
>         and v1.id = v2.id ;;
> {code}
> teiid returns different results, for example, when using limits in all subqueries Teiid will return 3652, but when commenting out all limit clauses teiid in turn will return already 0. 



--
This message was sent by Atlassian Jira
(v7.13.8#713008)