Wrong Results on select using UNION ALL, COUNT, GROUP BY
(Doc ID 1317045.1)
Last updated on JUNE 27, 2018
Applies to:Oracle TimesTen In-Memory Database - Version 220.127.116.11.0 to 18.104.22.168.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 22.214.171.124.0 - 126.96.36.199.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!