Bugs item #583714, was opened at 2002-07-19 10:08
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=376685&aid=583714&group_id=22866
Category: JBossCMP
Group: v3.0 Rabbit Hole
Status: Closed
Resolution: Works For Me
Priority: 5
Submitted By: Johan Granlund (johgr814)
Assigned to: Dain Sundstrom (dsundstrom)
>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
----------------------------------------------------------------------
>Comment By: Johan Granlund (johgr814)
Date: 2002-07-22 09:10
Message:
Logged In: YES
user_id=509036
Ok, I'm really sorry about this one. It was my LIKE t_id stuff
that wasn't correct. I missed a '%' in my code. It was
LIKE '1.%' that I meant.
----------------------------------------------------------------------
Comment By: Dain Sundstrom (dsundstrom)
Date: 2002-07-21 22:57
Message:
Logged In: YES
user_id=251431
TRUE is put there as a place holder to satify the where
clause. It gives the correct results for my simple tests.
----------------------------------------------------------------------
Comment By: Thom Nelson (thomnelson)
Date: 2002-07-21 22:34
Message:
Logged In: YES
user_id=509665
I'm not sure why TRUE is there, but it also appends the join
clause "t0_p.person_id=t3_p_cards.person_id" which should do
the trick. Have you checked the results of the query to see
if they're correct?
----------------------------------------------------------------------
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=376685&aid=583714&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
