← Back to branch summary

~linuxjedi/drizzle/trunk-bug-667053

« back to all changes in this revision

Viewing changes to mysql-test/suite/binlog/r/binlog_stm_drop_tmp_tbl.result

  • 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/suite/binlog/r/binlog_stm_drop_tmp_tbl.result
 
1
drop database if exists `drop-temp+table-test`;
 
2
reset master;
 
3
create database `drop-temp+table-test`;
 
4
use `drop-temp+table-test`;
 
5
create temporary table shortn1 (a int);
 
6
create temporary table `table:name` (a int);
 
7
create temporary table shortn2 (a int);
 
8
select get_lock("a",10);
 
9
get_lock("a",10)
 
10
1
 
11
select get_lock("a",10);
 
12
get_lock("a",10)
 
13
1
 
14
show binlog events from <binlog_start>;
 
15
Log_name        Pos     Event_type      Server_id       End_log_pos     Info
 
16
master-bin.000001       #       Query   #       #       create database `drop-temp+table-test`
 
17
master-bin.000001       #       Query   #       #       use `drop-temp+table-test`; create temporary table shortn1 (a int)
 
18
master-bin.000001       #       Query   #       #       use `drop-temp+table-test`; create temporary table `table:name` (a int)
 
19
master-bin.000001       #       Query   #       #       use `drop-temp+table-test`; create temporary table shortn2 (a int)
 
20
master-bin.000001       #       Query   #       #       use `drop-temp+table-test`; DROP /*!40005 TEMPORARY */ TABLE IF EXISTS `drop-temp+table-test`.`shortn2`,`drop-temp+table-test`.`table:name`,`drop-temp+table-test`.`shortn1`
 
21
drop database `drop-temp+table-test`;