[jira] [Commented] (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:comment-tabpanel=16877336#comment-16877336 ] Muhammad Gelbana commented on CALCITE-3063: --- Understood. Sorry I didn't know that. Thanks :) > 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)
[jira] [Commented] (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:comment-tabpanel=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)