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