~ubuntu-branches/ubuntu/trusty/mariadb-5.5/trusty-proposed

« back to all changes in this revision

Viewing changes to mysql-test/suite/rpl/r/rpl_relay_space_myisam.result

  • Committer: Package Import Robot
  • Author(s): Otto Kekäläinen
  • Date: 2013-12-22 10:27:05 UTC
  • Revision ID: package-import@ubuntu.com-20131222102705-mndw7s12mz0szrcn
Tags: upstream-5.5.32
Import upstream version 5.5.32

Show diffs side-by-side

added added

removed removed

Lines of Context:
 
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
SELECT * FROM t1 ORDER BY id;
 
12
name    age     id
 
13
Andy    31      00000001
 
14
Jacob   2       00000002
 
15
Caleb   1       00000003
 
16
SELECT * FROM t1 ORDER BY id;
 
17
name    age     id
 
18
Andy    31      00000001
 
19
Jacob   2       00000002
 
20
Caleb   1       00000003
 
21
DROP TABLE t1;
 
22
include/rpl_end.inc