restez and duckdb 0.9.0

[krlmlr]

We're in the process of releasing duckdb 0.9.0. Running your checks with the updated duckdb version revealed problems: https://github.com/duckdb/duckdb-r/blob/main/revdep/problems.md#restez . We would like to send the update to CRAN as soon as possible.

duckdb 0.9.0 might reorder rows more aggressively than previous versions did. If your queries rely on a particular row output order, please make sure that you specify it.

Can you please confirm? Installation instructions on https://github.com/duckdb/duckdb-r/tree/main#installation-from-r-universe are up to date. Thanks!

CC @hannes.

[krlmlr]

Just a heads-up, we're releasing duckdb to CRAN today.

[joelnitta]

@krlmlr Thanks for the heads-up, and sorry for my late reply.

There was one bug that I had to fix -- the database size in memory got smaller as a result of the update, which broke a test. All other tests pass.

The only querying of the database looks like this:

  qry <- paste0("SELECT accession,", nm,
                " FROM nucleotide WHERE accession IN ", qry_id)

where nm includes one or more column names, and qry_id includes ID numbers.

I don't think row order should matter for any of this.