Note 1636936 - 11g Wrong results with star_transformation_enabled = true

Summary

Symptom

A query returns wrong results.

The amount of rows returned by the query differs depending if star transformation is used or not.

Other terms

wrong results, bug 12827166, 11.2.0.1, 11.2.0.2

Reason and Prerequisites

Oracle bug

12827166 - WRONG RESULT WITH STAR TRANSFORMATION WITH TEMP TABLE

is the root cause for this problem.

Oracle versions 11.2.0.1, 11.2.0.2 and 11.2.0.3 are affected.

You may be hitting this bug if:

• star transformation is enabled
  star_transformation_enabled = true or
  star_transformation_enabled = temp_disable

• execution plan has index range predicate with equality in start or stop key

Solution

Oracle bug 12827166 is fixed in the following SAP Bundle Patches / Oracle patch collections:

11.2.0.1:
As 11.2.0.1 is no longer supported the patch for Oracle bug 12827166 will not be made available for 11.2.0.1.

11.2.0.2:
UNIX SBP 11202x_date ( date >= 201110 )
UNIX SGR 11202x_date ( date >= 201110 )
UNIX SXD 11202x_date ( date >= 201110 )
WIN 11.2.0.2.nP ( n >= 12 )

Workaround:

turn off star transformation using
alter system set star_transformation_enabled = false scope=both;

Attention:
Please be aware that turning off star transformation will lead to decreased performance of your BW queries.

We strongly recommend to upgrade to 11.2.0.2 and apply the SAP Bundle Patch / Windows Patch Collection containing the patch for Oracle bug 12827166 as soon as possible.

Header Data

Release Status:	Released for Customer
Released on:	14.10.2011 12:20:15
Master Language:	English
Priority:	HotNews
Category:	Program error
Primary Component:	BC-DB-ORA Oracle
Secondary Components:	BW-SYS-DB-ORA BW ORACLE