diff options
| author | unknown <holyfoot/hf@mysql.com/hfmain.(none)> | 2007-06-28 13:34:39 +0500 |
|---|---|---|
| committer | unknown <holyfoot/hf@mysql.com/hfmain.(none)> | 2007-06-28 13:34:39 +0500 |
| commit | 3f9bf9253343aaa9bfd581a1c7dc01f0c281dfc3 (patch) | |
| tree | faed50a78309c01cd737f3fe38346400a228c630 | |
| parent | 28187da7747029ee380b5ddcea84cc0002b4ad5d (diff) | |
| download | mariadb-git-3f9bf9253343aaa9bfd581a1c7dc01f0c281dfc3.tar.gz | |
events_bugs.test didn't remove all the objects it created
what caused some consequitive tests failures
mysql-test/r/events_bugs.result:
test result fixed
mysql-test/t/events_bugs.test:
typo fixed, event removed
| -rw-r--r-- | mysql-test/r/events_bugs.result | 4 | ||||
| -rw-r--r-- | mysql-test/t/events_bugs.test | 3 |
2 files changed, 5 insertions, 2 deletions
diff --git a/mysql-test/r/events_bugs.result b/mysql-test/r/events_bugs.result index 5de93dc8ac2..f51209db6f1 100644 --- a/mysql-test/r/events_bugs.result +++ b/mysql-test/r/events_bugs.result @@ -571,10 +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@lcalhost; +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, CREATE, EVENT ON `events_test`.* TO 'evtest1'@'localhost' connection e1; USE events_test; @@ -591,6 +592,7 @@ INSERT INTO test.event_log VALUES (NULL,@evname,@cnt+1,current_timestamp()); ROLLBACK; END;| connection default; +DROP EVENT ev_sched_1823; DROP USER evtest1@localhost; USE test; ===================================================================================== diff --git a/mysql-test/t/events_bugs.test b/mysql-test/t/events_bugs.test index 7748cacf47f..ebe4d83331d 100644 --- a/mysql-test/t/events_bugs.test +++ b/mysql-test/t/events_bugs.test @@ -668,7 +668,7 @@ 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@lcalhost; +GRANT select,insert ON TEST.* TO evtest1@localhost; SHOW GRANTS FOR evtest1@localhost; --echo connection e1; @@ -693,6 +693,7 @@ DELIMITER ;| --sleep 6 --echo connection default; +DROP EVENT ev_sched_1823; connection default; DROP USER evtest1@localhost; |