Heavy Error in Firebird-DB with Numeric / Decimal Fields - value is multiplied with 10000 insert and update
Original Reporter info from Mantis: griebold
-
Reporter name: Gernot Riebold
Original Reporter info from Mantis: griebold
- Reporter name: Gernot Riebold
Description:
Firebird-DB Version 2.5.5 /UTF8 has a Numeric(10,2) and / or a Decimal(10,2) Field.
Insert and update multiplies numeric and decimal value with 10000. This happens until values are too big to store in the DB.
Problem happens reproducable with Lazarus 1.6. Works with Lazarus 1.4.
Steps to reproduce:
Firebird-DB with a Numeric(10,2) and / or a Decimal(10,2) Field. Create a small project with 1 IBConnection, SqlTransaction, SQLLibraryLoader, Query, DataSource, DB-Navigator, DBGrid.
Insert / Update the Numeric and / or Decimal Field. In the DB value is inserted / updated multiplied with 10000.
Problem only with Lazarus 1.6
Additional information:
Attached you find a Lazarus project with a readme.txt and a PDF with 4 screenshots to reproduce the problem.
Please change the credentials (Hostname, Database Path) for the DB in unit1 - procedure TForm1.FormCreate.
I use Numeric for amount fields.
Mantis conversion info:
- Mantis ID: 29760
- OS: Windows 10
- OS Build: 10 x64
- Build: Lazarus 1.6
- Platform: Windows
- Version: 3.0.0
- Fixed in version: 3.1.1
- Fixed in revision: 32054 (#9431648b)
- Monitored by: » griebold (Gernot Riebold)