← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to mysql-test/suite/rpl/r/rpl_row_err_ignoredtable.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/rpl/r/rpl_row_err_ignoredtable.result
 
1
stop slave;
 
2
drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
 
3
reset master;
 
4
reset slave;
 
5
drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
 
6
start slave;
 
7
create table t1 (a int primary key);
 
8
insert into t1 values (1),(1);
 
9
ERROR 23000: Duplicate entry '1' for key 1
 
10
show slave status;
 
11
Slave_IO_State  Master_Host     Master_User     Master_Port     Connect_Retry   Master_Log_File Read_Master_Log_Pos     Relay_Log_File  Relay_Log_Pos   Relay_Master_Log_File   Slave_IO_Running        Slave_SQL_Running       Replicate_Do_DB Replicate_Ignore_DB     Replicate_Do_Table      Replicate_Ignore_Table  Replicate_Wild_Do_Table Replicate_Wild_Ignore_Table     Last_Errno      Last_Error      Skip_Counter    Exec_Master_Log_Pos     Relay_Log_Space Until_Condition Until_Log_File  Until_Log_Pos   Master_SSL_Allowed      Master_SSL_CA_File      Master_SSL_CA_Path      Master_SSL_Cert Master_SSL_Cipher       Master_SSL_Key  Seconds_Behind_Master
 
12
#       127.0.0.1       root    MASTER_PORT     1       master-bin.000001       269     #       #       master-bin.000001       Yes     Yes                                                     0               0       269     #       None            0       No                                              #
 
13
show tables like 't1';
 
14
Tables_in_test (t1)
 
15
t1
 
16
drop table t1;
 
17
select get_lock('crash_lock%20C', 10);
 
18
get_lock('crash_lock%20C', 10)
 
19
1
 
20
create table t2 (a int primary key);
 
21
insert into t2 values(1);
 
22
create table t3 (id int);
 
23
insert into t3 values(connection_id());
 
24
 update t2 set a = a + 1 + get_lock('crash_lock%20C', 10);
 
25
select (@id := id) - id from t3;
 
26
(@id := id) - id
 
27
0
 
28
kill @id;
 
29
drop table t2,t3;
 
30
show binlog events from 102;
 
31
Log_name        Pos     Event_type      Server_id       End_log_pos     Info
 
32
master-bin.000001       #       Query   1       #       #
 
33
master-bin.000001       #       Table_map       1       #       #
 
34
master-bin.000001       #       Write_rows      1       #       #
 
35
master-bin.000001       #       Query   1       #       #
 
36
master-bin.000001       #       Query   1       #       #
 
37
master-bin.000001       #       Table_map       1       #       #
 
38
master-bin.000001       #       Write_rows      1       #       #
 
39
master-bin.000001       #       Query   1       #       #
 
40
master-bin.000001       #       Table_map       1       #       #
 
41
master-bin.000001       #       Write_rows      1       #       #
 
42
master-bin.000001       #       Table_map       1       #       #
 
43
master-bin.000001       #       Update_rows     1       #       #
 
44
master-bin.000001       #       Query   1       #       #