Research stricter interpolation revdep failures

tidyverse / dbplyr

Database (DBI) backend for dplyr

https://dbplyr.tidyverse.org

Other

474 stars 173 forks source link

Research stricter interpolation revdep failures #1465

Closed hadley closed 7 months ago

hadley commented 7 months ago

arrow — https://github.com/apache/arrow/pull/40197
bcdata — https://github.com/bcgov/bcdata/pull/338
CDMConnector — https://github.com/darwin-eu/CDMConnector/pull/16 (also affects CohortSurvival, DrugUtilisation, IncidencePrevalence, PatientProfiles)

hadley commented 7 months ago

I think arrow problem might be:

library(dbplyr)
library(dplyr, warn.conflicts = FALSE)

y <- data.frame(id = 1)
lazy_frame(x = 1) %>% filter(x == y$id)
#> Error in `filter()`:
#> ℹ In argument: `x == y$id`
#> Caused by error:
#> ! Cannot translate a data.frame to SQL.
#> ℹ Do you want to force evaluation in R with (e.g.) `!!y$x` or `local(y$x)`?

^{Created on 2024-02-21 with reprex v2.1.0}

Hmmm, or maybe not?