diff options
Diffstat (limited to 'repl-tests/test-repl-alter/run.test')
-rw-r--r-- | repl-tests/test-repl-alter/run.test | 11 |
1 files changed, 11 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 |