Debian Codegraph @

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

raw
1 source include/master-slave.inc;
2 source include/have_binlog_format_statement.inc;
3
4 # Suppress "unsafe" warnings.
5 #
6 --disable_query_log
7 CALL mtr.add_suppression(
8 CONCAT('Unsafe statement written to the binary log using ',
9 'statement format since BINLOG_FORMAT = STATEMENT'));
10 --enable_query_log
11
12 CREATE TABLE t1 (f1 INT NOT NULL AUTO_INCREMENT PRIMARY KEY, f2 INT);
13 INSERT /*+ SET_VAR(auto_increment_increment=10) SET_VAR(tmp_table_size=1024)*/
14 INTO t1 VALUES (NULL, @@tmp_table_size), (NULL, @@tmp_table_size);
15
16 --source include/sync_slave_sql_with_master.inc
17 # f1 column has inceremented values with step 10 since auto_increment_increment=10 is written to binlog.
18 # f2 column should contain default tmp_table_size value. It means that hint is not executed on the slave.
19 SELECT * FROM t1;
20 connection master;
21 DROP TABLE t1;
22 --source include/rpl_sync.inc
23 --source include/rpl_end.inc
24
25
26
27
28