Debian Codegraph @

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

raw
1 --source include/galera_cluster.inc
2
3 #
4 # MDEV-28750 Assertion `trans_safe || !updated || thd->transaction->stmt.modified_non_trans_table' failed in virtual bool multi_update::send_eof()
5 #
6 CREATE TABLE ti (a INT UNSIGNED, b SMALLINT, id BIGINT NOT NULL, KEY(b), PRIMARY KEY(id)) ENGINE=InnoDB;
7 CREATE TABLE tm (a INT PRIMARY KEY, b MEDIUMTEXT) ENGINE=MyISAM;
8 SET GLOBAL wsrep_max_ws_rows=2;
9 START TRANSACTION;
10 INSERT INTO tm SET b=NULL, a=2;
11 INSERT INTO ti VALUES (1,2,4);
12 UPDATE tm AS t1 SET t1.a=t1.a * 2;
13 UPDATE ti AS t1 SET t1.a=t1.a * 2;
14 UPDATE tm AS t1 SET t1.a=t1.a * 2;
15 --error ER_WARNING_NOT_COMPLETE_ROLLBACK
16 UPDATE ti AS t1 SET t1.a=t1.a * 2;
17 SHOW WARNINGS;
18 COMMIT;
19 SELECT * FROM ti;
20 SELECT * from tm;
21 DROP TABLE ti,tm;
22
23 CREATE TABLE ti (a INT UNSIGNED, b SMALLINT, id BIGINT NOT NULL, KEY(b), PRIMARY KEY(id)) ENGINE=InnoDB;
24 CREATE TABLE tm (a INT PRIMARY KEY, b MEDIUMTEXT) ENGINE=MyISAM;
25 SET GLOBAL wsrep_max_ws_rows=2;
26 START TRANSACTION;
27 INSERT INTO tm SET b=NULL, a=2;
28 SET sql_mode=only_full_group_by;
29 INSERT INTO ti VALUES (1,2,4);
30 --error ER_GALERA_REPLICATION_NOT_SUPPORTED
31 UPDATE tm AS t1, ti AS t2 SET t1.a=t1.a * 2, t2.a=t2.a * 2;
32 --error ER_GALERA_REPLICATION_NOT_SUPPORTED
33 UPDATE tm AS t1, ti AS t2 SET t1.a=t1.a * 2, t2.a=t2.a * 2;
34 COMMIT;
35 SELECT * FROM ti;
36 SELECT * from tm;
37 DROP TABLE ti,tm;
38
39 CREATE TABLE ti (a INT UNSIGNED, b SMALLINT, id BIGINT NOT NULL, KEY(b), PRIMARY KEY(id)) ENGINE=InnoDB;
40 CREATE TABLE tm (a INT PRIMARY KEY, b MEDIUMTEXT) ENGINE=MyISAM;
41 START TRANSACTION;
42 INSERT INTO tm SET b=NULL, a=2;
43 SET sql_mode=only_full_group_by;
44 INSERT INTO ti VALUES (1,2,4);
45 --error ER_WRONG_ARGUMENTS
46 SET GLOBAL wsrep_max_ws_rows=2;
47 --error ER_WRONG_ARGUMENTS
48 set GLOBAL wsrep_max_ws_size=2047;
49 COMMIT;
50 SELECT * FROM ti;
51 SELECT * from tm;
52 DROP TABLE ti,tm;
53
54 CREATE TABLE ti (a INT UNSIGNED, b SMALLINT, id BIGINT NOT NULL, KEY(b), PRIMARY KEY(id)) ENGINE=InnoDB;
55 CREATE TABLE tm (a INT PRIMARY KEY, b MEDIUMTEXT) ENGINE=InnoDB;
56 SET GLOBAL wsrep_max_ws_rows=2;
57 START TRANSACTION;
58 INSERT INTO tm SET b=NULL, a=2;
59 INSERT INTO ti VALUES (1,2,4);
60 --error ER_ERROR_DURING_COMMIT
61 UPDATE tm AS t1, ti AS t2 SET t1.a=t1.a * 2, t2.a=t2.a * 2;
62 UPDATE tm AS t1, ti AS t2 SET t1.a=t1.a * 2, t2.a=t2.a * 2;
63 COMMIT;
64 SELECT * FROM ti;
65 SELECT * from tm;
66 DROP TABLE ti,tm;
67
68 CREATE TABLE ti (a INT UNSIGNED, b SMALLINT, id BIGINT NOT NULL, KEY(b), PRIMARY KEY(id)) ENGINE=InnoDB;
69 CREATE TABLE tm (a INT PRIMARY KEY, b MEDIUMTEXT) ENGINE=MyISAM;
70 SET GLOBAL wsrep_max_ws_rows=0;
71 START TRANSACTION;
72 INSERT INTO tm SET b=NULL, a=2;
73 INSERT INTO ti VALUES (1,2,4);
74 UPDATE tm AS t1, ti AS t2 SET t1.a=t1.a * 2, t2.a=t2.a * 2;
75 UPDATE tm AS t1, ti AS t2 SET t1.a=t1.a * 2, t2.a=t2.a * 2;
76 COMMIT;
77 SELECT * FROM ti;
78 SELECT * from tm;
79 DROP TABLE ti,tm;
80
81 #
82 # MDEV-25548 Assertion `transactional_table || !changed || thd->transaction.stmt.modified_non_trans_table' failed.
83 #
84 CREATE TABLE t1 (col INT);
85 INSERT INTO t1 VALUES (0xF4AB);
86 CREATE TEMPORARY TABLE t1 (c1 INT) ENGINE=mrg_myisam UNION=(t1) insert_method=FIRST;
87 SET GLOBAL wsrep_max_ws_rows=1;
88 DROP TABLES t1;
89 INSERT INTO t1 VALUES (6373);
90 CREATE TABLE t2 ENGINE=heap SELECT * FROM t1;
91
92 DROP TABLE t1, t2;
93
94 SET default_storage_engine="HEAP";
95 CREATE TABLE t1 (f1 BIGINT);
96 SET GLOBAL wsrep_max_ws_rows = 1;
97 INSERT INTO t1 VALUES (NOW()),(NOW()),(NOW());
98 SELECT COUNT(*) AS EXPECT_3 FROM t1;
99 DROP TABLE t1;
100
101 CREATE TABLE t1 (i INT) ENGINE=MyISAM DEFAULT CHARSET=utf8 SELECT 1 as i;
102 DROP TABLE t1;
103
104 SET GLOBAL wsrep_max_ws_rows=0;