ORA-00932: inconsistent datatypes: expected - got BLOB after HHH-10345 with Oracle12cDialect

Description

FooBarTest.testLimit
FooBarTest.testPersistCollections
ParameterTest.testNonPrimitiveArrayParameterBinding
ParameterTest.testPrimitiveArrayParameterBinding
PredicateTest.testByteArray
ImplicitJoinTest.testImplicitJoinFromExplicitCollectionJoin

These tests fail on Oracle12c with Oracle12cDialect because Hibernate tries to compare blob with blob1=blob2 but Oracle requires function dbms_lob.compare

f.ex.

Failing sql:

fails with

Environment

Oracle12c
Oracle12cDialect

Assignee

Guillaume Smet

Reporter

Martin Šimka

Fix versions

Labels

backPortable

None

Suitable for new contributors

None

Requires Release Note

None

Pull Request

None

backportDecision

None

Affects versions

Priority

Major
Configure