XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: Domain Model
    • Labels:
      None
    • Proposal:
      Hide

      <sort specification> ::= <column reference> [ ASC | DESC ]

      Show
      <sort specification> ::= <column reference> [ ASC | DESC ]

      Description

      The BNF for a query has:
      <sort specification> ::= <column name> [ ASC | DESC ]

      However if we want to allow queries with JOINs to order their results, like:
      SELECT B.cmis:ObjectId, B.dc:title FROM cmis:Document A JOIN cmis:Document B ON A.cmis:ObjectId = B.my:field WHERE A.dc:description = 'foo' ORDER BY B.dc:title

      Then we have to use a BNF like:
      <sort specification> ::= <column reference> [ ASC | DESC ]

      Note: In this BNF statement, SQL-92 has <column name>, but SQL 2008 actually has a very generic <value expression> instead. I think <column reference> is sufficient for CMIS.

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              florent.guillaume Florent Guillaume (Inactive)
            • Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: