← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to mysql-test/extra/binlog_tests/drop_temp_table.test

  • Committer: brian
  • Date: 2008-06-25 05:29:13 UTC
  • Revision ID: brian@localhost.localdomain-20080625052913-6upwo0jsrl4lnapl
clean slate

Show diffs side-by-side

added added

removed removed

Lines of Context:
mysql-test/extra/binlog_tests/drop_temp_table.test
 
1
 
 
2
--disable_warnings
 
3
drop database if exists `drop-temp+table-test`;
 
4
--enable_warnings
 
5
 
 
6
connect (con1,localhost,root,,);
 
7
connect (con2,localhost,root,,);
 
8
connection con1;
 
9
reset master;
 
10
create database `drop-temp+table-test`;
 
11
use `drop-temp+table-test`;
 
12
create temporary table shortn1 (a int);
 
13
create temporary table `table:name` (a int);
 
14
create temporary table shortn2 (a int);
 
15
select get_lock("a",10);
 
16
disconnect con1;
 
17
 
 
18
connection con2;
 
19
# We want to SHOW BINLOG EVENTS, to know what was logged. But there is no
 
20
# guarantee that logging of the terminated con1 has been done yet.
 
21
# To be sure that logging has been done, we use a user lock.
 
22
select get_lock("a",10);
 
23
let $VERSION=`select version()`;
 
24
source include/show_binlog_events.inc;
 
25
drop database `drop-temp+table-test`;
 
26
 
 
27
# End of 4.1 tests