cayenne-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Andrey Razumovsky (JIRA)" <j...@apache.org>
Subject [jira] Closed: (CAY-1341) EJBQL: joins on joined table not added to generated SQL
Date Thu, 17 Dec 2009 16:29:18 GMT

     [ 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.


Mime
View raw message