dbRemoveTable does not drop the table on Spark

[IoannaNika]

While testing DatabaseConnector 7 with CDMConnector on spark, I came across this issue: dbRemoveTable() does not drop the table.

The two statements here https://github.com/OHDSI/DatabaseConnector/blob/main/R/DBI.R#L695 need to be split and to be executed separately. Otherwise, from my understanding, only the first command is executed hence the table is not dropped.

[schuemie]

Thanks! Should be fixed now (in the version_7 branch)

[IoannaNika]

Thank you, it works!