search

sysown / proxysql

High-performance MySQL proxy with a GPL license.
http://www.proxysql.com
GNU General Public License v3.0
6.05k stars 983 forks source link

Support "SET STATEMENT" syntax #4569

Closed federico-razzoli closed 5 months ago

federico-razzoli commented 5 months ago

A customer reported this warning:

2024-06-18 17:28:21 MySQL_Session.cpp:8392:unable_to_parse_set_statement(): [WARNING] Unable to parse unknown SET query from client 192.168.0.1:50312. Setting lock_hostgroup. Please report a bug for future enhancements:SET STATEMENT SQL_SELECT_LIMIT=10 FOR SELECT  ...

The SET STATEMENT ... SELECT syntax is MariaDB specific. It should be supported with no warnings. It has no effect on the following queries, so it doesn't require any special action from ProxySQL.

renecannao commented 5 months ago

Ciao @federico-razzoli . Thank you for the report. This should be a duplicate of #3644 . If you agree I will close this one.

Thanks

federico-razzoli commented 5 months ago

@renecannao Sorry, I missed it. I agree that this one is a duplicate.

renecannao commented 5 months ago

@federico-razzoli : no problem! Closing #4569 as a duplicate of #3644