EJBQL: joins on joined table not added to generated SQL
-------------------------------------------------------
Key: CAY-1341
URL: https://issues.apache.org/jira/browse/CAY-1341
Project: Cayenne
Issue Type: Bug
Components: Cayenne Core Library
Affects Versions: 3.0 beta 1
Reporter: Andrey Razumovsky
Here's the query:
select g from Gallery g inner join g.paintingArray p where
p.toArtist.artistName like '%a%'
It generates
SELECT t0.GALLERY_ID AS ec0_1, t0.GALLERY_NAME AS ec0_0 FROM GALLERY t0 INNER
JOIN PAINTING t1 ON (t0.GALLERY_ID = t1.GALLERY_ID) WHERE t2.ARTIST_NAME LIKE ?
Join for artist is not added, so query fails with error: Column not found:
T2.ARTIST_NAME
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
