Patch for ORA-03001 ORA-02070: database does not support subqueries in this context in Oracle 19c.
There is a query that works in several versions of Oracle Database Oracle 12cR2, Oracle 12cR1, Oracle 11gR2, but does not work in Oracle 19c (19.3.0.0.0).
The error occurs:
ORA-03001: unimplemented feature
ORA-02070: database does not support subqueries in this context
The workaround to resolve this error was:
alter system set optimizer_features_enable='12.2.0.1';
I encountered the following error
Bug 30453957 : SQL QUERY FAILS TO PARSE IN 18C WITH ORA-03001 AND ORA-02070
There is a patch for Oracle 18c.
I would like to know if there is a patch for this type of error for Oracle 19c.