My Oracle Support Banner

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

Last updated on APRIL 17, 2023

Applies to:

Oracle Database - Enterprise Edition - Version and later
Information in this document applies to any platform.


On : version, RDBMS

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.


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

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