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

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

    XMLWordPrintable

Details

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

    Description

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

      Attachments

        Activity

          People

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

            Dates

              Created:
              Updated:
              Resolved: