Bug 117948 – After upgrading to MySQL 5, dev-db/mysql-python returns the wrong types for DECIMAL fields

• Status: RESOLVED FIXED
• Product: Gentoo Linux

[Description Lee Packham 2006-01-05 14:54:42 UTC]

MySQLdb doesn't recognise the new DECIMAL field type correctly and returns strings to Python when doing things like SUM().

This has the effect of code that doesn't cast the output from a cursor and then uses the output to compare will throw an exception.

Fixed ebuild (tar.gz'd for people to use in overlays) will be attached.

[Comment 1 Lee Packham 2006-01-05 14:55:11 UTC]

Created attachment 76278 [details]
Overlay ebuild (for portage overlay) that fixes the problem

[Comment 2 Jakub Moc (RETIRED) 2006-01-05 15:06:10 UTC]

Please, attach a plaintext patch. Thanks.

[Comment 3 Lee Packham 2006-01-05 15:36:15 UTC]

Created attachment 76285 [details, diff]
Patch for MySQLdb 1.2.0 to work with MySQL 5

[Comment 4 Alastair Tse (RETIRED) 2006-02-06 14:07:01 UTC]

thanks for the patch. added to mysql-python-1.2.0-r1.