Do not use RE2 on CRAN

[krlmlr]

Add a check here to check it's not used.

[krlmlr]

Does rhub2 catch this?

Run: https://github.com/duckdb/duckdb-r/actions/runs/8402600629

[krlmlr]

Yes, rhub2 catches this. I've also created a PR that breaks RE2::Init(), which is called for every regex operation AFAICT.

@hannes @Tmonster: There are at least two scenarios where re2 is invoked (involuntarily) -- listing tables and exporting the database, perhaps the latter is a variant of the former. I could work around for CRAN, but this will also show if other packages call duckdb::dbListTables() or duckdb::dbExistsTable(), which is sometimes also called from dbWriteTable() .

To reproduce, install the R package from #125.

library(duckdb)
#> Loading required package: DBI

con <- dbConnect(duckdb())
dbGetQuery(con, "SELECT * FROM sqlite_master")
#> Error: {"exception_type":"Invalid Input","exception_message":"Attempting to execute an unsuccessful or closed pending query result\nError: Invalid Error: Checking without re2 support"}
dbGetQuery(con, "SELECT * FROM information_schema.tables")
#> Error: {"exception_type":"Invalid Input","exception_message":"Attempting to execute an unsuccessful or closed pending query result\nError: Invalid Error: Checking without re2 support"}
dbGetQuery(con, "SELECT * FROM duckdb_tables()")
#> Error: {"exception_type":"Invalid Input","exception_message":"Attempting to execute an unsuccessful or closed pending query result\nError: Invalid Error: Checking without re2 support"}

^{Created on 2024-03-24 with reprex v2.1.0}

export_location <- tempfile("duckdb_test_export")
dir.create(export_location)

con <- DBI::dbConnect(duckdb::duckdb())
DBI::dbExecute(con, "CREATE TABLE integers(i integer)")
#> [1] 0
DBI::dbExecute(con, "insert into integers select * from range(10)")
#> [1] 10
DBI::dbExecute(con, "CREATE TABLE integers2(i INTEGER)")
#> [1] 0
DBI::dbExecute(con, "INSERT INTO integers2 VALUES (1), (5), (7), (1928)")
#> [1] 4
DBI::dbExecute(con, paste0("EXPORT DATABASE '", export_location, "'"))
#> Error: rapi_prepare: Failed to prepare query EXPORT DATABASE '/var/folders/dj/yhk9rkx97wn_ykqtnmk18xvc0000gn/T//Rtmp5kUEV2/duckdb_test_export141f23e55a3c7'
#> Error: Invalid Error: Checking without re2 support

^{Created on 2024-03-24 with reprex v2.1.0}

[krlmlr]

On the other hand, there are only two downstream packages that have compiled code: arrow and another one, none of them shows the failing checks now. We can submit, but this is a time bomb worth fixing eventually.

[hannes]

This may be fixed by duckdb/duckdb#11252 from the next version 0.10.2