[JBoss JIRA] (TEIID-4610) Impala regexp_replace function colliding with prepared values
- First Post
- Replies
- Stats
-
Go to
- ----- 2025 -----
- March
- February
- January
- ----- 2024 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2023 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2022 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2021 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2020 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2019 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2018 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2017 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2016 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2015 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2014 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2013 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2012 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2011 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2010 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2009 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
[
https://issues.jboss.org/browse/TEIID-4610?page=com.atlassian.jira.plugin...
]
Steven Hawkins commented on TEIID-4610:
---------------------------------------
I don't quite follow what is going on here. In the user query you have
concat('"',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)
3041
days inactive
3041
days old
0 comments
1 participants
tags (0)
participants (1)
-
Steven Hawkins (JIRA)