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

Extend user-defined aggregates to include multi-argument aggregators

    XMLWordPrintableJSON

    Details

    • Type: Improvement
    • Status: Open
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 10.15.1.3
    • Fix Version/s: None
    • Component/s: SQL
    • Labels:
      None
    • Urgency:
      Normal

      Description

      Right now, a user can't implement an aggregate like LISTAGG (GROUP_CONCAT) because LISTAGG takes multiple arguments (the expression being concatenated plus a separator character). The cleanest solution would be an Aggregator which is phrased in terms of a tuple argument. We should check with the Java language experts to see how far away they are from adding tuples to Java. If that feature is a long way out, then we might need to add our own tuple abstraction or add a series of Aggregator interfaces, one for 2 arg aggregates, one for 3 arg aggregates, and so on.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                Unassigned
                Reporter:
                rhillegas Richard N. Hillegas
              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated: