[request] support for integer64 from bit64 package

[dselivanov]

Would be great to have support for mapping of R's bit64::integer64 to monetdb BIGINT. (I believe this is quite simple since bit64::integer64 is just long long and I'm pretty sure same as BIGINT)

I can't find a solution how to keep integer64. Is there any workaround?

[hannes]

We will add this at some point. The workaround now is a CAST to string before the result column is handed over.

[hannes]

Want to give it a try? I'd be happy to review a PR.

[dselivanov]

Can'r promise, but mb will try to create PR this weekend.

[hannes]

Okay, I did this in the end, this should work (with the master branch)

library(bit64)
library(DBI)
con <- dbConnect(MonetDBLite::MonetDBLite())

options(monetdb.int64=T)

a <- data.frame(a=as.integer64(c(42, NA, 4294967294)))

dbWriteTable(con, "a", a)
print(res <- dbGetQuery(con, "SELECT * from a"))
print(str(res))

The monetdb.int64 option enables the writing of bit64 integer64 vectors as BIGINT and the conversion of results of BIGINT to integer64 R vectors. Is this what you expected?

[hannes]

Referencing a DBI issue on the topic here: r-dbi/DBI#248

[dselivanov]

Awesome! I will test and report back.

[dselivanov]

@hannesmuehleisen works perfectly. Many thanks!

[hannes]

Extended to support dbConnect parameter bigint as standardized by DBI:

library(bit64)
library(DBI)
con <- dbConnect(MonetDBLite::MonetDBLite(), bigint="integer64")
a <- data.frame(a=as.integer64(c(42, NA, 4294967294)))
dbWriteTable(con, "a", a)
print(res <- dbGetQuery(con, "SELECT * from a"))
print(str(res))