From 416b483ba1af9dbef5bd0a0e71d9cfdf46af9da8 Mon Sep 17 00:00:00 2001 From: Alan Knowles Date: Thu, 16 Apr 2015 13:25:34 +0800 Subject: [PATCH] mysql/core_enum_trigger_check.sql --- mysql/core_enum_trigger_check.sql | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) diff --git a/mysql/core_enum_trigger_check.sql b/mysql/core_enum_trigger_check.sql index 5165f4f1..2dac9b48 100644 --- a/mysql/core_enum_trigger_check.sql +++ b/mysql/core_enum_trigger_check.sql @@ -7,7 +7,8 @@ CREATE PROCEDURE core_enum_trigger_check (i_etype VARCHAR(128) , i_id INT) BEGIN DECLARE v_cnt INT; SET v_cnt = 0; - SELECT count(*) INTO v_cnt FROM core_enum WHERE etype = i_etype, id = i_id; + -- should this check active??? + SELECT count(*) INTO v_cnt FROM core_enum WHERE etype = i_etype AND id = i_id; IF (v_cnt < 1) THEN UPDATE `Core Enum Does not exist` SET x = 1; END; -- 2.39.2