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")

Scarabee
  • 5,437
  • 5
  • 29
  • 55
LaTeXFan
  • 1,136
  • 4
  • 14
  • 36
  • 2
    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. – sebastian-c Mar 09 '17 at 09:06
  • 1
    @sebastian-c Yes, indeed I only got that warning once. My original/real question is whether I should be worried about this. – LaTeXFan Mar 10 '17 at 07:43
  • I don't think it's a problem, but if it worries you - I found rolling back RSQLite removed the warning: http://stackoverflow.com/a/41514737/1465387 – sebastian-c Mar 10 '17 at 09:51

0 Answers0