all values in a logical column are set to 0

[stla]

Please see https://github.com/hadley/dplyr/issues/1867

[krlmlr]

Can't replicate with the current development version of RMySQL, only with the CRAN version.

[bdforbes]

This is working in RMariaDB:

    con <- dbConnect(RMariaDB::MariaDB(), group = "my-db")
    dbWriteTable(con, "test", data.frame(a=T, b=F), overwrite = T)

Since RMySQL is being phased out, it may be time to jump to RMariaDB so that logicals can be used without always converting to integer.

[ganesan611]

Hi,

When I fetch the table values from mysql, me too facing the same issue like binary column all values marked as zero's

regards, Ganesan.K

[bdforbes]

Hi @ganesan611, the solution is to use the RMariaDB::MariaDB() connector instead.

[ganesan611]

Thank you for your immediate response. I will try what you have suggested.

[bdforbes]

You're welcome, let me know if you have any trouble. The code I posted above should indicate whether or not logicals are converting correctly for you. Make sure to change the group and test table as appropriate for your setup.