[R-sig-DB] crash with RMySQL
Jeffrey Horner
je||@horner @end|ng |rom v@nderb||t@edu
Wed Apr 8 00:08:27 CEST 2009
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
More information about the R-sig-DB
mailing list