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
|
