[SPARK-27952] String Functions: regexp_replace is not compatible

• Type: Sub-task
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 3.0.0
• Component/s: SQL
• Assignee: Unassigned
• Reporter: Zhu, Lipeng
• Created: 05/Jun/19 04:48
• Updated: 29/Dec/19 05:59

Description

PostgreSQL's regexp_replace has the syntax: regexp_replace(source, pattern, replacement [, flags ]). This is not compatible with our syntax regexp_replace(str, regexp, rep). The flags parameter is an optional text string containing zero or more single-letter flags that change the function's behavior. Flag i specifies case-insensitive matching, while flag g specifies replacement of each matching substring rather than only the first one. Some examples:

regexp_replace('foobarbaz', 'b..', 'X')
                                   fooXbaz
regexp_replace('foobarbaz', 'b..', 'X', 'g')
                                   fooXX
regexp_replace('foobarbaz', 'b(..)', 'X\1Y', 'g')
                                   fooXarYXazY

More details: https://www.postgresql.org/docs/11/functions-matching.html#FUNCTIONS-POSIX-REGEXP