R Crashes with dbWriteTable() + odbc + MariaDB ODBC 3.0.5 (¿Stable?) Connector

[jtelleria]

Issue Description and Expected Result

When writing a POSIXct data.frame() column to a database through odbc::dbWriteTable() and using MariaDB ODBC Connector 3.0.5 (¿Stable?) the R Session Crashes.

Probably it is MariaDB ODBC Connector's fault, as it is so buggy :S

I'll report on MariaDB's JIRA also:
https://jira.mariadb.org/projects/MDEV/issues/MDEV-16471?filter=allopenissues

Database

MariaDB 10.2.7 + MariaDB ODBC Connector 3.05

With MySQL ODBC Connector 8.0.11 works perfectly.

Reproducible Example

library(odbc)

con <- odbc::dbConnect(
  drv = odbc::odbc(), 
  dsn = "MariaDB_ODBC_Tornado24",
  database = "eo_mariadb"
)

t_failure <- data.frame(
  Posixct_failure = c(as.POSIXct("2018-05-02"), as.POSIXct("2018-06-03"))
)

dbWriteTable(
  conn = con,
  name = "t_failure",
  value = t_failure,
  overwrite = TRUE,
  append = FALSE
)

sessionInfo()
R version 3.4.4 (2018-03-15)
Platform: x86_64-w64-mingw32/x64 (64-bit)
Running under: Windows >= 8 x64 (build 9200)

Matrix products: default

locale:
[1] LC_COLLATE=Spanish_Spain.1252  LC_CTYPE=Spanish_Spain.1252    LC_MONETARY=Spanish_Spain.1252
[4] LC_NUMERIC=C                   LC_TIME=Spanish_Spain.1252    

attached base packages:
[1] stats     graphics  grDevices utils     datasets  methods   base     

other attached packages:
[1] RevoUtils_10.0.9     RevoUtilsMath_10.0.1

loaded via a namespace (and not attached):
[1] compiler_3.4.4 tools_3.4.4    yaml_2.1.19   

MariaDB JIRA Issue

https://jira.mariadb.org/browse/ODBC-149

[jtelleria]

Fixed by MariaDB Team with ODBC Connector 3.0.6

Now works perfectly, and data transfer is faster than ever! :)