summaryrefslogtreecommitdiff
path: root/mysql-test/t/rpl000005.test
diff options
context:
space:
mode:
Diffstat (limited to 'mysql-test/t/rpl000005.test')
-rw-r--r--mysql-test/t/rpl000005.test12
1 files changed, 12 insertions, 0 deletions
diff --git a/mysql-test/t/rpl000005.test b/mysql-test/t/rpl000005.test
new file mode 100644
index 00000000000..944f701d765
--- /dev/null
+++ b/mysql-test/t/rpl000005.test
@@ -0,0 +1,12 @@
+source include/master-slave.inc;
+connection master;
+drop table if exists test;
+CREATE TABLE test (name varchar(64), age smallint(3));
+INSERT INTO test SET name='Andy', age=31;
+INSERT test SET name='Jacob', age=2;
+INSERT into test SET name='Caleb', age=1;
+ALTER TABLE test ADD id int(8) ZEROFILL AUTO_INCREMENT PRIMARY KEY;
+@r/rpl000005.result select * from test;
+connection slave;
+sleep 0.5;
+@r/rpl000005.result select * from test;