In this Document
APPLIES TO:
Oracle Database - Standard Edition - Version 19.1.0.0.0 and later
Information in this document applies to any platform.
SYMPTOMS
After upgrading 19c, a query that functioned before upgrading is encountering ORA-00979: Not A GROUP BY Expression.
CHANGES
CAUSE
Unpublished Bug 31504723 which has been investigated by development and not fixed yet.
SOLUTION
[Workarounds]
Please use either of below:
alter session set "_simple_view_merging" = false;
or
alter session set "_fix_control"='8528517:0';
REFERENCES
NOTE:8528517.8 - Bug 8528517 - Error ora-979 is not raised consistently.
