summaryrefslogtreecommitdiff
path: root/mysql-test/suite/galera/r/enforce_storage_engine2.result
blob: 8b174139eaee33e4f1ab28b29161185df214a210 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
connection node_2;
connection node_1;
#
# MDEV-9312: storage engine not enforced during galera cluster
# replication
#
connection node_1;
CREATE TABLE t1(i INT) ENGINE=INNODB;
CREATE TABLE t2(i INT) ENGINE=MYISAM;
Warnings:
Note	1266	Using storage engine InnoDB for table 't2'
connection node_2;
SHOW TABLES;
Tables_in_test
t1
t2
SHOW CREATE TABLE t1;
Table	Create Table
t1	CREATE TABLE `t1` (
  `i` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1
SHOW CREATE TABLE t2;
Table	Create Table
t2	CREATE TABLE `t2` (
  `i` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1
DROP TABLE t1, t2;
# End of tests