Debian Codegraph @

mysql-test/suite/rpl/r/binlog_check_constraint_checks_flag.result

raw
1 include/master-slave.inc
2 [connection master]
3 connection master;
4 create table t10(
5 pk int primary key,
6 a int,
7 constraint a_big check (a>10)
8 );
9 insert into t10 values (1, 20);
10 set check_constraint_checks=off;
11 update t10 set a=a-15 where pk=1;
12 update t10 set a=a+100 where pk=1;
13 set check_constraint_checks=on ;
14 select * from t10;
15 pk a
16 1 105
17 connection slave;
18 select * from t10;
19 pk a
20 1 105
21 connection master;
22 drop table t10;
23 connection slave;
24 include/rpl_end.inc