Uploaded image for project: 'Teiid'
  1. Teiid
  2. TEIID-5414

LISTAGG support

XMLWordPrintable

    • Icon: Feature Request Feature Request
    • Resolution: Done
    • Icon: Major Major
    • 11.2
    • None
    • Query Engine
    • None

      It would be useful to have supported new SQL2016 syntax for LISTAGG. Currently TEIID suport only *STRING_AGG *keyword, so I have to regexp replace it in SQL syntax generated by JOOQ sql builder as it uses new *LISTAGG *keyword in default.

      Parameteres syntax should be the same in both so the easiest option is to add just alias into grammar. However LISTAGG supports also some advanced syntax which could be useful too.

              rhn-engineering-shawkins Steven Hawkins
              lukyer Lukas Lukyer (Inactive)
              Votes:
              1 Vote for this issue
              Watchers:
              3 Start watching this issue

                Created:
                Updated:
                Resolved: