summaryrefslogtreecommitdiff
path: root/mysql-test/r/events_trans_notembedded.result
diff options
context:
space:
mode:
authorunknown <holyfoot/hf@mysql.com/hfmain.(none)>2007-04-07 23:16:03 +0500
committerunknown <holyfoot/hf@mysql.com/hfmain.(none)>2007-04-07 23:16:03 +0500
commit3f0c44c605c6e6f9e3bbb92f7a43a598be5d5b1b (patch)
tree30bcd4ec4d03670f92fddab7f0fbec38f2168f2d /mysql-test/r/events_trans_notembedded.result
parent156735bd126603034740e00ad9951674500b22c8 (diff)
downloadmariadb-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.result45
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;