49
49
UPDATE t1 LEFT JOIN t4 ON (t1.id=t4.id) SET a=0 where t1.id=1;
50
50
--source include/wait_for_slave_sql_error_and_skip.inc
51
51
Last_SQL_Error = Error 'Table 'test.t4' doesn't exist' on query. Default database: 'test'. Query: 'UPDATE t1 LEFT JOIN t4 ON (t1.id=t4.id) SET a=0 where t1.id=1'
52
set global sql_slave_skip_counter=1;
52
SET GLOBAL SQL_SLAVE_SKIP_COUNTER=1;
53
53
include/start_slave.inc
54
54
UPDATE t1 LEFT JOIN (t4, t7) ON (t1.id=t4.id and t1.id=t7.id) SET a=0 where t1.id=1;
55
55
--source include/wait_for_slave_sql_error_and_skip.inc
56
56
Last_SQL_Error = Error 'Table 'test.t4' doesn't exist' on query. Default database: 'test'. Query: 'UPDATE t1 LEFT JOIN (t4, t7) ON (t1.id=t4.id and t1.id=t7.id) SET a=0 where t1.id=1'
57
set global sql_slave_skip_counter=1;
57
SET GLOBAL SQL_SLAVE_SKIP_COUNTER=1;
58
58
include/start_slave.inc
59
59
UPDATE t1 LEFT JOIN (t2, t4, t7) ON (t1.id=t2.id and t1.id=t4.id and t1.id=t7.id) SET a=0, b=0 where t1.id=1;
60
60
--source include/wait_for_slave_sql_error_and_skip.inc
61
61
Last_SQL_Error = Error 'Table 'test.t4' doesn't exist' on query. Default database: 'test'. Query: 'UPDATE t1 LEFT JOIN (t2, t4, t7) ON (t1.id=t2.id and t1.id=t4.id and t1.id=t7.id) SET a=0, b=0 where t1.id=1'
62
set global sql_slave_skip_counter=1;
62
SET GLOBAL SQL_SLAVE_SKIP_COUNTER=1;
63
63
include/start_slave.inc
64
64
UPDATE t1 LEFT JOIN (t2, t3, t7) ON (t1.id=t2.id and t1.id=t3.id and t1.id=t7.id) SET a=0, b=0, c=0 where t1.id=1;
65
65
--source include/wait_for_slave_sql_error_and_skip.inc
66
66
Last_SQL_Error = Error 'Table 'test.t7' doesn't exist' on query. Default database: 'test'. Query: 'UPDATE t1 LEFT JOIN (t2, t3, t7) ON (t1.id=t2.id and t1.id=t3.id and t1.id=t7.id) SET a=0, b=0, c=0 where t1.id=1'
67
set global sql_slave_skip_counter=1;
67
SET GLOBAL SQL_SLAVE_SKIP_COUNTER=1;
68
68
include/start_slave.inc
69
69
UPDATE t1 LEFT JOIN t7 ON (t1.id=t7.id) SET a=0, g=0 where t1.id=1;
70
70
--source include/wait_for_slave_sql_error_and_skip.inc
71
71
Last_SQL_Error = Error 'Table 'test.t7' doesn't exist' on query. Default database: 'test'. Query: 'UPDATE t1 LEFT JOIN t7 ON (t1.id=t7.id) SET a=0, g=0 where t1.id=1'
72
set global sql_slave_skip_counter=1;
72
SET GLOBAL SQL_SLAVE_SKIP_COUNTER=1;
73
73
include/start_slave.inc
74
74
UPDATE t7 LEFT JOIN t1 ON (t1.id=t7.id) SET a=0, g=0 where t7.id=1;
75
75
--source include/wait_for_slave_sql_error_and_skip.inc
76
76
Last_SQL_Error = Error 'Table 'test.t7' doesn't exist' on query. Default database: 'test'. Query: 'UPDATE t7 LEFT JOIN t1 ON (t1.id=t7.id) SET a=0, g=0 where t7.id=1'
77
set global sql_slave_skip_counter=1;
77
SET GLOBAL SQL_SLAVE_SKIP_COUNTER=1;
78
78
include/start_slave.inc
79
79
UPDATE t1 LEFT JOIN (t4, t5, t7) ON (t1.id=t4.id and t1.id=t5.id and t1.id=t7.id) SET a=0, g=0 where t1.id=1;
80
80
--source include/wait_for_slave_sql_error_and_skip.inc
81
81
Last_SQL_Error = Error 'Table 'test.t4' doesn't exist' on query. Default database: 'test'. Query: 'UPDATE t1 LEFT JOIN (t4, t5, t7) ON (t1.id=t4.id and t1.id=t5.id and t1.id=t7.id) SET a=0, g=0 where t1.id=1'
82
set global sql_slave_skip_counter=1;
82
SET GLOBAL SQL_SLAVE_SKIP_COUNTER=1;
83
83
include/start_slave.inc
84
84
UPDATE t1 LEFT JOIN (t4, t7, t8) ON (t1.id=t4.id and t1.id=t7.id and t1.id=t8.id) SET a=0, g=0 where t1.id=1;
85
85
--source include/wait_for_slave_sql_error_and_skip.inc
86
86
Last_SQL_Error = Error 'Table 'test.t4' doesn't exist' on query. Default database: 'test'. Query: 'UPDATE t1 LEFT JOIN (t4, t7, t8) ON (t1.id=t4.id and t1.id=t7.id and t1.id=t8.id) SET a=0, g=0 where t1.id=1'
87
set global sql_slave_skip_counter=1;
87
SET GLOBAL SQL_SLAVE_SKIP_COUNTER=1;
88
88
include/start_slave.inc
89
89
UPDATE t1 LEFT JOIN (t7, t8, t9) ON (t1.id=t7.id and t1.id=t8.id and t1.id=t9.id) SET a=0, g=0, h=0, i=0 where t1.id=1;
90
90
--source include/wait_for_slave_sql_error_and_skip.inc
91
91
Last_SQL_Error = Error 'Table 'test.t7' doesn't exist' on query. Default database: 'test'. Query: 'UPDATE t1 LEFT JOIN (t7, t8, t9) ON (t1.id=t7.id and t1.id=t8.id and t1.id=t9.id) SET a=0, g=0, h=0, i=0 where t1.id=1'
92
set global sql_slave_skip_counter=1;
92
SET GLOBAL SQL_SLAVE_SKIP_COUNTER=1;
93
93
include/start_slave.inc
94
94
UPDATE t7 LEFT JOIN (t1, t2, t3) ON (t7.id=t1.id and t7.id=t2.id and t7.id=t3.id) SET g=0, a=0, b=0, c=0 where t7.id=1;
95
95
--source include/wait_for_slave_sql_error_and_skip.inc
96
96
Last_SQL_Error = Error 'Table 'test.t7' doesn't exist' on query. Default database: 'test'. Query: 'UPDATE t7 LEFT JOIN (t1, t2, t3) ON (t7.id=t1.id and t7.id=t2.id and t7.id=t3.id) SET g=0, a=0, b=0, c=0 where t7.id=1'
97
set global sql_slave_skip_counter=1;
97
SET GLOBAL SQL_SLAVE_SKIP_COUNTER=1;
98
98
include/start_slave.inc
99
99
UPDATE t7 LEFT JOIN (t4, t5, t3) ON (t7.id=t4.id and t7.id=t5.id and t7.id=t3.id) SET g=0, c=0 where t7.id=1;
100
100
--source include/wait_for_slave_sql_error_and_skip.inc
101
101
Last_SQL_Error = Error 'Table 'test.t7' doesn't exist' on query. Default database: 'test'. Query: 'UPDATE t7 LEFT JOIN (t4, t5, t3) ON (t7.id=t4.id and t7.id=t5.id and t7.id=t3.id) SET g=0, c=0 where t7.id=1'
102
set global sql_slave_skip_counter=1;
102
SET GLOBAL SQL_SLAVE_SKIP_COUNTER=1;
103
103
include/start_slave.inc
104
104
UPDATE t7 LEFT JOIN (t8, t9, t3) ON (t7.id=t8.id and t7.id=t9.id and t7.id=t3.id) SET g=0, h=0, i=0, c=0 where t7.id=1;
105
105
--source include/wait_for_slave_sql_error_and_skip.inc
106
106
Last_SQL_Error = Error 'Table 'test.t7' doesn't exist' on query. Default database: 'test'. Query: 'UPDATE t7 LEFT JOIN (t8, t9, t3) ON (t7.id=t8.id and t7.id=t9.id and t7.id=t3.id) SET g=0, h=0, i=0, c=0 where t7.id=1'
107
set global sql_slave_skip_counter=1;
107
SET GLOBAL SQL_SLAVE_SKIP_COUNTER=1;
108
108
include/start_slave.inc
109
109
UPDATE t1 LEFT JOIN t4 ON (t1.id=t4.id) SET a=0, d=0 where t1.id=1;
110
110
--source include/wait_for_slave_sql_error_and_skip.inc
111
111
Last_SQL_Error = Error 'Table 'test.t4' doesn't exist' on query. Default database: 'test'. Query: 'UPDATE t1 LEFT JOIN t4 ON (t1.id=t4.id) SET a=0, d=0 where t1.id=1'
112
set global sql_slave_skip_counter=1;
112
SET GLOBAL SQL_SLAVE_SKIP_COUNTER=1;
113
113
include/start_slave.inc
114
114
UPDATE t1 LEFT JOIN (t4, t5, t6) ON (t1.id=t4.id and t1.id=t5.id and t1.id=t6.id) SET a=0, d=0, e=0, f=0 where t1.id=1;
115
115
--source include/wait_for_slave_sql_error_and_skip.inc
116
116
Last_SQL_Error = Error 'Table 'test.t4' doesn't exist' on query. Default database: 'test'. Query: 'UPDATE t1 LEFT JOIN (t4, t5, t6) ON (t1.id=t4.id and t1.id=t5.id and t1.id=t6.id) SET a=0, d=0, e=0, f=0 where t1.id=1'
117
set global sql_slave_skip_counter=1;
117
SET GLOBAL SQL_SLAVE_SKIP_COUNTER=1;
118
118
include/start_slave.inc
119
119
UPDATE t4 LEFT JOIN (t1, t5, t6) ON (t4.id=t1.id and t4.id=t5.id and t4.id=t6.id) SET a=0, e=0, f=0 where t4.id=1;
120
120
--source include/wait_for_slave_sql_error_and_skip.inc
121
121
Last_SQL_Error = Error 'Table 'test.t4' doesn't exist' on query. Default database: 'test'. Query: 'UPDATE t4 LEFT JOIN (t1, t5, t6) ON (t4.id=t1.id and t4.id=t5.id and t4.id=t6.id) SET a=0, e=0, f=0 where t4.id=1'
122
set global sql_slave_skip_counter=1;
122
SET GLOBAL SQL_SLAVE_SKIP_COUNTER=1;
123
123
include/start_slave.inc
124
124
UPDATE t7 LEFT JOIN (t1, t4, t2) ON (t7.id=t1.id and t7.id=t4.id and t7.id=t2.id) SET a=0, b=0, d=0, g=0 where t7.id=1;
125
125
--source include/wait_for_slave_sql_error_and_skip.inc
126
126
Last_SQL_Error = Error 'Table 'test.t7' doesn't exist' on query. Default database: 'test'. Query: 'UPDATE t7 LEFT JOIN (t1, t4, t2) ON (t7.id=t1.id and t7.id=t4.id and t7.id=t2.id) SET a=0, b=0, d=0, g=0 where t7.id=1'
127
set global sql_slave_skip_counter=1;
127
SET GLOBAL SQL_SLAVE_SKIP_COUNTER=1;
128
128
include/start_slave.inc
130
130
show tables like 't%';