~ubuntu-branches/ubuntu/hardy/mysql-dfsg-5.0/hardy-updates

« back to all changes in this revision

Viewing changes to mysql-test/t/flush_block_commit.test

  • Committer: Bazaar Package Importer
  • Author(s): Martin Pitt
  • Date: 2007-04-02 16:10:53 UTC
  • mfrom: (1.1.9 upstream)
  • Revision ID: james.westby@ubuntu.com-20070402161053-zkil9hjq9k5p1uzv
Tags: 5.0.37-0ubuntu1
* New upstream bugfix release.
  - Fixes replication failure with auto-increment and on duplicate key
    update, a regression introduced into 5.0.24. (LP: #95821)
* debian/control: Set Ubuntu maintainer.
* debian/rules: Change comments from 'Debian etch' to 'Ubuntu 7.04'.

Show diffs side-by-side

added added

removed removed

Lines of Context:
75
75
drop table t1;
76
76
 
77
77
# End of 4.1 tests
78
 
 
79
 
# FLUSH TABLES WITH READ LOCK should block writes to binlog too
80
 
connection con1;
81
 
create table t1 (a int) engine=innodb;
82
 
reset master;
83
 
set autocommit=0;
84
 
insert t1 values (1);
85
 
connection con2;
86
 
flush tables with read lock;
87
 
show master status;
88
 
connection con1;
89
 
send commit;
90
 
connection con2;
91
 
sleep 1;
92
 
show master status;
93
 
unlock tables;
94
 
connection con1;
95
 
reap;
96
 
drop table t1;
97
 
set autocommit=1;
98