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

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

    Details

    • Type: Quality Risk
    • Status: Resolved (View Workflow)
    • Priority: Major
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: 10.1, 10.0.2
    • Component/s: ODBC
    • Labels:
      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",

        Gliffy Diagrams

          Attachments

            Activity

              People

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

                Dates

                • Created:
                  Updated:
                  Resolved: