My Oracle Support Banner

WRONG RESULT WITH OFE 11201/11107 FOR FA QUERY WITH SERIAL EXEC (Doc ID 2430478.1)

Last updated on JULY 20, 2024

Applies to:

Oracle Database Backup Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Oracle Database Cloud Service - Version N/A and later
Oracle Database - Enterprise Edition - Version 12.1.0.2 and later
Oracle Database Cloud Schema Service - Version N/A and later
Information in this document applies to any platform.

Symptoms

Select on Peoplesoft query is giving wrong results(0 rows selected) with HASH Join Plan whereas with /*+ RULE */ hint for the same query in 12.1.0.2 is giving correct results (4,278 rows selected) with a Nested Loop Plan.

12102: (Run WITHOUT a Hint, get a Hash Join):

Select
    total_rows,
    'No Hint'  as Type,
    B.Name     as DB_name,
    C.Version
  from
  (select count(*) as total_rows

---------------

0 rows selected.

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
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.