[teiid-issues] [JBoss JIRA] (TEIID-4610) Impala regexp_replace function colliding with prepared values
Scott Wallace (JIRA)
issues at jboss.org
Tue Nov 29 15:12:02 EST 2016
[ https://issues.jboss.org/browse/TEIID-4610?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Scott Wallace updated TEIID-4610:
---------------------------------
Description:
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]}}
was:
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.`product_name`, '\'', ''') FROM warehouse.fact_transaction_process_date_detail g_0 WHERE g_0.`process_date_key` = ? AND g_0.`publisher_key` = 112]}}
> 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)
More information about the teiid-issues
mailing list