[teiid-issues] [JBoss JIRA] (TEIID-4833) Oracle JDBC Connector: Support for LISTAGG

[ https://issues.jboss.org/browse/TEIID-4833?page=com.atlassian.jira.plugin... ] 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. -- This message was sent by Atlassian JIRA (v7.2.3#72005)