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. d39.sql
        3 kB
        Knut Anders Hatlen
      2. derby-joinon.tar.gz
        10 kB
        James Alan Shepherd

        Issue Links

          Activity

          Knut Anders Hatlen made changes -
          Status Reopened [ 4 ] Closed [ 6 ]
          Resolution Won't Fix [ 2 ]
          Gavin made changes -
          Workflow jira [ 37727 ] Default workflow, editable Closed status [ 12801249 ]
          Kathey Marsden made changes -
          Issue & fix info High Value Fix,Repro attached [ 10422, 10424 ] Repro attached [ 10424 ]
          Dag H. Wanvik made changes -
          Labels derby_triage10_8
          Urgency Normal
          Myrna van Lunteren made changes -
          Issue & fix info [High Value Fix, Repro attached]
          Kathey Marsden made changes -
          Component/s Newcomer [ 12310640 ]
          Knut Anders Hatlen made changes -
          Attachment d39.sql [ 12374910 ]
          Knut Anders Hatlen made changes -
          Status Resolved [ 5 ] Reopened [ 4 ]
          Resolution Cannot Reproduce [ 5 ]
          Kathey Marsden made changes -
          Resolution Cannot Reproduce [ 5 ]
          Status Open [ 1 ] Resolved [ 5 ]
          Kathey Marsden made changes -
          Link This issue relates to DERBY-3395 [ DERBY-3395 ]
          James Alan Shepherd made changes -
          Attachment derby-joinon.tar.gz [ 12372974 ]
          Deepa Remesh made changes -
          Field Original Value New Value
          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
          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
          Component/s Newcomer [ 12310640 ]
          Environment
          Erik Bengtson created issue -

            People

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

              Dates

              • Created:
                Updated:
                Resolved:

                Development