[ http://issues.apache.org/jira/browse/DERBY-39?page=all ]
Deepa Remesh updated DERBY-39:
------------------------------
Component: Newcomer
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
was:
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
Environment:
> Strange error in JOIN ON clause
> -------------------------------
>
> Key: DERBY-39
> URL: http://issues.apache.org/jira/browse/DERBY-39
> Project: Derby
> Type: Bug
> Components: SQL, Newcomer
> Versions: 10.0.2.0
> Reporter: Erik Bengtson
>
> 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.
-
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
