语句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是一样的,
复制代码
1jpa Predicate的hql语句在 hibernate处理时会把语句2的括号去掉,变成语句1的模样
原文 https://blog.csdn.net/fj520lb/article/details/17379843
最后
以上就是疯狂百褶裙最近收集整理的关于mysql hibernate在把hql转为sql的时候,把or两边的括号去掉的问题的全部内容，更多相关mysql内容请搜索靠谱客的其他文章。
本图文内容来源于网友提供，作为学习参考使用，或来自网络收集整理，版权属于原作者所有。
发表评论 取消回复