]
Scott Wallace updated TEIID-4610:
---------------------------------
Attachment: server.log
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
Attachments: server.log
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}