[teiid-issues] [JBoss JIRA] (TEIID-4833) Oracle JDBC Connector: Support for LISTAGG
Steven Hawkins (JIRA)
issues at jboss.org
Mon Apr 3 16:26:00 EDT 2017
[ https://issues.jboss.org/browse/TEIID-4833?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13388119#comment-13388119 ]
Steven Hawkins edited comment on TEIID-4833 at 4/3/17 4:25 PM:
---------------------------------------------------------------
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.
was (Author: shawkins):
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)
More information about the teiid-issues
mailing list