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

          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: