Bugs item #583713, was opened at 2002-07-19 10:07
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=376685&aid=583713&group_id=22866
Category: None
Group: None
Status: Open
Resolution: None
Priority: 5
Submitted By: Johan Granlund (johgr814)
Assigned to: Nobody/Anonymous (nobody)
Summary: JBoss-QL "IS NOT EMPTY" doesn't work
Initial Comment:
I'm running JBoss 3.0.1RC1 with Postgres 7.2.
The JBoss-QL "IS NOT EMPTY" statement doesn't work
it simply generates the SQL-statement "TRUE".
Sample:
JBoss-QL:
SELECT DISTINCT OBJECT(p) FROM Person p, IN
(p.nodePersonRoles) npr WHERE npr.node.tId LIKE ?1
AND p.cards IS NOT EMPTY
Generates SQL:
SELECT DISTINCT t0_p.person_id
FROM person t0_p, node_person_role t2_npr, card
t3_p_cards, node t1_npr_node
WHERE (t1_npr_node.t_id LIKE '1.' AND TRUE)
AND (t0_p.person_id=t3_p_cards.person_id
AND t2_npr.node_id=t1_npr_node.node_id
AND t0_p.person_id=t2_npr.person
----------------------------------------------------------------------
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=376685&aid=583713&group_id=22866
-------------------------------------------------------
This sf.net email is sponsored by:ThinkGeek
Welcome to geek heaven.
http://thinkgeek.com/sf
_______________________________________________
Jboss-development mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-development
