Debian Codegraph @

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

raw
1 connection node_2;
2 connection node_1;
3 connection node_1;
4 create table t1_Aria(a int, count int, b int, key(b)) engine=Aria;
5 INSERT INTO t1_Aria values (1,1,1);
6 create table t1_MyISAM(a int, count int, b int, key(b)) engine=MyISAM;
7 INSERT INTO t1_MyISAM values (1,1,1);
8 create table t1_InnoDB(a int, count int, b int, key(b)) engine=InnoDB;
9 INSERT INTO t1_InnoDB values (1,1,1);
10 SET SESSION default_storage_engine=MyISAM;
11 CREATE TABLE t2 AS SELECT * FROM t1_Aria;
12 CREATE TABLE t3 AS SELECT * FROM t1_MyISAM;
13 CREATE TABLE t4 AS SELECT * FROM t1_InnoDB;
14 SHOW CREATE TABLE t2;
15 Table Create Table
16 t2 CREATE TABLE `t2` (
17 `a` int(11) DEFAULT NULL,
18 `count` int(11) DEFAULT NULL,
19 `b` int(11) DEFAULT NULL
20 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
21 SHOW CREATE TABLE t3;
22 Table Create Table
23 t3 CREATE TABLE `t3` (
24 `a` int(11) DEFAULT NULL,
25 `count` int(11) DEFAULT NULL,
26 `b` int(11) DEFAULT NULL
27 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
28 SHOW CREATE TABLE t4;
29 Table Create Table
30 t4 CREATE TABLE `t4` (
31 `a` int(11) DEFAULT NULL,
32 `count` int(11) DEFAULT NULL,
33 `b` int(11) DEFAULT NULL
34 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
35 DROP TABLE t2, t3,t4;
36 SET SESSION default_storage_engine=Aria;
37 CREATE TABLE t2 AS SELECT * FROM t1_Aria;
38 CREATE TABLE t3 AS SELECT * FROM t1_MyISAM;
39 CREATE TABLE t4 AS SELECT * FROM t1_InnoDB;
40 SHOW CREATE TABLE t2;
41 Table Create Table
42 t2 CREATE TABLE `t2` (
43 `a` int(11) DEFAULT NULL,
44 `count` int(11) DEFAULT NULL,
45 `b` int(11) DEFAULT NULL
46 ) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1
47 SHOW CREATE TABLE t3;
48 Table Create Table
49 t3 CREATE TABLE `t3` (
50 `a` int(11) DEFAULT NULL,
51 `count` int(11) DEFAULT NULL,
52 `b` int(11) DEFAULT NULL
53 ) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1
54 SHOW CREATE TABLE t4;
55 Table Create Table
56 t4 CREATE TABLE `t4` (
57 `a` int(11) DEFAULT NULL,
58 `count` int(11) DEFAULT NULL,
59 `b` int(11) DEFAULT NULL
60 ) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1
61 DROP TABLE t2, t3,t4;
62 SET SESSION default_storage_engine=InnoDB;
63 CREATE TABLE t2 AS SELECT * FROM t1_Aria;
64 CREATE TABLE t3 AS SELECT * FROM t1_MyISAM;
65 CREATE TABLE t4 AS SELECT * FROM t1_InnoDB;
66 SHOW CREATE TABLE t2;
67 Table Create Table
68 t2 CREATE TABLE `t2` (
69 `a` int(11) DEFAULT NULL,
70 `count` int(11) DEFAULT NULL,
71 `b` int(11) DEFAULT NULL
72 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
73 SHOW CREATE TABLE t3;
74 Table Create Table
75 t3 CREATE TABLE `t3` (
76 `a` int(11) DEFAULT NULL,
77 `count` int(11) DEFAULT NULL,
78 `b` int(11) DEFAULT NULL
79 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
80 SHOW CREATE TABLE t4;
81 Table Create Table
82 t4 CREATE TABLE `t4` (
83 `a` int(11) DEFAULT NULL,
84 `count` int(11) DEFAULT NULL,
85 `b` int(11) DEFAULT NULL
86 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
87 DROP TABLE t2, t3,t4;
88 DROP TABLE t1_MyISAM, t1_Aria,t1_InnoDB;