from A b where b.size<3
What exactly are you trying to point out here?
* there is a missing space b/w "b1" and "where"?? * the order of the comparison is reversed?
If the latter, just write:
from A b where 3 > b.size
If the former, please submit an issue to JIRA.
Dmitry Olyenyov wrote:
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
-------------------------------------------------------
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