~vadim-tk/percona-server/percona-galera-5.1.57-0.8.1

SELECT EVENT_CATALOG, EVENT_SCHEMA, EVENT_NAME, DEFINER, EVENT_BODY, EVENT_DEFINITION, EVENT_TYPE, EXECUTE_AT, INTERVAL_VALUE, INTERVAL_FIELD, STATUS,ON_COMPLETION, EVENT_COMMENT FROM INFORMATION_SCHEMA.EVENTS ORDER BY EVENT_SCHEMA, EVENT_NAME;

CREATE DATABASE events_test2;

CREATE USER ev_test@localhost;

GRANT ALL ON events_test.* to ev_test@localhost;

GRANT ALL ON events_test2.* to ev_test@localhost;

REVOKE EVENT ON events_test2.* FROM ev_test@localhost;

#now we are on con1

connect (ev_con1,localhost,ev_test,,events_test2);

select "NEW CONNECTION";

SELECT USER(), DATABASE();

SHOW GRANTS;

--echo "Here comes an error:";

#NO EVENT_ACL on events_test2

--error 1044

SHOW EVENTS;

USE events_test;

--echo "We should see one event";

--replace_column 8 # 9 #

SHOW EVENTS;

#now create an event with the same name but we are different user

SELECT CONCAT("Let's create some new events from the name of ", USER());

--error ER_EVENT_ALREADY_EXISTS

CREATE EVENT one_event ON SCHEDULE EVERY 20 SECOND DO SELECT 123;

CREATE EVENT two_event ON SCHEDULE EVERY 20 SECOND ON COMPLETION NOT PRESERVE COMMENT "two event" DO SELECT 123;

CREATE EVENT three_event ON SCHEDULE EVERY 20 SECOND ON COMPLETION PRESERVE COMMENT "three event" DO SELECT 123;

--echo "Now we should see 3 events:";

--replace_column 8 # 9 #

SHOW EVENTS;

--echo "This should show us only 2 events:";

--replace_column 8 # 9 #

SHOW EVENTS LIKE 't%event';

--echo "This should show us no events:";

--replace_column 8 # 9 #

SHOW EVENTS FROM test LIKE '%';

#ok, we are back

connection default;

GRANT EVENT ON events_test2.* TO ev_test@localhost;

connection ev_con1;

USE events_test2;

CREATE EVENT four_event ON SCHEDULE EVERY 20 SECOND DO SELECT 42;

connection default;

USE events_test;

--echo "We should see 4 events : one_event, two_event, three_event & four_event"

DROP DATABASE events_test2;

--echo "We should see 3 events : one_event, two_event, three_event"

connection default;

CREATE DATABASE events_test2;

USE events_test2;

CREATE EVENT five_event ON SCHEDULE EVERY 20 SECOND DO SELECT 42;

connection ev_con1;

--echo "Should see 4 events - one, two, three & five"

connection default;

REVOKE EVENT ON events_test2.* FROM ev_test@localhost;

connection ev_con1;

USE test;

--echo "Should see 3 events - one, two & three"

--echo "Let's test ALTER EVENT which changes the definer"

USE events_test;

ALTER EVENT one_event ON SCHEDULE EVERY 10 SECOND;

--echo "The definer should be ev_test@localhost"

connection default;

USE events_test;

ALTER EVENT one_event COMMENT "comment";

connection ev_con1;

--echo "The definer should be root@localhost"

ALTER EVENT one_event DO SELECT 12;

--echo "The definer should be ev_test@localhost"

connection default;

--echo "make the definer again root@localhost"

ALTER EVENT one_event COMMENT "new comment";

connection ev_con1;

--echo "test DROP by another user"

DROP EVENT one_event;

connection default;

--echo "One event should not be there"

100

connection ev_con1;

101

disconnect ev_con1;

102

--source include/wait_until_disconnected.inc

103

connection default;

104

DROP USER ev_test@localhost;

105

DROP DATABASE events_test2;

106

107

108

# End of tests

109

110

111

--source include/check_events_off.inc

112

113

DROP DATABASE events_test;