Getting warning messages in R after updating sqldf
Asked Answered
U

0

6

I just updated all R packages including sqldf today. Then I kept getting warning message as follows:

Warning message:
Quoted identifiers should have class SQL, use DBI::SQL() if the caller performs the quoting. 

What is the problem here? Is this warning serious? How to fix it?

Update:

This happens after updating sqldf and its associated packages. The command I use is sqldf("select * from something order by something")

Updraft answered 8/2, 2017 at 1:27 Comment(3)
I can confirm that this occurs in sqldf 0.4-10. To reproduce, try this in a fresh session: library(sqldf);sqldf("select * from iris limit 1");sqldf("select * from iris limit 1") You should get the warning the first time, but not the second.Purvis
@Purvis Yes, indeed I only got that warning once. My original/real question is whether I should be worried about this.Updraft
I don't think it's a problem, but if it worries you - I found rolling back RSQLite removed the warning: https://mcmap.net/q/1705325/-sqldf-create-table-from-data-frame-error-quot-no-such-table-quot-and-two-tables-created-instead-of-onePurvis

© 2022 - 2024 — McMap. All rights reserved.