Comparing strings with numbers

[krlmlr]

options(conflicts.policy = list(warn = FALSE))
library(duckplyr)

data.frame(a = 1) |>
  filter(a != "")
#>   a
#> 1 1

data.frame(a = 1) |>
  as_duckplyr_df() |>
  filter(a != "")
#> materializing:
#> ---------------------
#> --- Relation Tree ---
#> ---------------------
#> Filter [!=(a, '')]
#>   r_dataframe_scan(0x10c5491b8)
#> 
#> ---------------------
#> -- Result Columns  --
#> ---------------------
#> - a (DOUBLE)
#> 
#> [1] a
#> <0 rows> (or 0-length row.names)

^{Created on 2023-11-16 with reprex v2.0.2}

Upstream: duckdb/duckdb-r#44

[krlmlr]

Now:

options(conflicts.policy = list(warn = FALSE))
library(duckplyr)

data.frame(a = 1) |>
  filter(a != "")
#>   a
#> 1 1

data.frame(a = 1) |>
  as_duckplyr_df() |>
  filter(a != "")
#> materializing:
#> ---------------------
#> --- Relation Tree ---
#> ---------------------
#> Filter [!=(a, '')]
#>   r_dataframe_scan(0x10887eae0)
#> 
#> ---------------------
#> -- Result Columns  --
#> ---------------------
#> - a (DOUBLE)
#> 
#>   a
#> 1 1

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