Failure on these tests
org.hibernate.test.propertyref.basic.PropertyRefTest.testJoinFetchPropertyRef
org.hibernate.test.propertyref.basic.PropertyRefTest.testManyToManyPropertyRef
org.hibernate.test.propertyref.basic.PropertyRefTest.testOneToOnePropertyRef

with an error on delete below - Implicit conversion from datatype 'VARCHAR' to 'BIGINT' is not allowed. Use the CONVERT function to run this query

create table USER_SYSTEM (
USER_ID varchar(255) not null,
SYSTEM varchar(255) null
) lock datarows

create table PROPREF_PERS (
id bigint not null,
name varchar(100) null,
person_userid varchar(8) not null,
primary key (id)
) lock datarows

delete
from
USER_SYSTEM
where
(
USER_ID
) in (
select
id
from
PROPREF_PERS
)