← Back to branch summary

~ubuntu-branches/ubuntu/lucid/mysql-dfsg-5.1/lucid-security

« back to all changes in this revision

Viewing changes to mysql-test/suite/rpl/t/rpl_binlog_grant.test

  • Committer: Package Import Robot
  • Author(s): Marc Deslauriers
  • Date: 2012-02-22 22:33:55 UTC
  • mto: (1.2.1) (37.1.1 lucid-security)
  • mto: This revision was merged to the branch mainline in revision 36.
  • Revision ID: package-import@ubuntu.com-20120222223355-ku1tb4r70osci6v2
Tags: upstream-5.1.61
Import upstream version 5.1.61

Show diffs side-by-side

added added

removed removed

Lines of Context:
mysql-test/suite/rpl/t/rpl_binlog_grant.test
20
20
start transaction;
21
21
insert into t values (1);
22
22
grant select on t to x@y;
 
23
let $wait_binlog_event= grant select;
 
24
source include/wait_for_binlog_event.inc;
23
25
#
24
26
# There is no active transaction here
25
27
#
26
28
rollback;
27
29
show grants for x@y;
28
 
--replace_result $VERSION VERSION
29
 
--replace_regex /\/\* xid=.* \*\//\/* XID *\//
30
 
show binlog events;
31
30
start transaction;
32
31
insert into t values (2);
33
32
revoke select on t from x@y;
 
33
let $wait_binlog_event= revoke select;
 
34
source include/wait_for_binlog_event.inc;
34
35
#
35
36
# There is no active transaction here
36
37
#
37
38
commit;
38
39
select * from t;
39
40
show grants for x@y;
40
 
--replace_result $VERSION VERSION
41
 
--replace_regex /\/\* xid=.* \*\//\/* XID *\//
42
 
show binlog events;
43
41
drop user x@y;
44
42
drop database d1;
45
43
--sync_slave_with_master
 
44
--source include/rpl_end.inc