Bug Description
Executing MySQL routine DDL through the MCP can fail because the built-in MySQL driver sends non-result statements through the prepared statement protocol.
Reported error:
error returned from database: 1295 (HY000): This command is not supported in the prepared statement protocol yet
DROP PROCEDURE IF EXISTS sociedades_close;
Steps to Reproduce
- Configure a MySQL connection in Tabularis.
- Execute through the MCP:
DROP PROCEDURE IF EXISTS sociedades_close;
- Observe MySQL error 1295 from the prepared statement protocol.
Expected Behavior
Routine DDL such as DROP/CREATE/ALTER PROCEDURE and FUNCTION should execute successfully when MySQL requires text protocol.
Actual Behavior
The statement is routed through the prepared statement protocol and MySQL rejects it with error 1295.
Scope
- MySQL driver only.
- MCP benefits automatically because it uses the normal driver execute_query path.
Verification
Focused classifier tests pass with:
cargo test text_protocol --lib
Bug Description
Executing MySQL routine DDL through the MCP can fail because the built-in MySQL driver sends non-result statements through the prepared statement protocol.
Reported error:
Steps to Reproduce
Expected Behavior
Routine DDL such as DROP/CREATE/ALTER PROCEDURE and FUNCTION should execute successfully when MySQL requires text protocol.
Actual Behavior
The statement is routed through the prepared statement protocol and MySQL rejects it with error 1295.
Scope
Verification
Focused classifier tests pass with:
cargo test text_protocol --lib