Debian Codegraph @

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

raw
1 include/master-slave.inc
2 Warnings:
3 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
4 Note #### Storing MySQL user name or password information in the connection metadata repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START REPLICA; see the 'START REPLICA Syntax' in the MySQL Manual for more information.
5 [connection master]
6 SHOW VARIABLES LIKE 'relay_log_space_limit';
7 Variable_name Value
8 relay_log_space_limit 0
9 CREATE TABLE t1 (name varchar(64), age smallint(3))ENGINE=InnoDB;
10 Warnings:
11 Warning 1681 Integer display width is deprecated and will be removed in a future release.
12 INSERT INTO t1 SET name='Andy', age=31;
13 INSERT INTO t1 SET name='Jacob', age=2;
14 INSERT INTO t1 SET name='Caleb', age=1;
15 ALTER TABLE t1 ADD id int(8) ZEROFILL AUTO_INCREMENT PRIMARY KEY,
16 ALGORITHM=COPY;
17 Warnings:
18 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
19 Warning 1681 Integer display width is deprecated and will be removed in a future release.
20 SELECT * FROM t1 ORDER BY id;
21 name age id
22 Andy 31 00000001
23 Jacob 2 00000002
24 Caleb 1 00000003
25 include/sync_slave_sql_with_master.inc
26 SELECT * FROM t1 ORDER BY id;
27 name age id
28 Andy 31 00000001
29 Jacob 2 00000002
30 Caleb 1 00000003
31 DROP TABLE t1;
32 include/rpl_end.inc