Bug #31625 PREPARED STATEMENT syntax does not allow to create TRIGGERS
Submitted: 16 Oct 2007 2:06 Modified: 16 Oct 2007 10:57
Reporter: Dennis Birkholz Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: Prepared statements Severity:S4 (Feature request)
Version:5.0.44 OS:Linux (Gentoo Linux)
Assigned to: CPU Architecture:Any
Tags: prepared statements, triggers

[16 Oct 2007 2:06] Dennis Birkholz
Description:
A trigger cannot be created with a prepared statement (from within a stored procedure). An error of type:
ERROR 1295 (HY000): This command is not supported in the prepared statement protocol yet
is given instead

How to repeat:
SET @myQuery = 'CREATE DEFINER = CURRENT_USER TRIGGER ...';  INTO @lastQuery;
PREPARE myQuery FROM @myQuery;
EXECUTE myQuery;
DROP PREPARE myQuery;

Suggested fix:
Implement create trigger support in prepared statement syntax.
[16 Oct 2007 10:57] Sveta Smirnova
Thank you for the reasonable feature request.
[9 Dec 2008 19:07] João Vitor Paes de Barros do Carmo
Waiting for this fix/feature too...
[31 Dec 2009 15:16] Scott Mankowitz
Sure. Me too.
[10 Mar 2017 0:19] michael plavins
The worklog URL from 7 years ago is now: 
https://dev.mysql.com/worklog/task/?id=2871