Does anyone know why the following query, which is good in DB2, is no good
in Oracle:
SELECT c.container_id FROM Simple sim2_, Container c, manyToMany man0_
WHERE (sim2_.count_=2 and man0_.elt=sim2_.id_ and
c.container_id=man0_.container_id2 and man0_.list_index=
(SELECT count(*) FROM manyToMany man1_ WHERE
c.container_id=man1_.container_id2)-1)
Hibernate generates that SQL for this query:
select c from c in class Container where c.manyToMany[ c.manyToMany.size -
1].count = 2
which is kinda useful.
Gavin
|
