Loknath Priyatham Teja Singamsetty created PHOENIX-3215:
------------------------------------------------------------
Summary: Add oracle regexp_like function in phoenix
Key: PHOENIX-3215
URL: https://issues.apache.org/jira/browse/PHOENIX-3215
Project: Phoenix
Issue Type: Improvement
Reporter: Loknath Priyatham Teja Singamsetty
Assignee: Loknath Priyatham Teja Singamsetty
Priority: Minor
We have regexp_substr today which returns a substring of a string by applying a
regular expression start from the offset of a one-based position.
However, when using query builder frameworks like JOOQ code generators that
generates java code from database and build type safe sql queries out of box,
lack of regexp_like syntax is making developers to take work arounds to build
the equivalent queries.
Hard coding Query for regexp_substr as JOOQ does not support it:
{quote}
regex = regex + " AND regexp_substr("+
TestResultEntity.Column.BASELINE_MESSAGE.getName() +", ?)" + matching;
{quote}
Here is the oracle documentation for regexp_like
https://docs.oracle.com/cd/B12037_01/server.101/b10759/conditions018.htm
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
