SuperCluster - Select Statement Returns Wrong Results with replace

Asset ID:	1-72-1916632.1
Update Date:	2014-10-16
Keywords:

Solution Type Problem Resolution Sure

Solution 1916632.1 : SuperCluster - Select Statement Returns Wrong Results with replace

Related Items


Oracle SuperCluster M6-32 Hardware
 Oracle SuperCluster T5-8 Hardware
 Oracle SuperCluster T5-8 Half Rack
 Oracle Database - Enterprise Edition
 SPARC SuperCluster T4-4
 Oracle SuperCluster T5-8 Full Rack

Related Categories


PLA-Support>Eng Systems>Exadata/ODA/SSC>SPARC SuperCluster>DB: SuperCluster_EST

In this Document

Symptoms

Cause

Solution

References

Created from <SR 3-9364838941>

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.4 to 12.1.0.1 [Release 11.2 to 12.1]
Oracle SuperCluster M6-32 Hardware - Version All Versions to All Versions [Release All Releases]
SPARC SuperCluster T4-4 - Version All Versions to All Versions [Release All Releases]
Oracle SuperCluster T5-8 Hardware - Version All Versions to All Versions [Release All Releases]
Oracle SuperCluster T5-8 Full Rack - Version All Versions to All Versions [Release All Releases]
Oracle Solaris on SPARC (64-bit)

Symptoms

Simple select predicates returning wrong results when the query is run on SuperCluster.Correct results are returned if cell_offload_processing is set to false. Known to affect queries containing "REPLACE" function.

Cause

The problem could be due to the following bug:

Bug 19296555 - SUPERCLUSTER: SELECT RETURNS WRONG RESULT

Solution

Apply a fix for Bug 19296555 - SUPERCLUSTER: SELECT RETURNS WRONG RESULT

or

Set cell_offload_processing is set to false ( as a temporary workaround)

References

<BUG:19420986> - BLR BACKPORT OF BUG 19296555 ON TOP OF 11.2.0.4.0 (BLR #3980643)
<BUG:19296555> - QUERY WITH SIMPLE SELECT PREDICATES RETURNS WRONG RESULTS IN SSC

Attachments

This solution has no attachment