summaryrefslogtreecommitdiff
path: root/mysql-test/suite/rpl/include/rpl_sv_relay_space.test
diff options
context:
space:
mode:
authorMichael Widenius <monty@mariadb.org>2018-03-09 15:14:33 +0200
committerMonty <monty@mariadb.org>2018-03-29 13:59:44 +0300
commit39018f2a5a56a03769149cbccfb6481ce2af30d4 (patch)
tree3d00d2d405142729e77589d7bbbfa8e511bdf84c /mysql-test/suite/rpl/include/rpl_sv_relay_space.test
parent108ed228547943c65723adf86989a5aff844e01a (diff)
downloadmariadb-git-39018f2a5a56a03769149cbccfb6481ce2af30d4.tar.gz
Move mysql-test-run/extra/rpl_tests to suite/rpl/include
Renamed suite/rpl/include/rpl_sync.inc to rpl_sync_test.inc to remove clash with include/rpl_sync.inc
Diffstat (limited to 'mysql-test/suite/rpl/include/rpl_sv_relay_space.test')
-rw-r--r--mysql-test/suite/rpl/include/rpl_sv_relay_space.test24
1 files changed, 24 insertions, 0 deletions
diff --git a/mysql-test/suite/rpl/include/rpl_sv_relay_space.test b/mysql-test/suite/rpl/include/rpl_sv_relay_space.test
new file mode 100644
index 00000000000..6edbbf68266
--- /dev/null
+++ b/mysql-test/suite/rpl/include/rpl_sv_relay_space.test
@@ -0,0 +1,24 @@
+source include/master-slave.inc;
+
+#
+# Bug#7100 relay_log_space_max missing from SHOW VARIABLES
+#
+SHOW VARIABLES LIKE 'relay_log_space_limit';
+
+# Matz says: I have no idea what this is supposed to test, but it has
+# potential for generating different results with some storage engines
+# that process rows in an order not dependent on the insertion order.
+
+eval CREATE TABLE t1 (name varchar(64), age smallint(3))ENGINE=$engine_type;
+INSERT INTO t1 SET name='Andy', age=31;
+INSERT INTO t1 SET name='Jacob', age=2;
+INSERT INTO t1 SET name='Caleb', age=1;
+ALTER TABLE t1 ADD id int(8) ZEROFILL AUTO_INCREMENT PRIMARY KEY,
+ ALGORITHM=COPY;
+SELECT * FROM t1 ORDER BY id;
+sync_slave_with_master;
+SELECT * FROM t1 ORDER BY id;
+connection master;
+DROP TABLE t1;
+
+--source include/rpl_end.inc