diff options
Diffstat (limited to 'mysql-test/r/rpl000005.result')
| -rw-r--r-- | mysql-test/r/rpl000005.result | 15 |
1 files changed, 15 insertions, 0 deletions
diff --git a/mysql-test/r/rpl000005.result b/mysql-test/r/rpl000005.result index 4f1541c75ca..3e9028bf2cf 100644 --- a/mysql-test/r/rpl000005.result +++ b/mysql-test/r/rpl000005.result @@ -1,8 +1,23 @@ +slave stop; +drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9; +reset master; +reset slave; +drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9; +slave start; +drop table if exists t1; +CREATE TABLE t1 (name varchar(64), age smallint(3)); +INSERT INTO t1 SET name='Andy', age=31; +INSERT 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; +select * from t1; name age id Andy 31 00000001 Jacob 2 00000002 Caleb 1 00000003 +select * from t1; name age id Andy 31 00000001 Jacob 2 00000002 Caleb 1 00000003 +drop table t1; |