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

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.