Wrong Results on select using UNION ALL, COUNT, GROUP BY
(Doc ID 1317045.1)
Last updated on FEBRUARY 28, 2019
Applies to:Oracle TimesTen In-Memory Database - Version 126.96.36.199.0 to 188.8.131.52.0 [Release 11.2]
Information in this document applies to any platform.
***Checked for relevance on 02-Oct-2013***
***Checked for relevance on 05-Mar-2015***
On TimesTen version 184.108.40.206.0 - 220.127.116.11.1, a query that satisfies all of the following three conditions could return wrong results.
- There's SET OPERATOR or OUTER JOIN
- UNION, UNION ALL, MINUS, INTERSECT, OUTER, OUTER JOIN, and (+)
The following query is one example of the queries that satisfy above all three conditions and could return wrong results.
(select count(*) a from tab1 group by col1
select count(*) from tab2 group by col1);
The following query is an counter-example that doesn't satisfy the condtion 3 because GROUP BY clause
is outside of a sub-query.
(select count(*) a from tab1
select count(*) a from tab2) t1
group by t1.a;
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document