Wrong Result when Fix for Bug 21099502 is Present on a Query which Uses UNION View and GROUP BY Clause
(Doc ID 2536136.1)
Last updated on MAY 02, 2019
Applies to:Oracle Database - Enterprise Edition - Version 184.108.40.206 and later
Oracle Database - Standard Edition - Version 220.127.116.11 and later
Information in this document applies to any platform.
Wrong result may be seen when the fix to bug 21099502 is present on a query which uses UNION view whose branches have GROUP BY clause, and there is a predicate in the outer query block.
( SELECT COL1,
WHERE COL3 = 1
WHERE COL3 = 2
GROUP BY COL1 ) SUB
T1.COL1 = SUB.COL1 AND
T1.COL2 = SUB.COL2 AND
T1.COL1 in ('1','2','3','4');
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