Uploaded image for project: 'Teiid'
  1. Teiid
  2. TEIID-5176

Postgresql ODBC driver converts {fn CONCAT()} calls to a "textcat()" function

XMLWordPrintable

    • Icon: Quality Risk Quality Risk
    • Resolution: Done
    • Icon: Major Major
    • 10.0.4, 10.2, 8.12.12.6_4, 10.1.2
    • None
    • ODBC
    • None

      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",

              rhn-engineering-shawkins Steven Hawkins
              rhn-support-dsteigner Deborah Steigner (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

                Created:
                Updated:
                Resolved: