summaryrefslogtreecommitdiff
path: root/mysql-test/t/set_statement_notembedded_binlog.test
diff options
context:
space:
mode:
authorOleksandr Byelkin <sanja@mariadb.com>2015-02-17 12:54:51 +0100
committerOleksandr Byelkin <sanja@mariadb.com>2015-03-12 10:19:32 +0100
commita71e2d23bd08ca041a953df44f2235a8ef20bfcc (patch)
tree97600c27c01b16da1c009b30160654b07cf0388b /mysql-test/t/set_statement_notembedded_binlog.test
parentdab12366b1c7ee4e3477ac9dd37ea6c24113cf5b (diff)
downloadmariadb-git-a71e2d23bd08ca041a953df44f2235a8ef20bfcc.tar.gz
MDEV-7006 MDEV-7007: SET STATEMENT and slow log
fixed embedded server tests MDEV-7009: SET STATEMENT min_examined_row_limit has no effect MDEV-6948:SET STATEMENT gtid_domain_id = ... FOR has no effect (same for gtid_seq_no and server_id) old values of SET STATENENT variables now saved in its own Query_arena and restored later
Diffstat (limited to 'mysql-test/t/set_statement_notembedded_binlog.test')
-rw-r--r--mysql-test/t/set_statement_notembedded_binlog.test22
1 files changed, 22 insertions, 0 deletions
diff --git a/mysql-test/t/set_statement_notembedded_binlog.test b/mysql-test/t/set_statement_notembedded_binlog.test
new file mode 100644
index 00000000000..c9c23342936
--- /dev/null
+++ b/mysql-test/t/set_statement_notembedded_binlog.test
@@ -0,0 +1,22 @@
+--source include/have_log_bin.inc
+--source include/not_embedded.inc
+
+--disable_warnings
+drop table if exists t1;
+drop view if exists t1;
+--enable_warnings
+
+--echo #
+--echo # MDEV-6948: SET STATEMENT gtid_domain_id = ... FOR has no effect
+--echo # (same for gtid_seq_no and server_id)
+--echo #
+reset master;
+create table t1 (i int);
+set gtid_domain_id = 10;
+insert into t1 values (1),(2);
+set statement gtid_domain_id = 20 for insert into t1 values (3),(4);
+
+--replace_column 1 x 2 x 3 x 4 x 5 x
+show binlog events limit 5,5;
+
+drop table t1;