[
https://issues.redhat.com/browse/TEIID-5937?page=com.atlassian.jira.plugi...
]
Steven Hawkins updated TEIID-5937:
----------------------------------
Original Estimate: 4 hours
Remaining Estimate: 4 hours
Story Points: 0.5
Sprint: DV Sprint 62
Note that this is an issue with projection optimization due to using an effectively scalar
subquery. If you are selecting from regular tables there is no issue.
Union All followed by except returns wrong results
--------------------------------------------------
Key: TEIID-5937
URL:
https://issues.redhat.com/browse/TEIID-5937
Project: Teiid
Issue Type: Bug
Components: Query Engine
Affects Versions: 13.1
Reporter: Dmitrii Pogorelov
Assignee: Steven Hawkins
Priority: Blocker
Original Estimate: 4 hours
Remaining Estimate: 4 hours
The following queries return wrong results:
{code:sql}
-- <null> though should return 1
select * from views.test2 except select * from views.test1
UNION ALL
select * from views.test1 except select * from views.test2 ;;
-- <null> though should return 1
(select * from views.test2 except select * from views.test1
UNION ALL
select * from views.test1) except select * from views.test2 ;;
{code}
--
This message was sent by Atlassian Jira
(v7.13.8#713008)