;
Sent: Thursday, February 08, 2001 1:15 AM
Subject: RE: Bug converting string into integer
> > In a SELECT I have to convert a string into a number.
> >
> > I used to use something like 'string'+0, where 'string' is a string
> > rapresentation of a
> In a SELECT I have to convert a string into a number.
>
> I used to use something like 'string'+0, where 'string' is a string
> rapresentation of an integer.
>
> Now I noticed that in many cases it returns a rounded floating point!!!
>
> For example:
>
> mysql> select '11'+0;
> +
It's a bug either in your processor or in your distribution
libraries. Your SELECT returns correctly on my Linux and FreeBSD
servers.
-Tilghman
--
"There cannot be a crisis today. My schedule is already full."
--Henry Kissinger
> -Original Message-
> From: Federico Giannici [mai