[
https://issues.apache.org/jira/browse/CAY-1341?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Andrey Razumovsky closed CAY-1341.
----------------------------------
Resolution: Fixed
Fix Version/s: 3.0 beta 2
Assignee: Andrey Razumovsky
> 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
> Assignee: Andrey Razumovsky
> Fix For: 3.0 beta 2
>
>
> 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.
