ако това не е губене на данни, здраве му кажи :-))

mysql> create table test (test numeric(4,2));
Query OK, 0 rows affected (0.04 sec)

mysql> insert into test (test) values (10000000);
Query OK, 1 row affected (0.00 sec)

mysql> select * from test;
+--------+
| test |
+--------+
| 999.99 |
+--------+
1 row in set (0.00 sec)

mysql> select version();
+-----------------------------+
| version() |
+-----------------------------+
| 4.0.24_Debian-10ubuntu1-log |
+-----------------------------+
1 row in set (0.00 sec)