Bug 349811

Summary:	mysql long comment bug is still unresolved in mysql-5.1.51
Product:	Gentoo Linux	Reporter:	Jeremy Huddleston Sequoia <jeremyhu>
Component:	[OLD] Server	Assignee:	Gentoo Linux bug wranglers <bug-wranglers>
Status:	RESOLVED DUPLICATE
Severity:	normal
Priority:	High
Version:	unspecified
Hardware:	All
OS:	Linux
Whiteboard:
Package list:		Runtime testing required:	---

Description Jeremy Huddleston Sequoia 2010-12-26 18:14:32 UTC

Bug #329685 is not fixed.  Creating a new bug since I lack permissions to reopen the original:


--------------
DROP PROCEDURE IF EXISTS DELETE_CUSTOM_ONE
--------------

Query OK, 0 rows affected, 1 warning

--------------
CREATE PROCEDURE DELETE_CUSTOM_ONE(
		IN tname varchar(64),
		IN tjoin varchar(64),
                IN _id bigint
                )
SQL SECURITY INVOKER
COMMENT 'Delete packet in a custom table (specified at runtime) using a prepared query'
BEGIN
        SET @l_sql = CONCAT('DELETE FROM ',@tname,' WHERE ',@tname,'.',@tfield,' = ',_id);
        PREPARE delete_stmt FROM @l_sql;
        EXECUTE delete_stmt;
        DEALLOCATE PREPARE delete_stmt;
END
--------------

ERROR 1607 (HY000) at line 862: Cannot create stored routine `DELETE_CUSTOM_ONE`. Check warnings
Bye

Comment 1 Jeroen Roovers (RETIRED) gentoo-dev

2010-12-27 17:54:58 UTC


*** This bug has been marked as a duplicate of bug 329685 ***