[R] dbGetQuery() returns wrong value

Christofer Bogaso bog@@o@chri@tofer @ending from gm@il@com
Mon Jul 30 10:57:34 CEST 2018


I used following SQL query to fetch information from DB

> dbGetQuery(Conn, "select ID from XXXX where date = '2018-07-18' and ID =
'72075186224672770' limit 10")
1 72075186224672768

As you see, it is returning a different result from what actual query
string contains.

However when I used the same query in some other SQL client, I get the
expected result as:


Any idea on what went wrong in R supplied query would be highly appreciated.

	[[alternative HTML version deleted]]

More information about the R-help mailing list