Bug #28038 Falcon Large DECIMAL values stored incorrectly
Submitted: 23 Apr 2007 19:43
Reporter: Hakan Küçükyılmaz Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Falcon storage engine Severity:S3 (Non-critical)
Version: OS:Any
Assigned to: CPU Architecture:Any

[23 Apr 2007 19:43] Hakan Küçükyılmaz 
Description:
If I have a DECIMAL(20) column with MyISAM, I can store a 20-digit number.
If I have a DECIMAL(20) column with JStar, I can't.

How to repeat:
mysql> create table tj5 (s1 decimal(20)) engine = falcon;
Query OK, 0 rows affected (0.01 sec)

mysql> insert into tj5 values (12345678901234567890);
Query OK, 1 row affected (0.01 sec)

mysql> select * from tj5;
+----------------------+
| s1 |
+----------------------+
| -6806097876350287150 |
+----------------------+
1 row in set (0.00 sec)
[23 Apr 2007 19:43] Hakan Küçükyılmaz 
Test case is falcon_bug_28038.test.