Message: A new issue has been created in JIRA.
--------------------------------------------------------------------- View the issue: http://issues.apache.org/jira/browse/DERBY-39 Here is an overview of the issue: --------------------------------------------------------------------- Key: DERBY-39 Summary: Strange error in JOIN ON clause Type: Bug Status: Unassigned Priority: Major Project: Derby Components: SQL Versions: 10.0.2.0 Assignee: Reporter: Erik Bengtson Created: Mon, 11 Oct 2004 3:35 AM Updated: Mon, 11 Oct 2004 3:35 AM Description: 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 --------------------------------------------------------------------- JIRA INFORMATION: 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 If you want more information on JIRA, or have a bug to report see: http://www.atlassian.com/software/jira
