ProxySQL is passing semicolon to database when doing SET NAMES

[bpatel-dt]

We are running ProxySQL version 1.3.7-0-gadcc2c7, codename Truls and while doing tests, we noticed that we have a query for SET NAMES from php as..

$this->getDb('sql2')->query('SET NAMES utf8;');

ProxySQL is passing semicolon to DB and from DB we get error...
SQLSTATE[#4200]: <>: 1115 Unknown character set: 'utf8;'

Please note the semicolon in the character set name. The code works if we connect directly to the database, but breaks if we go through ProxySQL...

Shouldn't the semicolon be trimmed?

Thanks

[renecannao]

Semicolon should be trimmed, that's right.

Meanwhile, you can simply remove the semicolon from the PHP code.

Thanks

[renecannao]

Fixed in 1.4.1 and 1.3.8 (both not released yet).
Thanks