[
https://issues.jboss.org/browse/TEIID-3491?page=com.atlassian.jira.plugin...
]
Steven Hawkins commented on TEIID-3491:
---------------------------------------
Because they are thread safe, we may look at using a more global pattern cache.
For pushdown support it does look like we'll have to be careful. Many of the other
implementations appear to replace all by default, have support for different or no flags,
and the have variations in the regex syntax as you highlight with the back references.
More than likely this means we'll need to add a method where the translator can be
asked if it supports a given pattern.
Add support for REGEXP_REPLACE
------------------------------
Key: TEIID-3491
URL:
https://issues.jboss.org/browse/TEIID-3491
Project: Teiid
Issue Type: Feature Request
Components: Query Engine
Reporter: Tom Arnold
Assignee: Steven Hawkins
Add support for REGEXP_REPLACE function like in Postgres.
http://www.postgresql.org/docs/9.3/static/functions-string.html
Pushdown version might be tricky.
* MySQL - No support.
* Postgres - Good.
* Oracle - Good, but "g" flag to replace all matches is set by positional
params instead.
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)