Hi, guys! Suppose we have two tables:
create table A (id number, name varchar2(10)); create table B ( id number, a_id number, xxx varchar2(11)); When I execute following "find" query it generates incorrect select: sesstion.find("from A where b.size < 3"); it generates select like this: select XXXXXXXXX from A a1 where ((select count(*) from b b1where b1.a_id = a1.id ) < 3) But the correct select woud be: select XXXXXXXXX from A a1 where ( 3 > (select count(*) from b b1 where b1.a_id = a1.id )) I tried to use both Oracle9 and Oracle dialects with the same results. How can I fix the mapping? -- With best regards, Dmitry. ------------------------------------------------------- This SF.net email sponsored by: Enterprise Linux Forum Conference & Expo The Event For Linux Datacenter Solutions & Strategies in The Enterprise Linux in the Boardroom; in the Front Office; & in the Server Room http://www.enterpriselinuxforum.com _______________________________________________ hibernate-devel mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/hibernate-devel