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

Add support for GROUP BY ROLLUP

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Closed
    • Minor
    • Resolution: Fixed
    • 10.4.1.3
    • 10.6.1.0
    • SQL
    • None

    Description

      Provide an implementation of the ROLLUP form of multi-dimensional grouping according to the SQL standard.

      See http://wiki.apache.org/db-derby/OLAPRollupLists for some more detailed information about this aspect of the SQL standard.

      Attachments

        1. prototypeChangeNoTests.diff
          12 kB
          Bryan Pendleton
        2. IncludesASimpleTest.diff
          14 kB
          Bryan Pendleton
        3. useLookahead.diff
          14 kB
          Bryan Pendleton
        4. fixWhiteSpace.diff
          14 kB
          Bryan Pendleton
        5. rollupNullability.diff
          16 kB
          Bryan Pendleton
        6. rewriteGroupByRS.diff
          53 kB
          Bryan Pendleton
        7. passesRegressionTests.diff
          62 kB
          Bryan Pendleton
        8. UpdateToTrunkSep2009.diff
          64 kB
          Bryan Pendleton
        9. useAggregateObserver.diff
          60 kB
          Bryan Pendleton
        10. withDagsCastTest.diff
          62 kB
          Bryan Pendleton
        11. setCurrentRow.diff
          62 kB
          Bryan Pendleton

        Issue Links

          is related to

          Sub-task - The sub-task of the issue DERBY-3050 Convert groupBy.sql tests to JUnit and include them in GroupByTest.java

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. DERBY-5584 Select statement with subqueries with group by and count distinct statements returns wrong number of results

          • Major - Major loss of function.
          • Closed

          Activity

            People

              bryanpendleton Bryan Pendleton
              bryanpendleton Bryan Pendleton
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: