Debian Codegraph @

mysql-test/suite/group_replication/r/gr_storage_engines.result

raw
1 include/group_replication.inc
2 Warnings:
3 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
4 Note #### Storing MySQL user name or password information in the connection metadata repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START REPLICA; see the 'START REPLICA Syntax' in the MySQL Manual for more information.
5 [connection server1]
6 Create tables with different storage engines, Group Replication should not block this.
7 USE test;
8 CREATE TABLE tn (c1 int PRIMARY KEY, c2 int) ENGINE=INNODB;
9 CREATE TABLE t1 (c1 int not null, c2 int not null) ENGINE=CSV;
10 CREATE TABLE t2 (c1 int PRIMARY KEY, c2 int) ENGINE=MyISAM;
11 CREATE TABLE t3 (c1 int PRIMARY KEY, c2 int) ENGINE=MEMORY;
12 CREATE TABLE t4 (c1 int, c2 int) ENGINE=ARCHIVE;
13 CREATE TABLE t5 (c1 int PRIMARY KEY, c2 int) ENGINE=BLACKHOLE;
14 CREATE TABLE t6 (C1 INT PRIMARY KEY, c2 int) ENGINE=MERGE UNION=(t2) INSERT_METHOD=LAST;
15
16 Group Replication Should block DML's on non-transactional tables
17
18 INSERT INTO t6 (c1,c2) VALUES(1, 2);
19 ERROR HY000: The table does not comply with the requirements by an external plugin.
20 INSERT INTO tn (c1) VALUES (6+10);
21 UPDATE t6 SET c2= 100;
22 ERROR HY000: The table does not comply with the requirements by an external plugin.
23 REPLACE INTO t6(c1) VALUES(2);
24 ERROR HY000: The table does not comply with the requirements by an external plugin.
25 REPLACE INTO t6 (c1) SELECT tn.c1 FROM tn;
26 ERROR HY000: The table does not comply with the requirements by an external plugin.
27 UPDATE t6, tn SET t6.c1= 100, tn.c1= 100;
28 ERROR HY000: The table does not comply with the requirements by an external plugin.
29 DELETE FROM t6;
30 ERROR HY000: The table does not comply with the requirements by an external plugin.
31 DELETE FROM tn;
32 INSERT INTO t5 (c1,c2) VALUES(1, 2);
33 ERROR HY000: The table does not comply with the requirements by an external plugin.
34 INSERT INTO tn (c1) VALUES (5+10);
35 UPDATE t5 SET c2= 100;
36 ERROR HY000: The table does not comply with the requirements by an external plugin.
37 REPLACE INTO t5(c1) VALUES(2);
38 ERROR HY000: The table does not comply with the requirements by an external plugin.
39 REPLACE INTO t5 (c1) SELECT tn.c1 FROM tn;
40 ERROR HY000: The table does not comply with the requirements by an external plugin.
41 UPDATE t5, tn SET t5.c1= 100, tn.c1= 100;
42 ERROR HY000: The table does not comply with the requirements by an external plugin.
43 DELETE FROM t5;
44 ERROR HY000: The table does not comply with the requirements by an external plugin.
45 DELETE FROM tn;
46 INSERT INTO t4 (c1,c2) VALUES(1, 2);
47 ERROR HY000: The table does not comply with the requirements by an external plugin.
48 INSERT INTO tn (c1) VALUES (4+10);
49 UPDATE t4 SET c2= 100;
50 ERROR HY000: Table storage engine for 't4' doesn't have this option
51 REPLACE INTO t4(c1) VALUES(2);
52 ERROR HY000: The table does not comply with the requirements by an external plugin.
53 REPLACE INTO t4 (c1) SELECT tn.c1 FROM tn;
54 ERROR HY000: The table does not comply with the requirements by an external plugin.
55 UPDATE t4, tn SET t4.c1= 100, tn.c1= 100;
56 ERROR HY000: Table storage engine for 't4' doesn't have this option
57 DELETE FROM t4;
58 ERROR HY000: Table storage engine for 't4' doesn't have this option
59 DELETE FROM tn;
60 INSERT INTO t3 (c1,c2) VALUES(1, 2);
61 ERROR HY000: The table does not comply with the requirements by an external plugin.
62 INSERT INTO tn (c1) VALUES (3+10);
63 UPDATE t3 SET c2= 100;
64 ERROR HY000: The table does not comply with the requirements by an external plugin.
65 REPLACE INTO t3(c1) VALUES(2);
66 ERROR HY000: The table does not comply with the requirements by an external plugin.
67 REPLACE INTO t3 (c1) SELECT tn.c1 FROM tn;
68 ERROR HY000: The table does not comply with the requirements by an external plugin.
69 UPDATE t3, tn SET t3.c1= 100, tn.c1= 100;
70 ERROR HY000: The table does not comply with the requirements by an external plugin.
71 DELETE FROM t3;
72 ERROR HY000: The table does not comply with the requirements by an external plugin.
73 DELETE FROM tn;
74 INSERT INTO t2 (c1,c2) VALUES(1, 2);
75 ERROR HY000: The table does not comply with the requirements by an external plugin.
76 INSERT INTO tn (c1) VALUES (2+10);
77 UPDATE t2 SET c2= 100;
78 ERROR HY000: The table does not comply with the requirements by an external plugin.
79 REPLACE INTO t2(c1) VALUES(2);
80 ERROR HY000: The table does not comply with the requirements by an external plugin.
81 REPLACE INTO t2 (c1) SELECT tn.c1 FROM tn;
82 ERROR HY000: The table does not comply with the requirements by an external plugin.
83 UPDATE t2, tn SET t2.c1= 100, tn.c1= 100;
84 ERROR HY000: The table does not comply with the requirements by an external plugin.
85 DELETE FROM t2;
86 ERROR HY000: The table does not comply with the requirements by an external plugin.
87 DELETE FROM tn;
88 INSERT INTO t1 (c1,c2) VALUES(1, 2);
89 ERROR HY000: The table does not comply with the requirements by an external plugin.
90 INSERT INTO tn (c1) VALUES (1+10);
91 UPDATE t1 SET c2= 100;
92 ERROR HY000: The table does not comply with the requirements by an external plugin.
93 REPLACE INTO t1(c1) VALUES(2);
94 ERROR HY000: The table does not comply with the requirements by an external plugin.
95 REPLACE INTO t1 (c1) SELECT tn.c1 FROM tn;
96 ERROR HY000: The table does not comply with the requirements by an external plugin.
97 UPDATE t1, tn SET t1.c1= 100, tn.c1= 100;
98 ERROR HY000: The table does not comply with the requirements by an external plugin.
99 DELETE FROM t1;
100 ERROR HY000: The table does not comply with the requirements by an external plugin.
101 DELETE FROM tn;
102 Check that INSERT...SELECT statement on InnoDB table(tn) from a non-transactional table(Eg:MyISAM t2) fails
103 INSERT INTO tn (c1) SELECT (t2.c1) FROM t2;
104 ERROR HY000: The table does not comply with the requirements by an external plugin.
105 change storage engine to "InnoDB" on t2 and check INSERT...SELECT on tn succeeds
106 ALTER TABLE t2 ENGINE=INNODB;
107 INSERT INTO tn (c1) SELECT (t2.c1) FROM t2;
108 DROP TABLE tn;
109 DROP TABLE t1;
110 DROP TABLE t2;
111 DROP TABLE t3;
112 DROP TABLE t4;
113 DROP TABLE t5;
114 DROP TABLE t6;
115 SET SESSION sql_log_bin= 0;
116 call mtr.add_suppression("Table.*does not have any PRIMARY KEY. This is not compatible with Group Replication.");
117 call mtr.add_suppression("Table.*does not use the InnoDB storage engine. This is not compatible with Group Replication.");
118 SET SESSION sql_log_bin= 1;
119 include/group_replication_end.inc