Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
None
-
None
Description
We are testing out utilizing the MariaDB python connector and have noticed a difference in how things seem to be converted. We have a lot of processes that return the value as a decimal, and from that point we do comparisons on them. When running the MariaDB python connector, these seem to be converted into a string when returned from the database, this causing issues in the direct comparisons.
MariaDB Connector return with decimal values, shown as a string:
[['27', 53549, '0.0005', '0.9995']]
Other connectors:
[[Decimal('27'), 53549, Decimal('0.0005'), Decimal('0.9995')]]
Attachments
Activity
| Field | Original Value | New Value |
|---|---|---|
| Fix Version/s | 0.9.56 [ 24303 ] |
| Status | Open [ 1 ] | Confirmed [ 10101 ] |
Even if it is a double it could be returned as such. Just probably not returned as a string as it is.
| issue.field.resolutiondate | 2020-04-05 20:04:29.0 | 2020-04-05 20:04:29.361 |
| Component/s | Generic [ 14515 ] | |
| Resolution | Fixed [ 1 ] | |
| Status | Confirmed [ 10101 ] | Closed [ 6 ] |
| Workflow | MariaDB v3 [ 106681 ] | MariaDB v4 [ 135624 ] |
Decimal is a non standard type and requires import of the decimal module. Decimal also needs to be supported when passing parameters to execute() and executemany().