~ubuntu-branches/ubuntu/precise/mysql-5.1/precise

« back to all changes in this revision

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

  • Committer: Bazaar Package Importer
  • Author(s): Chuck Short
  • Date: 2010-06-21 15:31:05 UTC
  • mfrom: (1.1.3 upstream)
  • mto: This revision was merged to the branch mainline in revision 6.
  • Revision ID: james.westby@ubuntu.com-20100621153105-pbbz3t6nyrf9t2zq
Tags: upstream-5.1.48
ImportĀ upstreamĀ versionĀ 5.1.48

Show diffs side-by-side

added added

removed removed

Lines of Context:
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