[
https://issues.jboss.org/browse/TEIID-4833?page=com.atlassian.jira.plugin...
]
Steven Hawkins commented on TEIID-4833:
---------------------------------------
LISTAGG since it returns an oracle varchar2 is not quite a replacement for stringagg,
which returns a clob. Listagg has explicit overflow handling in the event that 4000 bytes
are exceeded.
As a quick solution I'll expose a listagg aggregate from the oracle translator. It
will use a more standard syntax though:
listagg (val, delim) order by ...
And the translator will handle adding the within group syntax.
Oracle JDBC Connector: Support for LISTAGG
------------------------------------------
Key: TEIID-4833
URL:
https://issues.jboss.org/browse/TEIID-4833
Project: Teiid
Issue Type: Feature Request
Components: JDBC Connector
Reporter: John Rodrigues
Assignee: Steven Hawkins
Add support for the Oracle LISTAGG function to the Teiid Oracle connector.
Refer to this discussion for context: [OracleConnector LISTAGG
function|https://developer.jboss.org/message/970282]
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)