Debian Codegraph @

mysql-test/suite/galera/t/MDEV-33828.test

raw
1 --source include/galera_cluster.inc
2 --source include/have_innodb.inc
3
4 SET AUTOCOMMIT=ON;
5 SELECT @@autocommit;
6
7 SET LOCAL enforce_storage_engine=InnoDB;
8
9 CREATE TABLE t1(id int not null primary key auto_increment, name varchar(64)) ENGINE=InnoDB;
10 INSERT INTO t1(name) VALUES ('name1'),('name3'),('name6'),('name2');
11
12 DELIMITER |;
13 CREATE PROCEDURE sel_proc()
14 BEGIN
15 DECLARE CONTINUE HANDLER FOR SQLEXCEPTION BEGIN END;
16 SELECT * FROM t1;
17 END|
18
19 CREATE PROCEDURE ins_proc()
20 BEGIN
21 DECLARE CONTINUE HANDLER FOR SQLEXCEPTION BEGIN END;
22 INSERT INTO t1 VALUES ('name_proc');
23 END|
24 DELIMITER ;|
25
26 SET AUTOCOMMIT=OFF;
27 SELECT @@autocommit;
28
29 START TRANSACTION;
30
31 insert into t1(name) values('name10');
32
33 select param_list, returns, db, type from mysql.proc where name='sel_proc';
34
35 call ins_proc();
36
37 COMMIT;
38
39 SET AUTOCOMMIT=ON;
40
41 SELECT * FROM t1;
42 DROP TABLE t1;
43 DROP PROCEDURE sel_proc;
44 DROP PROCEDURE ins_proc;