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
[31 May 2024 6:03] Claudio Pereira 
Trying to create events to working as a scheduled jobs to parallel multiples execution of a procedure.
Unfortunately this feature is not working yet.

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.057 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.