[teiid-issues] [JBoss JIRA] (TEIID-5176) Postgresql ODBC driver converts {fn CONCAT()} calls to a "textcat()" function

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: Quality Risk Components: ODBC Reporter: Debbie Steigner Assignee: Steven Hawkins Fix For: 10.1, 10.0.2, 8.12.12.6_4 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",