Return-Path: Delivered-To: apmail-incubator-open-jpa-dev-archive@locus.apache.org Received: (qmail 73928 invoked from network); 13 Nov 2006 20:26:00 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 13 Nov 2006 20:25:59 -0000 Received: (qmail 43234 invoked by uid 500); 13 Nov 2006 20:26:10 -0000 Delivered-To: apmail-incubator-open-jpa-dev-archive@incubator.apache.org Received: (qmail 43205 invoked by uid 500); 13 Nov 2006 20:26:10 -0000 Mailing-List: contact open-jpa-dev-help@incubator.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: open-jpa-dev@incubator.apache.org Delivered-To: mailing list open-jpa-dev@incubator.apache.org Received: (qmail 43196 invoked by uid 99); 13 Nov 2006 20:26:10 -0000 Received: from herse.apache.org (HELO herse.apache.org) (140.211.11.133) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 13 Nov 2006 12:26:10 -0800 X-ASF-Spam-Status: No, hits=0.0 required=10.0 tests= X-Spam-Check-By: apache.org Received: from [140.211.11.4] (HELO brutus.apache.org) (140.211.11.4) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 13 Nov 2006 12:25:58 -0800 Received: from brutus (localhost [127.0.0.1]) by brutus.apache.org (Postfix) with ESMTP id AABEB7142D7 for ; Mon, 13 Nov 2006 12:25:37 -0800 (PST) Message-ID: <26822780.1163449537696.JavaMail.jira@brutus> Date: Mon, 13 Nov 2006 12:25:37 -0800 (PST) From: "Jakob Braeuchi (JIRA)" To: open-jpa-dev@incubator.apache.org Subject: [jira] Created: (OPENJPA-81) Wrong alias used when querying an attribute of a 1:n child MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-Virus-Checked: Checked by ClamAV on apache.org Wrong alias used when querying an attribute of a 1:n child ---------------------------------------------------------- Key: OPENJPA-81 URL: http://issues.apache.org/jira/browse/OPENJPA-81 Project: OpenJPA Issue Type: Bug Components: query Environment: openJPA 0.9.7 MySQL 5.0.15 Reporter: Jakob Braeuchi the query over the 1:n relationship 'katergorien' em.createQuery("select distinct k from KategorieGruppe k " + "where k.kategorien.bezeichnung like ?1 " + "order by k.bezeichnung asc"); uses a wrong alias t2 in the generated SQL: SELECT DISTINCT t0.id, t0.bezeichnung FROM ekv2kategoriegruppe t0 INNER JOIN ekv2kategorie t1 ON t0.id = t1.idGruppe WHERE (t2.bezeichnung LIKE ? ESCAPE '\\') ORDER BY t0.bezeichnung ASC [params=(String) F%] Unknown column 't2.bezeichnung' in 'where clause' -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira