connector-x icon indicating copy to clipboard operation
connector-x copied to clipboard

MySql tinyint gets converted to a boolean

Open synapticarbors opened this issue 7 months ago • 1 comments

This seems like a bug to me, but the MySQL tinyint type gets converted to a boolean value here: https://github.com/sfu-db/connector-x/blob/main/connectorx/src/transports/mysql_arrow.rs#L44

This change was made in https://github.com/sfu-db/connector-x/commit/2570c4c74a139566df301f0457f014663081cbf7

Looking at the mysql documentation, a tinyint ranges from -128 to 127 for the signed version and 0 to 255 for the unsigned one. So it would seem like this should be mapped as a i8 at a minimum.

synapticarbors avatar Mar 17 '25 16:03 synapticarbors