Return-Path: 
 <dev-return-16287-apmail-openjpa-dev-archive=openjpa.apache.org@openjpa.apache.org>
Delivered-To: apmail-openjpa-dev-archive@www.apache.org
Received: (qmail 72683 invoked from network); 23 Apr 2010 19:45:16 -0000
Received: from unknown (HELO mail.apache.org) (140.211.11.3)
  by 140.211.11.9 with SMTP; 23 Apr 2010 19:45:16 -0000
Received: (qmail 62018 invoked by uid 500); 23 Apr 2010 19:45:16 -0000
Delivered-To: apmail-openjpa-dev-archive@openjpa.apache.org
Received: (qmail 61951 invoked by uid 500); 23 Apr 2010 19:45:15 -0000
Mailing-List: contact dev-help@openjpa.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:dev-help@openjpa.apache.org>
List-Unsubscribe: <mailto:dev-unsubscribe@openjpa.apache.org>
List-Post: <mailto:dev@openjpa.apache.org>
List-Id: <dev.openjpa.apache.org>
Reply-To: dev@openjpa.apache.org
Delivered-To: mailing list dev@openjpa.apache.org
Received: (qmail 61941 invoked by uid 99); 23 Apr 2010 19:45:15 -0000
Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136)
    by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 23 Apr 2010 19:45:15 +0000
X-ASF-Spam-Status: No, hits=-1339.2 required=10.0
	tests=ALL_TRUSTED,AWL
X-Spam-Check-By: apache.org
Received: from [140.211.11.22] (HELO thor.apache.org) (140.211.11.22)
    by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 23 Apr 2010 19:45:10 +0000
Received: from thor (localhost [127.0.0.1])
	by thor.apache.org (8.13.8+Sun/8.13.8) with ESMTP id o3NJinC1013413
	for <dev@openjpa.apache.org>; Fri, 23 Apr 2010 19:44:50 GMT
Message-ID: <8424305.166561272051889351.JavaMail.jira@thor>
Date: Fri, 23 Apr 2010 15:44:49 -0400 (EDT)
From: "Joachim Bartz (JIRA)" <jira@apache.org>
To: dev@openjpa.apache.org
Subject: [jira] Updated: (OPENJPA-1458) Named parameters are not handled by
 OpenJPA correctly
In-Reply-To: <378758535.219871263410574374.JavaMail.jira@brutus.apache.org>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit
X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394


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

Joachim Bartz updated OPENJPA-1458:
-----------------------------------

    Attachment:     (was: OPENJPA-1458-TestCases.jar)

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