openjpa-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Donald Woods (JIRA)" <j...@apache.org>
Subject [jira] Updated: (OPENJPA-1283) Incorrect SQL for JPQL query selecting Map value from an elementCollection of a Map and the map the value is an embeddable
Date Tue, 22 Sep 2009 20:12:16 GMT

     [ https://issues.apache.org/jira/browse/OPENJPA-1283?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Donald Woods updated OPENJPA-1283:
----------------------------------

    Affects Version/s:     (was: 2.0.0)
                       2.0.0-M2
        Fix Version/s:     (was: 2.0.0)
                       2.0.0-M3

> Incorrect SQL for JPQL query selecting Map value from an elementCollection of a Map and
the map the value is an embeddable
> --------------------------------------------------------------------------------------------------------------------------
>
>                 Key: OPENJPA-1283
>                 URL: https://issues.apache.org/jira/browse/OPENJPA-1283
>             Project: OpenJPA
>          Issue Type: Bug
>    Affects Versions: 2.0.0-M2
>            Reporter: Catalina Wei
>            Assignee: Catalina Wei
>             Fix For: 2.0.0-M3
>
>
> SELECT VALUE(f) FROM Policy p, IN (p.funds) f WHERE f.fundName = :fName and p.annuityHolderId
= :holderId 
> 	Where Policy has an ElementCollection as a Map: 
>     @ElementCollection(targetClass = Fund.class, fetch=FetchType.EAGER)
>     @CollectionTable(name="POLICY_FUNDS",joinColumns={@JoinColumn(name="FK_POLICY_ID")})
>     @MapKeyColumn(name = "FUND_ID")
>     public Map<Integer, IFund> getFunds() {
>         return Funds;
>     }
> The generated SQL was incorrect:
> SELECT t2.id FROM INSPOLICY t0 
>     INNER JOIN POLICY_FUNDS t1 ON t0.id = t1.FK_POLICY_ID, 
>     INSPOLICY t2 
> WHERE (t1.fundName = ? AND t0.FK_ANNUITY_HOLDER_ID = ?)
> The correct SQL should projecting out t1.*.

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