Re: Bug converting string into integer

2001-02-07 Thread Sam Wong
; 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

RE: Bug converting string into integer

2001-02-07 Thread Carsten H. Pedersen
> 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; > +

RE: Bug converting string into integer

2001-02-07 Thread The Tilghman
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