MySQL Bugs: #4936: DOUBLE (4,2) field record only up to 99.99

Bug #4936	DOUBLE (4,2) field record only up to 99.99
Submitted:	6 Aug 2004 20:25	Modified:	7 Aug 2004 10:18
Reporter:	Rodrigo Mourao	Email Updates:
Status:	Not a Bug	Impact on me:	None
Category:	MySQL Server: InnoDB storage engine	Severity:	S1 (Critical)
Version:	4.1.3b	OS:	Windows (Windows)
Assigned to:	Sergei Golubchik	CPU Architecture:	Any

Description:
On Windows 98/XP when I upgrade from 4.1.1a to 4.1.3b the double fields 4,2 only records up to 99.99

When I copy back the files of version 4.1.1a, the fields record normaly.

The tables are InnoDB format and I see that MySQL-front show the words fixed or dinamic in record count  of tables in new version. (In old version the total records count is ok)

I don't test with MyISAM, but I have an table in this format and its show fixed in record count with new version

I don't try to create a new table in 4.1.3b to see if this problem occour

Sorry by my poor english.
Kind Regards
Rodrigo
Brazil

How to repeat:
Install the version 4.1.3b and create a table with double 4,2 and try entry a value more than 99.99

Bug in record count of version 4.1.3b

Attachment: mysql_bug - 4.1.3b.jpg (image/pjpeg, text), 163.92 KiB.

Mysql 4.1.1a ok

Attachment: mysql_ok - 4.1.1a.jpg (image/pjpeg, text), 143.50 KiB.

I am changing to verified status because at least it is a not documented
change between versions.

I repeat the test in 4.1.2-alpha and it have the same bug

I try to recreate the table in this version but the bug is there

Thank you for taking the time to write to us, but this is not
a bug. Please double-check the documentation available at
http://www.mysql.com/documentation/ and the instructions on
how to report a bug at http://bugs.mysql.com/how-to-report.php

Additional info:

Type specification is FLOAT(M, D).
According to the

http://dev.mysql.com/doc/mysql/en/Column_types.html

  M
      Indicates the maximum display size. The maximum legal
      display size is 255. 
  D
      Applies to floating-point and fixed-point types and indicates
      the number of digits following the decimal point. The maximum
      possible value is 30, but should be no greater than M-2.

so if you have total display width 4, and 2 of them are used for digits after floating point, then, naturally, you cannot have more than 2 digis before floating point. It's the correct behaviour, as defined by the standard.

Thanks, 

Sorry by my wrong submission.
I test and all its ok.

I take the mistake because in old version its work and now I need to set the field with longer with.

Kind Regards