title: Strange ' Data truncation: Out of range value' error for Decimal column
body: <p>I have a column <code>foo</code> in a mysql table, which is of the type <code>DECIMAL (10,10)</code>.</p>
  
  <p>If I try to insert a record in it with the value of <code>foo</code> as 100.0, that produces the error ' Data truncation: Out of range value for column 'foo' at row 1`</p>
  
  <p>What am I doing wrong - doesn't <code>10,10</code> means upto 10 digits both before and after the decimal point, which should allow for this number?</p>