Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Fixed
-
1.1.2
-
None
-
mariadb-connector-c was upgraded from 3.1.13 to 3.2.7, Fedora linux mariadb server 10.5 and 10.6
-
3.10
Description
query containing non-ascii characters fails as of 1.1.2, no issues previously, works with other DB libraries, replace `col_Unitéble_id_seq` with an all ascii name and no issue
import mariadb
|
|
|
conn = mariadb.connect(
|
user="scott", password="tiger", host="localhost", db="test",
|
)
|
|
|
cursor = conn.cursor()
|
|
cursor.execute(
|
f"SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE "
|
f"TABLE_TYPE='SEQUENCE' and TABLE_NAME=? and TABLE_SCHEMA=?",
|
("col_Unitéble_id_seq", "foobar")
|
)
|
|
cursor.close()
|
|
conn.close()
|
|
|
output:
Traceback (most recent call last):
|
File "/home/classic/dev/sqlalchemy/test3.py", line 11, in <module>
|
cursor.execute(
|
File "/home/classic/.venv3/lib/python3.10/site-packages/mariadb/cursors.py", line 293, in execute
|
self._readresponse()
|
mariadb.ProgrammingError: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '"foobar"?' at line 1
|
|