[ https://issues.apache.org/jira/browse/DERBY-39?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Knut Anders Hatlen reopened DERBY-39: ------------------------------------- Reopening since the comments mention plenty of repros. I don't know if it's a bug, but it is reproducible. > Strange error in JOIN ON clause > ------------------------------- > > Key: DERBY-39 > URL: https://issues.apache.org/jira/browse/DERBY-39 > Project: Derby > Issue Type: Bug > Components: Newcomer, SQL > Affects Versions: 10.0.2.0 > Reporter: Erik Bengtson > Attachments: 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. - You can reply to this email to add a comment to the issue online.