Details

    • Type: Bug Bug
    • Status: Closed
    • Priority: Major Major
    • Resolution: Won't Fix
    • Affects Version/s: 10.0.2.0
    • Fix Version/s: None
    • Component/s: SQL
    • Urgency:
      Normal
    • Issue & fix info:
      Repro attached

      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

      1. derby-joinon.tar.gz
        10 kB
        James Alan Shepherd
      2. d39.sql
        3 kB
        Knut Anders Hatlen

        Issue Links

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              Erik Bengtson
            • Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Development