openjpa-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Pinaki Poddar (JIRA)" <j...@apache.org>
Subject [jira] Created: (OPENJPA-710) Unordered collection field adds ORDER BY clause
Date Tue, 02 Sep 2008 21:15:44 GMT
Unordered collection field adds ORDER BY clause
-----------------------------------------------

                 Key: OPENJPA-710
                 URL: https://issues.apache.org/jira/browse/OPENJPA-710
             Project: OpenJPA
          Issue Type: Bug
            Reporter: Pinaki Poddar
            Assignee: Pinaki Poddar
             Fix For: 1.3.0


An ORDER BY clause is added while selecting even for collection-valued fields that do not
require ordering. 

For example, consider a typical Parent-Child model with bi-directional relationship where
Parent.children is declared and/or initialized as a Set rather than a List will result in
the following SQL
       "SELECT t0.id, t0.name, t1.id FROM PARENT t0 LEFT OUTER JOIN CHILD t1 ON t0.id = t1.PARENT_ID
ORDER BY t1.PARENT_ID"
corresponding to JPQL "select p from Parent p left join fetch p.children".

Is ORDER BY clause necessary in this context? I
t also adds an extra performance overhead on the SQL query execution for a fairly frequent
usage pattern.


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