[R-sig-DB] crash with RMySQL

[christophe dutang]

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]]