~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/t/lock_tables_lost_commit.test

• browse files at revision 499.1.1
• compare with another revision
• compare with revision 520.3.2
• download diff
• download tarball
• view history from revision 499.1.1

Show diffs side-by-side

added

removed

tests/t/lock_tables_lost_commit.test

8

8

connection con1;

9

9

--disable_warnings

10

10

drop table if exists t1;

11

 

create table t1(a int) engine=innodb;

 

11

create table t1(a int);

12

12

--enable_warnings

13

13

lock tables t1 write;

14

14

insert into t1 values(10);

17

17

connection con2;

18

18

# The bug was that, because of the LOCK TABLES, the handler "forgot" to commit,

19

19

# and the other commit when we write to the binlog was not done because of

20

 

# binlog-ignore-db  

 

20

# binlog-ignore-db

 

21

# PBXT: the transaction is committed, but it is a bit delayed

 

22

# this is due to the delay in pbxt_commit() - read GOTCHA

 

23

--sleep 1

21

24

select * from t1;

22

25

drop table t1;

23

26

 

• Older »

Loggerhead is a web-based interface for Breezy
Version: 2.0.1