← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/t/lock_tables_lost_commit.test

  • Committer: Brian Aker
  • Date: 2009-06-05 23:10:06 UTC
  • mto: This revision was merged to the branch mainline in revision 1055.
  • Revision ID: brian@gaz-20090605231006-01nyw7pfpj2z2v8p
Remove guts in parser for LOCK TABLE.

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/t/lock_tables_lost_commit.test
1
 
# This is a test for bug 578
2
 
 
3
 
 
4
 
connect (con1,localhost,root,,);
5
 
connect (con2,localhost,root,,);
6
 
 
7
 
connection con1;
8
 
--disable_warnings
9
 
drop table if exists t1;
10
 
create table t1(a int);
11
 
--enable_warnings
12
 
lock tables t1 write;
13
 
insert into t1 values(10);
14
 
disconnect con1;
15
 
 
16
 
connection con2;
17
 
# The bug was that, because of the LOCK TABLES, the handler "forgot" to commit,
18
 
# and the other commit when we write to the binlog was not done because of
19
 
# binlog-ignore-db
20
 
# PBXT: the transaction is committed, but it is a bit delayed
21
 
# this is due to the delay in pbxt_commit() - read GOTCHA
22
 
--sleep 1
23
 
select * from t1;
24
 
drop table t1;
25
 
 
26
 
# End of 4.1 tests