Return-Path: Delivered-To: apmail-db-derby-dev-archive@www.apache.org Received: (qmail 72227 invoked from network); 17 Feb 2011 09:50:51 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.3) by minotaur.apache.org with SMTP; 17 Feb 2011 09:50:51 -0000 Received: (qmail 10399 invoked by uid 500); 17 Feb 2011 09:50:51 -0000 Delivered-To: apmail-db-derby-dev-archive@db.apache.org Received: (qmail 10104 invoked by uid 500); 17 Feb 2011 09:50:48 -0000 Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: Delivered-To: mailing list derby-dev@db.apache.org Received: (qmail 10094 invoked by uid 99); 17 Feb 2011 09:50:47 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 17 Feb 2011 09:50:47 +0000 X-ASF-Spam-Status: No, hits=-2000.0 required=5.0 tests=ALL_TRUSTED,T_RP_MATCHES_RCVD X-Spam-Check-By: apache.org Received: from [140.211.11.116] (HELO hel.zones.apache.org) (140.211.11.116) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 17 Feb 2011 09:50:45 +0000 Received: from hel.zones.apache.org (hel.zones.apache.org [140.211.11.116]) by hel.zones.apache.org (Postfix) with ESMTP id 99DA11AA831 for ; Thu, 17 Feb 2011 09:50:24 +0000 (UTC) Date: Thu, 17 Feb 2011 09:50:24 +0000 (UTC) From: "Knut Anders Hatlen (JIRA)" To: derby-dev@db.apache.org Message-ID: <2125594445.2275.1297936224626.JavaMail.tomcat@hel.zones.apache.org> Subject: [jira] Commented: (DERBY-39) Strange error in JOIN ON clause MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 X-Virus-Checked: Checked by ClamAV on apache.org [ https://issues.apache.org/jira/browse/DERBY-39?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12995736#comment-12995736 ] Knut Anders Hatlen commented on DERBY-39: ----------------------------------------- Since this is a very old bug report, no one has shown any interest in working on it, and no other databases that we know of accept the query, should we close it as won't fix? > Strange error in JOIN ON clause > ------------------------------- > > Key: DERBY-39 > URL: https://issues.apache.org/jira/browse/DERBY-39 > Project: Derby > Issue Type: Bug > Components: SQL > Affects Versions: 10.0.2.0 > Reporter: Erik Bengtson > Labels: derby_triage10_8 > Attachments: d39.sql, derby-joinon.tar.gz > > > The exception: > --------------------------------------- > Error: An ON clause associated with a JOIN operator is not valid. > --------------------------------------- > happens when I run the below SQL script: > --------------------------------------- > SELECT > THIS.DOSSIERTEMPLATE_ID > FROM DOSSIERTEMPLATE THIS, > ENTITLEMENT UNBOUND_ENTITLE > INNER JOIN > ENTITLEMENT II > ON UNBOUND_ENTITLE.ENTITLEMENT_ID = II.ENTITLEMENT_ID > INNER JOIN > DOSSIERTEMPLATERESOURCE BB > ON II.ENTITLED_TO_RESOURCE_ID_OID = BB.DOSSIERTEMPLATERESOURCE_ID > INNER JOIN > I18N THIS_LABEL > ON THIS.LABEL_I18N_ID_OID = THIS_LABEL.I18N_ID > --------------------------------------- > It works fine if I run without the LABEL join > --------------------------------------- > SELECT > THIS.DOSSIERTEMPLATE_ID > FROM DOSSIERTEMPLATE THIS, > ENTITLEMENT UNBOUND_ENTITLE > INNER JOIN > ENTITLEMENT II > ON UNBOUND_ENTITLE.ENTITLEMENT_ID = II.ENTITLEMENT_ID > INNER JOIN > DOSSIERTEMPLATERESOURCE BB > ON II.ENTITLED_TO_RESOURCE_ID_OID = BB.DOSSIERTEMPLATERESOURCE_ID > --------------------------------------- > The column LABEL_I18N_ID_OID is BIGINT and has a FK to I18N_ID, which is BIGINT as well -- This message is automatically generated by JIRA. - For more information on JIRA, see: http://www.atlassian.com/software/jira