Materialized View Returns Wrong Results After Upgrade to 188.8.131.52
(Doc ID 2297095.1)
Last updated on FEBRUARY 03, 2019
Applies to:Oracle Database - Standard Edition - Version 184.108.40.206 to 220.127.116.11 [Release 12.1]
Information in this document applies to any platform.
- Materialized view created with an ansi outer join SQL, returns wrong results after upgrade to 18.104.22.168:
- This is similar to <Document 1957943.1> (unpublished bug 16726638), but the wrong results still occur after applying the patch 16726638
- This reproduces in 22.214.171.124 but not in 126.96.36.199 or when OPTIMIZER_FEATURES_ENABLE='188.8.131.52'
- Following testcase provides an example of wrong results:
Upgrade database to 184.108.40.206.
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