[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:comment-tabpanel&focusedCommentId=13604502#comment-13604502 ] 

Steven Hawkins commented on TEIID-5414:
---------------------------------------

Will evaluate in 11.x.  TEIID-4833 added support for pushing down for a simple form of LISTAGG when using an oracle source, so this issue would cover full engine support.

> 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.x
>
>
> 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)