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 NOVEMBER 07, 2023
Applies to:
Oracle Database - Enterprise Edition - Version 19.11.0.0.0 to 19.15.0.0.0 [Release 19]Information in this document applies to any platform.
Symptoms
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.
Changes
You have recently upgraded to Oracle Database Release Update (RU) 19.11 through 19.15.
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 |