The follow-on-locking Oracle mechanism should consider UNION as well

Description

The Oracle Dialect inspects the currently executing query and decides whether to apply follow-on-locking. The current logic looks for DISTINCT, GROUP BY, ORDER BY, and some pagination patterns.

We need to accommodate set operators as well, especially UNION which is used for TABLE_PER_CLASS inheritance.

Environment

None

Status

Assignee

Vlad Mihalcea

Reporter

Vlad Mihalcea

Fix versions

Labels

None

backPortable

None

Suitable for new contributors

None

Requires Release Note

None

Pull Request

None

backportDecision

None

Priority

Major
Configure