openjpa-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Catalina Wei (JIRA)" <j...@apache.org>
Subject [jira] Created: (OPENJPA-215) unneeded left join SQL for queries with inner join fetch, related to issue OPENJPA-134
Date Thu, 12 Apr 2007 01:10:32 GMT
unneeded left join SQL  for queries with  inner join fetch, related to issue OPENJPA-134
----------------------------------------------------------------------------------------

                 Key: OPENJPA-215
                 URL: https://issues.apache.org/jira/browse/OPENJPA-215
             Project: OpenJPA
          Issue Type: Bug
          Components: sql
    Affects Versions: 0.9.6, 0.9.7, 0.9.8
            Reporter: Catalina Wei


In verifying fixes for issue OPEN-134, found an outstanding problem. 
Extra unneeded join generated for the following query with inner join fetch while left join
fetch generates correct SQL:

    select o from Order o inner join fetch o.lineitems

the generated SQL has an extra left join that causes the result set empty, I will create a
new JIRA issue for this problem:
1297 demo TRACE [main] openjpa.Query - Executing query: select o from Order o inner join fetch
o.lineitems

1297 demo TRACE [main] openjpa.jdbc.SQL - <t 1094861122, conn 1831234854> executing
prepstmnt 726281034 SELECT t0.oid, t0.version, t0.amount, t0.customer_countryCode, t0.customer_id,
t0.delivered, t2.order_oid, t2.lid, t2.version, t2.cost, t2.part_partno, t2.quantity FROM
TORDER t0 INNER JOIN TORDERITEM t1 ON t0.oid = t1.order_oid LEFT OUTER JOIN TORDERITEM t2
ON t0.oid = t2.order_oid ORDER BY t2.order_oid ASC FOR READ ONLY 

Abe,
I have verified this fix with EagerFetchMode parallel and join. However, there is an outstanding
problem for the following query with inner join fetch while left join fetch generates correct
SQL:

    select o from Order o inner join fetch o.lineitems

the generated SQL has an extra left join that causes the result set empty, I will create a
new JIRA issue for this problem:
1297 demo TRACE [main] openjpa.Query - Executing query: select o from Order o inner join fetch
o.lineitems

1297 demo TRACE [main] openjpa.jdbc.SQL - <t 1094861122, conn 1831234854> executing
prepstmnt 726281034 SELECT t0.oid, t0.version, t0.amount, t0.customer_countryCode, t0.customer_id,
t0.delivered, t2.order_oid, t2.lid, t2.version, t2.cost, t2.part_partno, t2.quantity FROM
TORDER t0 INNER JOIN TORDERITEM t1 ON t0.oid = t1.order_oid LEFT OUTER JOIN TORDERITEM t2
ON t0.oid = t2.order_oid ORDER BY t2.order_oid ASC FOR READ ONLY 



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