Support "SET STATEMENT" syntax
federico-razzoli opened this issue · 3 comments
federico-razzoli commented
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
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
@renecannao Sorry, I missed it. I agree that this one is a duplicate.
renecannao commented
@federico-razzoli : no problem!
Closing #4569 as a duplicate of #3644