dbListTables lists a table but dbExistsTable says it doesn't exist

[joethorley]

The following code demonstrates the problem

con <- DBI::dbConnect(RSQLite::SQLite(), ":memory:")
DBI::dbCreateTable(con, "`loCal`", mtcars)
DBI::dbListTables(con) # lists table 
DBI::dbExistsTable(con, "`loCal`") # but says it doesn't exist
DBI::dbDisconnect(con)

[krlmlr]

Thanks, confirmed. This problem seems to be restricted to table names that start and end with a backtick.

Need to use

name <- dbUnquoteIdentifier(conn, dbQuoteIdentifier(conn, name))[[1]]@table

in sqliteListTablesWithName(), but this should then also work with identifiers that contain a schema.

[github-actions]

This old thread has been automatically locked. If you think you have found something related to this, please open a new issue and link to this old issue if necessary.