[teiid-issues] [JBoss JIRA] (TEIID-4610) Impala regexp_replace function colliding with prepared values

[Steven Hawkins (JIRA)]

    [ https://issues.jboss.org/browse/TEIID-4610?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13331901#comment-13331901 ] 

Steven Hawkins commented on TEIID-4610:
---------------------------------------

I don't quite follow what is going on here.  In the user query you have concat('&quot',char(59)), which will be replaced with the literal value '"'.  In the source query you are showing ''' - but there is no where in our logic where the xml escape value would be changed into a the replacement character.  Can you confirm this is your exact user query and/or provide a 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
>
> Impala regexp_replace function appears to collide with prepared values only when attemping to replace apostrophe.
> Error: 
> {{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 00:00:00.0'] SQL: SELECT regexp_replace(g_0.`string_column`, '\'', ''') FROM some_impala_table g_0 WHERE g_0.`date_key` = ? AND g_0.`customer_id` = 112]}}



--
This message was sent by Atlassian JIRA
(v7.2.3#72005)