~ubuntu-branches/ubuntu/trusty/mysql-5.6/trusty

« back to all changes in this revision

Viewing changes to mysql-test/suite/engines/funcs/r/rpl_row_inexist_tbl.result

  • Committer: Package Import Robot
  • Author(s): James Page
  • Date: 2014-02-12 11:54:27 UTC
  • Revision ID: package-import@ubuntu.com-20140212115427-oq6tfsqxl1wuwehi
Tags: upstream-5.6.15
ImportĀ upstreamĀ versionĀ 5.6.15

Show diffs side-by-side

added added

removed removed

Lines of Context:
 
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 not null primary key);
 
8
insert into  t1 values (1);
 
9
create table t2 (a int);
 
10
insert into  t2 values (1);
 
11
update t1, t2 set t1.a = 0 where t1.a = t2.a;
 
12
show tables;
 
13
Tables_in_test
 
14
t1
 
15
select * from t1;
 
16
a
 
17
0
 
18
drop table t1;
 
19
insert into t1 values (1);
 
20
show slave status;
 
21
Slave_IO_State  #
 
22
Master_Host     127.0.0.1
 
23
Master_User     root
 
24
Master_Port     MASTER_MYPORT
 
25
Connect_Retry   1
 
26
Master_Log_File master-bin.000001
 
27
Read_Master_Log_Pos     #
 
28
Relay_Log_File  #
 
29
Relay_Log_Pos   #
 
30
Relay_Master_Log_File   master-bin.000001
 
31
Slave_IO_Running        Yes
 
32
Slave_SQL_Running       No
 
33
Replicate_Do_DB 
 
34
Replicate_Ignore_DB     
 
35
Replicate_Do_Table      
 
36
Replicate_Ignore_Table  test.t2
 
37
Replicate_Wild_Do_Table 
 
38
Replicate_Wild_Ignore_Table     
 
39
Last_Errno      1146
 
40
Last_Error      Error executing row event: 'Table 'test.t1' doesn't exist'
 
41
Skip_Counter    0
 
42
Exec_Master_Log_Pos     #
 
43
Relay_Log_Space #
 
44
Until_Condition None
 
45
Until_Log_File  
 
46
Until_Log_Pos   0
 
47
Master_SSL_Allowed      No
 
48
Master_SSL_CA_File      
 
49
Master_SSL_CA_Path      
 
50
Master_SSL_Cert 
 
51
Master_SSL_Cipher       
 
52
Master_SSL_Key  
 
53
Seconds_Behind_Master   #
 
54
Master_SSL_Verify_Server_Cert   No
 
55
Last_IO_Errno   0
 
56
Last_IO_Error   
 
57
Last_SQL_Errno  1146
 
58
Last_SQL_Error  Error executing row event: 'Table 'test.t1' doesn't exist'
 
59
Replicate_Ignore_Server_Ids     
 
60
Master_Server_Id        1
 
61
drop table t1, t2;