The overwrite_table_missing test case (and others) writes the iris dataset, where the Species column is a factor to the database, then reads it back and checks for equality. However, it is not clear how dbWriteTable should preserve factors, for which no equivalent SQL type exists. Suggest to make this less brittle by converting Species column to a string beforehand.
The overwrite_table_missing test case (and others) writes the iris dataset, where the Species column is a factor to the database, then reads it back and checks for equality. However, it is not clear how dbWriteTable should preserve factors, for which no equivalent SQL type exists. Suggest to make this less brittle by converting Species column to a string beforehand.