Unable to parse query because of SET character_set_connection=utf8mb4

[resworld]

Hi all,

we have upgraded our proxysql to latest (2.5.5) version that comes as stable from the percona's repositories and facing an issue with queries that are having some SET parameters in the beginning. We didn't have that issue in previous version of the ProxySQL.

2023-11-10 12:34:51 MySQL_Session.cpp:6590:handler___status_WAITING_CLIENT_DATA___STATE_SLEEP___MYSQL_COM_QUERY_qpo(): [ERROR] Unable to parse query. If correct, report it as a bug: SET character_set_connection=utf8mb4, character_set_client=utf8mb4, sql_mode = "NO_UNSIGNED_SUBTRACTION";

As you can see, there's spaces between set params in the query, as it is required. I've tried to add following settings in order to solve this issue, but the problem still exists:

mysql-multiplexing = false
mysql-set_parser_algorithm = 2

The ProxySQL version is:
proxysql2-2.5.5-1.1.el9.x86_64

Can you please advice us what we can do in order to have this solved?

[duronrulez]

remove the trailing ; and it will work fine

[resworld]

Thank you for suggestion. It works now!

[renecannao]

Re-opening . It is a bug

[renecannao]

Closed by #4385