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

Extend user-defined aggregates to include multi-argument aggregators

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Open
    • Major
    • Resolution: Unresolved
    • 10.15.1.3
    • None
    • SQL
    • None
    • 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

          relates to

          Improvement - An improvement or enhancement to an existing feature or task. DERBY-6991 GROUP_CONCAT / LISTAGG

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

          Activity

            People

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

              Dates

                Created:
                Updated: