diff options
| author | Eric Leblond <eric@inl.fr> | 2010-09-22 00:37:20 +0200 |
|---|---|---|
| committer | Eric Leblond <eric@inl.fr> | 2010-09-22 00:40:16 +0200 |
| commit | e17f700190b31a94214bf062a01ef31abafc38b9 (patch) | |
| tree | 8e8f5e441984defcf1986008968bfeeaa2164ef7 /doc | |
| parent | 9dbbe09f03d018351df9d99590a9fc0f00678ae6 (diff) | |
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.
Diffstat (limited to 'doc')
| -rw-r--r-- | doc/mysql-ulogd2.sql | 4 |
1 files changed, 2 insertions, 2 deletions
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; |