Debian Codegraph @

mysql-test/suite/rpl/r/rpl_relay_space_myisam.result

raw
1 include/master-slave.inc
2 [connection master]
3 SHOW VARIABLES LIKE 'relay_log_space_limit';
4 Variable_name Value
5 relay_log_space_limit 0
6 CREATE TABLE t1 (name varchar(64), age smallint(3))ENGINE=MyISAM;
7 INSERT INTO t1 SET name='Andy', age=31;
8 INSERT INTO t1 SET name='Jacob', age=2;
9 INSERT INTO t1 SET name='Caleb', age=1;
10 ALTER TABLE t1 ADD id int(8) ZEROFILL AUTO_INCREMENT PRIMARY KEY,
11 ALGORITHM=COPY;
12 SELECT * FROM t1 ORDER BY id;
13 name age id
14 Andy 31 00000001
15 Jacob 2 00000002
16 Caleb 1 00000003
17 connection slave;
18 SELECT * FROM t1 ORDER BY id;
19 name age id
20 Andy 31 00000001
21 Jacob 2 00000002
22 Caleb 1 00000003
23 connection master;
24 DROP TABLE t1;
25 include/rpl_end.inc