[GitHub] [arrow-rs] Jefffrey commented on issue #3803: regexp_match skips first match when returning match

["Jefffrey (via GitHub)" <gi...@apache.org>]

Jefffrey commented on issue #3803:
URL: https://github.com/apache/arrow-rs/issues/3803#issuecomment-1456915003

   If parity with Postgres is desired, then this would be considered a bug. Relevant extract:
   
   > If a match is found, and the `pattern` contains no parenthesized subexpressions, then the result is a single-element text array containing the substring matching the whole pattern
   
   From: https://www.postgresql.org/docs/current/functions-matching.html
   
   Also it might be somewhat confusing as returning a not-null value in the output ListArray indicates a match was found (else it would be null instead of a StringArray), but resultant StringArray itself is empty without the match. The behaviour seems somewhat inconsistent?


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: github-unsubscribe@arrow.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org