RMySQL icon indicating copy to clipboard operation
RMySQL copied to clipboard

Dot to underscore conversion in column names

Open murphyke opened this issue 10 years ago • 2 comments

In the olden days, dots in R variable names would be translated to underscores in column names. It seems that at some point, RMySQL stopped behaving this way. What are the prospects of an option to restore the previous behavior?

murphyke avatar Apr 20 '15 19:04 murphyke

Very low, because I think it's a bad idea. It's impossible to do correctly across databases because there's no predefined list of reserved words. Instead, you'll just need to quote the column names.

hadley avatar Apr 20 '15 19:04 hadley

I agree that it was not a great convention; the only argument for such an option would be the pipelines and ecosystems out there that rely on the old behavior.

murphyke avatar Apr 20 '15 20:04 murphyke