Unexpected behavior from get_tbl_information_dbi when tbl name created with dbplyr::in_schema

[brancengregory]

The code found here produces behavior which will cause failure, including of core functions like create_agent

If the tbl supplied to create_agent is created with dbplyr::in_schema like so:

con <- DBI::dbConnect(RPostgres::Postgres())
test_tbl <- tbl(con, dbplyr::in_schema(schema = "public", table = "<table_name>"))

Then, get_tbl_information_dbi will convert the table name into a length two character vector. Then when the q_types query is created it will also be a length two character vector. When the query is sent to the db, it fails.

@rich-iannone, I would love any guidance on how to create a reprex for these types of issues. I have needed to create them for other bugs I've found in R packages, but haven't been able to figure out how to mock the db connection.

Anyways, I'm happy to take a swing at fixing this. I'm thinking we could check the class of dbplyr::remote_name(tbl) and change behavior accordingly. Thoughts or alternatives?

[brancengregory]

PS. I created this issue like in the screenshot which bypassed the issue template unintended by me