sfu-db / connector-x

Fastest library to load data from DB to DataFrames in Rust and Python
https://sfu-db.github.io/connector-x
MIT License
2.02k stars 163 forks source link

MySQL ERROR 1615 (HY000): Prepared statement needs to be re-prepared #701

Open punx120 opened 3 weeks ago

punx120 commented 3 weeks ago

What language are you using?

Python

What version are you using?

0.3.3

What database are you using?

MySQL (10.3.36-MariaDB)

Example query / code

The following code fails to run:

import connectorx as cx
MYSQL_CONN_URL = 'mysql://.../db'
print(cx.read_sql(MYSQL_CONN_URL, 'select * from VIEW'))

Output is:

Traceback (most recent call last):
    result = _read_sql(
RuntimeError: MySqlError { ERROR 1615 (HY000): Prepared statement needs to be re-prepared }

It works if i use the 'text' protocol. Is there a workaround?

Thank you