Debian Codegraph @

mysql-test/suite/galera/t/galera_ctas.test

raw
1 --source include/galera_cluster.inc
2 --source include/have_innodb.inc
3 --source include/have_aria.inc
4
5 --connection node_1
6 create table t1_Aria(a int, count int, b int, key(b)) engine=Aria;
7 INSERT INTO t1_Aria values (1,1,1);
8 create table t1_MyISAM(a int, count int, b int, key(b)) engine=MyISAM;
9 INSERT INTO t1_MyISAM values (1,1,1);
10 create table t1_InnoDB(a int, count int, b int, key(b)) engine=InnoDB;
11 INSERT INTO t1_InnoDB values (1,1,1);
12
13 SET SESSION default_storage_engine=MyISAM;
14 CREATE TABLE t2 AS SELECT * FROM t1_Aria;
15 CREATE TABLE t3 AS SELECT * FROM t1_MyISAM;
16 CREATE TABLE t4 AS SELECT * FROM t1_InnoDB;
17 SHOW CREATE TABLE t2;
18 SHOW CREATE TABLE t3;
19 SHOW CREATE TABLE t4;
20 DROP TABLE t2, t3,t4;
21
22 SET SESSION default_storage_engine=Aria;
23 CREATE TABLE t2 AS SELECT * FROM t1_Aria;
24 CREATE TABLE t3 AS SELECT * FROM t1_MyISAM;
25 CREATE TABLE t4 AS SELECT * FROM t1_InnoDB;
26 SHOW CREATE TABLE t2;
27 SHOW CREATE TABLE t3;
28 SHOW CREATE TABLE t4;
29 DROP TABLE t2, t3,t4;
30
31 SET SESSION default_storage_engine=InnoDB;
32 CREATE TABLE t2 AS SELECT * FROM t1_Aria;
33 CREATE TABLE t3 AS SELECT * FROM t1_MyISAM;
34 CREATE TABLE t4 AS SELECT * FROM t1_InnoDB;
35 SHOW CREATE TABLE t2;
36 SHOW CREATE TABLE t3;
37 SHOW CREATE TABLE t4;
38
39 DROP TABLE t2, t3,t4;
40 DROP TABLE t1_MyISAM, t1_Aria,t1_InnoDB;