Wrong Result With Projection Pushdown Disabled After Upgrading To 12.2
(Doc ID 2407464.1)
Last updated on FEBRUARY 20, 2019
Applies to:Oracle Database - Enterprise Edition - Version 18.104.22.168 and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.
- Query returns more rows than normal when projection push-down is disabled after upgrading to 12.2
- None of the following workarounds returns correct results:
alter session set "_fix_control" = '23210039:0';
alter session set "_optimizer_aggr_groupby_elim" = FALSE ;
alter session set "_optimizer_cbqt_or_expansion"=off;
alter session set optimizer_features_enable = '22.214.171.124';
alter session set "_optimizer_group_by_placement" = false;
alter session set "_optimizer_ansi_rearchitecture" = FALSE;
- The only work-around that gives results is setting _PUSH_JOIN_PREDICATE to TRUE
Upgrade to 12.2.
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