I think I found a bug: lazarus-3.4-fpc-3.2.2-win64 When inserting into a Firebird database

Summary

When I insert data into the Firebird database, the data is entered incorrectly. The problem occurs when the number is greater than 9223372 (Win64). It also works perfectly when compiled in Win32 Lazarus. INSERT INTO TABLE01 (FIELD01) VALUES (9500000.0004) running it works perfectly.

System Information

  • Operating system: Win10 22H2 Hungarian x64, Win11 23H2 EnglishInternational x64v2
  • Firebird: 2.5, 4.0.5, 5.0.1
  • Processor architecture: x64
  • Compiler version: Lazarus 3.4 (rev lazarus_3_4) FPC 3.2.2 x86_64-win64-win32/win64
  • Device: Computer

Steps to reproduce

I am attaching the test, Firebird 2.5 (embedded)

Example Project

test.7z

What is the current bug behavior?

The data is entered incorrectly.

What is the expected (correct) behavior?

Relevant logs and/or screenshots

bug

Possible fixes

Edited by Attila Fehér