Hibernate 4.1.4.Final: still the same issue (Postgresql 8.4):
Hibernate: select this_.id as id4_0_, ... from uslugi.zapros_common this_ where this_.is_archive=? order by this_.id asc limit ?
Hibernate: select ... from ... where zaprostkmv0_.zapros_common_id in (select this_.id from uslugi.zapros_common this_ where this_.is_archive=?)
Hibernate 4.1.4.Final: still the same issue (Postgresql 8.4):