[ https://issues.apache.org/jira/browse/CALCITE-3063?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16877187#comment-16877187 ]
Michael Mior commented on CALCITE-3063: --------------------------------------- Fixed in [{{adf4cc4}}|https://github.com/apache/calcite/commit/adf4cc4dc5cdb9f5e49c85d10f46a2fdcd831ccf]. > 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 > 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)