MySQL Bugs: #28876: After a REVOKE EVENT privilege an ALTER EVENT crashes server.

Bug #28876	After a REVOKE EVENT privilege an ALTER EVENT crashes server.
Submitted:	4 Jun 2007 14:17	Modified:	7 Jun 2007 7:20
Reporter:	Horst Hunger	Email Updates:
Status:	Not a Bug	Impact on me:	None
Category:	MySQL Server: Stored Routines	Severity:	S2 (Serious)
Version:	5.1.19	OS:	Linux (suse 10.1)
Assigned to:		CPU Architecture:	Any

Description:
The following sequence of sql statements were successful, though error -1044 was expected:

--echo connection default (root);
connection default;
REVOKE event ON ev_db_1.* FROM evtest1@localhost;

--echo connection e1;
connection e1;
ALTER EVENT ev_db_1.ev_privs_1421 ON SCHEDULE EVERY 2 SECOND
	STARTS current_timestamp;

The expected behaviour:

USE ev_db_1;
# ER_DBACCESS_DENIED_ERROR 1044
--error ER_DBACCESS_DENIED_ERROR
ALTER EVENT ev_privs_1421 ON SCHEDULE EVERY 2 SECOND
	STARTS current_timestamp;

More see attached test program.

How to repeat:
copy attached program into mysql-test/t, generate a result file and execute 
perl mysql-test-run.pl --suite=events ev_bug6

Thank you for the report.

Verified as described using 5.1.19 package. With current BK sources mysqld crashes at line 39

I think the report is bogus, as the connection e1 has been already established when the on the default connection the EVENT ACL is being revoked. The ACL system of MySQL loads the rights during connect and caches them in memory. If there are changes, they will affect only new connections. Please correct me, if I have missed something.

Andrey, you are right. I've just changed test and mysqld behaves as expected.

Changed part:

From line 35:
REVOKE event ON ev_db_1.* FROM evtest1@localhost;

connection e1;
disconnect e1;

connect (e1,localhost,evtest1,ev1,ev_db_1,$MASTER_MYPORT,$MASTER_MYSOCK);
--echo connection e1;
connection e1;
ALTER EVENT ev_db_1.ev_privs_1421 ON SCHEDULE EVERY 2 SECOND
	STARTS current_timestamp;

With today sources mysqld doesn't crash