MariaDB MY SQL Column Type Mapping

[sssaha]

What language are you using?

Python.

What version are you using?

0.4.3

What database are you using?

MariaDB

What dataframe are you using?

Pandas

Can you describe your bug?

MariaDB BIGINT gets converted to Float64

What are the steps to reproduce the behavior?

---

Database setup if the error only happens on specific data or data type

Example query / code

base_df = cx.read_sql(fr"mysql://{database_config.USERNAME}:{database_config.PASSWORD}@{database_config.SERVER}:{database_config.PORT}/{database_config.DATABASE}",
                         f'Select * from {database_config.TABLE}')

What is the error?

See the mapping of the BIGINT to float64