Exactly the point. I am not saying it is wrong. I am just wondering if
it is supposed to operate this way. I would assume (possibly incorrectly)
that a number supplied as a string would be transformed to numerical form
by MySQL, then inserted into the database (and consequently rounded or
truncated, I don't care which, I just want consistency) as is done when
you insert a number as a number.
On Fri, 11 Apr 2003, gerald_clark wrote:
> Well, in one case he supplied a string, not a number.
> It most likely was promoted to a float before is was saved.
>
> Jones, Clifton R [CC] wrote:
>
> >No, I think he was surprised to find mySQL rounded two identical values
> >*differently*.. please read his posting for the results....
> >
> >
> >
> >
> >>-----Original Message-----
> >>From: gerald_clark [mailto:gerald_clark@stripped]
> >>Sent: Friday, April 11, 2003 9:33 AM
> >>To: Matt Loschert
> >>Cc: mysql@stripped
> >>Subject: Re: rounding/truncation of decimal fields
> >>
> >>
> >>Why do you find this surprising?
> >>You defined the field to have 2 deciimal places..
> >>
> >>Matt Loschert wrote:
> >>
> >>
> >>
> >>>I have quick question about rounding and/or truncation of a
> >>>
> >>>
> >>decimal table
> >>
> >>
> >>>field. I ran into this unexpectedly and found it surprising.
> >>>
> >>>Given the following input:
> >>>
> >>>
> >>> DROP TABLE IF EXISTS test1;
> >>> CREATE TABLE test1 (id tinyint, truncated decimal(12,2));
> >>> INSERT INTO test1 VALUES (1, '0.004');
> >>> INSERT INTO test1 VALUES (2, 0.004 );
> >>> INSERT INTO test1 VALUES (3, '0.005');
> >>> INSERT INTO test1 VALUES (4, 0.005 );
> >>> SELECT * FROM test1;
> >>> SELECT VERSION();
- Matt
--
Matt Loschert - Software Engineer | email: loschert@stripped |
ServInt Internet Services | web: http://www.servint.net/ |
McLean, Virginia USA | phone: (703) 847-1381 |
