[ARROW-18250] [R] str_replace with NA does not match stringr behavior

• Type: Bug
• Status: Open
• Priority: Critical
• Resolution: Unresolved
• Component/s: R
• External issue URL: https://github.com/apache/arrow/issues/33432
• Assignee: Unassigned
• Reporter: Lucas Mation
• Created: 04/Nov/22 12:49
• Updated: 11/Jan/23 11:59

Description

q <- data.table(x=c('','1','2'))
q %>% write_dataset('q')

#in R

q %>% mutate(x2=x %>% str_replace('^
s*$',NA_character_))

   x   x2
1:   <NA>
2: 1    1
3: 2    2

#in arrow

q2 <- 'q' %>% open_dataset %>% mutate(x2=x %>% str_replace('^
s*$',NA_character_)) %>% collect

q2

   x x2
1:     
2: 1  1
3: 2  2

Issue Links

• relates to: ARROW-18202 [R][C++] Different behaviour of R's base::gsub() binding aka libarrow's replace_string_regex kernel since 10.0.0