From e17f700190b31a94214bf062a01ef31abafc38b9 Mon Sep 17 00:00:00 2001 From: Eric Leblond Date: Wed, 22 Sep 2010 00:37:20 +0200 Subject: Mysql schema: fix procedure declaration It seems that some version of MySQL were more delicate about comment in procedure. THis patch fixes a problem with a procedure comment and fix the inner code which was not using the correct variable. --- doc/mysql-ulogd2.sql | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) (limited to 'doc') diff --git a/doc/mysql-ulogd2.sql b/doc/mysql-ulogd2.sql index 906dce2..c8edd4f 100644 --- a/doc/mysql-ulogd2.sql +++ b/doc/mysql-ulogd2.sql @@ -875,9 +875,9 @@ CREATE PROCEDURE DELETE_CUSTOM_ONE( IN _id bigint ) SQL SECURITY INVOKER -COMMENT 'Delete packet in a custom table (specified at runtime) using a prepared query' +COMMENT 'Delete packet in a custom table (specified at runtime)' BEGIN - SET @l_sql = CONCAT('DELETE FROM ',@tname,' WHERE ',@tname,'.',@tfield,' = ',_id); + SET @l_sql = CONCAT('DELETE FROM ',@tname,' WHERE ',@tname,'.',@tjoin,' = ',_id); PREPARE delete_stmt FROM @l_sql; EXECUTE delete_stmt; DEALLOCATE PREPARE delete_stmt; -- cgit v1.2.3