Wrong Result With Projection Pushdown Disabled After Upgrading To 12.2
(Doc ID 2407464.1)
Last updated on AUGUST 04, 2018
Applies to:Oracle Database - Enterprise Edition - Version 188.8.131.52 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 = '184.108.40.206';
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!