diff options
author | unknown <holyfoot/hf@mysql.com/hfmain.(none)> | 2007-04-07 23:16:03 +0500 |
---|---|---|
committer | unknown <holyfoot/hf@mysql.com/hfmain.(none)> | 2007-04-07 23:16:03 +0500 |
commit | 3f0c44c605c6e6f9e3bbb92f7a43a598be5d5b1b (patch) | |
tree | 30bcd4ec4d03670f92fddab7f0fbec38f2168f2d /mysql-test/r/events_trans_notembedded.result | |
parent | 156735bd126603034740e00ad9951674500b22c8 (diff) | |
download | mariadb-git-3f0c44c605c6e6f9e3bbb92f7a43a598be5d5b1b.tar.gz |
after-merging fix
mysql-test/r/events_trans.result:
result fixed
mysql-test/r/windows.result:
merging fix
mysql-test/t/events_trans.test:
moved to events_trans_notembedded.test
mysql-test/r/events_trans_notembedded.result:
New BitKeeper file ``mysql-test/r/events_trans_notembedded.result''
mysql-test/t/events_trans_notembedded.test:
New BitKeeper file ``mysql-test/t/events_trans_notembedded.test''
Diffstat (limited to 'mysql-test/r/events_trans_notembedded.result')
-rw-r--r-- | mysql-test/r/events_trans_notembedded.result | 45 |
1 files changed, 45 insertions, 0 deletions
diff --git a/mysql-test/r/events_trans_notembedded.result b/mysql-test/r/events_trans_notembedded.result new file mode 100644 index 00000000000..1e3dfffe232 --- /dev/null +++ b/mysql-test/r/events_trans_notembedded.result @@ -0,0 +1,45 @@ +drop database if exists events_test; +drop database if exists mysqltest_db2; +create database events_test; +use events_test; +grant create, insert, select, delete on mysqltest_db2.* +to mysqltest_user1@localhost; +create database mysqltest_db2; +set autocommit=off; +select @@autocommit; +@@autocommit +0 +create table t1 (a varchar(255)) engine=innodb; +begin work; +insert into t1 (a) values ("OK: create event: insufficient privileges"); +create event e1 on schedule every 1 day do select 1; +ERROR 42000: Access denied for user 'mysqltest_user1'@'localhost' to database 'mysqltest_db2' +rollback work; +select * from t1; +a +OK: create event: insufficient privileges +delete from t1; +commit work; +begin work; +insert into t1 (a) values ("OK: alter event: insufficient privileges"); +alter event e1 on schedule every 1 day do select 1; +ERROR 42000: Access denied for user 'mysqltest_user1'@'localhost' to database 'mysqltest_db2' +rollback work; +select * from t1; +a +OK: alter event: insufficient privileges +delete from t1; +commit work; +begin work; +insert into t1 (a) values ("OK: drop event: insufficient privileges"); +drop event e1; +ERROR 42000: Access denied for user 'mysqltest_user1'@'localhost' to database 'mysqltest_db2' +rollback work; +select * from t1; +a +OK: drop event: insufficient privileges +delete from t1; +commit work; +drop user mysqltest_user1@localhost; +drop database mysqltest_db2; +drop database events_test; |