[R-sig-DB] Problems with RMySQL and MySQL server version 5.1

[Prof Brian Ripley]

There is a long, long history of precisely this (version mismatches
in MySQL binaries cause crashes).  We had it at 4.x, so I am not
surprised to see it at 5.x now 'x' is no longer unique.

When I distributed binaries, the README on my site pointed this out:
I suggest you ask Uwe to put it in his README, and if possible do a
version check at run time.

Jeffrey Horner wrote:
> An FYI to those users having problems with windows RMySQL CRAN binaries.
> 
> -------- Original Message --------
> Subject: Problems with RMySQL and MySQL server version 5.1
> Date: Wed, 7 Jan 2009 09:12:56 +0100
> From: Erik Jørgensen <Erik.Jorgensen using agrsci.dk>
> To: jeff.horner using vanderbilt.edu
> 
> Hi Jeffrey
> 
> I have some problems with the use of RMySQL since upgrading to RMySQL
> version 0.7-2 and MySQL server version 5.1. The RGUI crashes, when I
> e.g. call the function dbGetQuery(conn, sqlstring) (but not e.g.
> dbListTables(conn)).
> 
> It seems that it is due to incompatibility with MySQL version 5.1.
> When I replace the libMySQL.dll file from version 5.1 with the 5.0
> version of the file, the problem disappears.
> 
> Best regards
> 
> Erik Jørgensen
> Faculty of Agricultural Sciences,
> Aarhus University,
> Denmark
> 
> PS. R - version 2.8.1 - Windows XP Professional Service Pack3. I
> specify the path to the DLL-file manually  via the environment
> variable  MYSQL_HOME.
> 


-- 
Brian D. Ripley,                  ripley using stats.ox.ac.uk
Professor of Applied Statistics,  http://www.stats.ox.ac.uk/~ripley/
University of Oxford,             Tel:  +44 1865 272861 (self)
1 South Parks Road,                     +44 1865 272866 (PA)
Oxford OX1 3TG, UK                Fax:  +44 1865 272595