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

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

    Details

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

        Gliffy Diagrams

          Attachments

            Activity

              People

              • Assignee:
                shawkins Steven Hawkins
                Reporter:
                dsteigne Debbie Steigner
              • Votes:
                0 Vote for this issue
                Watchers:
                4 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: