-
Type:
Bug
-
Status: Closed (View Workflow)
-
Priority:
Blocker
-
Resolution: Not a Bug
-
Affects Version/s: 1.0.4
-
Fix Version/s: N/A
-
Component/s: DBAPI 2.0
-
Labels:None
-
Environment:MariaDB 10.5.7
When I try to get system tables with this sample:
db_connection = db_connector.connect(....) |
db_cursor = db_connection.cursor(prepared=True) |
db_cursor.execute("select version()") |
server_version = Version(db_cursor.fetchone()[0]) |
db_cursor.execute("SHOW VARIABLES like 'have_ssl'") |
have_ssl = str2bool(db_cursor.fetchone()[1], raise_exc=True) |
query = "select TABLE_NAME from information_schema.tables where TABLE_SCHEMA=%s and TABLE_NAME=%s" |
try: |
db_cursor.execute(query, ("mysql", "global_priv")) |
If fails with:
Commands out of sync; you can't run this command now
Using the same code with the MySQL python connector will work.