Unit test warnings / silent writeToTable failure

[katy-sadowski]

Error in testthat tests:

Writing table failed: Columns `cdm_field_name`, `concept_id`, `unit_concept_id`, `subcategory`, `warning`, `error`, `not_applicable_reason`, `notes_value` not found

This is strange, as these columns are definitely included in the DDL. We need to investigate what's going on.

This was silently failing in our unit tests because the write to table step is wrapped in a try/catch. So the unit test should also be updated to expect no logged error.

[katy-sadowski]

We're also getting this warning on write to table tests; should look into this as well: Column 'warning' is of type 'logical', but this is not supported by many DBMSs. Converting to numeric (1 = TRUE, 0 = FALSE)

[katy-sadowski]

Write to table failure was occurring because test files are run in parallel, and we were getting collisions between different tests using the same results DB table. Fixed this in #502. Still TODO:

• Don't let writeToTable fail silently (should at the very least throw a warning)
• Fix logical type warning mentioned in comment above