[ https://issues.apache.org/jira/browse/PHOENIX-3215?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Loknath Priyatham Teja Singamsetty reassigned PHOENIX-3215: ------------------------------------------------------------ Assignee: (was: Loknath Priyatham Teja Singamsetty ) > 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 > 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.15#6346)