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

Re-enable user defined aggregates

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Closed
    • Major
    • Resolution: Fixed
    • None
    • 10.10.1.1
    • SQL
    • None
    • Patch Available

    Description

      Nicolas Dufour in an email thread titled "functions and list" started on November 2, 2005 requests the ability to create user defined aggregates.

      This functionality used to be in Cloudscape. It was disabled presumably because it was considered non-standard. However, most of the machinery needed for this feature is still in the code. We should re-enable user defined aggregates after we agree on acceptable syntax.

      Attachments

        1. UserDefinedAggregates.html
          12 kB
          Richard N. Hillegas
        2. UserDefinedAggregates.html
          15 kB
          Richard N. Hillegas
        3. derby-672-01-aa-ddl.diff
          57 kB
          Richard N. Hillegas
        4. derby-672-02-ac-nonDistinct.diff
          80 kB
          Richard N. Hillegas
        5. derby-672-03-aa-distinct.diff
          16 kB
          Richard N. Hillegas
        6. derby-672-03-ab-distinct.diff
          22 kB
          Richard N. Hillegas
        7. derby-672-04-aa-fixJSR169test.diff
          1 kB
          Richard N. Hillegas
        8. derby-672-05-aa-java7testOrderProblem.diff
          16 kB
          Richard N. Hillegas
        9. derby-672-06-aa-grantRevoke.diff
          23 kB
          Richard N. Hillegas
        10. derby-672-07-aa-fixJSR169again.diff
          0.8 kB
          Richard N. Hillegas
        11. derby-672-08-aa-fixJSR169yetAgain.diff
          0.7 kB
          Richard N. Hillegas
        12. derby-672-09-ab-udtAggregates.diff
          11 kB
          Richard N. Hillegas
        13. derby-672-10-af-typeBounds.diff
          26 kB
          Richard N. Hillegas
        14. derby-672-11-aa-tests.diff
          38 kB
          Richard N. Hillegas
        15. derby-672-11-ab-tests.diff
          42 kB
          Richard N. Hillegas
        16. derby-672-12-aa-implicitCasts.diff
          16 kB
          Richard N. Hillegas
        17. derby-672-13-aa-differentReturnType.diff
          7 kB
          Richard N. Hillegas
        18. UserDefinedAggregates.html
          18 kB
          Richard N. Hillegas
        19. derby-672-14-aa-collations.diff
          2 kB
          Richard N. Hillegas
        20. derby-672-15-aa-setCollation.diff
          2 kB
          Richard N. Hillegas
        21. derby-672-16-aa-forbidInGroupBy.diff
          5 kB
          Richard N. Hillegas
        22. derby-672-17-aa-moreTests.diff
          7 kB
          Richard N. Hillegas
        23. derby-672-18-aa-udaInJar.diff
          6 kB
          Richard N. Hillegas
        24. derby-672-19-aa-precisionChecks.diff
          5 kB
          Richard N. Hillegas
        25. derby-672-20-aa-exactBounds.diff
          16 kB
          Richard N. Hillegas
        26. d672-no-exceptions.diff
          3 kB
          Knut Anders Hatlen
        27. derby-672-21-aa-typeDependencies.diff
          5 kB
          Richard N. Hillegas
        28. UserDefinedAggregates.html
          18 kB
          Richard N. Hillegas
        29. derby-672-22-aa-makeModeAggregateStateSerializable.diff
          0.9 kB
          Richard N. Hillegas
        30. derby-672-23-aa-improveJavadocForAggregator.merge.diff
          1 kB
          Richard N. Hillegas

        Issue Links

          is related to

          Bug - A problem which impairs or prevents the functions of the product. DERBY-3550 The Reference guide says that you can create your own user-defined aggregates, but Derby does not have this capability.

          • Major - Major loss of function.
          • Closed

          Improvement - An improvement or enhancement to an existing feature or task. DERBY-6127 Tell users to make sure that the state of a user-defined aggregate needs to be serializable

          • Major - Major loss of function.
          • Closed

          Improvement - An improvement or enhancement to an existing feature or task. DERBY-5466 Add support for SQL Standard statistics functions, such as STDDEV_POP, STDDEV_SAMP, VAR_POP, VAR_SAMP

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

          Bug - A problem which impairs or prevents the functions of the product. DERBY-5901 You can declare user-defined functions which shadow builtin functions by the same name.

          • Major - Major loss of function.
          • Open

          Activity

            People

              rhillegas Richard N. Hillegas
              rhillegas Richard N. Hillegas
              Votes:
              6 Vote for this issue
              Watchers:
              7 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: