db-jdo-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "RaviRaja (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (JDO-730) Creating the innerjoin without relationship between objects
Date Fri, 11 Jul 2014 06:34:06 GMT

    [ https://issues.apache.org/jira/browse/JDO-730?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14058470#comment-14058470

RaviRaja commented on JDO-730:

Thanq for you reply,

       The above query is making cross join. But we need an innerjoin between objects with
ON clause. However this can be solved by .contains() clause but it implicitly innerjoins only
primary and foreign keys. But we need innerjoin rather than primary and foreign key

Query as follows:

select this.x, b.y from com.xyz.Class1 where this.contains(b) variables com.xyz.Class2 b

This query only innerjoins with ON clause condition this.pkey==b.foreignkey

But we need the explicit innerjoins rather than implicit innerjoins 

> Creating the innerjoin without relationship between objects
> -----------------------------------------------------------
>                 Key: JDO-730
>                 URL: https://issues.apache.org/jira/browse/JDO-730
>             Project: JDO
>          Issue Type: Wish
>          Components: api
>    Affects Versions: JDO 3.1-rc1
>            Reporter: RaviRaja
>            Assignee: Michael Bouschen
>             Fix For: JDO 3.1
> Cannot make innerjoin like this without relationship:
> select a.x, b.y from Table1 as a INNER JOIN Table 2 as b ON a.z=b.w
> Note: a.z and b.w are not primary and foreign keys

This message was sent by Atlassian JIRA

View raw message