Support MYSQL_TYPE_BIT in MySQL

[Yanhuanjin]

What language are you using?

Python

What version are you using?

0.3.0

What database are you using?

MySQL

What dataframe are you using?

Pandas

Can you describe your bug?

When the queried database field was bit, an error was reported.

Example query / code

I create a table and the data looks like bellow.

When I queried this table, error occuried.

df = cx.read_sql(conn, "SELECT * FROM test;")

What is the error?

PanicException Traceback (most recent call last) in ----> 1 df = cx.read_sql(conn, sql_list)

C:\ProgramData\Anaconda3\lib\site-packages\connectorx_init_.py in read_sql(conn, query, return_type, protocol, partition_on, partition_range, partition_num, index_col) 222 raise ValueError("You need to install pandas first") 223 --> 224 result = _read_sql( 225 conn, 226 "pandas",

PanicException: not implemented: MYSQL_TYPE_BIT

[wangxiaoying]

BIT type is not supported in mysql yet: https://sfu-db.github.io/connector-x/databases/mysql.html

[florianlaws]

I would also appreciate this being suported.

[cmartin1968]

Support for MYSQL BIT type would be helpful for me as well.