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
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