Impala regexp_replace function colliding with prepared values ------------------------------------------------------------- Key: TEIID-4610 URL: https://issues.jboss.org/browse/TEIID-4610 Project: Teiid Issue Type: Bug Components: Misc. Connectors Affects Versions: 8.13.3 Reporter: Scott Wallace Assignee: Steven Hawkins Impala regexp_replace function appears to collide with prepared values only when attemping to replace apostrophe. select impala.regexp_replace(string_column,char(39),concat('&apos',char(59))) from some_impala_table where date_key = concat(substring('2016-01-15',1,7),'-01') and customer_id = 112 Error: {noformat} org.teiid.runtime.client.TeiidClientException: java.lang.RuntimeException: Remote org.teiid.core.TeiidProcessingException: TEIID30504 warehouse: 500051 TEIID11008:TEIID11004 Error executing statement(s): [Prepared Values: ['2016-01-01'] SQL: SELECT regexp_replace(g_0.`string_column`, '\'', ''') FROM some_impala_table g_0 WHERE g_0.`process_date_key` = ? AND g_0.`customer_id` = 112] {noformat}