Uploaded image for project: 'Derby'
  1. Derby
  2. DERBY-39

Strange error in JOIN ON clause

    Details

    • Type: Bug
    • Status: Closed
    • Priority: 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

        Attachments

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

          Issue Links

            Activity

              People

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

                Dates

                • Created:
                  Updated:
                  Resolved: