[r] bigint advertised in duckdb() and dbConnect(), but only the former is supported

[mtmorgan]

What happens?

For BIGINT columns the help page ?duckdb suggests a field bigint = "integer64" can be present either in dbConnect(duckdb(bigint = "integer64")) or dbConnect(duckdb(), bigint = "integer64"), but this is only respected in the first case.

The help page code is at https://github.com/duckdb/duckdb/blob/f7f5cf30aa5dfbc900c98c57bef2d729f2bf1b56/tools/rpkg/man/duckdb.Rd#L31 and the implementation showing that bigint will often be ignored is at https://github.com/duckdb/duckdb/blob/f7f5cf30aa5dfbc900c98c57bef2d729f2bf1b56/tools/rpkg/R/dbConnect__duckdb_driver.R#L55-L58

To Reproduce

Install dependencies:

install.packages(c('duckdb', 'bit64'))
library(duckdb)

bigint used when in duckdb()...

con = dbConnect(duckdb(bigint = "integer64"))
dbWriteTable(con, "one", data.frame(i64 = bit64::as.integer64(1:5)))
dbGetQuery(con, "DESCRIBE one")
##   column_name column_type null  key default extra
## 1         i64      BIGINT  YES <NA>    <NA>    NA

...but not when in dbConnect()

con = dbConnect(duckdb(), bigint = "integer64")
dbWriteTable(con, "one", data.frame(i64 = bit64::as.integer64(1:5)))
dbGetQuery(con, "DESCRIBE one")
##   column_name column_type null  key default extra
## 1         i64      DOUBLE  YES <NA>    <NA>    NA

OS:

aarch64-apple-darwin21.6.0

DuckDB Version:

0.8.1.1

DuckDB Client:

R

Full Name:

Martin Morgan

Affiliation:

Roswell Park Comprehensive Cancer Center

Have you tried this on the latest master branch?

• I agree

Have you tried the steps to reproduce? Do they include all relevant data and configuration? Does the issue you report still appear there?

• I agree

[krlmlr]

Thanks, confirmed:

library(duckdb)
#> Loading required package: DBI
con <- dbConnect(duckdb(), bigint = "integer64")
dbWriteTable(con, "one", data.frame(i64 = bit64::as.integer64(1:5)))
dbGetQuery(con, "DESCRIBE one")
#>   column_name column_type null  key default extra
#> 1         i64      DOUBLE  YES <NA>    <NA>    NA

^{Created on 2023-12-02 with reprex v2.0.2}

[krlmlr]

Is this still an issue with v0.10.1, on CRAN now?

[mtmorgan]

The behavior reported above does not occur with duckdb 0.10.1 on aarch64-apple-darwin20.