Wrong Results (Zero Count Returned) from Query with COUNT(DISTINCT ...) after Upgrading to RU 19.11 through 19.15
(Doc ID 2877705.1)
Last updated on APRIL 17, 2023
Applies to:Oracle Database - Enterprise Edition - Version 184.108.40.206.0 to 220.127.116.11.0 [Release 19]
Information in this document applies to any platform.
Wrong results (i.e., a count of zero, instead of a positive integer) occurs from a query which issues a COUNT(DISTINCT ...) aggregate.
Internal view, VW_DAG_0, is observed within the execution plan, in the case of correct results, whereas in the case of wrong results, VM_NWVW is observed.
Setting _FIX_CONTROL to '9791810:0' at the session level acts as a workaround.
You have recently upgraded to Oracle Database Release Update (RU) 19.11 through 19.15.
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