Details
-
Bug
-
Resolution: Duplicate
-
Major
-
None
-
None
-
None
-
None
Description
SourceForge Submitter: johgr814 .
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