copy_to with in_schema fails with DBI 1.0.0

[OssiLehtinen]

Using copy_to from dbplyr with in_schema name definition results in an error message, when working with DBI 1.0.0

copy_to(con, mtcars, name=in_schema("TEMP", "MTCARS"))
#> Error: Can't unquote TEMP.MTCARS

The code for method dbUnquoteIdentifier in DBI's quote.R seems to have changed, which I suspect is causing the problem. I think it doesn't like the "." produced by in_schema.

The previous version I was using (DBI 0.8.0) didn't have this issue.

Some technical specs: I'm running under Redhat 7, and the database is IBM db2 via odbc.

Please let me know if some essintial info is missing, and thanks for any help in advance!

Br, Ossi

[krlmlr]

Thanks. Does it work if you use DBI::Id(schema = "TEMP", name = "MTCARS") instead of in_schema(...) ? We need to think of a way to make dbplyr comatible with DBI >= 1.0.0 again.

[OssiLehtinen]

Unfortunately, doesn't seem to work either.

copy_to(con, mtcars, name=DBI::Id(schema = "TEMP", name = "MTCARS"))
#> Error: is_string(x = name) is not TRUE

[ghost]

This issue was moved by krlmlr to tidyverse/dbplyr/issues/119.

[lock]

This old issue has been automatically locked. If you believe you have found a related problem, please file a new issue (with reprex) and link to this issue. https://reprex.tidyverse.org/