[R-sig-DB] RMySQL crashes R?

[Ian Coe]

Hi,
  I'm running R 2.9x, MySQL 5.1x, and RMySQL 0.74x. I'm noticing that if
I try to import more than 1 column of data using RMySQL R crashes.  I
suspect it could be due to the warnings I got about RMySQL being
compiled under a different version of mysql than I am using.   Does
anyone have a work around for this?  

More specifically...

This works:
data=dbGetQuery(con,statement="select price from prices")

This crashes R
data=dbGetQuery(con,statement="select price, item from prices")

Thanks,
Ian