JBoss DV throws "The function 'textcat( is an unknown form." when executing ODBC query
Issue
- ERROR: TEIID30068 The function 'textcat( is an unknown form. Check that the function name and number of arguments is correct.; Error while executing the query
Environment
- Red Hat JBoss Data Virtualization (DV) 6.3
- ODBC
- query includes clause like
{fn CONCAT({fn CONCAT("table"."column1", ', ')}, "table"."column2")} AS "columnAlias"
Subscriber exclusive content
A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.