mysql hibernate在把hql转为sql的时候,把or两边的括号去掉的问题

语句1

select * from credit_operation_log creditoper0_ 
where creditoper0_.subject_id='1111' and (creditoper0_.credit_contract_id in ('2222')) or creditoper0_.customer_id='3333' and (creditoper0_.credit_contract_id is null) order by creditoper0_.create_time desc;

语句2

select * from credit_operation_log creditoper0_ 
where (creditoper0_.subject_id='1111' and (creditoper0_.credit_contract_id in ('2222'))) or (creditoper0_.customer_id='3333' and (creditoper0_.credit_contract_id is null)) order by creditoper0_.create_time desc;
 

虽然语句1的or没有括号,但是执行的效果跟语句2是一样的,

jpa Predicate的hql语句在 hibernate处理时会把语句2的括号去掉,变成语句1的模样

原文 https://blog.youkuaiyun.com/fj520lb/article/details/17379843