[teiid-issues] [JBoss JIRA] (TEIID-5176) Postgresql ODBC driver converts {fn CONCAT()} calls to a "textcat()" function
RH Bugzilla Integration (JIRA)
issues at jboss.org
Fri Dec 8 10:26:00 EST 2017
[ https://issues.jboss.org/browse/TEIID-5176?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
RH Bugzilla Integration updated TEIID-5176:
-------------------------------------------
Bugzilla References: https://bugzilla.redhat.com/show_bug.cgi?id=1523672
Bugzilla Update: Perform
> Postgresql ODBC driver converts {fn CONCAT()} calls to a "textcat()" function
> ------------------------------------------------------------------------------
>
> Key: TEIID-5176
> URL: https://issues.jboss.org/browse/TEIID-5176
> Project: Teiid
> Issue Type: Bug
> Reporter: Debbie Steigner
> Assignee: Steven Hawkins
>
> Customer is using tableau which converts to a SQL statement that includes nested concat function calls like [1]. The Postgresql ODBC driver appears to interpret those {fn CONCAT()} calls and converts to a "textcat()" function, which then results in a parsing error from Teiid since we don't support a textcat() function.
> [1] {fn CONCAT({fn CONCAT("TripSourceHotelBooking"."HotelCity", ', ')}, "TripSourceHotelBooking"."HotelCountry")} AS "Calculation_984036526439337984",
--
This message was sent by Atlassian JIRA
(v7.5.0#75005)
More information about the teiid-issues
mailing list