Skip to content

PostgreSQL compatibility: regexp_replace should honor PostgreSQL multiline flag m #22258

@Dandandan

Description

@Dandandan

Split out from #22247.

Mismatch

regexp_replace should honor PostgreSQL multiline flag m.

SELECT regexp_replace(E'a\nb', '^b', 'x', 'm');

PostgreSQL:

a
x

DataFusion:

a\nb

Expected behavior

For PostgreSQL-compatible SQL semantics, DataFusion should either match PostgreSQL's result or raise the same class of domain/semantic error.

Metadata

Metadata

Labels

bugSomething isn't workinggood first issueGood for newcomers

Type

No type
No fields configured for issues without a type.

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions