> I have verified this fix with EagerFetchMode parallel and join. > However, > there is an outstanding problem for the following query with inner > join > fetch while left join fetch generates correct SQL; the inner join > fetch > generates extra unneeded left join:
I think this is a separate issue. Thanks for filing a separate JIRA on it. Notice: This email message, together with any attachments, may contain information of BEA Systems, Inc., its subsidiaries and affiliated entities, that may be confidential, proprietary, copyrighted and/or legally privileged, and is intended solely for the use of the individual or entity named in this message. If you are not the intended recipient, and have received this message in error, please immediately return this by email and then delete it.