Query sample incorrect

XMLWordPrintable

    • Type: Bug
    • Resolution: Applied
    • Priority: Minor
    • V1.0 Errata
    • Affects Version/s: V1.0 Errata
    • Component/s: Domain Model
    • None
    • 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 )

      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)

            Assignee:
            Florian Müller (Inactive)
            Reporter:
            Jens Hübel (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Created:
              Updated:
              Resolved: