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.csdn.net/fj520lb/article/details/17379843

最后

以上就是疯狂百褶裙为你收集整理的mysql hibernate在把hql转为sql的时候,把or两边的括号去掉的问题的全部内容，希望文章能够帮你解决mysql hibernate在把hql转为sql的时候,把or两边的括号去掉的问题所遇到的程序开发问题。

如果觉得靠谱客网站的内容还不错，欢迎将靠谱客网站推荐给程序员好友。