SqlDecimal raises RuntimeError for numbers less than or equal to 1e-5 independent of the scale specified

[dfox-rms]

Hi, I am having receiving an error when converting Python floats to SqlDecimal.

Here is a minimal example:

import ctds
afloat = 1e-4
# runs successfully
result = ctds.SqlDecimal(afloat, 38, 0)

bfloat = 1e-5
# raises "RuntimeError: failed to convert '1e-05'"
try:
    result = ctds.SqlDecimal(bfloat, 38, 0)
except RuntimeError as e:
    print(e)

cfloat = 1e-5
# raises "RuntimeError: failed to convert '1e-05'"
try:
    result = ctds.SqlDecimal(cfloat, 38, 8)
except RuntimeError as e:
    print(e)

My setup:
MacOS BigSur
Version 11.7
Python 3.10.9
Working in a Conda Environment
Name Version Build Channel
ctds 1.14.0 py310h90acd4f_3 conda-forge
Result of running $ tsql -C:
Compile-time settings (established with the "configure" script)
Version: freetds v1.1.15
freetds.conf directory: /Users/.../miniconda3/envs/.../etc
MS db-lib source compatibility: no
Sybase binary compatibility: no
Thread safety: yes
iconv library: yes
TDS version: auto
iODBC: no
unixodbc: yes
SSPI "trusted" logins: no
Kerberos: no
OpenSSL: yes
GnuTLS: no
MARS: yes

Thanks for any assistance you can provide. CTDS has been a great help on previous projects, so thanks!