Debian Codegraph @

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

raw
1 connection node_2;
2 connection node_1;
3 connection node_1;
4 CREATE TABLE t1 (f1 INTEGER) ENGINE=InnoDB;
5 CREATE TABLE t2 (f1 INTEGER) ENGINE=InnoDB;
6 SHOW CREATE TABLE t1;
7 Table Create Table
8 t1 CREATE TABLE `t1` (
9 `f1` int(11) DEFAULT NULL
10 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
11 SHOW CREATE TABLE t2;
12 Table Create Table
13 t2 CREATE TABLE `t2` (
14 `f1` int(11) DEFAULT NULL
15 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
16 connection node_2;
17 SHOW CREATE TABLE t1;
18 Table Create Table
19 t1 CREATE TABLE `t1` (
20 `f1` int(11) DEFAULT NULL
21 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
22 SHOW CREATE TABLE t2;
23 Table Create Table
24 t2 CREATE TABLE `t2` (
25 `f1` int(11) DEFAULT NULL
26 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
27 connection node_1;
28 CREATE TABLE t3 (f1 INTEGER) ENGINE=InnoDB; CREATE TABLE t4 (f1 INTEGER) ENGINE=InnoDB;;
29 SHOW CREATE TABLE t3;
30 Table Create Table
31 t3 CREATE TABLE `t3` (
32 `f1` int(11) DEFAULT NULL
33 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
34 SHOW CREATE TABLE t4;
35 Table Create Table
36 t4 CREATE TABLE `t4` (
37 `f1` int(11) DEFAULT NULL
38 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
39 connection node_2;
40 SHOW CREATE TABLE t3;
41 Table Create Table
42 t3 CREATE TABLE `t3` (
43 `f1` int(11) DEFAULT NULL
44 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
45 SHOW CREATE TABLE t4;
46 Table Create Table
47 t4 CREATE TABLE `t4` (
48 `f1` int(11) DEFAULT NULL
49 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
50 connection node_1;
51 INSERT INTO t1 VALUES (1);
52 CREATE TABLE t5 (f1 INTEGER) ENGINE=InnoDB;
53 SELECT COUNT(*) = 1 FROM t1;
54 COUNT(*) = 1
55 1
56 SHOW CREATE TABLE t5;
57 Table Create Table
58 t5 CREATE TABLE `t5` (
59 `f1` int(11) DEFAULT NULL
60 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
61 connection node_2;
62 SELECT COUNT(*) = 1 FROM t1;
63 COUNT(*) = 1
64 1
65 SHOW CREATE TABLE t5;
66 Table Create Table
67 t5 CREATE TABLE `t5` (
68 `f1` int(11) DEFAULT NULL
69 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
70 connection node_1;
71 CREATE TABLE t6 (f1 INTEGER) ENGINE=InnoDB; INSERT INTO t2 VALUES (1);;
72 SELECT COUNT(*) = 1 FROM t2;
73 COUNT(*) = 1
74 1
75 SHOW CREATE TABLE t6;
76 Table Create Table
77 t6 CREATE TABLE `t6` (
78 `f1` int(11) DEFAULT NULL
79 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
80 connection node_2;
81 SELECT COUNT(*) = 1 FROM t2;
82 COUNT(*) = 1
83 1
84 SHOW CREATE TABLE t6;
85 Table Create Table
86 t6 CREATE TABLE `t6` (
87 `f1` int(11) DEFAULT NULL
88 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
89 include/diff_servers.inc [servers=1 2]
90 connection node_1;
91 DROP TABLE t1, t2, t3, t4, t5, t6;