Wrong Results With Hash Outer Join And NVL2 In Group By Section
(Doc ID 2818303.1)
Last updated on JULY 20, 2024
Applies to:
Oracle Database - Enterprise Edition - Version 19.10.0.0.0 and laterInformation in this document applies to any platform.
Symptoms
On : 19.10.0.0.0 version, RDBMS
ACTUAL BEHAVIOR
---------------
Wrong results with hash outer join and NVL2 in group by section
As per tittle.
Full test case provided in ATTACHMENT, reproduced in our environment Oracle 19c version 19.10 and Oracle Cloud which runs 19.5.
Problem initially discovered by creating "Top N sets" in Tableau 20.4 which creates query similar to one provided.
I've generated the test case based on the Tableau generated query and experimented with functions.
The test case can be executed in any environment and creates a table with 100 rows.
Comments provided in test case details.
Cause
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
Symptoms |
Cause |
Solution |
References |