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

Activity

1. Dandandan

   added

   bugSomething isn't workingSomething isn't working

   good first issueGood for newcomersGood for newcomers

   on May 16, 2026
2. kumarUjjawal commented on May 18, 2026

   

   kumarUjjawal

   on May 18, 2026

   Contributor

   More actions

   memory D SELECT regexp_replace(E'a\nb', '^b', 'x', 'm');
   ┌────────────────────────────────────────┐
   │ regexp_replace('a\nb', '^b', 'x', 'm') │
   │                varchar                 │
   ├────────────────────────────────────────┤
   │ a\nb                                   │
   └────────────────────────────────────────┘
   

   duckdb/duckdb#17056
3. Jefffrey commented on May 28, 2026

   

   Jefffrey

   on May 28, 2026

   Contributor

   More actions

   Can't reproduce on main

   DataFusion CLI v53.1.0
   > SELECT regexp_replace(E'a\nb', '^b', 'x', 'm');
   +-------------------------------------+
   | regexp_replace(Utf8("a              |
   | b"),Utf8("^b"),Utf8("x"),Utf8("m")) |
   +-------------------------------------+
   | a                                   |
   | x                                   |
   +-------------------------------------+
   1 row(s) fetched.
   Elapsed 0.059 seconds.
4. Jefffrey

   closed this as not plannedon May 28, 2026