Bugs item #551533, was opened at 2002-05-02 14:40
You can respond by visiting:
http://sourceforge.net/tracker/?func=detail&atid=376685&aid=551533&group_id=22866
Category: JBossCMP
Group: CVS HEAD
Status: Open
Resolution: None
Priority: 5
Submitted By: Alexei Guevara (aguevara)
Assigned to: Nobody/Anonymous (nobody)
Summary: EJB-QL compiler bug (3.0.0RC2)
Initial Comment:
EJB-QL:
SELECT DISTINCT OBJECT(r)
FROM record r,
IN (r.fields) f1,
IN (r.fields) f2,
IN (r.assns) assn
WHERE f1.attrName=?1
AND f1.attrValue=?2
AND f2.attrName=?3
AND f2.attrValue=?4
AND assn.dataSourceName<>?5
GENERATED SQL:
SELECT DISTINCT t0_r.id
FROM record t0_r, field t1_f1, field t2_f2,
datasourcerecordassn t3_assn
WHERE t1_f1.attr_name = ?
AND t1_f1.attr_value = ?
AND t2_f2.attr_name = ?
AND t2_f2.attr_value = ?
AND t3_assn.ds_name <> ?
AND (t0_r.id=t3_assn.record_id
AND t0_r.id=t2_f2.record_id)
BUG: there is a join missing between t1_f1 and t0_r
(t0_r.id=t1_f1.record_id)
CORRECT SQL:
SELECT DISTINCT t0_r.id
FROM record t0_r, field t1_f1, field t2_f2,
datasourcerecordassn t3_assn
WHERE t1_f1.attr_name = ?
AND t1_f1.attr_value = ?
AND t2_f2.attr_name = ?
AND t2_f2.attr_value = ?
AND t3_assn.ds_name <> ?
AND (t0_r.id=t3_assn.record_id
AND t0_r.id=t2_f2.record_id
AND t0_r.id=t1_f1.record_id)
----------------------------------------------------------------------
You can respond by visiting:
http://sourceforge.net/tracker/?func=detail&atid=376685&aid=551533&group_id=22866
_______________________________________________________________
Have big pipes? SourceForge.net is looking for download mirrors. We supply
the hardware. You get the recognition. Email Us: [EMAIL PROTECTED]
_______________________________________________
Jboss-development mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-development
