From de0ba5c894df8f86512d025f4196d62687efb1bb Mon Sep 17 00:00:00 2001
From: unknown <igor@olga.mysql.com>
Date: Sun, 1 Jul 2007 11:00:29 -0700
Subject: Corrected a test case.
---
mysql-test/r/events_bugs.result | 8 +++++---
1 file changed, 5 insertions(+), 3 deletions(-)
(limited to 'mysql-test/r/events_bugs.result')
diff --git a/mysql-test/r/events_bugs.result b/mysql-test/r/events_bugs.result
index c90b3a458ff..5de0b841a03 100644
--- a/mysql-test/r/events_bugs.result
+++ b/mysql-test/r/events_bugs.result
@@ -571,11 +571,11 @@ CREATE USER evtest1@localhost;
SET PASSWORD FOR evtest1@localhost = password('ev1');
REVOKE ALL PRIVILEGES, GRANT OPTION FROM evtest1@localhost;
GRANT create, insert, select, event ON events_test.* TO evtest1@localhost;
-GRANT select,insert ON TEST.* TO evtest1@localhost;
+GRANT select,insert ON test.* TO evtest1@localhost;
SHOW GRANTS FOR evtest1@localhost;
Grants for evtest1@localhost
GRANT USAGE ON *.* TO 'evtest1'@'localhost' IDENTIFIED BY PASSWORD '*3170F3644E31580C25DE4A08F4C07CC9A2D40C32'
-GRANT SELECT, INSERT ON `TEST`.* TO 'evtest1'@'localhost'
+GRANT SELECT, INSERT ON `test`.* TO 'evtest1'@'localhost'
GRANT SELECT, INSERT, CREATE, EVENT ON `events_test`.* TO 'evtest1'@'localhost'
connection e1;
USE events_test;
@@ -585,13 +585,15 @@ SET AUTOCOMMIT = 0;
SET @evname = 'ev_sched_1823';
SET @cnt = 0;
SELECT COUNT(*) INTO @cnt FROM test.event_log WHERE ev_nm = @evname;
-IF @cnt <= 6 THEN
+IF @cnt < 6 THEN
INSERT INTO test.event_log VALUES (NULL,@evname,@cnt+1,current_timestamp());
COMMIT;
END IF;
SELECT COUNT(*) INTO @cnt FROM test.event_log WHERE ev_nm = @evname;
+IF @cnt < 6 THEN
INSERT INTO test.event_log VALUES (NULL,@evname,@cnt+1,current_timestamp());
ROLLBACK;
+END IF;
END;|
connection default;
DROP EVENT ev_sched_1823;
--
cgit v1.2.1