[teiid-issues] [JBoss JIRA] (TEIID-5240) Add functionality for operators ILIKE / IREGEXP / RLIKE to Oracle translator
[
https://issues.jboss.org/browse/TEIID-5240?page=com.atlassian.jira.plugin...
]
Steven Hawkins resolved TEIID-5240.
-----------------------------------
Resolution: Duplicate Issue
Already resolved by TEIID-1694/TEIID-1602 as the translator support like_regex pushdown.
To expose regexp_like properly requires some additional handling as functions rewritten as
conditions become condition = 1, which oracle does not support. Given that like_regex is
already supported, that does not seem necessary. Also oracle does not have direct support
for case insensitive matching and instead recommends just using upper/lower as
appropriate. If Teiid level support is desired for a new predicate/condition called ilike
or ilike_regex, then we can revisit this pushdown.
Add functionality for operators ILIKE / IREGEXP / RLIKE to Oracle
translator
----------------------------------------------------------------------------
Key: TEIID-5240
URL: https://issues.jboss.org/browse/TEIID-5240
Project: Teiid
Issue Type: Enhancement
Components: Misc. Connectors
Affects Versions: 8.12.12.6_3
Reporter: Marc Shirley
Assignee: Steven Hawkins
Request to add operations ILIKE / IREGEXP / RLIKE to the Oracle translator similar to
what was added in TEIID-4711 for Impala.
--
This message was sent by Atlassian JIRA
(v7.5.0#75005)