Uploaded image for project: 'Derby'
  1. Derby
  2. DERBY-581 Modify SQL to skip N rows of the result and return the next M rows
  3. DERBY-2998

Add support for ROW_NUMBER() window function

    XMLWordPrintableJSON

Details

    • Sub-task
    • Status: Closed
    • Minor
    • Resolution: Fixed
    • None
    • 10.4.1.3
    • SQL
    • None

    Description

      As part of implementing the overall OLAP Operations features of SQL (DERBY-581), implement the ROW_NUMBER() window function.

      More information about this feature is available at http://wiki.apache.org/db-derby/OLAPRowNumber

      DERBY-2998 implements

      • framework code for windows and window function result columns.
      • the ROW_NUMBER() window function according to SQL2003
        but the implementation is limited by
      • only supporting an empty, unnamed, inline window definition (i.e the full, unordered resultset)
      • not being fully optimized

      Attachments

        1. d2998-10.diff
          52 kB
          Thomas Nielsen
        2. d2998-10.stat
          1 kB
          Thomas Nielsen
        3. d2998-11.diff
          50 kB
          Thomas Nielsen
        4. d2998-12.diff
          52 kB
          Thomas Nielsen
        5. d2998-12.stat
          1 kB
          Thomas Nielsen
        6. d2998-13.diff
          53 kB
          Thomas Nielsen
        7. d2998-13.stat
          1 kB
          Thomas Nielsen
        8. d2998-14.diff
          52 kB
          Thomas Nielsen
        9. d2998-14.stat
          1 kB
          Thomas Nielsen
        10. d2998-15.diff
          55 kB
          Thomas Nielsen
        11. d2998-15.stat
          1 kB
          Thomas Nielsen
        12. d2998-16.diff
          57 kB
          Thomas Nielsen
        13. d2998-16.stat
          2 kB
          Thomas Nielsen
        14. d2998-17.diff
          59 kB
          Thomas Nielsen
        15. d2998-17.stat
          1 kB
          Thomas Nielsen
        16. d2998-18.diff
          58 kB
          Thomas Nielsen
        17. d2998-18.stat
          2 kB
          Thomas Nielsen
        18. d2998-19.diff
          57 kB
          Thomas Nielsen
        19. d2998-19.stat
          2 kB
          Thomas Nielsen
        20. d2998-4.diff
          44 kB
          Thomas Nielsen
        21. d2998-4.stat
          1 kB
          Thomas Nielsen
        22. d2998-5.diff
          39 kB
          Thomas Nielsen
        23. d2998-5.stat
          0.9 kB
          Thomas Nielsen
        24. d2998-6.diff
          45 kB
          Thomas Nielsen
        25. d2998-6.stat
          1 kB
          Thomas Nielsen
        26. d2998-7.diff
          45 kB
          Thomas Nielsen
        27. d2998-7.stat
          1 kB
          Thomas Nielsen
        28. d2998-8.diff
          46 kB
          Thomas Nielsen
        29. d2998-8.stat
          1 kB
          Thomas Nielsen
        30. d2998-9.diff
          52 kB
          Thomas Nielsen
        31. d2998-9.stat
          1 kB
          Thomas Nielsen
        32. d2998-9-derby.log
          60 kB
          Thomas Nielsen
        33. d2998-doc-1.diff
          4 kB
          Thomas Nielsen
        34. d2998-doc-1.stat
          0.1 kB
          Thomas Nielsen
        35. d2998-doc-2.diff
          4 kB
          Thomas Nielsen
        36. d2998-doc-2.stat
          0.1 kB
          Thomas Nielsen
        37. d2998-followup-2.diff
          0.6 kB
          Thomas Nielsen
        38. d2998-followup-2.stat
          0.1 kB
          Thomas Nielsen
        39. d2998-followup-distinct.diff
          5 kB
          Thomas Nielsen
        40. d2998-followup-distinct.diff
          5 kB
          Thomas Nielsen
        41. d2998-followup-distinct.stat
          0.2 kB
          Thomas Nielsen
        42. d2998-followup-doc3.diff
          1 kB
          Thomas Nielsen
        43. d2998-followup-doc3.stat
          0.0 kB
          Thomas Nielsen
        44. d2998-followup-issue1.diff
          0.6 kB
          Thomas Nielsen
        45. d2998-followup-issue1.stat
          0.1 kB
          Thomas Nielsen
        46. d2998-followup-issue4.diff
          3 kB
          Thomas Nielsen
        47. d2998-followup-issue4.stat
          0.1 kB
          Thomas Nielsen
        48. d2998-followup-removeunused.diff
          0.9 kB
          Thomas Nielsen
        49. d2998-followup-testsuite.diff
          0.7 kB
          Thomas Nielsen
        50. d2998-followup-testsuite.stat
          0.1 kB
          Thomas Nielsen
        51. d2998-test.diff
          5 kB
          Thomas Nielsen
        52. d2998-test.stat
          0.1 kB
          Thomas Nielsen
        53. d2998-test2.diff
          2 kB
          Thomas Nielsen
        54. d2998-test2.stat
          0.1 kB
          Thomas Nielsen
        55. d2998-test3.diff
          3 kB
          Thomas Nielsen
        56. d2998-test3.stat
          0.1 kB
          Thomas Nielsen
        57. d2998-test4.diff
          6 kB
          Thomas Nielsen
        58. d2998-test4.stat
          0.1 kB
          Thomas Nielsen
        59. d2998-test6.diff
          8 kB
          Thomas Nielsen
        60. d2998-test7.diff
          7 kB
          Thomas Nielsen
        61. d2998-test8.diff
          11 kB
          Thomas Nielsen
        62. d2998-test9.diff
          12 kB
          Thomas Nielsen
        63. rreffuncrownumber.html
          4 kB
          Thomas Nielsen

        Issue Links

          relates to

          Bug - A problem which impairs or prevents the functions of the product. DERBY-3634 Cannot use row_number() in ORDER BY clause

          • Major - Major loss of function.
          • Closed

          Improvement - An improvement or enhancement to an existing feature or task. DERBY-4079 Add support for SQL:2008 <result offset clause> and <fetch first clause> to limit result set cardinality

          • Major - Major loss of function.
          • Closed

          Activity

            People

              thomanie Thomas Nielsen
              thomanie Thomas Nielsen
              Votes:
              5 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: