Debian Codegraph @

mysql-test/suite/rpl/t/rpl_default.test

raw
1 #
2 # Test of replicating default values
3 # As the table is using non deterministic functions, replication must
4 # switch to binlog format.
5 #
6
7 -- source include/have_binlog_format_mixed_or_row.inc
8 -- source include/master-slave.inc
9
10 connection master;
11
12 create table t1 (a int DEFAULT (1+1), b bigint default uuid_short(), u blob default user());
13 insert into t1 (a) values(1);
14
15 let $b=query_get_value(select * from t1, b, 1);
16 let $u=query_get_value(select * from t1, u, 1);
17
18 sync_slave_with_master;
19 connection slave;
20
21 show create table t1;
22 --disable_query_log
23 eval select a,"$b"=b as uuid,"$u"=u as user from t1;
24 --enable_query_log
25 connection master;
26
27 drop table t1;
28
29 --source include/rpl_end.inc