Debian Codegraph @

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

raw
1 connection node_2;
2 connection node_1;
3 connection node_1;
4 set wsrep_sync_wait=0;
5 connect node_1a, 127.0.0.1, root, , test, $NODE_MYPORT_1;
6 SET SESSION wsrep_sync_wait = 0;
7 connection node_1;
8 SET GLOBAL wsrep_slave_threads=2;
9 CREATE TABLE `par-ent` ( id INT AUTO_INCREMENT PRIMARY KEY, j INT) ENGINE=InnoDB;
10 CREATE TABLE `child` (id INT AUTO_INCREMENT PRIMARY KEY, parent_id INT, j INT, FOREIGN KEY (parent_id) REFERENCES `par-ent`(id)) ENGINE=InnoDB;
11 INSERT INTO `par-ent` VALUES (23,0);
12 connection node_2;
13 connection node_1a;
14 SET GLOBAL DEBUG_DBUG='+d,wsrep_ha_write_row';
15 connection node_2;
16 INSERT INTO `child` VALUES (21,23,0),(22,23,0),(23,23,0);
17 connection node_1a;
18 SET DEBUG_SYNC='now WAIT_FOR wsrep_ha_write_row_reached';
19 connection node_2;
20 UPDATE `par-ent` SET j=2 WHERE id=23;
21 connection node_1a;
22 SET GLOBAL DEBUG_DBUG='-d,wsrep_ha_write_row';
23 SET DEBUG_SYNC='now SIGNAL wsrep_ha_write_row_continue';
24 SET GLOBAL DEBUG_DBUG="RESET";
25 SET DEBUG_SYNC = 'RESET';
26 SET GLOBAL wsrep_slave_threads=DEFAULT;
27 connection node_2;
28 drop table `child`;
29 drop table `par-ent`;
30 connection node_1;
31 SET GLOBAL wsrep_slave_threads=2;
32 CREATE TABLE `p-arent-` ( id INT AUTO_INCREMENT PRIMARY KEY, j INT) ENGINE=InnoDB;
33 CREATE TABLE `c-hild` (id INT AUTO_INCREMENT PRIMARY KEY, parent_id INT, j INT, FOREIGN KEY (parent_id) REFERENCES `p-arent-`(id)) ENGINE=InnoDB;
34 INSERT INTO `p-arent-` VALUES (23,0);
35 connection node_2;
36 connection node_1a;
37 SET GLOBAL DEBUG_DBUG='+d,wsrep_ha_write_row';
38 connection node_2;
39 INSERT INTO `c-hild` VALUES (21,23,0),(22,23,0),(23,23,0);
40 connection node_1a;
41 SET DEBUG_SYNC='now WAIT_FOR wsrep_ha_write_row_reached';
42 connection node_2;
43 UPDATE `p-arent-` SET j=2 WHERE id=23;
44 connection node_1a;
45 SET GLOBAL DEBUG_DBUG='-d,wsrep_ha_write_row';
46 SET DEBUG_SYNC='now SIGNAL wsrep_ha_write_row_continue';
47 SET GLOBAL DEBUG_DBUG="RESET";
48 SET DEBUG_SYNC = 'RESET';
49 SET GLOBAL wsrep_slave_threads=DEFAULT;
50 connection node_2;
51 drop table `c-hild`;
52 drop table `p-arent-`;