Wrong Results on select using UNION ALL, COUNT, GROUP BY
Last updated on SEPTEMBER 22, 2016
Applies to:Oracle TimesTen In-Memory Database - Version 22.214.171.124.0 to 126.96.36.199.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 188.8.131.52.0 - 184.108.40.206.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;
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms