mysql - 无法在 HQL 中使用两个选择

Question

使用 Hibernate 及其查询语言。我尝试在 POJO 中执行以下查询

String sql = "select  (select count(*) from Data v where "
        + insuranceId 
        +" in (v.insuranceId1.id, v.insuranceId2.id, v.insuranceId3.id))"
        +" + (select count(*) from Sat s where " 
        + insuranceId 
        +" in (s.insuranceId1.id, s.insuranceId2.id, s.insuranceId3.id))";

em.createQuery(sql, Long.class).getSingleResult();

我收到以下错误

2:27:47,128 ERROR [stderr] (http-/0.0.0.0:8080-5) java.lang.IllegalArgumentException: org.hibernate.hql.internal.ast.QuerySyntaxException: unexpected end of subtree [select  (select count(*) from Data v where 991 in (v.insuranceId1.id, v.insuranceId2.id, v.insuranceId3.id)) + (select count(*) from Slot s where 991 in (s.insuranceId1.id, s.insuranceId2.id, s.insuranceId3.id))]

请指教

Answer 1

尝试createNativeQuery

Object l = em.createNativeQuery(sql).getSingleResult();

它应该返回包含计数总和的整数。

我认为 HQL 不支持不带 FROM 子句的 select。