hibernate 处理 group by 的重大bug

hibernate重大BUG


HQL:
select t.objid
  from T01VPeople t
where 1 != 1
    or (t.t01Peoplemodel.propertyname = 'hotel_city' and
       t.objlong in (select tree.ptid
                        from T01Propertytree tree
                       where tree.treename like '%上海%'))
    or (t.t01Peoplemodel.propertyname = 'hotel_name' and
       t.objstringhit like '%龙东%'))
group by t.objid
having count(t.objid) = 2

Hibernate转换成sql：

select
            t01vpeople0_.OBJID as col_0_0_
        from
            T01_V_PEOPLE t01vpeople0_,
            T01_PEOPLEMODEL t01peoplem1_
        where
            t01vpeople0_.OMID=t01peoplem1_.OMID
            and (
                1<>1
                or t01peoplem1_.PROPERTYNAME='hotel_city'
                and (
                    t01vpeople0_.OBJLONG in (
                        select
                            t01propert2_.PTID
                        from
                            T01_PROPERTYTREE t01propert2_
                        where
                            t01propert2_.TREENAME like '%上海%'
                    )
                )
                or t01peoplem1_.PROPERTYNAME='hotel_name'
                and (
                    t01vpeople0_.OBJSTRINGHIT like '%龙东%'
                )
            )

正确语句：

select
            t01vpeople0_.OBJID as col_0_0_
        from
            T01_V_PEOPLE t01vpeople0_,
            T01_PEOPLEMODEL t01peoplem1_
        where
            t01vpeople0_.OMID=t01peoplem1_.OMID
            and (
                1<>1
                or t01peoplem1_.PROPERTYNAME='hotel_city'
                and (
                    t01vpeople0_.OBJLONG in (
                        select
                            t01propert2_.PTID
                        from
                            T01_PROPERTYTREE t01propert2_
                        where
                            t01propert2_.TREENAME like '%上海%'
                    )
                )
                or t01peoplem1_.PROPERTYNAME='hotel_name'
                and (
                    t01vpeople0_.OBJSTRINGHIT like '%龙东%'
                )
            )
group by t01vpeople0_.OBJID having count(t01vpeople0_.OBJID) =2



--------------------------------------------------------------------------

ORM: T01VPeople <-->T01_V_PEOPLE   T01Peoplemodel <--> T01_PEOPLEMODEL
     关联 ：T01_V_PEOPLE.omid   <--> T01_PEOPLEMODEL.omid

评论

2 楼 zygege 2009-06-19  

难道楼上的意思是HQL映射成SQL不是ORM映射

被楼上打败

1 楼 KimShen 2009-06-19  

抛开是不是bug不说
您这还算是ORM映射吗? 推荐你使用createSQL接口 而不是HQL