Repository navigation
PostgreSQL compatibility: regexp_count should count empty-pattern matches #22267
Description
Split out from #22247.
Mismatch
regexp_count should count empty-pattern matches.
SELECT regexp_count('abc', '');PostgreSQL:
4
DataFusion:
0
Expected behavior
For PostgreSQL-compatible SQL semantics, DataFusion should either match PostgreSQL's result or raise the same class of domain/semantic error.
Activity
xiedeyantu commentedon May 16, 2026
take
toby-bridges commentedon May 17, 2026
I’m taking a look at this one. I’m going to verify the current empty-pattern behavior locally and, if it stays narrowly scoped, send a small fix with tests.
toby-bridges commentedon May 17, 2026
I’m taking a look at this one. I’m going to verify the current
regexp_countempty-pattern behavior locally and, if it stays narrowly scoped, send a small fix with tests.xiedeyantu commentedon May 17, 2026
Thank you for also paying attention to this issue. I have taken this issue and am working on fixing it. I will submit the PR once I have it sorted out.
fix regexp_count should count empty-pattern matches (apache#22311)