The data type is defined as bigint On Mon, Jul 30, 2018 at 4:45 PM Eric Berger <ericjber...@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.christo...@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.christo...@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. >> > >> > >> >> [[alternative HTML version deleted]] >> >> ______________________________________________ >> R-help@r-project.org mailing list -- To UNSUBSCRIBE and more, see >> https://stat.ethz.ch/mailman/listinfo/r-help >> PLEASE do read the posting guide >> http://www.R-project.org/posting-guide.html >> and provide commented, minimal, self-contained, reproducible code. >> > > [[alternative HTML version deleted]] ______________________________________________ R-help@r-project.org mailing list -- To UNSUBSCRIBE and more, see https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.
