Debian Codegraph @

mysql-test/suite/rpl/t/mysql-wsrep#110-2.test

raw
1 #
2 # codership/mysql-wsrep/110 - Assertion `table_found' failed in unpack_row() with SAVEPOINT, trigger, error handler
3 #
4
5 --source include/have_innodb.inc
6 --source include/have_binlog_format_row.inc
7 --source include/master-slave.inc
8
9 CREATE TABLE t1 (f1 INTEGER PRIMARY KEY);
10 CREATE TABLE t2 (f1 INTEGER PRIMARY KEY);
11 CREATE TABLE t3 (f1 INTEGER PRIMARY KEY);
12
13 CREATE TRIGGER tr1 AFTER INSERT ON t1 FOR EACH ROW CALL p1(NEW.f1);
14
15 DELIMITER |;
16
17 CREATE PROCEDURE p1 (IN x INT)
18 BEGIN
19 DECLARE EXIT HANDLER FOR SQLEXCEPTION
20 BEGIN
21 ROLLBACK TO event_logging;
22 INSERT t3 VALUES (x);
23 END;
24 SAVEPOINT event_logging;
25
26 INSERT INTO t2 VALUES (x);
27
28 RELEASE SAVEPOINT event_logging;
29 END|
30 DELIMITER ;|
31
32 INSERT INTO t2 VALUES (1);
33 INSERT INTO t1 VALUES (1);
34
35
36 DROP TABLE t3;
37 DROP TABLE t2;
38 DROP TABLE t1;
39
40 DROP PROCEDURE p1;
41
42 sync_slave_with_master;
43 --source include/rpl_end.inc
44