Bugs item #498902, was opened at 2002-01-03 02:35
You can respond by visiting:
http://sourceforge.net/tracker/?func=detail&atid=376685&aid=498902&group_id=22866
Category: JBossCMP
Group: v3.0 Rabbit Hole
>Status: Closed
>Resolution: Fixed
Priority: 5
Submitted By: Jochen Cordes (jcordes)
Assigned to: Dain Sundstrom (dsundstrom)
Summary: Wrong SQL for finder-method w/ IN clause
Initial Comment:
System Configuration
--------------------
Windows 98
MySQL 3.23.40
JDK 1.3.1
Problem Description
-------------------
Im running into problems when trying to invoke a
finder-method on a unidirectional one-many-
relationship (Customer-Address). I defined a table-
mapping and addresses get inserted accordingly. The
query looks like this
SELECT OBJECT(a) FROM Customer c, IN (c.addresses) AS
a WHERE c.id = ?1 AND a.type='shipping'
where the generated SQL is
SELECT t2_a.id FROM Customer t1_c, Address t2_a,
Customer_Address t3_t1_c_to_addresses WHERE (t1_c.id
= ? AND t2_a.type = 'shipping') AND
t1_c.id=t4_t1_c_to_addresses.customer_id AND
t2_a.id=t4_t
1_c_to_addresses.address_id
Known Issue
-----------
t4 should be t3.
----------------------------------------------------------------------
>Comment By: Dain Sundstrom (dsundstrom)
Date: 2002-01-29 09:58
Message:
Logged In: YES
user_id=251431
TEST EJB-QL:
------------
SELECT OBJECT(a)
FROM Customer c, IN (c.addresses) AS a
WHERE c.id = ?1 AND a.state='CA'
BEFORE FIX:
-----------
SELECT t2_a.id, t2_a.street, t2_a.city, t2_a.state,
t2_a.zip, t2_a.zipPlus4
FROM CustomerEJB t1_c,
AddressEJB t2_a,
CUSTOMER_ADDRESS t3_t1_c_to_addresses
WHERE (t1_c.id = ? AND t2_a.state = 'CA') AND
t1_c.id=t4_t1_c_to_addresses.CUSTOMER AND
t2_a.id=t4_t1_c_to_addresses.CUSTOMER
AFTER FIX:
----------
SELECT t2_a.id, t2_a.street, t2_a.city, t2_a.state,
t2_a.zip, t2_a.zipPlus4
FROM CustomerEJB t1_c,
AddressEJB t2_a,
CUSTOMER_ADDRESS t3_CUSTOMER_ADDRESS
WHERE (t1_c.id = ? AND t2_a.state = 'CA') AND
t1_c.id=t3_CUSTOMER_ADDRESS.CUSTOMER AND
t2_a.id=t3_CUSTOMER_ADDRESS.ADDRESS
----------------------------------------------------------------------
You can respond by visiting:
http://sourceforge.net/tracker/?func=detail&atid=376685&aid=498902&group_id=22866
_______________________________________________
Jboss-development mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-development
