Uploaded image for project: 'OASIS Content Management Interoperability Services (CMIS) TC'
  1. OASIS Content Management Interoperability Services (CMIS) TC
  2. CMIS-688

Query sample incorrect

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Minor
    • Resolution: Applied
    • Affects Version/s: V1.0 Errata
    • Fix Version/s: V1.0 Errata
    • Component/s: Domain Model
    • Labels:
      None
    • Proposal:
      Hide

      Instead it should be

      SELECT Y.CLAIM_NUM, X.PROPERTY_ADDRESS, Y.DAMAGE_ESTIMATES
      FROM (POLICY AS X JOIN CLAIMS AS Y ON X.POLICY_NUM = Y.POLICY_NUM)
      WHERE ( 100000 = ANY Y.DAMAGE_ESTIMATES )

      Show
      Instead it should be SELECT Y.CLAIM_NUM, X.PROPERTY_ADDRESS, Y.DAMAGE_ESTIMATES FROM (POLICY AS X JOIN CLAIMS AS Y ON X.POLICY_NUM = Y.POLICY_NUM) WHERE ( 100000 = ANY Y.DAMAGE_ESTIMATES )

      Description

      In section 2.1.10.2.4.2.2 <Quantified comparison predicate> the following query example is not parsable according to CMISQL grammar

      SELECT Y.CLAIM_NUM, X.PROPERTY_ADDRESS, Y.DAMAGE_ESTIMATES
      FROM POLICY AS X JOIN CLAIMS AS Y ON ( X.POLICY_NUM = Y.POLICY_NUM )
      WHERE ( 100000 = ANY Y.DAMAGE_ESTIMATES )

      (wrong parenthesis in FROM)

        Attachments

          Activity

            People

            • Assignee:
              fmueller Florian Müller (Inactive)
              Reporter:
              jhuebel Jens Hübel (Inactive)
            • Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: