Debian Codegraph @

mysql-test/suite/rpl/r/rpl_innodb_bug28430.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 use test;
7 CREATE TABLE test.regular_tbl(id MEDIUMINT NOT NULL AUTO_INCREMENT,
8 dt TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON
9 UPDATE CURRENT_TIMESTAMP, user CHAR(255), uuidf LONGBLOB,
10 fkid MEDIUMINT, filler VARCHAR(255),
11 PRIMARY KEY(id)) ENGINE='innodb';
12 CREATE TABLE test.bykey_tbl(id MEDIUMINT NOT NULL AUTO_INCREMENT,
13 dt TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE
14 CURRENT_TIMESTAMP, user CHAR(255), uuidf LONGBLOB,
15 fkid MEDIUMINT, filler VARCHAR(255),
16 PRIMARY KEY(id)) ENGINE='innodb'
17 PARTITION BY KEY(id) partitions 5;
18 CREATE TABLE test.byrange_tbl(id MEDIUMINT NOT NULL AUTO_INCREMENT,
19 dt TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE
20 CURRENT_TIMESTAMP, user CHAR(255), uuidf LONGBLOB,
21 fkid MEDIUMINT, filler VARCHAR(255),
22 PRIMARY KEY(id)) ENGINE='innodb'
23 PARTITION BY RANGE(id)
24 SUBPARTITION BY hash(id) subpartitions 2
25 (PARTITION pa1 values less than (10),
26 PARTITION pa2 values less than (20),
27 PARTITION pa3 values less than (30),
28 PARTITION pa4 values less than (40),
29 PARTITION pa5 values less than (50),
30 PARTITION pa6 values less than (60),
31 PARTITION pa7 values less than (70),
32 PARTITION pa8 values less than (80),
33 PARTITION pa9 values less than (90),
34 PARTITION pa10 values less than (100),
35 PARTITION pa11 values less than MAXVALUE);
36 CREATE PROCEDURE test.proc_norm()
37 BEGIN
38 DECLARE ins_count INT DEFAULT 1000;
39 DECLARE del_count INT;
40 DECLARE cur_user VARCHAR(255);
41 DECLARE local_uuid VARCHAR(255);
42 DECLARE local_time TIMESTAMP;
43 SET local_time= NOW();
44 SET cur_user= CURRENT_USER();
45 SET local_uuid= UUID();
46 WHILE ins_count > 0 DO
47 INSERT INTO test.regular_tbl VALUES (NULL, NOW(), USER() , UUID(),
48 ins_count,'Going to test MBR for MySQL');
49 SET ins_count = ins_count - 1;
50 END WHILE;
51 SELECT MAX(id) FROM test.regular_tbl INTO del_count;
52 WHILE del_count > 0 DO
53 DELETE FROM test.regular_tbl WHERE id = del_count;
54 SET del_count = del_count - 2;
55 END WHILE;
56 END|
57 CREATE PROCEDURE test.proc_bykey()
58 BEGIN
59 DECLARE ins_count INT DEFAULT 1000;
60 DECLARE del_count INT;
61 DECLARE cur_user VARCHAR(255);
62 DECLARE local_uuid VARCHAR(255);
63 DECLARE local_time TIMESTAMP;
64 SET local_time= NOW();
65 SET cur_user= CURRENT_USER();
66 SET local_uuid= UUID();
67 WHILE ins_count > 0 DO
68 INSERT INTO test.bykey_tbl VALUES (NULL, NOW(), USER() , UUID(),
69 ins_count,'Going to test MBR for MySQL');
70 SET ins_count = ins_count - 1;
71 END WHILE;
72 SELECT MAX(id) FROM test.bykey_tbl INTO del_count;
73 WHILE del_count > 0 DO
74 DELETE FROM test.bykey_tbl WHERE id = del_count;
75 SET del_count = del_count - 2;
76 END WHILE;
77 END|
78 CREATE PROCEDURE test.proc_byrange()
79 BEGIN
80 DECLARE ins_count INT DEFAULT 1000;
81 DECLARE del_count INT;
82 DECLARE cur_user VARCHAR(255);
83 DECLARE local_uuid VARCHAR(255);
84 DECLARE local_time TIMESTAMP;
85 SET local_time= NOW();
86 SET cur_user = CURRENT_USER();
87 SET local_uuid=UUID();
88 WHILE ins_count > 0 DO
89 INSERT INTO test.byrange_tbl VALUES (NULL, NOW(), USER(), UUID(),
90 ins_count,'Going to test MBR for MySQL');
91 SET ins_count = ins_count - 1;
92 END WHILE;
93 SELECT MAX(id) FROM test.byrange_tbl INTO del_count;
94 WHILE del_count > 0 DO
95 DELETE FROM test.byrange_tbl WHERE id = del_count;
96 SET del_count = del_count - 2;
97 END WHILE;
98 END|
99 CALL test.proc_norm();
100 SELECT count(*) as "Master regular" FROM test.regular_tbl;
101 Master regular 500
102 CALL test.proc_bykey();
103 SELECT count(*) as "Master bykey" FROM test.bykey_tbl;
104 Master bykey 500
105 CALL test.proc_byrange();
106 SELECT count(*) as "Master byrange" FROM test.byrange_tbl;
107 Master byrange 500
108 include/sync_slave_sql_with_master.inc
109 show create table test.byrange_tbl;
110 Table byrange_tbl
111 Create Table CREATE TABLE `byrange_tbl` (
112 `id` mediumint NOT NULL AUTO_INCREMENT,
113 `dt` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
114 `user` char(255) DEFAULT NULL,
115 `uuidf` longblob,
116 `fkid` mediumint DEFAULT NULL,
117 `filler` varchar(255) DEFAULT NULL,
118 PRIMARY KEY (`id`)
119 ) ENGINE=InnoDB AUTO_INCREMENT=1001 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
120 /*!50100 PARTITION BY RANGE (`id`)
121 SUBPARTITION BY HASH (`id`)
122 SUBPARTITIONS 2
123 (PARTITION pa1 VALUES LESS THAN (10) ENGINE = InnoDB,
124 PARTITION pa2 VALUES LESS THAN (20) ENGINE = InnoDB,
125 PARTITION pa3 VALUES LESS THAN (30) ENGINE = InnoDB,
126 PARTITION pa4 VALUES LESS THAN (40) ENGINE = InnoDB,
127 PARTITION pa5 VALUES LESS THAN (50) ENGINE = InnoDB,
128 PARTITION pa6 VALUES LESS THAN (60) ENGINE = InnoDB,
129 PARTITION pa7 VALUES LESS THAN (70) ENGINE = InnoDB,
130 PARTITION pa8 VALUES LESS THAN (80) ENGINE = InnoDB,
131 PARTITION pa9 VALUES LESS THAN (90) ENGINE = InnoDB,
132 PARTITION pa10 VALUES LESS THAN (100) ENGINE = InnoDB,
133 PARTITION pa11 VALUES LESS THAN MAXVALUE ENGINE = InnoDB) */
134 SELECT count(*) "Slave norm" FROM test.regular_tbl;
135 Slave norm 500
136 SELECT count(*) "Slave bykey" FROM test.bykey_tbl;
137 Slave bykey 500
138 SELECT count(*) "Slave byrange" FROM test.byrange_tbl;
139 Slave byrange 500
140 DROP PROCEDURE test.proc_norm;
141 DROP PROCEDURE test.proc_bykey;
142 DROP PROCEDURE test.proc_byrange;
143 DROP TABLE test.regular_tbl;
144 DROP TABLE test.bykey_tbl;
145 DROP TABLE test.byrange_tbl;
146 include/rpl_end.inc