[
https://issues.jboss.org/browse/TEIID-5414?page=com.atlassian.jira.plugin...
]
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)