[ARROW-18242] [R] arrow implementation of lubridate::dmy parses invalid date "00001976" as date

• Type: Bug
• Status: Open
• Priority: Critical
• Resolution: Unresolved
• Fix Version/s: 11.0.0
• Component/s: R
• External issue URL: https://github.com/apache/arrow/issues/33425
• Assignee: Unassigned
• Reporter: Lucas Mation
• Created: 03/Nov/22 17:09
• Updated: 11/Jan/23 11:59

Description

Sorry for so many issues, but I think this is another bug.

Wrong behavior of the arrow implementation of the  `lubridate::dmy`.

An invalid date such as '00001976' is being parsed as a valid (and completely unrelated) date.

#in R
'00001976' %>% dmy
[1] NA
Warning message:
  All formats failed to parse. No formats found. 

#In arrow
q <- data.table(x=c('00001976','30111976','01011976'))
q %>% write_dataset('q')
q2 <- 'q' %>% open_dataset %>% mutate(x2=dmy) %>% collect
q2
x
1: 1975-11-30
2: 1976-11-30
3: 1976-01-01
#notice '00001976' is an invalid date. First row of x2 should be NA!!!