[teiid-issues] [JBoss JIRA] (TEIID-5414) LISTAGG support

[Steven Hawkins (JIRA)]

     [ https://issues.jboss.org/browse/TEIID-5414?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Steven Hawkins resolved TEIID-5414.
-----------------------------------
    Resolution: Done


Added parsing and pushdown support for listagg - with the catch that pushdown support is still based upon a limited form of the string_agg function (string_agg fully subsumes the syntax/features of listagg).

> LISTAGG support
> ---------------
>
>                 Key: TEIID-5414
>                 URL: https://issues.jboss.org/browse/TEIID-5414
>             Project: Teiid
>          Issue Type: Feature Request
>          Components: Query Engine
>            Reporter: Lukáš Svačina
>            Assignee: Steven Hawkins
>             Fix For: 11.2
>
>
> 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.



--
This message was sent by Atlassian JIRA
(v7.5.0#75005)