Quantcast

[jira] [Created] (OPENJPA-2132) Traversal of a OneToMany relationship returns an empty list when InheritanceType.JOINED or SINGLE_TABLE is used.

classic Classic list List threaded Threaded
7 messages Options
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

[jira] [Created] (OPENJPA-2132) Traversal of a OneToMany relationship returns an empty list when InheritanceType.JOINED or SINGLE_TABLE is used.

JIRA jira@apache.org
Traversal of a OneToMany relationship returns an empty list when InheritanceType.JOINED or SINGLE_TABLE is used.
----------------------------------------------------------------------------------------------------------------

                 Key: OPENJPA-2132
                 URL: https://issues.apache.org/jira/browse/OPENJPA-2132
             Project: OpenJPA
          Issue Type: Bug
          Components: query
    Affects Versions: 2.1.1, 2.0.1, 2.2.0
            Reporter: Heath Thomann
            Assignee: Heath Thomann
         Attachments: OneManyJoinableTest.test

I will include a test, named 'OneManyJoinableTest.test' which recreates the issue of this JIRA.  Basically though, the test consists of a parent class defined with '@Inheritance(strategy=InheritanceType.JOINED)'.  One of the subclasses in the hierarchy contains a (bidirectional) OneToMany relationship.  When traversing the ManyToOne side of the relations, all works well.  But when traversing the OneToMany side an empty list is returned.  When running the test, it can be seen that OpenJPA generate incorrect SQL, as follows:

SELECT t1.id, t0.id, t2.id, t3.id, t1.name FROM UMLType t0, UMLNamed t1, UMLClass t2, UMLPrimitiveType t3 WHERE t0.OWNERPACKAGE_ID = ? AND t2.id IS NULL AND t3.id IS NULL AND t0.id = t1.id AND t0.id = t2.id(+) AND t0.id = t3.id(+)

Note that the 't2.id IS NULL AND t3.id IS NULL' seems suspect.

This same test passes on OpenJPA 1.2.x but fails on OpenJPA 2.0.x on wards.  





--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira

       
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

[jira] [Updated] (OPENJPA-2132) Traversal of a OneToMany relationship returns an empty list when InheritanceType.JOINED or SINGLE_TABLE is used.

JIRA jira@apache.org

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

Heath Thomann updated OPENJPA-2132:
-----------------------------------

    Attachment: OneManyJoinableTest.test
   

> Traversal of a OneToMany relationship returns an empty list when InheritanceType.JOINED or SINGLE_TABLE is used.
> ----------------------------------------------------------------------------------------------------------------
>
>                 Key: OPENJPA-2132
>                 URL: https://issues.apache.org/jira/browse/OPENJPA-2132
>             Project: OpenJPA
>          Issue Type: Bug
>          Components: query
>    Affects Versions: 2.0.1, 2.1.1, 2.2.0
>            Reporter: Heath Thomann
>            Assignee: Heath Thomann
>         Attachments: OneManyJoinableTest.test
>
>
> I will include a test, named 'OneManyJoinableTest.test' which recreates the issue of this JIRA.  Basically though, the test consists of a parent class defined with '@Inheritance(strategy=InheritanceType.JOINED)'.  One of the subclasses in the hierarchy contains a (bidirectional) OneToMany relationship.  When traversing the ManyToOne side of the relations, all works well.  But when traversing the OneToMany side an empty list is returned.  When running the test, it can be seen that OpenJPA generate incorrect SQL, as follows:
> SELECT t1.id, t0.id, t2.id, t3.id, t1.name FROM UMLType t0, UMLNamed t1, UMLClass t2, UMLPrimitiveType t3 WHERE t0.OWNERPACKAGE_ID = ? AND t2.id IS NULL AND t3.id IS NULL AND t0.id = t1.id AND t0.id = t2.id(+) AND t0.id = t3.id(+)
> Note that the 't2.id IS NULL AND t3.id IS NULL' seems suspect.
> This same test passes on OpenJPA 1.2.x but fails on OpenJPA 2.0.x on wards.  

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira

       
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

[jira] [Assigned] (OPENJPA-2132) Traversal of a OneToMany relationship returns an empty list when InheritanceType.JOINED or SINGLE_TABLE is used.

JIRA jira@apache.org
In reply to this post by JIRA jira@apache.org

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

Dianne Richards reassigned OPENJPA-2132:
----------------------------------------

    Assignee: Dianne Richards  (was: Heath Thomann)
   

> Traversal of a OneToMany relationship returns an empty list when InheritanceType.JOINED or SINGLE_TABLE is used.
> ----------------------------------------------------------------------------------------------------------------
>
>                 Key: OPENJPA-2132
>                 URL: https://issues.apache.org/jira/browse/OPENJPA-2132
>             Project: OpenJPA
>          Issue Type: Bug
>          Components: query
>    Affects Versions: 2.0.1, 2.1.1, 2.2.0
>            Reporter: Heath Thomann
>            Assignee: Dianne Richards
>         Attachments: OneManyJoinableTest.test
>
>
> I will include a test, named 'OneManyJoinableTest.test' which recreates the issue of this JIRA.  Basically though, the test consists of a parent class defined with '@Inheritance(strategy=InheritanceType.JOINED)'.  One of the subclasses in the hierarchy contains a (bidirectional) OneToMany relationship.  When traversing the ManyToOne side of the relations, all works well.  But when traversing the OneToMany side an empty list is returned.  When running the test, it can be seen that OpenJPA generate incorrect SQL, as follows:
> SELECT t1.id, t0.id, t2.id, t3.id, t1.name FROM UMLType t0, UMLNamed t1, UMLClass t2, UMLPrimitiveType t3 WHERE t0.OWNERPACKAGE_ID = ? AND t2.id IS NULL AND t3.id IS NULL AND t0.id = t1.id AND t0.id = t2.id(+) AND t0.id = t3.id(+)
> Note that the 't2.id IS NULL AND t3.id IS NULL' seems suspect.
> This same test passes on OpenJPA 1.2.x but fails on OpenJPA 2.0.x on wards.  

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira

       
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

[jira] [Work started] (OPENJPA-2132) Traversal of a OneToMany relationship returns an empty list when InheritanceType.JOINED or SINGLE_TABLE is used.

JIRA jira@apache.org
In reply to this post by JIRA jira@apache.org

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

Work on OPENJPA-2132 started by Dianne Richards.

> Traversal of a OneToMany relationship returns an empty list when InheritanceType.JOINED or SINGLE_TABLE is used.
> ----------------------------------------------------------------------------------------------------------------
>
>                 Key: OPENJPA-2132
>                 URL: https://issues.apache.org/jira/browse/OPENJPA-2132
>             Project: OpenJPA
>          Issue Type: Bug
>          Components: query
>    Affects Versions: 2.0.1, 2.1.1, 2.2.0
>            Reporter: Heath Thomann
>            Assignee: Dianne Richards
>         Attachments: OneManyJoinableTest.test
>
>
> I will include a test, named 'OneManyJoinableTest.test' which recreates the issue of this JIRA.  Basically though, the test consists of a parent class defined with '@Inheritance(strategy=InheritanceType.JOINED)'.  One of the subclasses in the hierarchy contains a (bidirectional) OneToMany relationship.  When traversing the ManyToOne side of the relations, all works well.  But when traversing the OneToMany side an empty list is returned.  When running the test, it can be seen that OpenJPA generate incorrect SQL, as follows:
> SELECT t1.id, t0.id, t2.id, t3.id, t1.name FROM UMLType t0, UMLNamed t1, UMLClass t2, UMLPrimitiveType t3 WHERE t0.OWNERPACKAGE_ID = ? AND t2.id IS NULL AND t3.id IS NULL AND t0.id = t1.id AND t0.id = t2.id(+) AND t0.id = t3.id(+)
> Note that the 't2.id IS NULL AND t3.id IS NULL' seems suspect.
> This same test passes on OpenJPA 1.2.x but fails on OpenJPA 2.0.x on wards.  

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira

       
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

[jira] [Updated] (OPENJPA-2132) Traversal of a OneToMany relationship returns an empty list when InheritanceType.JOINED or SINGLE_TABLE is used.

JIRA jira@apache.org
In reply to this post by JIRA jira@apache.org

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

Heath Thomann updated OPENJPA-2132:
-----------------------------------

    Fix Version/s: 2.2.1
                   2.3.0
                   2.1.2
   

> Traversal of a OneToMany relationship returns an empty list when InheritanceType.JOINED or SINGLE_TABLE is used.
> ----------------------------------------------------------------------------------------------------------------
>
>                 Key: OPENJPA-2132
>                 URL: https://issues.apache.org/jira/browse/OPENJPA-2132
>             Project: OpenJPA
>          Issue Type: Bug
>          Components: query
>    Affects Versions: 2.0.1, 2.1.1, 2.2.0
>            Reporter: Heath Thomann
>            Assignee: Dianne Richards
>             Fix For: 2.1.2, 2.3.0, 2.2.1
>
>         Attachments: OneManyJoinableTest.test
>
>
> I will include a test, named 'OneManyJoinableTest.test' which recreates the issue of this JIRA.  Basically though, the test consists of a parent class defined with '@Inheritance(strategy=InheritanceType.JOINED)'.  One of the subclasses in the hierarchy contains a (bidirectional) OneToMany relationship.  When traversing the ManyToOne side of the relations, all works well.  But when traversing the OneToMany side an empty list is returned.  When running the test, it can be seen that OpenJPA generate incorrect SQL, as follows:
> SELECT t1.id, t0.id, t2.id, t3.id, t1.name FROM UMLType t0, UMLNamed t1, UMLClass t2, UMLPrimitiveType t3 WHERE t0.OWNERPACKAGE_ID = ? AND t2.id IS NULL AND t3.id IS NULL AND t0.id = t1.id AND t0.id = t2.id(+) AND t0.id = t3.id(+)
> Note that the 't2.id IS NULL AND t3.id IS NULL' seems suspect.
> This same test passes on OpenJPA 1.2.x but fails on OpenJPA 2.0.x on wards.  

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira

       
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

