"ORA-00907: missing right parenthesis" when using exists subquery with Oracle

Description

Using the Criteria API the statement sent to the database has a syntax error because of left parenthesis between keywords "and" and "exists".

See also https://forum.hibernate.org/viewtopic.php?f=1&t=1043907.

Environment

Wildfly 10.1., Oracle 11 database

Assignee

Unassigned

Reporter

Frank Langelage

Fix versions

None

Labels

None

backPortable

None

Suitable for new contributors

None

Requires Release Note

None

Pull Request

None

backportDecision

None

Components

Affects versions

Priority

Major
Configure