Debian Codegraph @

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

raw
1 connection node_2;
2 connection node_1;
3 CREATE TABLE ti (a INT UNSIGNED, b SMALLINT, id BIGINT NOT NULL, KEY(b), PRIMARY KEY(id)) ENGINE=InnoDB;
4 CREATE TABLE tm (a INT PRIMARY KEY, b MEDIUMTEXT) ENGINE=MyISAM;
5 SET GLOBAL wsrep_max_ws_rows=2;
6 START TRANSACTION;
7 INSERT INTO tm SET b=NULL, a=2;
8 INSERT INTO ti VALUES (1,2,4);
9 UPDATE tm AS t1 SET t1.a=t1.a * 2;
10 UPDATE ti AS t1 SET t1.a=t1.a * 2;
11 UPDATE tm AS t1 SET t1.a=t1.a * 2;
12 UPDATE ti AS t1 SET t1.a=t1.a * 2;
13 ERROR HY000: Some non-transactional changed tables couldn't be rolled back
14 SHOW WARNINGS;
15 Level Code Message
16 Error 1196 Some non-transactional changed tables couldn't be rolled back
17 Error 1180 wsrep_max_ws_rows exceeded
18 Error 1030 Got error 1180 "Unknown error 1180" from storage engine InnoDB
19 COMMIT;
20 SELECT * FROM ti;
21 a b id
22 SELECT * from tm;
23 a b
24 8 NULL
25 DROP TABLE ti,tm;
26 CREATE TABLE ti (a INT UNSIGNED, b SMALLINT, id BIGINT NOT NULL, KEY(b), PRIMARY KEY(id)) ENGINE=InnoDB;
27 CREATE TABLE tm (a INT PRIMARY KEY, b MEDIUMTEXT) ENGINE=MyISAM;
28 SET GLOBAL wsrep_max_ws_rows=2;
29 START TRANSACTION;
30 INSERT INTO tm SET b=NULL, a=2;
31 SET sql_mode=only_full_group_by;
32 INSERT INTO ti VALUES (1,2,4);
33 UPDATE tm AS t1, ti AS t2 SET t1.a=t1.a * 2, t2.a=t2.a * 2;
34 ERROR HY000: Galera replication not supported
35 UPDATE tm AS t1, ti AS t2 SET t1.a=t1.a * 2, t2.a=t2.a * 2;
36 ERROR HY000: Galera replication not supported
37 COMMIT;
38 SELECT * FROM ti;
39 a b id
40 1 2 4
41 SELECT * from tm;
42 a b
43 2 NULL
44 DROP TABLE ti,tm;
45 CREATE TABLE ti (a INT UNSIGNED, b SMALLINT, id BIGINT NOT NULL, KEY(b), PRIMARY KEY(id)) ENGINE=InnoDB;
46 CREATE TABLE tm (a INT PRIMARY KEY, b MEDIUMTEXT) ENGINE=MyISAM;
47 START TRANSACTION;
48 INSERT INTO tm SET b=NULL, a=2;
49 SET sql_mode=only_full_group_by;
50 INSERT INTO ti VALUES (1,2,4);
51 SET GLOBAL wsrep_max_ws_rows=2;
52 ERROR HY000: WSREP transaction is active
53 set GLOBAL wsrep_max_ws_size=2047;
54 ERROR HY000: WSREP transaction is active
55 COMMIT;
56 SELECT * FROM ti;
57 a b id
58 1 2 4
59 SELECT * from tm;
60 a b
61 2 NULL
62 DROP TABLE ti,tm;
63 CREATE TABLE ti (a INT UNSIGNED, b SMALLINT, id BIGINT NOT NULL, KEY(b), PRIMARY KEY(id)) ENGINE=InnoDB;
64 CREATE TABLE tm (a INT PRIMARY KEY, b MEDIUMTEXT) ENGINE=InnoDB;
65 SET GLOBAL wsrep_max_ws_rows=2;
66 START TRANSACTION;
67 INSERT INTO tm SET b=NULL, a=2;
68 INSERT INTO ti VALUES (1,2,4);
69 UPDATE tm AS t1, ti AS t2 SET t1.a=t1.a * 2, t2.a=t2.a * 2;
70 ERROR HY000: wsrep_max_ws_rows exceeded
71 UPDATE tm AS t1, ti AS t2 SET t1.a=t1.a * 2, t2.a=t2.a * 2;
72 COMMIT;
73 SELECT * FROM ti;
74 a b id
75 SELECT * from tm;
76 a b
77 DROP TABLE ti,tm;
78 CREATE TABLE ti (a INT UNSIGNED, b SMALLINT, id BIGINT NOT NULL, KEY(b), PRIMARY KEY(id)) ENGINE=InnoDB;
79 CREATE TABLE tm (a INT PRIMARY KEY, b MEDIUMTEXT) ENGINE=MyISAM;
80 SET GLOBAL wsrep_max_ws_rows=0;
81 START TRANSACTION;
82 INSERT INTO tm SET b=NULL, a=2;
83 INSERT INTO ti VALUES (1,2,4);
84 UPDATE tm AS t1, ti AS t2 SET t1.a=t1.a * 2, t2.a=t2.a * 2;
85 UPDATE tm AS t1, ti AS t2 SET t1.a=t1.a * 2, t2.a=t2.a * 2;
86 COMMIT;
87 SELECT * FROM ti;
88 a b id
89 4 2 4
90 SELECT * from tm;
91 a b
92 8 NULL
93 DROP TABLE ti,tm;
94 CREATE TABLE t1 (col INT);
95 INSERT INTO t1 VALUES (0xF4AB);
96 CREATE TEMPORARY TABLE t1 (c1 INT) ENGINE=mrg_myisam UNION=(t1) insert_method=FIRST;
97 SET GLOBAL wsrep_max_ws_rows=1;
98 DROP TABLES t1;
99 INSERT INTO t1 VALUES (6373);
100 CREATE TABLE t2 ENGINE=heap SELECT * FROM t1;
101 DROP TABLE t1, t2;
102 SET default_storage_engine="HEAP";
103 CREATE TABLE t1 (f1 BIGINT);
104 SET GLOBAL wsrep_max_ws_rows = 1;
105 INSERT INTO t1 VALUES (NOW()),(NOW()),(NOW());
106 SELECT COUNT(*) AS EXPECT_3 FROM t1;
107 EXPECT_3
108 3
109 DROP TABLE t1;
110 CREATE TABLE t1 (i INT) ENGINE=MyISAM DEFAULT CHARSET=utf8 SELECT 1 as i;
111 DROP TABLE t1;
112 SET GLOBAL wsrep_max_ws_rows=0;