rt:
现有一hql:
SELECT count(DISTINCT t.psn)
FROM Product t, QuotationAssignedsupplier q
WHERE t.isdeleted = '0' AND t.psn = q.psn AND q.sid = 'S0088'
OR PPN RLIKE '^M|^F|^O|^A|^Y'
这样的写法是hibernate不能执行...
现有一hql:
SELECT count(DISTINCT t.psn)
FROM Product t, QuotationAssignedsupplier q
WHERE t.isdeleted = '0' AND t.psn = q.psn AND q.sid = 'S0088'
OR PPN RLIKE '^M|^F|^O|^A|^Y'
这样的写法是hibernate不能执行...
--看看跟SQL一不一样
SELECT count(DISTINCT t.psn)
FROM Product t, QuotationAssignedsupplier q
WHERE t.isdeleted = '0' AND t.psn = q.psn AND q.sid = 'S0088'
OR PPN RLIKE 'MFOAY%'