R devel - Mar 2006 - RS-DBI does not recognized MySQL decimals (PR#8723)

Full_Name: Jason Trimble
Version: 2.2.1
OS: Windows XP and RedHat EL4
Submission from: (NULL) (209.166.128.18)


Whenever a MySQL query returns a Decimal result to R I get the following warning
in R: 

Warning message:RS-DBI driver warning: (unrecognized MySQL field type 246 in
column 1)

I get this for a simple query like ?SELECT 2, 2.5? 
anything that returns a
decimal!

Application version are:
R ver 2.1.1
RMySQL ver. 0.5-7
DBI ver. 0.1-10
MySQL  Ver 14.12 Distrib 5.0.18.

This message is in MIME format.  The first part should be readable text,
  while the remaining parts are likely unreadable without MIME-aware tools.

--27464147-1125417764-1143612462=:26272
Content-Type: TEXT/PLAIN; charset=iso-8859-1; format=flowed
Content-Transfer-Encoding: 8BIT

Please read the FAQ, and report problems in contributed packages to the 
maintainer and not R-bugs, as we ask.

I suspect the problem is in RMySQL, but the maintainer is the same as for 
DBI.

On Tue, 28 Mar 2006, jtrimble at bodymedia.com wrote:
> Full_Name: Jason Trimble
> Version: 2.2.1
> OS: Windows XP and RedHat EL4
> Submission from: (NULL) (209.166.128.18)
>
>
> Whenever a MySQL query returns a Decimal result to R I get the following
warning
> in R:
>
> Warning message:RS-DBI driver warning: (unrecognized MySQL field type 246
in
> column 1)
>
> I get this for a simple query like ?SELECT 2, 2.5? 
anything that returns a
> decimal!
>
> Application version are:
> R ver 2.1.1
> RMySQL ver. 0.5-7
> DBI ver. 0.1-10
> MySQL  Ver 14.12 Distrib 5.0.18.
>
> ______________________________________________
> R-devel at r-project.org mailing list
> https://stat.ethz.ch/mailman/listinfo/r-devel
>
>
-- 
Brian D. Ripley,                  ripley at 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
--27464147-1125417764-1143612462=:26272--