Bugs item #638488, was opened at 2002-11-14 08:14
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=376685&aid=638488&group_id=22866
Category: JBossCMP
Group: CVS HEAD
Status: Open
Resolution: None
Priority: 5
Submitted By: Jeremy Boynes (jboynes)
Assigned to: Nobody/Anonymous (nobody)
Summary: Incorrect SQL with OR and IS NOT EMPTY
Initial Comment:
Opening this as 621270 has been closed.
Incorrect SQL is generated for EJB-QL where IS NOT
EMPTY is used in a OR condition such as:
SELECT OBJECT(p)
FROM parent p
WHERE p.children IS NOT EMPTY
OR p.value = ?1
generates
SELECT t0_p.id
FROM Parent t0_p, Child t1_p_children
WHERE ((1=1) OR t0_p.value = ?) -- <---- oops
AND (t0_p.id=t1_p_children.parent)
----------------------------------------------------------------------
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=376685&aid=638488&group_id=22866
-------------------------------------------------------
This sf.net email is sponsored by: To learn the basics of securing
your web site with SSL, click here to get a FREE TRIAL of a Thawte
Server Certificate: http://www.gothawte.com/rd524.html
_______________________________________________
Jboss-development mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-development