]
Steven Hawkins updated TEIID-5414:
----------------------------------
Component/s: Query Engine
Fix Version/s: 11.x
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.