List:General Discussion« Previous MessageNext Message »
From:Matt Loschert Date:April 11 2003 7:36pm
Subject:Re: rounding/truncation of decimal fields
View as plain text  
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          |
Thread
rounding/truncation of decimal fieldsMatt Loschert10 Apr
  • Re: rounding/truncation of decimal fieldsgerald_clark11 Apr
RE: rounding/truncation of decimal fieldsClifton R [CC] Jones11 Apr
  • Re: rounding/truncation of decimal fieldsgerald_clark11 Apr
    • Re: rounding/truncation of decimal fieldsMatt Loschert11 Apr
      • Re: rounding/truncation of decimal fieldsDoug Thompson11 Apr
        • Re: rounding/truncation of decimal fieldsMatt Loschert12 Apr
          • Re: rounding/truncation of decimal fieldsDoug Thompson12 Apr
            • More on enumMartin Gainty12 Apr
            • Re: rounding/truncation of decimal fieldsMatt Loschert13 Apr
              • Re: rounding/truncation of decimal fieldsDoug Thompson13 Apr
              • Re: rounding/truncation of decimal fieldsDan Nelson13 Apr
                • Re: rounding/truncation of decimal fieldsMatt Loschert14 Apr
Re: rounding/truncation of decimal fieldsMoon79611 Apr