SHOW WARNINGS with inline comments incorrectly sets warning_count #5306
Description
When using DBIx::Sunny (a Perl database interface),
SHOW WARNINGS queries are sent with inline comments like:
SHOW /* example.pl line 10 */ WARNINGSThis causes ProxySQL to incorrectly return warning_count in the EOF packet, because the current logic
doesn't strip comments before checking the query.
proxysql/lib/mysql_connection.cpp
Line 1828 in 2637d28
Proposed fix: Use digest_text (which has comments stripped) instead of raw query, similar to the existing pattern at:
proxysql/lib/mysql_connection.cpp
Line 600 in 2637d28
I have already prepared a fix for this issue and plan to submit a pull request soon.
I'm relatively new to this codebase, so please let me know if I've misunderstood anything.