diff options
Diffstat (limited to 'repl-tests/test-repl-alter')
| -rw-r--r-- | repl-tests/test-repl-alter/run.test | 11 | ||||
| -rw-r--r-- | repl-tests/test-repl-alter/test.master | 4 |
2 files changed, 15 insertions, 0 deletions
diff --git a/repl-tests/test-repl-alter/run.test b/repl-tests/test-repl-alter/run.test new file mode 100644 index 00000000000..dab79a3d8f3 --- /dev/null +++ b/repl-tests/test-repl-alter/run.test @@ -0,0 +1,11 @@ +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; +@test.master select * from test; +connection slave; +@test.master select * from test;
\ No newline at end of file diff --git a/repl-tests/test-repl-alter/test.master b/repl-tests/test-repl-alter/test.master new file mode 100644 index 00000000000..763154b938e --- /dev/null +++ b/repl-tests/test-repl-alter/test.master @@ -0,0 +1,4 @@ +name age id +Andy 31 00000001 +Jacob 2 00000002 +Caleb 1 00000003 |