Translation of as.Date in Oracle is not correct in version 2.4

[apalacio9502]

Hello,

In version 2.4 the translation of as.Date is not correct, I think the error is generated by the migration to glue_sql2

dbplyr/R/backend-oracle.R

Line 118 in 83045c5

as.Date = function(x) glue_sql2(sql_current_con(), "DATE {x}"),

In the previous version the conversion of as.Date() was DATE '2023-01-01' and now it is DATE 2023-01-01, so the problem is that the quotes are missing from the value of the date. I think it would be fixed by adding the .val in the following way: glue_sql2(sql_current_con(), "DATE {.val x}")

Regards,

[mgirlich]

Thanks for the detailed issue description. Now fixed in the dev version.