[ARROW-17132] [R] Timezone handling in round-trip of POSIXct

• Type: Bug
• Status: Open
• Priority: Minor
• Resolution: Unresolved
• Component/s: R
• Labels: test
• External issue URL: https://github.com/apache/arrow/issues/32434

Language

R

• Assignee: Unassigned
• Reporter: Rok Mihevc
• Created: 19/Jul/22 23:50
• Updated: 11/Jan/23 11:48

Description

The following:

df <- tibble::tibble(
  time = as.POSIXct(seq(as.Date("1999-12-31", tz = "UTC"), as.Date("2001-01-01", tz = "UTC"), by = "day"))
)

compare_dplyr_binding(
  .input %>%
    mutate(x = yday(time)) %>%
    collect(),
  df
)

Fails with:

Failure (test-dplyr-funcs-datetime.R:574:3): extract wday from timestamp
`object` (`actual`) not equal to `expected` (`expected`).

`attr(actual$time, 'tzone')` is a character vector ('UTC')
`attr(expected$time, 'tzone')` is absent
Backtrace:
 1. arrow:::compare_dplyr_binding(...)
      at test-dplyr-funcs-datetime.R:574:2
 2. arrow:::expect_equal(via_batch, expected, ...)
      at tests/testthat/helper-expectation.R:115:4
 3. testthat::expect_equal(...)
      at tests/testthat/helper-expectation.R:42:4

This also happens for qday and probably other functions where input is temporal and output is numeric.