]
Steven Hawkins resolved TEIID-5176.
-----------------------------------
Fix Version/s: 10.0.4
10.2
10.1.2
(was: 10.1)
(was: 10.0.2)
Resolution: Done
Updated to run the rewrite when there is a function present.
This was only partially resolved in 10.1.0 and 10.0.2.
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.0.4, 10.2, 8.12.12.6_4, 10.1.2
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",