Bug #9127
Decimal values with precision over 50 can't be inserted in the persistent databases.
Status:
New
Priority:
Normal
Assignee:
-
Target version:
-
Start date:
Due date:
% Done:
0%
billable:
No
vendor_id:
GCD
case_num:
version_reported:
7156b/15122
version_resolved:
reviewer:
production:
No
env_name:
topics:
History
#2 Updated by Artur Școlnic almost 2 years ago
Values like 4000000000000000000000000000000000000000000000, with more than 40 digits, can be stored in OE persistent tables, but not in mariadb and postgresql. In 4gl, the scale of the decimal is adjusted in order not to exceed the precision of 50, in FWD the scale is fixed at 10 and the precision is 50, this means that mariadb and postgresql will append up to 10 zeros after the dot to the decimal fields, even if the final number exceeds 50 digits. A possible solution is to increase the precision of the decimal fields to 60.