[jira] [Resolved] (OPENJPA-2132) Traversal of a OneToMany relationship returns an empty list when InheritanceType.JOINED or SINGLE_TABLE is used.

JIRA jira@apache.org
In reply to this post by JIRA jira@apache.org

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

Albert Lee resolved OPENJPA-2132.
---------------------------------

    Resolution: Fixed
   

> Traversal of a OneToMany relationship returns an empty list when InheritanceType.JOINED or SINGLE_TABLE is used.
> ----------------------------------------------------------------------------------------------------------------
>
>                 Key: OPENJPA-2132
>                 URL: https://issues.apache.org/jira/browse/OPENJPA-2132
>             Project: OpenJPA
>          Issue Type: Bug
>          Components: query
>    Affects Versions: 2.0.1, 2.1.1, 2.2.0
>            Reporter: Heath Thomann
>            Assignee: Dianne Richards
>             Fix For: 2.1.2, 2.3.0, 2.2.1
>
>         Attachments: OneManyJoinableTest.test
>
>
> I will include a test, named 'OneManyJoinableTest.test' which recreates the issue of this JIRA.  Basically though, the test consists of a parent class defined with '@Inheritance(strategy=InheritanceType.JOINED)'.  One of the subclasses in the hierarchy contains a (bidirectional) OneToMany relationship.  When traversing the ManyToOne side of the relations, all works well.  But when traversing the OneToMany side an empty list is returned.  When running the test, it can be seen that OpenJPA generate incorrect SQL, as follows:
> SELECT t1.id, t0.id, t2.id, t3.id, t1.name FROM UMLType t0, UMLNamed t1, UMLClass t2, UMLPrimitiveType t3 WHERE t0.OWNERPACKAGE_ID = ? AND t2.id IS NULL AND t3.id IS NULL AND t0.id = t1.id AND t0.id = t2.id(+) AND t0.id = t3.id(+)
> Note that the 't2.id IS NULL AND t3.id IS NULL' seems suspect.
> This same test passes on OpenJPA 1.2.x but fails on OpenJPA 2.0.x on wards.  

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

[jira] [Closed] (OPENJPA-2132) Traversal of a OneToMany relationship returns an empty list when InheritanceType.JOINED or SINGLE_TABLE is used.

JIRA jira@apache.org
In reply to this post by JIRA jira@apache.org

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

Albert Lee closed OPENJPA-2132.
-------------------------------

   

> Traversal of a OneToMany relationship returns an empty list when InheritanceType.JOINED or SINGLE_TABLE is used.
> ----------------------------------------------------------------------------------------------------------------
>
>                 Key: OPENJPA-2132
>                 URL: https://issues.apache.org/jira/browse/OPENJPA-2132
>             Project: OpenJPA
>          Issue Type: Bug
>          Components: query
>    Affects Versions: 2.0.1, 2.1.1, 2.2.0
>            Reporter: Heath Thomann
>            Assignee: Dianne Richards
>             Fix For: 2.1.2, 2.3.0, 2.2.1
>
>         Attachments: OneManyJoinableTest.test
>
>
> I will include a test, named 'OneManyJoinableTest.test' which recreates the issue of this JIRA.  Basically though, the test consists of a parent class defined with '@Inheritance(strategy=InheritanceType.JOINED)'.  One of the subclasses in the hierarchy contains a (bidirectional) OneToMany relationship.  When traversing the ManyToOne side of the relations, all works well.  But when traversing the OneToMany side an empty list is returned.  When running the test, it can be seen that OpenJPA generate incorrect SQL, as follows:
> SELECT t1.id, t0.id, t2.id, t3.id, t1.name FROM UMLType t0, UMLNamed t1, UMLClass t2, UMLPrimitiveType t3 WHERE t0.OWNERPACKAGE_ID = ? AND t2.id IS NULL AND t3.id IS NULL AND t0.id = t1.id AND t0.id = t2.id(+) AND t0.id = t3.id(+)
> Note that the 't2.id IS NULL AND t3.id IS NULL' seems suspect.
> This same test passes on OpenJPA 1.2.x but fails on OpenJPA 2.0.x on wards.  

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
Loading...