My Oracle Support Banner

Wrong Results With Hash Outer Join And NVL2 In Group By Section (Doc ID 2818303.1)

Last updated on NOVEMBER 06, 2021

Applies to:

Oracle Database - Enterprise Edition - Version 19.10.0.0.0 and later
Information 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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.