Can not support to connect apache doris or starrocks through mysql protocol

[ulnit]

What language are you using?

ROAPI

What version are you using?

Replace this text with the version.

What database are you using?

Apache Doris

What dataframe are you using?

Arrow

What is the error?

WARN connectorx::sources::mysql] mysql text prepared statement error: MySqlError { ERROR 1064 (HY000): Unsupported command(COM_STMT_PREPARE) }, switch to limit1 method Error: Database error: MySqlError { ERROR 1064 (HY000): Unsupported command(COM_STMT_PREPARE) }

[l1xnan]

I had the same problem, it should occur during the prepared phase: https://github.com/sfu-db/connector-x/blob/7b3147436b7e20b96691348143d605e2249d6119/connectorx/src/sources/mysql/mod.rs#L101

It might have something to do with it: https://github.com/StarRocks/starrocks/pull/41080