[R-sig-DB] [R] RMySQL Keeps crashing

[Peter Benjamin Volk]

Hi Jeff,
>
>> Hi all,
>>
>> I am working on MySQL 5.0 with RMySQL 0.7-2. All commands except for
>> Select
>> statements work. I can create tables, Truncate then etc. When I issue a
>> Select statement with dbSendQuery containing more than one column in the
>> selection then R crashes. I have been looking around but could not
>> find any
>> solution to this. Does anyone knows whats wrong?
>
> Can you send the output of sessionInfo() and also a small example that
> reproduces the crash? It would be nice to know which OS you are
> working on.
R version 2.8.0 (2008-10-20)
i386-pc-mingw32

locale:
LC_COLLATE=German_Germany.1252;LC_CTYPE=German_Germany.1252;LC_MONETARY=German_Germany.1252;LC_NUMERIC=C;LC_TIME=German_Germany.1252

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

other attached packages:
[1] MASS_7.2-44     RMySQL_0.7-2    DBI_0.2-4       lattice_0.17-17

loaded via a namespace (and not attached):
[1] grid_2.8.0


I'm Working on Windows XP with SP3. The MySQL Server resides on an
Ubuntu Server. The failure also happens when I have the server on the
same system as R.

Thanks
Peter

-- 
Dipl.-Inf. Peter Benjamin Volk
Dresden University of Technology / Database Technology Group
Visiting Address: Noethnitzer Str. 46 / D-01187 Dresden / Germany
Postal Address:  Computer Science Dept / D-01062 Dresden / Germany
Phone: 
Tue, Wed: +49-351-463-37895 / +49-351-463-38259
Mon, Thu, Fri: +49-351-4048-312