Derby
  1. Derby
  2. DERBY-672

Re-enable user defined aggregates

    Details

    • Type: Improvement Improvement
    • Status: Closed
    • Priority: Major Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 10.10.1.1
    • Component/s: SQL
    • Labels:
      None
    • Issue & fix info:
      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.

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

        Issue Links

          Activity

          Rick Hillegas created issue -
          Mike Matrigali made changes -
          Field Original Value New Value
          Component/s SQL [ 11408 ]
          Rick Hillegas made changes -
          Link This issue is related to DERBY-3550 [ DERBY-3550 ]
          Dag H. Wanvik made changes -
          Issue Type New Feature [ 2 ] Improvement [ 4 ]
          Rick Hillegas made changes -
          Link This issue is related to DERBY-5466 [ DERBY-5466 ]
          Rick Hillegas made changes -
          Attachment UserDefinedAggregates.html [ 12537046 ]
          Rick Hillegas made changes -
          Attachment UserDefinedAggregates.html [ 12541240 ]
          Rick Hillegas made changes -
          Link This issue relates to DERBY-5901 [ DERBY-5901 ]
          Rick Hillegas made changes -
          Assignee Rick Hillegas [ rhillegas ]
          Rick Hillegas made changes -
          Attachment derby-672-01-aa-ddl.diff [ 12541244 ]
          Rick Hillegas made changes -
          Issue & fix info Patch Available [ 10102 ]
          Rick Hillegas made changes -
          Attachment derby-672-02-ac-nonDistinct.diff [ 12542817 ]
          Rick Hillegas made changes -
          Attachment derby-672-03-aa-distinct.diff [ 12543274 ]
          Rick Hillegas made changes -
          Attachment derby-672-03-ab-distinct.diff [ 12543299 ]
          Rick Hillegas made changes -
          Attachment derby-672-04-aa-fixJSR169test.diff [ 12543307 ]
          Rick Hillegas made changes -
          Rick Hillegas made changes -
          Attachment derby-672-06-aa-grantRevoke.diff [ 12543530 ]
          Rick Hillegas made changes -
          Attachment derby-672-07-aa-fixJSR169again.diff [ 12543532 ]
          Rick Hillegas made changes -
          Attachment derby-672-08-aa-fixJSR169yetAgain.diff [ 12543718 ]
          Rick Hillegas made changes -
          Attachment derby-672-09-ab-udtAggregates.diff [ 12546849 ]
          Rick Hillegas made changes -
          Attachment derby-672-10-af-typeBounds.diff [ 12547020 ]
          Rick Hillegas made changes -
          Attachment derby-672-11-aa-tests.diff [ 12548445 ]
          Rick Hillegas made changes -
          Attachment derby-672-11-ab-tests.diff [ 12548557 ]
          Rick Hillegas made changes -
          Attachment derby-672-12-aa-implicitCasts.diff [ 12549149 ]
          Rick Hillegas made changes -
          Rick Hillegas made changes -
          Attachment UserDefinedAggregates.html [ 12549302 ]
          Rick Hillegas made changes -
          Attachment derby-672-14-aa-collations.diff [ 12549363 ]
          Rick Hillegas made changes -
          Attachment derby-672-15-aa-setCollation.diff [ 12549368 ]
          Rick Hillegas made changes -
          Attachment derby-672-16-aa-forbidInGroupBy.diff [ 12549510 ]
          Rick Hillegas made changes -
          Attachment derby-672-17-aa-moreTests.diff [ 12549981 ]
          Rick Hillegas made changes -
          Attachment derby-672-18-aa-udaInJar.diff [ 12549989 ]
          Rick Hillegas made changes -
          Attachment derby-672-19-aa-precisionChecks.diff [ 12550028 ]
          Rick Hillegas made changes -
          Attachment derby-672-20-aa-exactBounds.diff [ 12550322 ]
          Knut Anders Hatlen made changes -
          Attachment d672-no-exceptions.diff [ 12550441 ]
          Rick Hillegas made changes -
          Attachment derby-672-21-aa-typeDependencies.diff [ 12550467 ]
          Rick Hillegas made changes -
          Attachment UserDefinedAggregates.html [ 12550472 ]
          Rick Hillegas made changes -
          Rick Hillegas made changes -
          Link This issue is related to DERBY-6127 [ DERBY-6127 ]
          Rick Hillegas made changes -
          Rick Hillegas made changes -
          Status Open [ 1 ] Resolved [ 5 ]
          Fix Version/s 10.10.1.1 [ 12321550 ]
          Resolution Fixed [ 1 ]
          Rick Hillegas made changes -
          Status Resolved [ 5 ] Closed [ 6 ]
          Gavin made changes -
          Workflow jira [ 12343335 ] Default workflow, editable Closed status [ 12801792 ]

            People

            • Assignee:
              Rick Hillegas
              Reporter:
              Rick Hillegas
            • Votes:
              6 Vote for this issue
              Watchers:
              7 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Development