duckplyr icon indicating copy to clipboard operation
duckplyr copied to clipboard

Fix descending sort for character data

Open krlmlr opened this issue 4 months ago • 4 comments

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

Sys.setenv("DUCKPLYR_FORCE" = "TRUE")

data.frame(a = letters[1:3]) |>
  as_duckplyr_df() |>
  arrange(desc(a))
#> Error: Binder Error: No function matches the given name and argument types '-(VARCHAR)'. You might need to add explicit type casts.
#>  Candidate functions:
#>  -(TINYINT) -> TINYINT
#>  -(TINYINT, TINYINT) -> TINYINT
#>  -(SMALLINT) -> SMALLINT
#>  -(SMALLINT, SMALLINT) -> SMALLINT
#>  -(INTEGER) -> INTEGER
#>  -(INTEGER, INTEGER) -> INTEGER
#>  -(BIGINT) -> BIGINT
#>  -(BIGINT, BIGINT) -> BIGINT
#>  -(HUGEINT) -> HUGEINT
#>  -(HUGEINT, HUGEINT) -> HUGEINT
#>  -(FLOAT) -> FLOAT
#>  -(FLOAT, FLOAT) -> FLOAT
#>  -(DOUBLE) -> DOUBLE
#>  -(DOUBLE, DOUBLE) -> DOUBLE
#>  -(DECIMAL) -> DECIMAL
#>  -(DECIMAL, DECIMAL) -> DECIMAL
#>  -(UTINYINT) -> UTINYINT
#>  -(UTINYINT, UTINYINT) -> UTINYINT
#>  -(USMALLINT) -> USMALLINT
#>  -(USMALLINT, USMALLINT) -> USMALLINT
#>  -(UINTEGER) -> UINTEGER
#>  -(UINTEGER, UINTEGER) -> UINTEGER
#>  -(UBIGINT) -> UBIGINT
#>  -(UBIGINT, UBIGINT) -> UBIGINT
#>  -(DATE, DATE) -> BIGINT
#>  -(DATE, INTEGER) -> DATE
#>  -(TIMESTAMP, TIMESTAMP) -> INTERVAL
#>  -(INTERVAL, INTERVAL) -> INTERVAL
#>  -(DATE, INTERVAL) -> DATE
#>  -(TIME, INTERVAL) -> TIME
#>  -(TIMESTAMP, INTERVAL) -> TIMESTAMP
#>  -(INTERVAL) -> INTERVAL

Created on 2024-02-04 with reprex v2.1.0

krlmlr avatar Feb 04 '24 19:02 krlmlr