Return-Path: Delivered-To: apmail-incubator-open-jpa-dev-archive@locus.apache.org Received: (qmail 68127 invoked from network); 14 Nov 2006 01:08:58 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 14 Nov 2006 01:08:58 -0000 Received: (qmail 63528 invoked by uid 500); 14 Nov 2006 01:09:09 -0000 Delivered-To: apmail-incubator-open-jpa-dev-archive@incubator.apache.org Received: (qmail 63497 invoked by uid 500); 14 Nov 2006 01:09:09 -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 63488 invoked by uid 99); 14 Nov 2006 01:09:09 -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 17:09:09 -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 17:08:58 -0800 Received: from brutus (localhost [127.0.0.1]) by brutus.apache.org (Postfix) with ESMTP id A28D67142FE for ; Mon, 13 Nov 2006 17:08:37 -0800 (PST) Message-ID: <24343246.1163466517645.JavaMail.jira@brutus> Date: Mon, 13 Nov 2006 17:08:37 -0800 (PST) From: "Marc Prud'hommeaux (JIRA)" To: open-jpa-dev@incubator.apache.org Subject: [jira] Updated: (OPENJPA-81) Bad error message when trying to query a Collection relation using dot notation In-Reply-To: <26822780.1163449537696.JavaMail.jira@brutus> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-Virus-Checked: Checked by ClamAV on apache.org [ http://issues.apache.org/jira/browse/OPENJPA-81?page=all ] Marc Prud'hommeaux updated OPENJPA-81: -------------------------------------- Component/s: diagnostics Summary: Bad error message when trying to query a Collection relation using dot notation (was: Wrong alias used when querying an attribute of a 1:n child) Issue Type: Improvement (was: Bug) Priority: Minor (was: Major) > Bad error message when trying to query a Collection relation using dot notation > ------------------------------------------------------------------------------- > > Key: OPENJPA-81 > URL: http://issues.apache.org/jira/browse/OPENJPA-81 > Project: OpenJPA > Issue Type: Improvement > Components: diagnostics, query > Environment: openJPA 0.9.7 > MySQL 5.0.15 > Reporter: Jakob Braeuchi > Priority: Minor > > 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