The problem can be still repeated when one has set optimizer_switch='semijoin=off' or 'materialization=off', or both.
Seems to be a generic subquery code problem.
The problem can be still repeated when one has set optimizer_ switch= 'semijoin= off' or 'materializatio n=off', or both.
Seems to be a generic subquery code problem.