You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@calcite.apache.org by "Michael Mior (JIRA)" <ji...@apache.org> on 2019/07/02 22:11:00 UTC
[jira] [Reopened] (CALCITE-3063) Babel parse should parse
PostgreSQL posix regular expressions
[ https://issues.apache.org/jira/browse/CALCITE-3063?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Michael Mior reopened CALCITE-3063:
-----------------------------------
Issues should not be closed until they have been released. They sit marked as resolved until then :)
> Babel parse should parse PostgreSQL posix regular expressions
> -------------------------------------------------------------
>
> Key: CALCITE-3063
> URL: https://issues.apache.org/jira/browse/CALCITE-3063
> Project: Calcite
> Issue Type: Bug
> Components: babel
> Affects Versions: 1.19.0
> Reporter: Muhammad Gelbana
> Assignee: Muhammad Gelbana
> Priority: Major
> Labels: pull-request-available
> Fix For: 1.21.0
>
> Time Spent: 1h
> Remaining Estimate: 0h
>
> Quoting from the referenced link below, posix operators are:
> ||Operator||Description||Example||
> |{{~}}|Matches regular expression, case sensitive|{{'thomas' ~ '.*thomas.*'}}|
> |{{~*}}|Matches regular expression, case insensitive|{{'thomas' ~* '.*Thomas.*'}}|
> |{{!~}}|Does not match regular expression, case sensitive|{{'thomas' !~ '.*Thomas.*'}}|
> |{{!~*}}|Does not match regular expression, case insensitive|{{'thomas' !~* '.*vadim.*'}}|
>
> +Reference:+ https://www.postgresql.org/docs/11/functions-matching.html#FUNCTIONS-POSIX-REGEXP
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)