Debian Codegraph @

mysql-test/suite/galera/r/galera_sp_insert_parallel.result

raw
1 connection node_2;
2 connection node_1;
3 CREATE TABLE t1 (f1 INTEGER PRIMARY KEY, f2 INTEGER) ENGINE=InnoDB;
4 CREATE PROCEDURE proc_insert()
5 BEGIN
6 DECLARE i INT;
7 DECLARE CONTINUE HANDLER FOR SQLEXCEPTION BEGIN END;
8 SET i = 0;
9 WHILE i < 1000 DO
10 INSERT IGNORE INTO t1 (f1, f2)
11 VALUES (FLOOR(1 + RAND() * 65535), FLOOR(1 + RAND() * 15)),
12 (FLOOR(1 + RAND() * 65535), FLOOR(1 + RAND() * 15)),
13 (FLOOR(1 + RAND() * 65535), FLOOR(1 + RAND() * 15)),
14 (FLOOR(1 + RAND() * 65535), FLOOR(1 + RAND() * 15)),
15 (FLOOR(1 + RAND() * 65535), FLOOR(1 + RAND() * 15)),
16 (FLOOR(1 + RAND() * 65535), FLOOR(1 + RAND() * 15)),
17 (FLOOR(1 + RAND() * 65535), FLOOR(1 + RAND() * 15)),
18 (FLOOR(1 + RAND() * 65535), FLOOR(1 + RAND() * 15)),
19 (FLOOR(1 + RAND() * 65535), FLOOR(1 + RAND() * 15));
20 SET i = i + 1;
21 END WHILE;
22 END|
23 connection node_1;
24 SELECT 0;
25 0
26 0
27 SET SESSION wsrep_sync_wait = 0;
28 CALL proc_insert;
29 connection node_2;
30 SELECT 0;
31 0
32 0
33 SET SESSION wsrep_sync_wait = 0;
34 CALL proc_insert;
35 connection node_1;
36 SET SESSION wsrep_sync_wait = default;
37 connection node_2;
38 SET SESSION wsrep_sync_wait = default;
39 connection node_1;
40 DROP PROCEDURE proc_insert;
41 DROP TABLE t1;