[R-sig-DB] crash with RMySQL
christophe dutang
dut@ngc @end|ng |rom gm@||@com
Wed Apr 8 00:02:07 CEST 2009
Hi Jeffrey,
For both the R interface and the MySQL interface, I get
AVG(mycolumnA) COUNT(mycolumnA) mycolumnB
1 0.1717 99 1
2 0.0619 226 2
3 0.0353 312 3
4 0.0867 196 4
5 0.5119 379 5
6 0.4354 379 6
7 0.1286 140 7
8 0.2898 176 8
9 0.2667 75 9
10 0.4177 79 10
11 0.6667 96 11
12 0.0000 2 12
So it works but I get the following warnings :
Warning messages:
1: In mysqlDescribeFields(res, ...) :
RS-DBI driver warning: (unknown type (246))
2: In mysqlDescribeFields(res, ...) :
RS-DBI driver warning: (unknown type (246))
I do not test RMySQL on the 'older config' with R 2.7.2
What do you think? time to announce it on CRAN?
Christophe
2009/4/7 Jeffrey Horner <jeff.horner using vanderbilt.edu>
> Hi Christophe,
>
> You can find an updated release of RMySQL 0.7-4 here:
>
> http://biostat.mc.vanderbilt.edu/RMySQL
>
> I built the binary version againts MySQL 5.1.33. Let me know if it works
> out for you. If it does, then I'll email a new package announce.
>
> Best,
>
> Jeff
>
> christophe dutang wrote on 04/07/2009 10:33 AM:
>
>> Thanks, if you've found the bug! I'll note that 'summary' is to blame!
>>
>> But I would like to know if the bug will be fixed with my old
>> configuration (R 2.7.2 version and MySQL 5.0.67, RMySQL 0.6-1, DBI 0.2-4)
>> which I use at work, while the latest config with R 2.8.1 is used at home ?
>>
>> Thanks again
>>
>> Christophe
>>
>> 2009/4/7 Jeffrey Horner <jeff.horner using vanderbilt.edu <mailto:
>> jeff.horner using vanderbilt.edu>>
>>
>>
>> christophe dutang wrote on 04/07/2009 04:35 AM:
>>
>> Hi,
>>
>> What do you want to check with mysqlClientLibraryVersions
>> outputs? the fact that RMySQL is built against the good version
>> of MySQL I used?
>>
>> When I tried to use RMySQL with a wrong version, I got a
>> warning, then I use the correct version of RMySQL from
>> http://biostat.mc.vanderbilt.edu/twiki/bin/view/Main/RMySQL
>>
>>
>> Recent RMySQL crashes on Windows involved mismatches in the compiled
>> versus the loaded client libraries.
>>
>> In your case, I've found the bug and am in the process of fixing it.
>> It involves legacy code which I don't fully understand 100% just
>> yet. In the mean time, don't call summary() as this is partly to blame.
>>
>> I expect to have a fix by the end of the day.
>>
>> Best,
>>
>> Jeff
>>
>>
>> Christophe
>>
>> 2009/4/6 Jeffrey Horner <jeff.horner using vanderbilt.edu
>> <mailto:jeff.horner using vanderbilt.edu>
>> <mailto:jeff.horner using vanderbilt.edu
>> <mailto:jeff.horner using vanderbilt.edu>>>
>>
>>
>> christophe dutang wrote on 04/05/2009 05:47 AM:
>>
>> Dear all,
>>
>> I'm using R 2.8.1 with MySQL 5.1.33, RMySQL 0.7-3 (built
>> against
>> MySQL 5.1.3 version), DBI 0.2-4 on windows XP.
>>
>>
>> Hi Christophe,
>>
>> Could you send the output of :
>>
>> library(RMySQL)
>> mysqlClientLibraryVersions()
>>
>> Thanks,
>>
>> Jeff
>> -- http://biostat.mc.vanderbilt.edu/JeffreyHorner
>>
>>
>>
>>
>> -- Christophe DUTANG
>> Ph. D. student at ISFA
>>
>>
>>
>> -- http://biostat.mc.vanderbilt.edu/JeffreyHorner
>>
>>
>>
>>
>> --
>> Christophe DUTANG
>> Ph. D. student at ISFA
>>
>
>
> --
> http://biostat.mc.vanderbilt.edu/JeffreyHorner
>
--
Christophe DUTANG
Ph. D. student at ISFA
[[alternative HTML version deleted]]
More information about the R-sig-DB
mailing list