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

Improve documentation of ROW_NUMBER function

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Closed
    • Minor
    • Resolution: Fixed
    • 10.10.1.1
    • 10.10.2.0, 10.11.1.1
    • Documentation
    • None

    Description

      The current documentation doesn't mention that we allow the window definition to be explicit.
      The restriction on WHERE clause no longer applies, nor does the sentence about ORDER BY not being allowed in subqueries. Cf. rreffuncrownumber.dita. Also, the documentation mentions that we don't support LIMIT, but not that we now support the FETCH/OFFSET clause, which is often a better option than ROW_NUMBER.

      Attachments

        1. DERBY-6103-5.zip
          10 kB
          Camilla Haase
        2. DERBY-6103-5.diff
          8 kB
          Camilla Haase
        3. DERBY-6103-4.zip
          10 kB
          Camilla Haase
        4. DERBY-6103-4.diff
          8 kB
          Camilla Haase
        5. DERBY-6103-3.zip
          10 kB
          Camilla Haase
        6. DERBY-6103-3.diff
          8 kB
          Camilla Haase
        7. DERBY-6103-2.zip
          10 kB
          Camilla Haase
        8. DERBY-6103-2.stat
          0.2 kB
          Camilla Haase
        9. DERBY-6103-2.diff
          8 kB
          Camilla Haase
        10. DERBY-6103.zip
          4 kB
          Camilla Haase
        11. DERBY-6103.stat
          0.1 kB
          Camilla Haase
        12. DERBY-6103.diff
          3 kB
          Camilla Haase

        Activity

          People

            chaase3 Camilla Haase
            dagw Dag H. Wanvik
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: