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

[Dmitrii Pogorelov (Jira)]

Dmitrii Pogorelov created TEIID-5930:
----------------------------------------

             Summary: 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


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)