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
