Re: rounding/truncation of decimal fields

[gerald_clark]

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();
>
>
>  
>