[R] dbGetQuery() returns wrong value

[Christofer Bogaso]

Hi,

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

72075186224672770

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

	[[alternative HTML version deleted]]