Parse error on MariaDB Connector ODBC session_track_system_variables

[lastmikoi]

Issue

When ProxySQL serves requests coming from a MariaDB Connector ODBC-powered client, ProxySQL is unable to parse a SET instructions related to session tracking even though ProxySQL forwards such capability in the "Server Greeting".

ProxySQL Version

2.5.5

OS Version

Debian 12.2 (codename Bookworm)

Reproduction steps

• Install unixodbc
• Install MariaDB Connector ODBC
• Configure both the driver and a MariaDB datasource pointing to a ProxySQL instance
• Run isql -v MariaDB-server (where MariaDB-server is the name of the previously configured datasource)

Error log

When running MariaDB ODBC Connector 3.2.2:

2024-07-12 16:46:32 MySQL_Session.cpp:6574:handler___status_WAITING_CLIENT_DATA___STATE_SLEEP___MYSQL_COM_QUERY_qpo(): [ERROR] Unable to parse query. If correct, report it as a bug: SET session_track_schema=1,session_track_system_variables='auto_increment_increment,tx_isolation'

When running MariaDB ODBC Connector 3.1.20:

2024-07-12 16:49:03 MySQL_Session.cpp:6574:handler___status_WAITING_CLIENT_DATA___STATE_SLEEP___MYSQL_COM_QUERY_qpo(): [ERROR] Unable to parse query. If correct, report it as a bug: SET session_track_schema=1,session_track_system_variables='autocommit,tx_isolation'

When running MariaDB ODBC Connector 3.1.19, 3.1.18:

2024-07-12 16:50:41 MySQL_Session.cpp:7938:unable_to_parse_set_statement(): [WARNING] Unable to parse unknown SET query from client REDACTED:42484. Setting lock_hostgroup. Please report a bug for future enhancements:SET session_track_system_variables='autocommit,tx_isolation'