My Oracle Support Banner

Wrong Results from Query on View Even After Applying 32639432 Fix (Doc ID 2807268.1)

Last updated on FEBRUARY 26, 2022

Applies to:

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

Symptoms

Query on view which was working earlier (19.10 in this case) returns no output after applying the 19.11 DBRU patch.
Same issue was seen even after applying the 19.12 DBRU patch.

Applying <Patch 32639432> from Bug 32177819 - Wrong result when using left outer join that uses a subquery (Doc ID 32177819.8), also does not help.

However, expected results are shown when the below workaround is used to disable the simple view merging:

alter session set "_simple_view_merging"=false;

 

 

Changes

 

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
Changes
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.