When working with a sqlite tbl, if_else() won't accept named arguments - but *will* accept unnamed.

if_else_bug.R

library(dplyr)

# Set up a temp sqlite database
db <- src_sqlite(tempfile(), create = TRUE)
iris2 <- copy_to(db, iris)


# if_else with named true and false on a data.frame -> no problem
iris %>% mutate(Sepal.Size = if_else(Sepal.Length > 5, 
                                     true = "big", 
                                     false = "not big"))


# if_else with named true and false on the sqlite tbl -> 
# Error in if_else(Sepal.Length > 5, true = "big", false = "not big") : 
#     unused arguments (true = "big", false = "not big")
iris2 %>% mutate(Sepal.Size = if_else(Sepal.Length > 5, 
                                      true = "big", 
                                      false = "not big"))


# it works if unnamed, however
iris2 %>% mutate(Sepal.Size = if_else(Sepal.Length > 5, 
                                      "big", 
                                      "not big"))



# Same problem with base::ifelse
iris2 %>% mutate(Sepal.Size = ifelse(Sepal.Length > 5, 
                                     yes = "big", 
                                     no = "not big"))