Repository navigation
Loss of scale when reading numeric with zero value #53
Description
Hello!
When reading a numeric column with zero value the scale of the numeric value is not preserved:
import firebird.driver as firebird
import decimal
con = firebird.connect('employee')
cur = con.cursor()
cur.execute("select cast('0.00' as NUMERIC(9,2)) from rdb$database")
val_from_db = cur.fetchone()[0]
val_from_py = decimal.Decimal('0.00')
val_from_db_str = format(val_from_db, 'f')
val_from_py_str = format(val_from_py, 'f')
print(val_from_db_str)
print(val_from_py_str)
assert val_from_db_str == val_from_py_str
cur.close()
con.close()Output:
0
0.00
Traceback (most recent call last):
File "/home/qweqq/test3.py", line 17, in <module>
assert val_from_db_str == val_from_py_str
While investigating the issue I found that a python decimal.Decimal with zero value divided by anything does not change its scale:
import decimal
print(format(decimal.Decimal('0') / 1000, 'f'))Output:
0
but if the zero value is scaled using the builtin scaleb method it works:
import decimal
print(format(decimal.Decimal('0').scaleb(-3), 'f'))Output:
0.000
Regards,
Activity
fix FirebirdSQL#53 Loss of scale when reading numeric with zero value
fix FirebirdSQL#53 Loss of scale when reading numeric with zero value
Merge pull request #54 from qweqq/patch-2
pcisar commentedon Jul 26, 2025
@qweqq Thanks