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

LISTAGG support

    XMLWordPrintable

Details

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

    Description

      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.

      Attachments

        Issue Links

          is related to

          Feature Request - Feature requests from customers and/or users TEIID-4833 Oracle JDBC Connector: Support for LISTAGG

          • Major - To be worked after higher priority work items are addressed. When the severity is high and the effort to change it is low to moderate, this term is chosen. Issues in this category likely have an existing workaround but implementation or execution may be non-trivial.
          • Resolved

          Activity

            People

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

              Dates

                Created:
                Updated:
                Resolved: