dbGetQuery() returns wrong value

The data type is defined as bigint

On Mon, Jul 30, 2018 at 4:45 PM Eric Berger <ericjberger at gmail.com> wrote:

The ID matches in the first 16 characters.
How is your table XXXX declared?


On Mon, Jul 30, 2018 at 2:00 PM, Christofer Bogaso <
bogaso.christofer at gmail.com> wrote:

Session Information for above error:

sessionInfo()

R version 3.5.0 (2018-04-23)
Platform: x86_64-w64-mingw32/x64 (64-bit)
Running under: Windows 10 x64 (build 16299)

Matrix products: default

locale:
[1] LC_COLLATE=English_United States.1252  LC_CTYPE=English_United
States.1252    LC_MONETARY=English_United States.1252 LC_NUMERIC=C
                 LC_TIME=English_United States.1252

attached base packages:
[1] stats     graphics  grDevices utils     datasets  methods   base

other attached packages:
[1] csvread_1.2   bit64_0.9-7   bit_1.1-14    RJDBC_0.2-7.1 rJava_0.9-10
DBI_1.0.0

loaded via a namespace (and not attached):
[1] compiler_3.5.0 tools_3.5.0

On Mon, Jul 30, 2018 at 2:27 PM Christofer Bogaso <
bogaso.christofer at gmail.com> wrote:

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.