Bug 29661065 - Wrong results with sql fetch query in 19c db (Doc ID 29661065.8)

To BottomTo Bottom
 

Bug 29661065  Wrong results with sql fetch query in 19c db

 This note gives a brief overview of bug 29661065. 
 The content was last updated on: 21-OCT-2019
 Click here for details of each of the sections below.

Affects:

Product (Component) Oracle Server (Rdbms)
Range of versions believed to be affected Versions >= 19 but BELOW 20.1
Versions confirmed as being affected
  • (None Specified)
Platforms affected Generic (all / most platforms affected)

Fixed:

The fix for 29661065 is first included in

Interim patches may be available for earlier versions - click here to check.

Symptoms:

Related To:
  • (None Specified)

Description

Incorrect generation of 'IS NOT NULL' predicates produce wrong results.
  
 
Rediscovery Notes
Incorrect generation of 'IS NOT NULL' predicates produce wrong results.
 
.
Workaround
"_fix_control"='24761824:OFF'
 
Note:This fix supersedes the fix in bug 28355134 .For interim patches please use this fix instead of the fix in bug 28355134 to address both the issues.

 

Please note: The above is a summary description only. Actual symptoms can vary. Matching to any symptoms here does not confirm that you are encountering this problem. For questions about this bug please consult Oracle Support.

 

References

Bug:29661065 (This link will only work for PUBLISHED bugs)
Note:245840.1 Information on the sections in this article