[CONPY-62] Decimal values returned as strings when passing in paramaters Created: 2020-05-05  Updated: 2020-05-05  Resolved: 2020-05-05

Status: Closed
Project: MariaDB Connector/Python
Component/s: DBAPI 2.0
Affects Version/s: None
Fix Version/s: 0.9.58

Type: Bug Priority: Major
Reporter: Rob Hedgpeth (Inactive) Assignee: Georg Richter
Resolution: Fixed Votes: 0
Labels: None


 Description   

Passing in parameters causes decimals to be returned as strings.

conn = mariadb.connect(**config)
cur = conn.cursor()
query = "select round(.75 * (? / 3), 2) as val"
cur.execute(query,[5])
print(result)

  1. returns ('1.25',)

conn = mariadb.connect(**config)
cur = conn.cursor()
query = "select round(.75 * (6 / 3), 2) as val"
cur.execute(query)
print(result)

  1. returns (Decimal('1.50'),)


 Comments   
Comment by Georg Richter [ 2020-05-05 ]

Fixed in rev. 87684a1fdbffd5207cabc288f67be4ac289b65fb

Generated at Thu Feb 08 03:29:57 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.