JPA查询不同于生成的sql查询

Question

  @Query(value="select rd.contractID as contractID, rd.gicCode as gicCode, count(rd) as ticketNo" 
      + " from RawData rd" 
      + " where rd.contractID is not null and ((rd.contractCostObject is null and rd.domestic = true) or (rd.mirrorSVO is null and rd.domestic = false))"
      + " group by rd.contractID, rd.gicCode")

但是生成的SQL查询是

select
    rawdata0_.contractID as col_0_0_,
    rawdata0_.gicCode as col_1_0_,
    count(rawdata0_.id) as col_2_0_ 
from
    RawData rawdata0_ 
where
    (
        rawdata0_.contractID is not null
    ) 
    and (
        (
            rawdata0_.contractCostObject is null
        ) 
        and rawdata0_.domestic=true 
        or (
            rawdata0_.mirrorSVO is null
        ) 
        and rawdata0_.domestic=false
    ) 
group by
    rawdata0_.contractID ,
    rawdata0_.gicCode

正如您所看到的，括号改变了，我相信两个查询中的条件并不相同。是虫子吗？使用hibernate和spring以及postgresql数据库。

Answer 1

和运算符优先于或运算符。

• 条件A和B或C和D

相当于

null

((rawdata0_.contractCostObject is null) and rawdata0_.domestic=true)
or 
((rawdata0_.mirrorSVO is null) and rawdata0_.domestic=false)