PostgreSQL compatibility: regexp_instr with an empty pattern should return 1 #22257

Activity

1. Dandandan

   added

   bugSomething isn't workingSomething isn't working

   good first issueGood for newcomersGood for newcomers

   on May 16, 2026
2. toby-bridges commented on May 17, 2026

   

   toby-bridges

   on May 17, 2026

   More actions

   I’m taking a look at this one. I’m going to verify the current regexp_instr empty-pattern behavior locally and, if it stays narrowly scoped, send a small fix with tests.
3. Jefffrey commented on May 26, 2026

   

   Jefffrey

   on May 26, 2026

   Contributor

   More actions

   I think it makes sense to implement this fix given the original PR was using postgres as a reference:

   • Implementation for regex_instr #15928 (comment)

   And Spark seems to agree
4. neilconway

   closed this as completedin #24054on Aug 4, 2026
5. 847850277

   added a commit that references this issue on Aug 4, 2026

   fix: handle empty patterns in regexp_instr (apache#24054)

   ...

   This issue will close once commit f248f45 is merged into the 'main' branch.

   f248f45
6. kosiew

   added a commit that references this issue on Aug 12, 2026

   fix: handle empty patterns in regexp_instr (apache#24054)

   ...

   This issue will close once commit 87f87cc is merged into the 'main' branch.

   87f87cc