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

MySQL ULongLong should be treated as integer

Open skbly7 opened this issue 7 months ago • 0 comments

What language are you using?

Python

What version are you using?

0.3.3

What database are you using?

MySQL

What dataframe are you using?

Arrow

Can you describe your bug?

MySQL ULongLong is treated as Float in conversion instead of LongLong.

This seem to be coming from here: https://github.com/sfu-db/connector-x/blob/main/connectorx/src/transports/mysql_arrow.rs#L48-L53

        { LongLong[i64]              => Int64[i64]              | conversion auto }
        { UTiny[u8]                  => Int64[i64]              | conversion auto }
        { UShort[u16]                => Int64[i64]              | conversion auto }
        { ULong[u32]                 => Int64[i64]              | conversion auto }
        { UInt24[u32]                => Int64[i64]              | conversion none }
        { ULongLong[u64]             => Float64[f64]            | conversion auto }  <--- 

Note: LongLong is already treated as Int64.

skbly7 avatar Jul 13 '24 08:07 skbly7