[CALCITE-3063] Babel parse should parse PostgreSQL posix regular expressions

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.19.0
• Fix Version/s: 1.21.0
• Component/s: babel
• Labels: pull-request-available
• Assignee: Mohamed Mohsen
• Reporter: Mohamed Mohsen
• Created: 11/May/19 03:26
• Updated: 10/Sep/19 21:37
• Resolved: 02/Jul/19 22:10

Description

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

Issue Links

• links to: GitHub Pull Request #1242