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

Strange error in JOIN ON clause

Attach filesAttach ScreenshotVotersWatch issueWatchersCreate sub-taskLinkCloneUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Won't Fix
    • 10.0.2.0
    • None
    • SQL
    • Normal
    • 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. derby-joinon.tar.gz
          10 kB
          James Alan Shepherd
        2. d39.sql
          3 kB
          Knut Anders Hatlen

        Issue Links

        Activity

          This comment will be Viewable by All Users Viewable by All Users
          Cancel

          People

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

            Dates

              Created:
              Updated:
              Resolved:

              Slack

                Issue deployment