openjpa-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Fay Wang (JIRA)" <j...@apache.org>
Subject [jira] Closed: (OPENJPA-1458) Named parameters are not handled by OpenJPA correctly
Date Tue, 09 Mar 2010 18:13:27 GMT

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

Fay Wang closed OPENJPA-1458.
-----------------------------


> Named parameters are not handled by OpenJPA correctly
> -----------------------------------------------------
>
>                 Key: OPENJPA-1458
>                 URL: https://issues.apache.org/jira/browse/OPENJPA-1458
>             Project: OpenJPA
>          Issue Type: Bug
>    Affects Versions: 2.0.0-M3
>            Reporter: Fay Wang
>            Assignee: Fay Wang
>             Fix For: 2.0.0
>
>         Attachments: OPENJPA-1458-TestCases.jar
>
>
> Named parameters are not handled correctly as shown below
> 9093  erww  TRACE  [main] openjpa.Query - Executing query: [select o from OrderJPA o
where o.OrderId in (select max(o1.OrderId) from OrderJPA o1 where ((o1.CustomerId = :customerId)
and (o1.DistrictId = :districtId) and (o1.WarehouseId = :warehouseId))) and (o.WarehouseId
= :warehouseId) and (o.CustomerId = :customerId) and (o.DistrictId = :districtId)] with parameters:
{customerId=10, districtId=1, warehouseId=12}
> 9194  erww  TRACE  [main] openjpa.jdbc.SQL - <t 29744585, conn 23467239> executing
prepstmnt 15580729 SELECT t0.O_D_ID, t0.O_ID, t0.O_W_ID, t0.O_ALL_LOCAL, t0.O_CARRIER_ID,
t0.O_C_ID, t0.O_ENTRY_D, t0.O_OL_CNT FROM ORDERS t0 WHERE (t0.O_ID IN (SELECT MAX(t1.O_ID)
FROM ORDERS t1 WHERE (t1.O_C_ID = ? AND t1.O_D_ID = ? AND t1.O_W_ID = ?) ) AND t0.O_W_ID =
? AND t0.O_C_ID = ? AND t0.O_D_ID = ?)  optimize for 1 row [params=(short) 10, (short) 1,
(short) 12, (short) 12, (short) 12, (short) 12]
> Release 1.2 and 1.3 works fine. This problem only happens in the trunk.

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