[R-sig-DB] crash with RMySQL

[Jeffrey Horner]

christophe dutang wrote on 04/07/2009 05:02 PM:
> 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))

Yes, that's what was supposed to happen had not the bug been there. 
Essentially RMySQL doesn't know about the new MySQL types, so I wanted 
the warning code to work, which it does. Particularly, AVG() is 
returning something called MYSQL_TYPE_NEWDECIMAL.

I want to make sure I understand more about RMySQL and different MySQL 
versions before I start changing large swathes of code to include 
support for new types.

Thanks for your help.

> 
> I do not test RMySQL on the 'older config' with R 2.7.2
> 
> What do you think? time to announce it on CRAN?

I think so. Probably tomorrow.

Jeff


> Christophe
> 
> 2009/4/7 Jeffrey Horner <jeff.horner using vanderbilt.edu 
> <mailto: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>
>         <mailto: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>>
>                <mailto: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


-- 
http://biostat.mc.vanderbilt.edu/JeffreyHorner